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
OSAdmin
OneStream Employee
6 years agoSecurity 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
- OSAdmin
OneStream Employee
Originally posted by Eric OsmanskiNo input
https://onestreamsoftware.sharepoint.com/sites/Services/Shared%20Documents/PIE%20%28Prod%20Info%20Exchange%29/Atria_Metadata_20180123_155847Z.xml
- NNContributor
Can't access the link, is it possible to add the example directly in here?
- DavidWNew Contributor II
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
Related Content
- 1 month ago