Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2003
    Posts
    163

    Unanswered: Can I hide displaying a certain member?

    Hi,

    I have a dimension called customers having the following levels:

    ALL
    Level 1 CustType
    Level 2 Cust Rank
    Level 3 Cust Name

    Suppose that the possible CustTypes are "Potential", "Active", "Lost".
    Is it possible to hide displaying Level 1 and below if the Custtype (Level 1) = "Potential"

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    create a view on the table like select col1,col3 from the table and access the view.
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Oct 2003
    Posts
    163
    Thanks for the reply. Yup it seems that the view approach is what I will have to go with.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •