WebI Hierarchy Issue
Need your help in resolving the hierarchy issue in WebI report pls., I've created a hierarchy path in a universe through IDT tool with the following levels,
Article -> Subclass -> Class -> Department -> Site -> Division.
When I create a WebI report on top of this universe and do a Start Drill option, the drill up option reflects on the same column. Rather I would require it to appear in levels of hierarchy in the expanded format. Attaching the screenshots for reference. Thank You in advance.
Matthew Shaw replied
Bit tricky to really understand. Try this:
Create a new report (tab) within the same document and add all the objects into one block (table).
Does this work ok?
If so, then add your breaks as necessary.
If not, then the 'dimension' 'Fiscal Week' isn't related to the other objects. How many queries (data providers) do you have within this document?