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.
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?