Calculate entity on the various members of the Consolidation dimension
In the project where I am currently, in the entity dimension there is the following hierarchy:
The requirements are:
Ent1, Ent1_Y, Ent2, Ent2_Y and Ent3 data will be input and will be consolidated applying the consolidation rules.
Ent_X will be calculated, being the difference between the entities defined in Perimeter_1 and Perimeter_X. The difference will be calculated across all members of the Consolidation dimension.
Have you ever parameterized something similar? Is it possible to do this in FCCS? That is, the values will be correct? Or is it not good practice?
I'm not sure if it's possible to parameterize this in FCCS.