Forum Discussion

STDN's avatar
STDN
New Contributor III
2 years ago

How to add two dimension hierarchy in same row/column

Hi All,   I have a dimension hierarchy like Account1(parent) and Account2(parent) hierarchy members in Account Dimension and i need those base members in the same row/column. I tried adding those...
Cube View
NicoleBruno's avatar
NicoleBruno
Valued Contributor
2 years ago

Hi - are you trying to show the data based on the base level account but also show the base account's parent on the same row for reference? If so, you can use a UD8 (or wherever your random dynamic members are) member set up as a dynamic calc with a formula pulling the parent as an annotation member. You'd then pull that UD8 along with V#Annotation in the CV to show the account parent. 

We currently do this with our UD2 dimension so if this is what you're trying to accomplish and the formula would be useful, let me know and I'll share. 

  • rchaturvedi27's avatar
    rchaturvedi27
    New Contributor II
    12 months ago

    Hi Nicole NicoleBruno , Can you please share the formula you are using in UD8? I am doing something like this :

    Dim U2Filter As List(Of Member) = api.Members.GetBaseMembers( _
    api.Pov.UD2Dim.DimPk, api.Members.GetMemberId(dimtype.UD2.Id, "TopUD2"))

    For Each memberObj In U2Filter
    ' memberObj.Name is an actual String
    BRApi.ErrorLog.LogMessage(si, memberObj.Name)
    next

    but its not working out.

    • NicoleBruno's avatar
      NicoleBruno
      Valued Contributor
      11 months ago

      Hi - apologies but I left my role at Endo and no longer have access to the calculation. Sorry!