Hi,
Here is the scenario:
I have a calculated measures created in the story. I also have a dimension which has a hierarchy.
The issue is with “Calculated Measures”, which works fine at the base level but does the calculation at the Node-level too. This is the problem.
But when I'm defining the calculation at a model level, it is working fine.
The system (Calculated Measures) is not able to differentiate between Base-member & Node level, and calculation is applied at all levels of hierarchy which should not happen ideally as node level should aggregate the values of its lower memeber instead of performing the calculation for itself.
Anyone who has faced this similar kind of issues or knows the workaround for this? Their comments would be deeply appreciated.
Thanks