For example if I have several metrics corresponding each to an allocation rule, and I want to define the allocation rule to be used for each entity of a company.
Is there a best way than using a SWITCH statement to associate a metric with a dimension.
In my example : SWITCH(Entities.Allocation Rule, “A”, ‘Allocation - A’, “B”, ‘Allocation - B’, ...)
It is not totally optimal because I have to update the formulas each time an allocation rule is added.
Thanks in advance !
Best answer by francoisView original