1

Topic: SSAS big

Good afternoon all.
Throw links on a floor-mat. Parts on very big  (> 100 million)
Better on  but it is possible on
Type such
http://www.artisconsulting.com/blogs/gr … dimensions
googled but the collective intelligence can on what the interesting specifies.

2

Re: SSAS big

Good afternoon. In educational basis a good pattern with the big measurements: "Internet Sales Order Details". Type Rolap.

3

Re: SSAS big

Denis@nk wrote:

Good afternoon. In educational basis a good pattern with the big measurements: "Internet Sales Order Details". Type Rolap.

Select count (*) from [dbo]. [FactInternetSales]
60398
I  2  for initial experiments in the same table
But in a source cube changed design and threw out this super-big .
practical value while disappeared - though  still floats
did not pay attention that Rolap - yes at  to a cube there are requests to an initial DB

SELECT DISTINCT
[dbo_FactInternetSales]. [SalesOrderNumber] AS [dbo_FactInternetSalesSalesOrderNumber0_0]
FROM [dbo]. [FactInternetSales] AS [dbo_FactInternetSales]

4

Re: SSAS big

Denis@nk;
In effect this example can be forgotten for it is not viable

5

Re: SSAS big

Shtepa wrote:

Denis@nk;
In effect this example can be forgotten for it is not viable

And at me the impression therefore was added too and asked a question

6

Re: SSAS big

Why so it is categorical? I tried to apply on , it was pleasant to me.