The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
PFowler
1 year agoNew Contributor II
Using Conditional Input to Suppress CV Columns
Hi All, As the name states above I'm trying to dynamically modify suppression settings on a column in a CV based on a value selected in a parameter. So for example let's say if a user selects an opt...
- 1 year ago
You would need to do this through an XFBR Business Rule and tying it into your CV Column Header format.
how to call XFBRs in a cube view.Namespace OneStream.BusinessRule.DashboardStringFunction.XFBR_Example 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 'how to call: XFBR(XFBR_Example,XFBRFunction,ParameterSelection=|!ParameterName!|) If args.FunctionName.XFEqualsIgnoreCase("XFBRFunction") Then Dim sParam As String = args.NameValuePairs.XFGetValue("ParameterSelection", String.Empty) If sParam.XFEqualsIgnoreCase("value1") Then Return "False" Else Return "True" End If End If Return Nothing Catch ex As Exception Throw ErrorHandler.LogWrite(si, New XFException(si, ex)) End Try End Function End Class End Namespace
Pete
1 year agoNew Contributor III
You would need to do this through an XFBR Business Rule and tying it into your CV Column Header format.
how to call XFBRs in a cube view.
Namespace OneStream.BusinessRule.DashboardStringFunction.XFBR_Example
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
'how to call: XFBR(XFBR_Example,XFBRFunction,ParameterSelection=|!ParameterName!|)
If args.FunctionName.XFEqualsIgnoreCase("XFBRFunction") Then
Dim sParam As String = args.NameValuePairs.XFGetValue("ParameterSelection", String.Empty)
If sParam.XFEqualsIgnoreCase("value1") Then
Return "False"
Else
Return "True"
End If
End If
Return Nothing
Catch ex As Exception
Throw ErrorHandler.LogWrite(si, New XFException(si, ex))
End Try
End Function
End Class
End Namespace
Related Content
- 1 year ago