Skip to Content
Former Member
Mar 08, 2009 at 06:54 AM

BW Hierarchy in Crystal 2008


I have created a Crystal report from BEx Query that uses the Org Unit Hierarchy in the Headcount and Personnel Actions Cube.

The Group navigation allows me to expand/collapse different nodes on the hierarchy which is great and what the customer really wants. But the way the hierarchy is fully expanded on the preview panel is not what the customer wants to see. They expected to see a summary and each node of the hierarchy is drillable to the next node similar to the Group navigation for the hierarchy.

Is it possible to collapse the hierarchy nodes in the Preview Panel or only show the HierarchyGroupLevel which has value 1 and then drill down to the correct child from the parent node?

Or is it better to create a universe from the BW Query and use drill down in Webi?

Hope this makes sense.

Thanks in Advance.