11-17-2022 11:03 AM
I know that there is the comparison utility, however I would like to compare extensibility in a cubeview. I am looking for a Dynamic Calc which gives me True or False if an account is part of the SummaryAccounts (compare the SummaryAccounts with the DetailedAccounts)
In the cubeview rows I will retrieve the A#DetailedAccounts.TreeDescendantsInclusive. In the columns I would like to have the dynamic calc which gives me true or false (in V#annotation) if part of the SummaryAccounts.
The result should look like this:
Somebody who already made/tried this? Or has a better solution?
Regards,
Arjen
Solved! Go to Solution.
11-17-2022 06:59 PM - edited 11-17-2022 07:00 PM
Hi Arjen: you can put this logic into a UD8 DynamicCalc and use it display in a QuickView / CubeView
Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId)
If viewMember.IsAnnotationType Then
Dim selectedAcct As Member = api.Pov.Account
Return BRApi.Finance.Members.GetAllMembers(si, BRApi.Finance.Dim.GetDimPk(si, "SummaryAccounts"), False).Contains(selectedAcct).ToString
End If
Its simply getting all members from your SummaryAccounts dimension and checks if the current account is in the list.
Make sure when you use this you are not suppressing zero/nodata rows and columns. Else, just run it next to data (U8#None, U8#WhateverYouNameThisHelper:V#Annotation) so it doesn't get suppressed.
11-17-2022 06:59 PM - edited 11-17-2022 07:00 PM
Hi Arjen: you can put this logic into a UD8 DynamicCalc and use it display in a QuickView / CubeView
Dim viewMember As ViewMember = ViewMember.GetItem(api.Pov.View.MemberPk.MemberId)
If viewMember.IsAnnotationType Then
Dim selectedAcct As Member = api.Pov.Account
Return BRApi.Finance.Members.GetAllMembers(si, BRApi.Finance.Dim.GetDimPk(si, "SummaryAccounts"), False).Contains(selectedAcct).ToString
End If
Its simply getting all members from your SummaryAccounts dimension and checks if the current account is in the list.
Make sure when you use this you are not suppressing zero/nodata rows and columns. Else, just run it next to data (U8#None, U8#WhateverYouNameThisHelper:V#Annotation) so it doesn't get suppressed.