DP Realignment - 1

DP realignment is a option to adjust data in planning area data as per business scenarios like changes in product hierarchy or sales hierarchy or a new product replacing old one. The main advantage of realignment over copy is that realignment creates the target CVC’s if they are not available in the POS.

Let us consider a master planning object structure TEST_POS as shown below.    (/sapapo/msdp_admin)

A planning area  TEST_PA is created on the TEST_POS

The planning area is initialized for 000 version.

The POS has two CVC’s one each for product P1 and P2.

Before realignment

As seen in the planning book ,sales history is available with the old product P1.But to generate the statistical forecast ,it will advisable to move all the sales history of Product P1 to product P2..

T-code for realignment  :/sapapo/rlgcopy

Click on Create/ Change Table to select the characteristics for realignment .This is a one time activity .Once the realignment table is created ,click on Maintain entries tab.

Delete Source option will result in deletion of source CVC’s

Copy factor can be used to make changes in the effect of realignment .The default copy  factor is 100 which is for 1:1 copy of data.

Business Scenario:

If a new product is expected to sell about half of the old product then the factor is changed to 50.

Copy logic: Copy logic=M is for overwrite the existing destination CVC  data with source CVC data  and Copy logic=A is for adding  the existing destination CVC  data with source CVC data.

Business Scenario:

If a company has two similar products P1,P2 and  P1 is being discontinued,then Copy logic =A can be used.This is due to the fact that sales of the discontinued product will be compensated by increased sales of P2  

Click on save and then the realignment step will be ready for execution.

After that click execute  in the realignment main screen

As seen in the screen shot realignment could not be executed due to locking .When users are work in the edit mode planning book then POS gets locked.

This happens in large implementations when  users are working in different time zones.So to execute the realignment time window needs to be given by business.

After all the users are out of planning book or change to display mode  realignment can be executed and same is visible in the logs shown below.  

As show below ,sales history has been copied to destination product P2.

To address the issue of locking info-cube realignment can be used .

The additional step of info-cube realignment is creation of  planning area extraction flow which is explained below.

Goto S&DP Administration (/sapapo/msdp_admin)  and select planning area .Go to change planning area.

Click on Data Extraction tools as shown

Click on Generate Data Source.Give the name of the data source .All the planning area data sources will start with 9A.

Now select the fields for data selection and hide the ones that are not needed. Usually  proportional factors is not extracted from planning area.

Planning area data source will be generated as show below.

Click on Data backup

Give the name of the backup cube and info-area

Click No to exclude proportional factor.

Info-cube will be successfully activated as show below

Info-cube will be visible in the specified info-area in RSA1

Now the 9A data-source has to replicated as show below.

Data source needs to replicated either as BI7 data source or 3X data source

The below screen shots are for BI7 flow

If the data-source is inactive then activate the same.

Now transformations needs to be created from data source to the backup cube

Create DTP to load the data from PSA to backup info-cube

Create Info package to extract the data from planning area to PSA.

As shown below 254 records are extracted from planning area to  PSA.

Execute the DTP to load the data from PSA  to Info-cube.

To use the  option of info-cube realignment ,click on choose info-cube and select the backup cube PA1. 

Finally all the steps of cube realignment can be automated  with a process chain as shown below.

The CVC Creation step in the process chain is needed as the realignment when executed in the info-cube does not make any changes in the POS or planning area. Also note that Delete Source option will not  delete of source CVC’s in the POS  but will make the data for source CVC’s in backup cube to zero.