Stop Force Consolidate in Excel

JuleneDS
New Contributor

I am stopping users from running forced calculate/translate/consolidate with the following in "WcfEventHandler". 

If args.IsBeforeEvent AndAlso (args.WcfServiceType = WcfServiceType.Calculate) AndAlso (args.OperationName="CalculateChartLogic" OrElse args.OperationName= "StartConsolidation" OrElse args.OperationName= "StartProcessCube" OrElse args.OperationName= "Translate" ) Then
				Dim isForced As Boolean = args.inputs(2)
					If isForced = "True" Then
						args.Cancel = True
						Throw New XFException(si, New Exception("You do not have access to Force Calculate/Translate/Consolidate."))		
					End If	
	   		 End If


How do I stop users from running these functions in a report in excel? 

0 REPLIES 0