Forum Discussion

KK2012's avatar
KK2012
New Contributor III
3 months ago

omit a derivative rule, but only for a specific period

Hi,

I’m currently working on a project where I need to omit a derivative rule, but only for a specific period. I'm looking for the most effective and clean way to achieve this without disrupting other rules or calculations that remain in effect.

Does anyone have experience with this or suggestions on how best to approach it? I’d appreciate insights on both technical implementation and best practices to ensure future maintainability.

Thank you, 

Transformation
  • MarcusH's avatar
    MarcusH
    Contributor III
    3 months ago

    I find that the easiest way to manage Transformation Rules which need to vary by period is to bring the period into the stage data. Select a dimension that currently maps all records to a single member (e.g. Mask * to None). This means that anything you import into this dimension will not change the Cube data. Add a Logical Operator | Business Rule to that dimension on the Data Source that brings in the current period. And you can then use that in the Derivative rule. If you want to exclude a particular period you might want to bring in something like M1-Yes, M2-Yes, M3-No etc so that you only have one record in the Derivative Rule.

  • MG's avatar
    MG
    Community Manager
    2 months ago

    Hi KK2012 

    Did you manage to solve this? Did MarcusH solution work or did you try something else?