05-13-2022
03:29 PM
- last edited
a week ago
by
JackLacava
Hi,
We're currently expanding on our CubeView & Dashboard reports available in the application & would like to display our performance by Country. Our cost locations are housed in UD1 with the base members being the individual cities and/or states & the immediate parents being the Country. Is there a way we can call the parents of base dimensions of the current UD1 selection? Currently we're able to build out a set structure for countries but if a user doesn't have security rights for a specific location their report will display other locations as 'No Access'.
Thanks!
05-16-2022 05:26 AM
This member expansion will work in a CubeView. The |!ParamBU1!| will display all the base members.
U1#|!ParamBU1!|.Parents
However, if you have multiple hierarchies then
U1#|!TargetBU!|.Parents.Where(Name Contains H1) assuming you have a prefix/sufix of H1 for the hierarchy you need.