• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 143
  • Last Modified:

Analysis Members - Members With No Data.

I am building a cube and I have created a dimension called country.  Our country table has many entries in it as it used by multiple systems for different things.   In regards to my cube there are only a couple of countries that have data related to them.  When I am looking at the data and I click the drop down to do a filter it is showing me every country.  Is there someway that you can hide all these extra members so that the users do not have a list of 50 countries that don't mean anything to them.  Basically I only want to show the members that actually have data against them in the cube.
1 Solution
Write a view that only gets the list of countries that are used (so create a dimension from the FACT table).  In the Data Source View design, call this view to create your dimension table.

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now