here's the situation:
I have 2 hierarchies on the ENTITY dimension HirA describing company structure (e.g incl area, country etc), the second hierarchy HirB is build up aggregating each base member to departments (independent from country etc)
In a report I defined a fix structure showing different departments (from HirB) in rows (using option NOEXPAND).
Now I want to restrict additionally to countries (via CV).
But it always shows all data for the defined node of HirB.
Is there a way to have a dynamic selection?
I cannot rebuild HirA and HirB as they are loaded from R/3 -> BW and maintaining them in BPC in case of changes is no option for the customer...
Please also ask for more details, if necessary.
Thanks and regards