Hide Element (Attribute) column at Drill up level


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


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.



    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


    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]}


    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.




    Reply Like 1
  • Michael Raam 





    Vijay Patel

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