I have defined a restricted key figure, which is global (created in the left panel).
The restriction is made on multiple single values of a characteristic, let’s say values A, B and C.
I would like to use this global restricted key figure to create different key figures in my query (local key figures), i.e.:
- Global restricted key figure + Local restriction on characteristic value A only
- Global restricted key figure + Local restriction on characteristic value B only
- Global restricted key figure + Local restriction on characteristic value C only
This means that I want to create additional local restrictions on this global restricted key figure.
Though, the given results show that the restrictions added in the local key figures are ignored (they are not taken into account and not applied to the global restricted key figure, which always shows a value equal to A+B+C).
To me, this behavior of the BEx is not correct.
Could you please explain how to cover this functional requirement?
It would not make sense to create 3-4-5-etc. global restricted key figures for each value, as I will have to repeat this process for many other values (D, E, F, etc) which I only want as local restricted key figures.