Forum Discussion

PFowler's avatar
PFowler
New Contributor II
25 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
    24 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