Skip to Content
0
Former Member
Oct 26, 2010 at 01:41 PM

Error when using DESTINATION_APP and RENAME_DIM

31 Views

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