The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

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
2 years 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
2 years ago

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