Using Conditional Input to Suppress CV Columns

Question

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 option from a parameter I want to modify suppression settings on certain columns based on that selection choice. I have two questions:Is there a way to do this?If there is a way, how would this business rule/function be passed? In the CV? In the Cube?&nbsp;Thank You...Any assistance on this would be extremely helpful.&nbsp;

Pete · Accepted Answer

You would need to do this through an XFBR Business Rule and tying it into your CV Column Header format.&nbsp;how to call XFBRs in a cube view.&nbsp;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&nbsp;

Forum Discussion

Using Conditional Input to Suppress CV Columns

2 Replies

Related Content

Column suppression

Conditional Formatting on BWPercent column

Row Suppression Based on Columns Data

Conditional Statement in the Cube View Columns

Conditional formatting based on the value of different rows/columns