TOGGLEDRILLSTATE error while using hierarchy

[Jithin V Stalin]

Hi Team,

I am seeing an issue while using hierarchies in a report. I am using a Product Hierarchies dimension to select the hierarchy dynamically in a report and the report works fine when i make a hierarchy selection using the Product Hierarchies dimension and the report switches the hierarchy based on my selection from Product Hierarchies dimension dropdown. But, when i drill any elements on the row up or down it generates a TOGGLEDRILLSTATE command in the MDX and throws an error(attached) when i change the hierarchy selection.

Please take a look into this issue.

[Jithin V Stalin]

Hi Team,

Is there any update on this issue??

[Ada Trajer]

Hi Jithin, to resolve this issue please enable Drive Full Refresh option for the Product Hierarchies dimension in the cube settings popup. With this option enabled the error should no longer appear.

‌

‌

[Jithin V Stalin]

Thanks you Ada! That fixed the issue.