Skip to Content

Manual Planning using Data Store Object (DSO) in Integratd Planning


Purpose:


This document provides you how to do Manual Planning on top of a Data Store Object.


Business Requirement:

Performing manual Planning through Input ready query using DSO.

Please follow the below steps.

  1. Create Data Store Object.
  2. Load Data to the Data Store Object.
  3. Create an Aggregation Level.
  4. Create an Input ready Query.
  5. Perform Manual Planning.

Steps in detail:

1) Create Data Store Object


To start with the Planning on top of a DSO, the prerequisite DSO should be Direct DSO.

In the below screenshot, the Direct DSO (ZDS_PLAN) was created.

Screen1.jpg

Select the Planning Mode option in the settings.

/wp-content/uploads/2015/08/screen2_761322.jpg

2) Create an Aggregation Level.


All characteristics of the DSO objects need to be used in the aggregation level.

Exception: If a characteristic can be derived from the used characteristics by a characteristic relationship defined on the DSO then this characteristic does not need to be included in the aggregation level.


An Aggregation level (ZPL_GLV) was created with all the fields from the DSO.

/wp-content/uploads/2015/08/screen3_761324.jpg

3) Load Data to the Data Store Object


Since the DSO is Direct DSO, the data load was done through the APD (Analysis Process Design).

/wp-content/uploads/2015/08/screen4_761325.jpg

Data in Direct DSO shown below after execution of APD.

/wp-content/uploads/2015/08/screen5_761330.jpg

4) Create an Input ready query


  Create an Input ready query on top of Aggregation level which was created above.

/wp-content/uploads/2015/08/screen6_761337.jpg

Make Input enable the key figures on which the planning is going to perform. Here the price and Quantity key figures are input enabled.

/wp-content/uploads/2015/08/screen7_761338.jpg

Change the Query property to Change mode.

/wp-content/uploads/2015/08/screen8_761342.jpg

Add the required Info objects into the Rows and Columns.Save the query.

5) Perform the manual Planning


Execute the query to perform the manual Planning. Here the query was executed in RSRT transaction code.

/wp-content/uploads/2015/08/screen9_761343.jpg

The key figures which are set to Input enabled those will appear in different format like below and they are input ready.

/wp-content/uploads/2015/08/screen12_761346.jpg

/wp-content/uploads/2015/08/screen10_761344.jpg

Enter the values in the input ready cells and click on save.

The data will store in Direct DSO.

/wp-content/uploads/2015/08/screen11_761345.jpg

To report this post you need to login first.

4 Comments

You must be Logged on to comment or reply to a post.

  1. Mihaela Maris

    Hello Phani,

    Thank you for this document. Really useful and nice explained.

    Can you please let me know the minimum SP for the BW in order to to make the planning over a direct update DSO to work?

    I tried on BW 7.4 SP8 and the query is not working when i set the KF in the query designer as input ready. When the KF is ‘Not input ready query’ the query works.

    Thanks,

    Mihaela

    (0) 

Leave a Reply