Reference other dimensions in the conversion file

[Former Member]

Hi all,

Is it possible to refer to other dimensions in the conversion file?

Assume I have the following dimensions: DIM1, DIM2, DIM3.

In the conversion file for DIM1, this is what I want to do:

INTERNAL, EXTERNAL, FORMULA

*, if([DIM2]="X", 1, 0)

I.e. I want to be able to check the values of other dimensions in the conversion file...

[Former Member]

SM.

You actually can do this before it gets to the conversion file by using an *IF logic on the dimension you are passing to that conversion sheet. You can find examples in the help file for the transformation files on how to apply this formula.

Here is an example that I have for passing a particular column for a dimension. This is in the *MAPPING section of the transformation file.

PROFIT_COST_CENTER= IF(STR(CC)*COL(11)STR(PC)+COL(12)=CCPC then *STR(PC_00000); STR(CC)+COL(11)=CC then STR(PC)+COL(12);STR(CC)+COL(11))