How Drilling through multiple Hierarchies works within a WebIntelligence document depending on the Scope of Analysis selected
[drilling] [drilling machine] [hierarchies] [well drilling]
Symptom
When drilling through multiple Hierarchies within a WebIntelligence report some objects are not shown/missing within the Hierarchy’s path when Scope of Analysis is "None" / "Custom"When drilling through multiple Hierarchies within a WebIntelligence report all objects are爏hown at all times爓ithin the Hierarchy’s path when Scope of analysis is "n Levels"
Reproducing the Issue
Business Objects XIR2, XI 3.0 and XI 3.1
In Designer:
Using eFashion universe create two new custom燞ierarchies (from Tools > Hierarchies):
H1 : Year, City, Month
H2 : Year, Category, Month
?2. Save and export the Universe into the Repository
See screenshot:
?
Create a new WebIntelligence document using eFashionSelect only Year as object and run the reportClick Drill icon to activate Drill modeClick on 2001: a window will open with the selection of the Hierarchies available. Choose H1 in order to drill down to CityClick on Austin: a window will open with the selection of the Hierarchies’ path available from the city Austin. Choose H1 in order to drill down on MonthClick on the arrow next the Month title:?a window will open with the list of Hierarchies availableAs you can see for H2 you can only drill up to Year but not爐o Category
燬ee screenshots:
Cause
This is爓hat happens in the background on the Scope of Analysis pane:
The default Scope level is "None". This means that very first time you create the report in the Scope of Analysis you’ll have, for each object爓ithin the Result Objects,爐hat same object repeated as many times as the number of the Hierarchies in which that object爄s present (in our case, the object Year is repeated three times for the Hierarchies Time Period, H1 and H2)The Scope level "None" preloads only the first object of the Hierarchy as this is the starting object for the drill. This choice saves space within the report and gives better performance too.Every time a drill down or a drill up is performed, the object chosen is loaded within every hierarchy in which it is present (Business Objects builds and stores the path of the Hierarchies during the drilling actions). Also the first time a drill action is performed the Scope level change into "Custom"This means that if two or more Hierarchies have the爏ame objects in common, especially objects in the middle of the Hierarchy’s path, if you drill down on path H1 then you cannot drill all the way up through the path H2 because Business Objects doesn’t know that some objects are missing in between.Example: drilling down into H1 loads the Hierarchies H1 and H2 in the following way:
H1 : Year -> City -> Month
H2 : Year -> (nothing) -> Month (the object Category has been left out)
This happens due to the combination of Scope level "None" and Hierarchies with objects in common
Resolution
This is a normal behaviour in Business Objects
Workaround 1)
Use?quot;One level", "Two levels" or?quot;Three levels" as Scope level.These Scope levels爌reload immediately one, two or three level of objects from爐he Hierarchies so Business Objects has already the whole path of the Hierachies and it’s possible to drill down on one path and then drill back up on the other. It needs to be considered that in this way the amount of data saved in the report is bigger and that performance can slow down.
See attachment:
Workaround 2)
When it’s time to save the document, reset the Scope level to "None" so the document will be purged and the situation comes back to the very begin.
See attachment:
See Also
Enhancement Request ADAPT01258195 has been created to change this functionality.