Skip to Content
0
Former Member
Apr 02, 2014 at 05:54 AM

BPC conversion file

324 Views

Hi experts,

I am really newbie for this aspect. really need advice.

we usually using like below in conversion file:

external internal formula

* js:%external%.toString().replace(/\s+/g,"")

in transformation file:

*conversion

ACCOUNT=ConversionFile.xls!ID

is it possible to fetch data from other dimension in ConversionFile.xls ?

cause i have requirement to move data transaction between BPC cube with some logic.

as example,

- source transaction data:

ACCOUNT CP_REL ENTITY INTERCO

no_account cp1 e1 intc1

no_account cp2 e2 intc2

- logic process:

CP_REL ACCOUNT

cp1 a1

cp2 a2

- destination transaction data:

ACCOUNT CP_REL ENTITY INTERCO

a1 cp1 e1 intc1

a2 cp2 e2 intc2

what i want to do is, in account ConversionFile.xls, i want to fetch current data of CP_REL, if(%external%=cp1 then a1; a2)

thank you.