A hierarchy is a set of data members arranged in levels or parent-child relationships
For example, a [Geography] hierarchy might contain the [Country], [State] and [City] levels
Hierarchies produce hierarchical columns in the result set produced by the query.
You can expand the items in the hierarchy to explore its data.
For example, you can expand the [California] level in a [Geography] hierarchy to explore data related to California.
You can select which members appear in the result set by using the Member Selector.
In hierarchical data sources, hierarchies are associated with a dimension and appear beneath the dimension with which they are associated in the list of available objects.
How they work
They normally come from hierarchical data defined at database level and accessed through OLAP Universes or BEx queries.
When accessing RDBMS sources they are commonly called hierarchies, but technically they are navigational paths.
Best practices - How to's
Accessing SAP Hierarchies in Webi with Opendocument and REBEAN
Impact of a BEx query change to universes and WebI documents
Web Intelligence 4.0 and time-dependent hierarchies
SAP Notes on "Consulting" Category. Application Area-BW-BEX-OT-F4
Differences in SAP-BI (BEx) and BO Reports
BI 4.0 SP05
Hide hierarchy objects in Webi BOE SP2+14 it was working now after system was upgraded to 16 & 17 is not available
BW Hierarchy Node value selected in a prompt shows full path in HTML viewer, only the value in all other viewers/editors
"Incorrect results in Window of ""Ambiguous Hierarchy for Drill"" in Web View mode."
hierarchy display in WebI
Hierarchical node default selection for variables are not supported by DSL
Not able to see Calculated Key Figure (CKF) under hierarchy structure
Hierarchy issue with Patch 4.2
Cannot run duplicated queries containing hierarchical objects
Useful KBs, Notes
Webi report filters based on hierarchies display all values when none are expected
Error: "An internal error occured while calling 'processDPCommandsEx' API. (Error: ERR_WIS_30270) (WIS 30270)" when refreshing WEBI report with a hierarchy object.
DHTML viewer: Hierarchy node variable LOV non-responsive in a Webi report
'List of values for current prompt requires value for following prompts' in prompt in WebI coming from a BEx hierarchy node variable.
BEx hierarchy variable is displayed in a flat list instead of in a tree hierarchy structure in Webi prompt
Linked nodes of an SAP BW Hierarchy are not supported in Webi (accessing BEx query via BICS) in BI4.0
Cannot select any node as prompt answer for prompt on hierarchy object in a Webi report
In WebI 4 how to change the display of hierarchy nodes and hierarchy node values in a prompt generated from a hierarchy node variable
WebI reports incorrect after BW 7.1.5 upgrade: Cannot drill below Level 5 of Hierarchy
Sort order of hierarchy node members is not the same in WebIntelligence as the source system (SAP R/3, SAP BW)
Unable to apply a Custom Sort on Hierarchical Dimensions
|1694760||Hierarchy expansion behavior set at BEx query level does not replicate in BI Launchpad|
Frequently Asked Questions:
Q.: Is it possible to display parent levels at the bottom of the results (by default they are at the top) i.e.:
A: No, at present the order is predefined and cannot be customized