Sanjay Shah
New Member
- Joined
- Jan 30, 2008
- Messages
- 26
Is there any way in which dimension members which dont have any associated facts can be hidden? For example lets say that I have 1000 Products which are in my Product Master (dimProduct). However if in my fact table there are only say 250 of these products. yet the Excel Pivot table (reporting on the SSAS cube) in the page filter shows all the 1000 products. If the product dimension is dragged to the row level, it shows only the 250 products. Is it possible to show just the 250 products at the page filter level also ?
This was the default behaviour when we built an Excel Pivot table from a relational source, but when we build it from an SSAS source we get this problem.
Any help would be very much appreciated.
Sanjay Shah
sanjay@prosysinfotech.com
This was the default behaviour when we built an Excel Pivot table from a relational source, but when we build it from an SSAS source we get this problem.
Any help would be very much appreciated.
Sanjay Shah
sanjay@prosysinfotech.com
