How can we apply conditional formatting for a parent member which has it's children members.

Hi Radhika,

You can create two rows here , Row1 : A#Cash, Row2: A#Cash.Children, apply formatting only in Row 1.

Hope this helps.

Hi Radhika,

if you don't want to create separate rows, you could also use conditional formatting (e.g. using MemberName as filter).

thanks,

Noemi

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