Skip to main content
B
Boer
Newcomer
November 17, 2022
Solved

Extensibility comparison

  • November 17, 2022
  • 1 reply
  • 0 views

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:

Extense.png

Somebody who already made/tried this? Or has a better solution?

Regards,

Arjen

 

Best answer by db_pdx

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.

 

1 reply

D
db_pdxAnswer
Contributor
November 17, 2022

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.

 

    Terms & ConditionsAccessibility statement