BPC: Conditional Formulas in Transformation Files, Possible?

[Former Member]

Hi All,

I have an issue where I have a standard conversion file for the Account dimension, however for certain accounts the account is also dependent on the Entity ID. Rather than writing several conversion files to maintain for each entity I am wondering if the following is possible:

Is it possible to write some sort of conditional formatting in the transformation file such as:

If (stringAccount)= "XXX" then (stringAccount) + (stringEntity) and go pick up conversion file A, else (stringAccount) and pick up conversion file B

Conversion File A would have Entity/Account combo as the External account, and the Internal account would be the account for that specific Entity. (I actually have this stored as a property on each entity but currently its assumed that some sort of dynamic EVPRO/property defintion will not function in a conversion file.)

Conversion File B would be my standard conversion file.

I am thinking that I this might be possible but need assitance in the syntax for the transformation file.

Any help is greatly appreciated!

Brian Tyson

Edited by: Brian Tyson on Aug 12, 2008 9:48 AM

[Former Member]

I think I have figured out how I am going to do this, my co-worker suggested the solution is more simple than I was making it out to be:

my transformation file will be:

Account= Accountstring + Entitystring

then int he conversion file i will have the following:

1001* 1001

1002* 1002

1003EntityA 1013

1003EntityB 1023

1003EntityC 1033

1004* 1004

Only thing is that I will have to hardcode, rather than using the property...

[Former Member]

Hi Bryan,

It is possible to use conditional formulas in the transformation file, I have used this quite a lot, but I don't think you can use them to dynamically call a conversion file. So unfortunately I don't think this approach will work either. But maybe the others have good ideas before you have to dive into SSIS to fix the problem

Joost