- changed component to Dashboard
TOGGLEDRILLSTATE error while using hierarchy
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.
Comments (4)
-
reporter -
reporter Hi Team,
Is there any update on this issue??
-
- changed status to resolved
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.
-
reporter Thanks you Ada! That fixed the issue.
- Log in to comment