SQL Server Performance

How to hide a member?

Discussion in 'Analysis Services/Data Warehousing' started by Joozh, Jan 14, 2005.

  1. Joozh New Member

    Hi,

    I have a dimension named Products with the following hierarchy:

    Type
    Sub Type
    Product


    Due to requirements I want that a particular product, whose name is "Blank Product" should not be displayed when the user drills down to the lowest level i.e. the Product level.

    I tried playing with the Advanced Properties tab but could not make any progress and thus will be grateful for help.

    Thanks.
  2. Raulie New Member

    Well you were on the right track in advanced properties for the dimension. You need to use the source table filter, but if your fact table is a view and all your dimension members are in the fact table then it could cause problems, I'm not sure test it out. You can also filter out the member at the database level.


    Raulie
    HP
  3. Joozh New Member

    Thanks for the reply.

    For this test scenario, my dimension is based directly on a table and not a view and I have tried the following in the source table filter (advanced property tab) but I get errors:

    "dbo"."tblProducts"."ProdName" <> "Blank Product"

    and also tried

    "dbo"."tblProducts"."ProdName" <> Blank Product


    Any clues?

Share This Page