Skip to main content
Jun 18, 2020 12:48 PM UTC

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

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

Jun 26, 2020 12:10 PM UTC
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

Member
Apr 5, 2023 8:24 AM UTC

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

Member
Nov 14, 2024 9:36 PM UTC

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