1

Topic: Count Distinct from OLAP for SSRS

Prompt how more correctly to solve the task please.
Is OLAP a cube with flights of planes. Each embarkation is characterized as ++ embarkation. Everyone has the ID.
Everyone Id has a dial-up of values (type of passengers adults/children/babies) At each type are a class (business/house-keeper etc.) and as result an amount.
There are these Id as separate Dimention.
Prompt  if I need to count to-in passengers all flies. And here if it is necessary to count to-in flights (Count Distinct ID) performance falls at once. Because it is necessary to consider already on side SSRS. And to-in passengers on types it would be quite good to count.  narrow enough and it is clear that it not the task for OLAP. But as a special case it should be considered and 10 minutes as now are desirable not.
Example:
Id = 1, AD, Business - 20
Id = 1, AD, Econom - 80
Id = 1, CHD, Business - 10
Id = 2, AD, Business - 10
Id = 2, CHD, Econom - 50
On an output it is necessary to receive:
Flt Cnt = 2, Ad Cnt = 3, Count = 110
Flt Cnt = 2, CHD Cnt = 2, Count = 60
Whether it is possible somehow  for Kalkulejshen  or it unreal for a cube if it is not set any conditions?

2

Re: Count Distinct from OLAP for SSRS

SSRS - http://www.sql.ru/forum/reporting
SSAS - http://www.sql.ru/forum/olap-dwh
It is better to ask there

3

Re: Count Distinct from OLAP for SSRS

msLex, thanks! For a long time did not come here.

4

Re: Count Distinct from OLAP for SSRS

igor2222 wrote:

And here if it is necessary to count to-in flights (Count Distinct ID),

create from f aggregations DistinctCount on the basis of the table from which you do group of measures this you

igor2222 wrote:

Is these Id as separate Dimention.

Generally on OLAP here