Analysis Members - Members With No Data.

Posted on 2007-08-09
Last Modified: 2011-04-14
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.
Question by:curtis591
    1 Comment
    LVL 3

    Accepted 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

    What Should I Do With This Threat Intelligence?

    Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

    Join & Write a Comment

    Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
    by Mark Wills PIVOT is a great facility and solves many an EAV (Entity - Attribute - Value) type transformation where we need the information held as data within a column to become columns in their own right. Now, in some cases that is relatively…
    To add imagery to an HTML email signature, you have two options available to you. You can either add a logo/image by embedding it directly into the signature or hosting it externally and linking to it. The vast majority of email clients display l…
    Internet Business Fax to Email Made Easy - With eFax Corporate (, you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…

    755 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now