Forum Discussion

PFowler's avatar
PFowler
New Contributor II
6 days ago

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...
  • Pete's avatar
    5 days 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