-
show only non-empty dimension members?
greetings,
if I create a dimension from fact table, then it only has members which appeared in fact table. but if I create dimension from dimension table, then it shows all members, even those with no data. how can I show only those with existing data in member list?
thank you
-
Try selecting the id field in the fact table as your member key, with the member name defined as the name from the dim table - this is really the optimal way to do it anyway, and a "best practice" overall ...
It is also the basis of the Analysis Services "Optimize Schema" option, as I detail in my article at: http://www.databasejournal.com/featu...le.php/3487361
Good Luck!
Bill
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|