Skip to main content
June 18, 2020

Security Question - can we block users from submitting data in excel? We want to prevent a user from submitting planning data on certain UD members

  • June 18, 2020
  • 3 replies
  • 0 views
Originally posted by Michael Malandra

1/23/2018

Security Question - can we block users from submitting data in excel? We want to prevent a user from submitting planning data on certain UD members

3 replies

June 26, 2020
Originally posted by Eric Osmanski

No input

https://onestreamsoftware.sharepoint.com/sites/Services/Shared%20Documents/PIE%20%28Prod%20Info%20Exchange%29/Atria_Metadata_20180123_155847Z.xml

Newcomer
April 5, 2023

Can't access the link, is it possible to add the example directly in here?

Newcomer
November 14, 2024

From Excel side, I'd suggest using Macro code to control the submission members in use at each data point. This way, you can pinpoint the specific UD member where submission is allowed. 

Like Eric suggested, you can also use "No Input" in Biz Rule - Finance - Conditional Input, don't forget to assign the rule to the cube in question.

If (Not scenarioType.XFEqualsIgnoreCase("Actual")) And (Not scenarioType.XFEqualsIgnoreCase("Budget")) And (Not scenarioType.XFEqualsIgnoreCase("ScenarioType1")) Then
If entityText8 = "" And (Not api.Entity.HasChildren()) Then
Return ConditionalInputResultType.NoInput
End If
End If