Printable View
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