11-08-2023 09:45 AM - last edited on 11-08-2023 11:23 AM by JackLacava
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 members and got below error, can anyone suggest how to resolve this.
Thanks in Advance.
11-08-2023 02:17 PM
Hi,
If I understand your question right you are trying to have two different accounts on the same row of your cube view, so Acc A and Acc B would be side by side.
I imagine Acc A and B would have different data against them so not sure what you'd like the cube view to display, in terms of data, for that Acc A, B row?
11-09-2023 11:28 AM
If you're trying to list both in a row OR column, you would list the member filters in the same expansion. You cannot use one dimension (e.g. Account) in both a row and a column.
Good:
Bad:
11-14-2023 12:32 PM
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.
01-12-2024 08:45 AM - edited 01-12-2024 09:23 AM
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.
01-29-2024 04:10 PM
Hi - apologies but I left my role at Endo and no longer have access to the calculation. Sorry!