Skip to Content
author's profile photo Former Member
Former Member

BPC: Conditional Formulas in Transformation Files, Possible?

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 02:18 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Aug 12, 2008 at 02:27 PM

    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...

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.