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
rchaturvedi27's avatar
rchaturvedi27
New Contributor II

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!