on 02-19-2009 7:17 AM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.