cancel
Showing results for 
Search instead for 
Did you mean: 

Help to fill BPS Cube with same data in a Cube with these conditions

Former Member
0 Kudos

Hi,

I need some help in implementing BPS in a small project. (Integrated Planning is not available).

An existing cube, Cube1 has: Year/month, Year, char1, char2, keyfig1, keyfig2

Keyfig1 is filled directly from R3 with actuals; keyfig2 (planned values) is filled manually filled with a monthly flat file load.

Now, there is a change in direction to fill keyfig2 through BPS features and bring in additional key figures all based on keyfig1.

Cube2 has been created only for the purpose of this BPS project. Cube2 was a copy of Cube1(with no data). For Cube1, I have created a Planningarea1 and PlanningLevel1; and for Cube2, Planningarea2 and PlanningLevel2 in BPS0.

How do I fill the BPS Cube2 with the same data as in BPS Cube1 with the following conditions:

keyfig1 : same as source value from R3 (not modifiable)

keyfig2 : modifiable by users only on the first and second of the month.

keyfig3 : keyfig1 * 1.1

keyfig4 : keyfig1 of previous Year/month

keyfig5 : same as source value from R3 (But modifiable)

keyfig6 : same as keyfig5 as of last day of 20th of the current month (not modifiable)

The goal is to create a multi planning area to join the two cubes. Hints all that will also be appreciated.

Thanks

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

You can fill all non modifibale kfs through cube update rules and can use BPS to fill modifiable kfs.

Plan kf2 and kf5 through BPS layout and other kfs through update rules.

Regards

Bindu

Answers (1)

Answers (1)

Former Member
0 Kudos

Your thought of having a multi area is right.

Create a multi area and being the basic areas to which you have assigned cube 1 and cube 2 underneath the multi area.

UNder your planing package, create a function of type Formula and create a parameter set like this:

= * 1.1.

Just this one line will is enough.

TO get keyfig 4 as previous month's key fig; you need another fox. To do this, you need to have a BPS variable to et previous month and use this variable in the parameter set.

Your fox will be like this.

DATA CURRMONTN TYPE 0CALMONTH.

DATA PREMONTH TYPE 0CALMONTH.

{KEYFIG4, CURRMONTH} = {KEYFIG1, PREMONTH}.

To make users modify only on days 1 and 2, you need to define a dara slice.

Ravi Thothadri