Forum Discussion

SamKing's avatar
SamKing
New Contributor II
3 years ago

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 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!

Cube View
  • Sai_Maganti's avatar
    Sai_Maganti
    Contributor II
    3 years ago

    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.