Hi Experts,
I am having an error while copying data from one app tp another using DESTINATION_APP.
This is my scenario:
I have an app - CC_App which has CC dimension. This CC dimension has an attribute "PC". My Master data values are:
ID EVDESCRIPTION PC
CC1 CC1 PC1
CC2 CC2 PC1
There is another app - PLANNING which has PC dimension. It has master data values as PC1.
So I am saying that CC1 and CC2 should roll up to PC1, using the attribute on CC1. These are two separate dimensions because of my design and cannot by put in a hierarchy. Eg: if CC1 and CC2 has 100 each, then PC1 in PLANNING App should show me 200.
My code is:
*XDIM_MEMBERSET TIME=2010.AUG
*XDIM_MEMBERSET VERSION=BUD
*XDIM_MEMBERSET MEASURES=PERIODIC
//*XDIM_MEMBERSET CC=CC.PROPERTIES("PC")
*XDIM_MEMBERSET InputCurrency=USD
*DESTINATION_APP=PLANNING
//*SKIP_DIM=CC
*RENAME_DIM CC=Profit_Center
*ADD_DIM CUR_TYPE=10
*WHEN CC.PC
*IS = "MOR_FOODS"
*REC(FACTOR=1)
//*REC(FACTOR=1,CC=CC.PC)
*ENDWHEN
*COMMIT
I have included this in my default logic. When I send data into the system, I am getting error "Root element is missing". Why so?
If I remove the // on
//*XDIM_MEMBERSET CC=CC.PROPERTIES("PC") and
//*REC(FACTOR=1,CC=CC.PC)
I get an error "Invlaid When/Endwhen"
Any early help would be highly appreciated.
Thanks.
Anand