Results 1 to 2 of 2

Thread: show only non-empty dimension members?

  1. #1
    Join Date
    Dec 2004
    Posts
    5

    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

  2. #2
    Join Date
    Jun 2004
    Location
    Atlanta and Manhattan
    Posts
    607
    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
  •