Child pages
  • BWonHana: 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 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
    • Source cube: hana optimized InfoCube with NCUM_REFP_UPD=Y (see note 2097535)
    • Target cube: hana optimized InfoCube with NCUM_REFP_UPD=Y (see note 2097535)
  • Three DTPs are needed
    • Extraction Mode: Initial Non-Cumulative for Non-Cumulative Values
    • Extraction Mode: Full with Paramter ‘Historical Data Transactions’
    • Extraction Mode: Delta
Processing Steps
  • Assure that target InfoCube does not contain any data
  • Execute DTP with Extraction Mode ‘Initial Non-Cumulative for Non-Cumulative Values’. All reference points (0recrodtp=1) are retrieved and written into the target cube
  • Compress this request in the target InfoCube
  • Execute a 'Full' extraction with Parameter ‘Historical Data Transactions’. All historical movements (0recordtp=2) are retrieved from the source cube.
  • Compress this request in the target Cube (reference points(marker) aren’t updated since all these historical movements have already been taken into account).
  • Execute the function module RSDV_VALID_RECREATE (see note 1548125 ). The parameter I_INFOCUBE must contain the name of the target InfoCube and the indicator I_REBUILD_FROM_FACT must be set to 'X'.
  • Run DTP with Extraction Mode 'Delta' in order to get the uncompressed movements from the source cube
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
 ReadWrite
Ncum Init

 recordtp=1

requid=0 & uncompressed requids

 recordtp=1
Delta (Init)

 recordtp=0

requid>0 (only uncompressed requids)

 recordtp=0
Full with 'Historical Movements'

 recordtp=2

requid=0 & uncompressed requids

 recordtp=2
 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

Example (BW75 system based on Hana)

  • Source Infocube ZATSTPEC1
  • Target InfoCube ZATSTPEC4

 

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-2 in order to get the reference points displayed as well.

 

We focus on the material M001 (there are 4 materials in this simple test cube). The marker(recordtp=1) has the value 10. There is one historical movement(recordtp=2) and one uncompressed new movement. A query would display the current stock value 14 (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:  

Only the field 0REQUID has changed.

After load of historical movements

You can see that only records with 0recordtp=2 were loaded into the target.

After compression

Please note that the marker(reference points) weren’t updated since all these historical Movements have already been taken into account!

After Delta load

After compression

Please note the following: - 0recordtp was set to 2 - 0requid was set to 0 - Reference points were updated (e.g. material M001: from 10 to 14)

 

 

  • No labels

1 Comment

  1. Hello Peter Stockinger, A really nice information to shared.