Using InfoCubes / Aggregates to Navigate 
Technical name: 0BWTC_C03_Q210
Based on InfoCube: BW Statistics - OLAP, Detail Navigation (0BWTC_C03)
Use
This
query is suitable for displaying as a diagram. The graphical display provides a quick overview of
how the InfoProviders and aggregates are used (see 
InfoCube).
Since
there can be several entries for a single navigation step, in the filter, the
Using InfoCubes/Aggregates to
Navigate query
uses the
Statistics Data UID (0TCTSTAUID) characteristic
restricted to the Navigation Step (GUID)
(0TCTSUID) variable.
This is filled from
the Filling Variables:
Navigation Steps for a Time Period (0BWTC_C10_Q001) BW statistics
query.
Filters
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
0TCTIOBJNM__0TCTOWNER |
Last
changed content (See |
0TCTSTAUID |
restricted to the navigation step (GUID) 0TCTSUID variable |
Free characteristics
InfoObject |
Description |
0TCTSYSID |
|
0CALDAY |
restricted to the characteristic variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS |
Variables used
Variable |
Description |
0TCTSUID |
Navigation step (GUID) This variable is of the characteristic value variable type with the replacement path processing type. It refers to the statistics data UID (0TCTSTAUID) characteristic. The replacement is made by the result of the BW statistics query Filling Variables: Navigation Steps for a Time Period (0BWTC_C10_Q001). |
0TCTDATS |
Tech.Cont.: Time period, for which data is selected |
Rows
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
0TCTIFCUBE |
restricted to fixed value “Exclude # from Selection”, meaning all the records that have not been posted or all the entries that have not been assigned are excluded |
Columns
InfoObject |
InfoObject description (and restrictions or calculation formulas) |
0TCTSTAUIK |
Example
