Using Hierarchies 
Using Hierarchies
Technical name: 0BWTC_C03_Q018
Based on InfoCube: BW Statistics - OLAP, Detail Navigation (0BWTC_C03)
Use
This query is suitable for display in a diagram. The graphic display enables a quick overview of hierarchy use.
Filters
|
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
|
0TCTIOBJNM__0TCTOWNER |
Last change Content (see  InfoObject) |
|
0TCTIOBJNM__0TCTDATTYP |
Last change Content (see InfoObject) |
|
0TCTOBJVERS |
Object Version
restricts to fixed value = A |
|
0TCTSTAUID |
Statistics Data UID
restricted to the navigation step (GUID) 0TCTSUID characteristic value varaible |
Free characteristics
|
InfoObject |
Description |
|
0TCTIOBJNM |
InfoObject |
|
0TCTIOBJVAL |
Characteristic Value |
|
0TCTIFCUBE |
InfoCube |
|
0TCTHIELEV |
Hierarchy Level |
|
0TCTSYSID |
BW System |
Variables used
|
Variable |
Description |
|
0TCTSUID |
Navigation step (GUID) |
Rows
|
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
|
0TCTHIEID |
Hierarchy |
Columns
|
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
|
0TCTSTAUIK |
Frequency |
Example
