Possibility of TSCUBE for Initial Values

[former_member343632]

Hi,

I have a scenario where Planning Book contains initial value for some key figures.We take back up of the Planning Area data into a Cube.

Thing is when the data gets loaded into the cube, the initial values become "0" .

If we restore the data from the cube, the original initial values can't be restored and need to make each cell to blank manually.

How to overcome this. Is there any way that we can restore the  blank values also?

Thanks in advance....

Regards,

Prabhat

[former_member187488 · Accepted solution]

Hi,

The setting should be made in your APO datasource to avoid extracting initial values into infocube.
In t-code /SAPAPO/SDP_EXTR, specify the datasource and push "datasource properties" button, activate the "No extraction of data records without key fig values" flag.

Best Regards,
Ada

[former_member343632 · Accepted solution]

Hi Ada,

Thank you for your reply.

If we avoid extracting "initial values" then in case of data restore, how the TSCUBE will work?

My confusion is what values will sit in the cube so that while doing data restore, the cells in the planning book will have blank values.

Thanks in advance,

Regards,

Pankaj Sinha

[former_member187488 · Accepted solution]

Hi Pankaj,

If you mark that flag, for any cell with initial value, no record will be created in the cube.

Best Regards,
Ada

[former_member343632 · Accepted solution]

So Ada - no record will be created in Cube means while doing TSCUBE,the planning book will have blank values for those cells.????

[former_member187488 · Accepted solution]

If you run TSCUBE afterwards, these cells will not be updated by any value, which means if the cell is initial when you extract data (infocube will not have entry for this cell), and afterwards the cell is filled by some value, then you execute TSCUBE, the "some value" will not be overwritten.
If you want to make a full restore, you'll need to clean up all values before you run TSCUBE.

BR,
Ada

[kenneth_snyder]

I am not sure how BW can distinguish between Zero and Initial value.  In APO DP there is a setting to allow the differentiation.  But not sure if this same setting exists in BW.

[former_member187488]

No, BW can distinguish zero and initial.

[kenneth_snyder]

If he has setting in Planning Area to distinguish between Zeroes/Blank and BW can do the same, what is the issue?

Ken

[former_member343632]

The blank values becomes "0" in the cube so when when we do TSCUBE, the blank values in Planning Book are then changed to "0"