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

JuleneDS's avatar
JuleneDS
New Contributor II
1 year ago

Stop Force Consolidate in Excel

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? 

Reports
No RepliesBe the first to reply