Here is the XFBR BR code that you can use to call in XFBR function in the cube view
Namespace OneStream.BusinessRule.DashboardStringFunction.CV_Formatting
Public Class MainClass
Public Function Main(ByVal si As SessionInfo, ByVal globals As BRGlobals, ByVal api As Object, ByVal args As DashboardStringFunctionArgs) As Object
Try
If args.FunctionName.XFEqualsIgnoreCase("ParentBold") Then
'Not working when usd with |MFAccount|
Dim AccountFilter As String = args.NameValuePairs("cvAccount")
Dim AccDimPk As DimPk = BRApi.Finance.Dim.GetDimPk(si, "CorpAccounts")
Dim AncestorID As Integer = BRApi.Finance.Members.GetMemberId(si, DimTYpe.Account.Id, "TotAccount")
Dim BaseID As Integer = BRApi.Finance.Members.GetMemberId(si, DimTYpe.Account.Id, AccountFilter)
Dim isBase As Boolean = BRApi.Finance.Members.IsBase(si, AccDimPk, AncestorID, BaseID)
If Not isBase Then
'BRApi.ErrorLog.LogMessage(si, AccountFilter)
Return "Bold=True"
End If
Return Nothing
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try
End Function
End Class
End Namespace
Hi Sridhar_M
If |MFAccount| does not work, how do you pass this information to the XFBR? If for example, cube is organized in the way that Row shows A#Account.TreeDescendantsInclusive how would you adjust XFBR or how do you gather 'cvAccount' so that finally only Parent Member is bolded?
Thanks
