cancel
Showing results for 
Search instead for 
Did you mean: 

Actual Key Figure in Planning Function

Former Member
0 Kudos

Hi,

I am not able to calculate a planning Key figure using a actual key figure, Is it not possible? My design is : Aggregation level on multiprovider which contains actual and plan cube

Thanks

Amit

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Yes, it is very much possible. There must be something wrong in your calculation.

I just differ a bit from above post a). The actual should not be neccessarilly in the filter because this you need for read purpose only. You may or may not lock this Key figure.

Thanks...

Shambhu

Former Member
0 Kudos

My code is :

DATA A1 TYPE 0INFOPROV.

DATA A2 TYPE ZGBB1.

DATA A3 TYPE ZPRC_LVL.

FOREACH A2,A3.

IF A1 = 'ZICHMPA1'.

ZPY_SLS = ZPY_SLS + ZPY_SLS * 20/100

{ZCY_SLSA, 'ZICHMPP2', A2, A3} = {ZPY_SLS, ZICHMPA1, A2, A3}.

ENDIF.

ENDFOR.

Operand:{Key figure name, 0INFOPROV, ZGBB1, ZPRC_LVL}

Here multiprovider is on ZICHMPA1 (Actual) and ZICHMPP2 (Plan) cube. I am trying to copy ZPY_SLS + ZPY_SLS * 20/100 (ZPYSLS is actual Key figure) to ZCY_SLSA (Plan key figure). Following is the error after check formula.

Formula error: Characteristic-dependent operand expected instead of ZPY_SLS

Syntax error in row 19, column 1

Pls help

Thanks

Amit

Former Member
0 Kudos

Hi Amit,

You can try this.

DATA A1 TYPE 0INFOPROV.

DATA A2 TYPE ZGBB1.

DATA A3 TYPE ZPRC_LVL.

DATA Z1 TYPE F.

Z1=0.

FOREACH A2,A3.

IF A1 = 'ZICHMPA1'.

Z1 = {ZPY_SLS,ZICHMPA1,A2,A3}.

Z1 = Z1 + (Z1*20/100).

{ZCY_SLSA, ZICHMPP2, A2, A3} = {Z1, ZICHMPA1, A2, A3}.

ENDIF.

ENDFOR.

Regards

Snehith.

Former Member
0 Kudos

Hi,

I tried this code now it gives the error that variable Z1 should be of type key figure name. But when i am trying to define Z1 of type key figure its not taking that.

error is in the line

{ZCY_SLSA, ZICHMPP2, A2, A3} = {Z1, ZICHMPA1, A2, A3}.

Formula error: Variable must be type KEYFIGURE_NAME

Thanks

Former Member
0 Kudos

Hi Amit,

Try this

{ZCY_SLSA, ZICHMPP2, A2, A3} = Z1.

Regards

Snehith.

Former Member
0 Kudos

Try this:

DATA A1 TYPE 0INFOPROV.

DATA A2 TYPE ZGBB1.

DATA A3 TYPE ZPRC_LVL.

FOREACH A1,A2,A3.

IF A1 = 'ZICHMPA1'.

{ZCY_SLSA, 'ZICHMPP2', A2, A3} = {ZPY_SLS, A1, A2, A3} * 1.2.

ENDIF.

ENDFOR.

Former Member
0 Kudos

Hi,

yes, it is possible. I assume you are using FOX:

a) Make sure that both your actuals and plan data are in the filtered data! It is not sufficient to only filter to the plan data, because then actuals will not be available within fox.

b) make sure that both actuals and plan data come in the same package in FOX: So e.g. make both actuals and plan data "Fields to be changed". This includes version, value type or whatever you have to distinguish actuals from plan.

If this does not help, please provide details of what exactly you are doing.

Regards,

Andreas

Former Member
0 Kudos

I have a doubt in IP with the following scenario..

I have the following keyfigures in my Basi cube(ZIC_BASIC)

PYSales

PYWOP

Following keyfigures in my Transactional cube(ZIC_TRANS)

CTNOTSLS

CYWOP

I have created a multiprovider(ZMULTI) on both cubes --> Aggregation level(ZAGGR) bulit on this multiprovider

MY Planning Function is as follows

CYNOTSLS = PYSALES * (CYWOP/PYWOP)

If I write a planning function with the below code will it work

{CYNOTSLS,ZIC_TRANS} ={ PYSALES,ZIC_BASIC} * ((CYWOP,ZIC_TRANS}/(PYWOP,ZIC_BASIC)).

I have a doubt whether I can do planning function with plan and actual cubes. Please do the needful.

One more doubt is when I design a query on this multiprovider with my plan keyfigures as input ready and start the query in change mode also. Inspite of that input ready is not available for my query.

Thanks in advance,

Pushpa M