Hide Element (Attribute) column at Drill up level

Hi,

Any suggestion ,how to hide element (attribute) in report based on condition ?

I have financial class Column which I want to hide when  other columns at drill up level 1 (top) and display only when drill up at lower level 3rd OR 4th)

in SSAS they have those properties that Hide member if parent level are blank OR NULL

Thanks

3replies Oldest first
  • Oldest first
  • Newest first
  • Active threads
  • Popular
  • Vijay,

     

    To assist understanding your question, please provide some more detail, perhaps a mocked up screen shot or two. We do fully support SSAS capabilities but I don't think hide member will address your request.

     

    JohnH

    Reply Like
  • Hi Vijay,

    If I get your scenario you would like to show different columns based on drill up/ down on rows.

    For this scenario let me suggest the following option.

     

    1. Create a MDX expression that returns the level of the items on rows.

    Exmaple: AXIS(1).ITEM(0).LEVEL.NAME

     

    2. Once you have the level value you can use it to create a dynamic set on columns

    Example:

    case
    when AXIS(1).ITEM(0).LEVEL.NAME = "Year"
    then {[Measures].[Cost], [Measures].[Discount], [Measures].[List Price], [Measures].[Over Head], [Measures].[Price]}
    else {[Measures].[Sales Discount], [Measures].[Net Profit per Item], [Measures].[Net Profit], [Measures].[Profit per Item]}
    end

     

    When the level on rows is "Year" the year related measures are displayed:

     

    When drilling down from the "Year" level to the "Quarter" level a different set of measures are displayed.

     

    Please let us know if this is what you had in mind.

     

    Tnx,

    Michael

    Reply Like 1
  • Michael Raam 

    Micheal.

     

    Thanks.

     

    Vijay Patel

    Reply Like
login to reply
Like1 Follow
  • Status Answered
  • 1 Liked by
  • 1 mth agoLast active
  • 3Replies
  • 63Views
  • 3 Following