We are under construction!
You may experience downtime, errors or visual oddities, but we anticipate all will be resolved by the end of the day.
Forum Discussion
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,
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.
