Time dependent mappings

This depends on whether you need to re-transform previous periods. If you do not need to, then you just update your mappings in Dec 25. The actual mappings that were used to transform the data is saved so you will not lose the previous periods' mappings. If you do need to re-transform previous periods then the easiest way is to use a Complex Expression. Use args.GetSource("T#") or args.GetTarget("T#") to get the Time member and then process that according to the period. You can search this forum for GetSource and GetTarget for more info and examples.

Thanks Marcus

I have a simple snippet below, but I am try to skip over the rule in the else section. Is this possible?

Mark

Dim currTime As String = args.GetTarget("T#")
Dim compTime As String = "2025M12"

If TimeDimHelper.GetIdFromName(currTime) < TimeDimHelper.GetIdFromName(compTime) Then
    Return args.OutputValue
Else
    'Skip over to the next rule
End If

Yes - you don't need an Else section. If the transformation rule does not return a value, it is effectively skipping that rule.

When I try that it returns a 0 in the output

I believe we used composite rules to accomplish this at a previous company though I don't have an example to provide, sorry. We did this so that if we had to reimport prior data, the mapping rules stayed in place and were an obvious reminder of why the data mapped a certain way for a certain period.