Hi everyone
We want to do a sign flip on an account to be applicable from a certain period. The sign flip must therefore not have an affect on historic periods. The requirement is as follows:
Perform a sign flip on an account data coming from a source system using a transformation rule complex expression where the month period is > 202412.
We would appreciate suggestion from anyone who has performed something similar in the past.
Thanks
Johan
You could do it in a Business Rule rather than a Complex Expression. Or you could add the Time dimension to an unused dimension on the Data Source. The maps for this unused dimension will always map to the same Target member (eg None) so the Time member has no effect on the target. You can then reference the source dimension member which contains the Time in the Complex expression.
I guess this depends on the type of import, but could you not use a parser rule on the amount? If the import is CSV based you can evaluate the other columns in the line. See example under "parser Rule" in design and reference guide here: Business Rule Types
