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 members2KViews0likes3CommentsCellStatus retrieves a different status than shown in the Cube View
Hi all, I'm trying to build a CV with Entities on rows and Scenarios on columns that will show the status of the cell with the help of a Dynamic Calc. Here's the aspect of the CV (Scenario and UD8 on columns): TEST is my dynamic calc (also crossed with V#Annotation so it can display text). As you can see, I can write on U8#None and yet the dynamic calc returns READ. Here's my code: Dim sEntName As String = api.Pov.Entity.Name Dim sScnName As String = api.Pov.Scenario.Name Dim sStatus As String = Api.Data.GetDataCell("Cb#CORP:E#" & sEntName & ":C#Local:S#" & sScnName & ":T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None").CellStatus.ToString brapi.ErrorLog.LogMessage(si,"sStatus = " & sEntName & " - " & sScnName & " - " & sStatus) If sStatus.XFContainsIgnoreCase("WriteAccess: False") Then Return "READ" Else Return "WRITE" End If Here's the POV of the first cell (on E#3002:S#Actual): Cb#CORP:E#3002G0:P#?:C#Local:S#Actual:T#2018M1:V#YTD:A#ADDUG:F#None:O#Forms:I#None:U1#None:U2#None:U3#None:U4#None:U5#None:U6#None:U7#None:U8#None And this is the Cell Status shown in the CV: However, the CellStatus that I'm retriving with my Dynamic Calc says the following (I highlight the incongruences in REDπ Description: sStatus = 3002G0 - Actual - StoredBits: 33, DerivedBits: 264, ExistenceType=IsRealData, StorageType=Input, NoDataZeroViewOverride: Default, Invalid: False, Error: False, IsDefaultFreq: False, ReadOnly: True, ReadAccess: False, WriteAccess: False, CanCalculateFromGrids: False, IsLocked: False, IsFromCalcScript: True, IsDynamicCalc: False, IsCalcStatus: False Does anybody have any clues why the CellStatus looks different between the script and the CV? Thanks, GSFSolved363Views0likes3CommentsDashboard requires user to have maintenance access
Hi, We have a Dashboard Maintenance Unit which requires a user to have maintenance access for the object to be able to open the dashboard. In which cases is it necessary to have maintenance access for a dashboard if you don't need to maintain it in the Application-tab?112Views0likes1CommentSIC Password and API keys are stored in a plain text file
Hi We are evaluating the SIC tool for integration and noticed that API keys and DB passwords are stored unencrypted in plain text files. This is becoming a huge security concern as this way of storing credentials is going to case sensitive data leaks. Not sure if this is already identified by any other client and if it is in the roadmap of fixes? Did any of the clients report this issue? Thanks Vidya Kadiyala CN RailSolved4.9KViews1like13CommentsSwitch data access security on users by time
I'm sure this question has been asked before in the forum, but I just couldn't find it in the community. We have this requirement where in the same Actual scenario, Corporate (a group of users) can only access the Actual data after the actual data is finalized by different entities. Any point of time leading to Day X, the entity has the control to pull the switch on releasing the data access to Corporate. On Day X, all the data is made accessible to Corporate. I thought about slice security, but it doesn't seem to accommodate this requirement due to the static nature of the DU filter; neither does Conditional Input, which doesn't control the general data access. Can someone please shed some light here on this design whether it's possible to lock down a group of users by time period?351Views0likes4CommentsCapability to Tie Active Directory to OneStream
Since many federal organizations utilize Active Directory at the Enterprise level, is there a way to tie Active Directory management to OS? For example, if a user's AD account gets disabled, so does their OS account? When a user's AD account is created in the particular OU, their OS account is created to the correlating group? Thanks.225Views0likes2CommentsJournal Quick Post Functionnality in v8
Hello, We have recently upgraded to v8. With the new security properties on Adjustment Workflow Profile disabled, users still don't have the "Quick Post" button after creating a journal : -Prevent Self-Post = False -Prevent Self-Approval = False Users have access to the 3 journal steps : -Journal Process Group -Journal Approval Group -Journal Post Group Does anyone know how to activate the Quick Post functionnality ? Thank you. Regards, TahinaSolved1.4KViews0likes8Comments