Disable Hierarchy Drill Down (OLAP)

Hello Dundas,

How do I disable Drilling down into a hierarchy without creating a cube perspective that contains only one level? Can I do this at the designer level? If so, how?

Thanks!

I just tried to find it myself but was unable to find it, if it is possible.

I have a feeling that knowing the use case that you are trying to do by disabling Hierarchy Drill Down we might be able to find a solution that for you.

Hi James,

Thanks for the response.

My use case is that I would like to provide in a visualization a top level overview without allowing the user to drill down into the hierarchy.

Hi Ryan,

The OLAP hierarchy levels can only be disabled by creating a cube perspective as you mentioned. Dashboard/metricset do not have such capabilities of managing hierarchy levels.
https://www.dundas.com/Support/learning/documentation/cleanse-consolidate-modify-data/create-a-cube-perspective

Regards,
Jay

1 Like