cancel
Showing results for 
Search instead for 
Did you mean: 

Hide the Hierarchy sign in the workbook

Former Member
0 Kudos

Hi All,

I built a workbook with 15 tabs based on 6 queries at different drilldown levels.

Now I need to hide the hierarchy sign that appears on the worksheet so that the user can not click and expand them.

I searched thru SDN and found that we can do this on page load and page refresh . But I have no idea about the code and where I should place the code.

Can anyone help me with this?

Thanks

Sri

View Entire Topic
Former Member
0 Kudos

Hi Sri,

You can change the display settings of the hierarchy at the BEx Analyzer. Right click on the uppermost hierarchy node and there will be an option to deactivate hierarchy display.

Hope this helps,

Juice