Restricting Data Loads Outside Workflow Time Period – Excel Quick View / XFset
Hey Team, I’ve observed that users are currently able to load data via Excel/Spreadsheet tools (Quick View / XFset) beyond the defined Workflow Time Period range for any scenario. This behavior persists even after setting the following Application General Properties to False: Allow Loads Before Workflow View Year Allow Loads After Workflow View Year Despite these settings, the restriction does not seem to be enforced, and users can still submit data outside the intended time range. Could you please advise if there are additional configurations or security settings required to fully restrict data loads outside the Workflow Time Period—especially when using Excel-based tools? Any guidance or best practices would be greatly appreciated. Best regards, Yogesh Kumar Goyal
DM Step Issue with Exporting Data with View Filters
Hi team, I'm trying to export data using a Data Management step with view filters. When I specify the view as V#Periodic,V#YTD, only V#Periodic data records is being extracted. If I reverse the order to V#YTD,V#Periodic, then only V#YTD data records get extracted. Has anyone faced this issue or knows how to correctly extract data with View dimension filters? Thanks in advance! 🙂How to get two decimal places in Member formula
Hi Everyone, I'm trying to write member formula (not dynamic calc), below is the syntax Dim Var1 as Decimal = Math.Round(api.Data.GetDataCell("A#630000").CellAmount, 2) api.Data.Calculate("A#520000 = A#430000 "*" & Var1 & "). after that getting error "Double is not valid, input string was incorrect format".
BI Blend Table - What is the significance of sEntity?
I just created a BI Blend table and when I open the file using a data adapter, I see the data unit and aggregation fields all have an extract column prefixed with "s" (i.e., sEntity, sScenario, sAccount, sUD1, etc.). What do these columns represent?
OneStream 9.0 file explorer error
Hello, I installed OS 9.0 on premise version recently and I am having the following error when I try to upload a file: You can find below the error details: Unable to load file.An error has occurred. BadRequest. User Interface Stack Trace: at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.UploadFileFromStream(XFFileTransferRequest request) at OneStream.Client.Api.FileExplorerServiceReference.FileExplorerServiceClient.<>c__DisplayClass370_0.<BeginUploadFileFromStream>b__0() at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) --- End of stack trace from previous location --- at System.Threading.ExecutionContext.RunFromThreadPoolDispatchLoop(Thread threadPoolThread, ExecutionContext executionContext, ContextCallback callback, Object state) at System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot, Thread threadPoolThread) Do you know what is the cause of this issue? Thank you in advance. Antony
