Skip to end of metadata
Go to start of metadata
Online Help:

SAP BW Modeling User Guide - Master Data Types: Attributes, Texts and Hierarchies

BW characteristics can have:

  1. Time-dependent Texts
  2. Time-dependent Attributes
  3. Time-dependent Hierarches (this topic is dicussed here..)

Once time-dependency is used for texts/attributes of chracteristics, it is possible to define the validity of text or attritbute value by maintaining the corresponding DATEFROM and DATETO fields. The latter fields are getting added automatically once time-dependency is active.

When executing a query time-dependent text/attribute values will be displayed in accordance to the key date used by the query.

The query key date to be used can be defined during query design time (Bex QueryDesigner, BWMT - BW Modeling Tools).
For details see Online Help: SAP BW Modeling User Guide - Screen Area

1. Time-dependent Texts - Example

  • Transaction RSD1 (in newer releases BWMT is to be used) 
  • Display e.g. delivered Characteristic 0COSTCENTER

Tab Master Data/Texts

 

Text Table /BI0/TCOSTCENTER

Query Example

Query Definition - FiltersQuery Definition - Rows/Columns

Query Execution - Select variable value

Key Date: 01.01.1990

Query Execution - Select variable value

Key Date: 01.01.2000

Query Result - Key Date: 01.01.1990

Query Result - Key Date: 01.01.2000

2. Time-dependent Attributes - Example

Tab Attributes

 

Table /BI0/QCOSTCENTER (containing time-dependent attributes)

Query Example


Query Definition - FiltersQuery Definition - Rows/Columns

Query Execution - Select variable value

Key Date: 01.01.1990

Query Execution - Select variable value

Key Date: 01.01.2000

Query Result - Key Date: 01.01.1990

Query Result - Key Date: 01.01.2000

3. Time-dependent Hierarchies

 

  • No labels