Skip to Content
Author's profile photo Former Member

Snapshot Scenario on Stock Data with APD

Hi to all!

I recently was asked to share my knowledge of how to implement a snapshot scenario on stock data out of 0IC_C03 with Analysis Process Designer (APD) and here are the steps to take with screen shots of how the objects are implemented in our BW system (7.0) since 2009. All general information about the different approaches for analyzing stock data with cumulative and non-cumulative key figures are perfectly explained in the document “How to Handle Inventory Management Scenarios in BW (NW2004)” and therefore will not be mentioned in this blog of mine here.

(Note: To get a clear and distortion-free view of the pictures you might klick on them to open the viewer)

Update 2012-08-08: I added some information and picture regarding the data flow from DSO to InfoCube

Snapshot Scenario with APD on Stock Data of 0IC_C03

  1. Create Query for selecting the data out of 0IC_C03 that you want to have in snapshot CubeP01 Query.pngP02 Query.png
  2. Implement a DSO (type: direct update) for the data of your snapshot queryP03 DSO.png
  3. Implement an analysis process with APD (transaction RSANWB) and include an ABAP routine and transformation for mapping source and target fields:P04 APD.pngP05 APD.pngP06 APD.png
  4. Execute the analysis process to insert data to your DSO; Result log:P07 APD.png
  5. Implement a standard InfoCube
    P08 InfoCube.png
  6. Implement a dataflow from DSO to InfoCube by following steps
    1. Update Rule from DSO to IC (note: formula for field ‘Counter’ is constant 1, other fields are mapped 1:1)
      P09 DataFlow 1.pngP11 UpdateRule.png
    2. Generation of a DataMart DataSource for your DSO
      P09 DataFlow 1.png
    3. Creation of InfoPackage (within screen DataSources for your BI-System)P09 DataFlow I.png
    4. Creation of InfoSource
      P09 InfoSource.png
  7. Now you can update your DSO and InfoCube by Process ChainP12 ProcessChain.png
    1. ProcessChain: Program to start APD:
      P13 ProcessChain.png
    2. ProcessChain: InfoPackage to load data from DSO to InfoCube with OLAP variable for selection of current week

      P14 ProcessChain.png

    Assigned Tags

        Be the first to leave a comment
        You must be Logged on to comment or reply to a post.