Child pages
  • Non-Hana DB: Data Mart extraction from ncum InfoCubes
Skip to end of metadata
Go to start of metadata

Overview

In the following we discuss how to load data from an InfoCube(non-flat!) with non-cumulative key figures into another InfoCube with non-cumulative key figures (e.g. a copy of the source cube). See also note 2325774.

  • Prerequisites
    • Non-Flat Infocube (on Hana Database, flat cubes are the default) 
    • Source cube: InfoCube with non-cumulative key figures
    • Target cube: InfoCube with non-cumulative key figures
  • Three DTPs are needed
    • Extraction Mode: Initial Non-Cumulative for Non-Cumulative Values
    • Extraction Mode: Full
    • Extraction Mode: Delta
Processing Steps
  1. Assure that target InfoCube does not contain any data
  2. Compress all requests of source cube (F-table empty)
  3. Run a DTP with extraction mode 'Initial Non-Cumulative for Non-Cumulative Values' to load all reference points (recordtp=1).
  4. Execute compression of this request (in the target cube) with 'Marker Update'
  5. Run a DTP with extraction mode 'Full' to load all (historical) movements (recordtp=0)
  6. Execute compression of this request (in the target cube) WITHOUT 'Marker Update' !
  7. Execute the function module RSDV_VALID_RECREATE (see note 1548125 ). The parameter I_INFOCUBE must contain the name of the InfoCube and the indicator I_REBUILD_FROM_FACT must be set to 'X'.
  8. New requests with movements can be loaded into the source cube
  9. Run a DTP with extraction mode 'Delta' to load these new data records into the target cube. These requests have to be compressed WITH 'Marker Update' 
It is recommended to check the data in the tartget cube after each step with the help of transaction LISTCUBE (as done in the example below). 
Technical Definition
 
Read
Write
Ncum Init

 recordtp=1

requid=0 & uncompressed requids

 recordtp=1
Delta (Init)

 recordtp=0

requid>0 (only uncompressed requids)

 recordtp=0
 Full

 recordtp=0 

requid=0 & uncompressed requids

 recordtp=0
Background Information to the hanling of Non-Cumulative Key Figures

1548125 Interesting facts about Inventory Cubes

See also

375098 Data mart extraction from non-cumulative InfoCubes 

Example

Sreenshots from the DTPs

NCUM INIT:

 

FULL:   

DELTA

Content of Source Cube

Check the content with the help of LISTCUBE, use the selection 0recordtp=0-1 in order to get the reference points displayed as well.

We focus on the material M001. The marker(recordtp=1) has the value 140.The cube is fully compressed (requid=0). A query would display the current stock value -530 (e.g. for 28.08.2015) for the material M001.

We check the data in the TARGET CUBE after each processing step
After ncum initialization

You can see that only records with 0recordtp=1 were loaded into the target. After compression (with marker update): 

Only the field 0REQUID has changed.

After load of historical movements

You can see that only records with 0recordtp=0 were loaded into the target. All historical movements have to be compressed WITHOUT updating the marker!

After compression

After Delta load

New movements have to be compressed with marker update.

 After compression

 

 

  • No labels