Calling parents of base members in a CubeView
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...
Forum Discussion
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.