Using Hierarchies (SAP Library - BW Statistics MultiProvider Queries)

Using Hierarchies

Technical name: 0BWTC_C10_Q018

Based on InfoCube: BW statistics MultiProvider (0BWTC_C10)

Use

The query Using Hierarchies (0BWTC_C10_Q018) shows, for each hierarchy, the key figures contained in the Last Use (Individual Record) (0BWTC_C10_S012) structure: the Number of Navigations (0TCTNAVCTR), as well as the date (0BWTC_C10_CK010) and the time of the last use (0BWTC_C10_CK011). Therefore, this query enables a quick overview of frequently used or no longer used hierarchies.

Filters

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0CALDAY	Calendar Day restricted to the characteristic value variable Tech.Cont.: Time Period, for which the data is selected, 0TCTDATS
0TCTOLAPACT	OLAP Processor Method restricted to the following fixed values: = ODBO (5) = Print in Batch (2) = Execute Query/ Navigation Step (1)
0TCTOBJVERS	Object Version restricted to fixed value = A

Free Characteristics

InfoObject	Description
0TCTIOBJNM	InfoObject
0TCTIOBJVAL	Characteristic Value
0TCTAGGRST	Aggregation Level
0TCTIOBJNM__0TCTIOBJTP	Last Change Content (see 0TCTIOBJNM InfoObject)
0TCTSYSID	BW System

Variables Used

Variable	Description
0TCTDATS	Tech.Cont.: Time period, for which data is selected

Rows

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0TCTHIEID	Hierarchy

Columns

InfoObject	Description of the InfoObject (Restriction or Calculation Formula)
0BWTC_C10_S012	Last Use (Individual Record)