Calling parents of base members in a CubeView

SamKing
New Contributor II

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!

1 REPLY 1

Sai_Maganti
Contributor II

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.