OneStream Platform Forums

Is it possible to place a restriction on a scenario member to prevent data write via XFSet? This would prevent data load via XFSet for Actuals (so the workflow can't be bypassed), however would allow data send via XFSet for budget / forecast scenarios. Would appreciate any input if other users have dealt with this issue in the past.  

Hello, We experience performance problems when we try to export Onestream data for insertion into a third-party system.For 100 entities and 12 months, processing takes 20 hours and is often killed by the system.Apparently, it's the dynamic accounts that take up a lot of time during extraction.Do you have the same problem and what are the solutions to optimize the export?Thanks

Hi,  Has anyone created an intercompany report by entity? I'm trying to use the vstagesourceandtargetdata table - is there any documentation with descriptions of the table's columns? Thanks!  

I’m working on a Drill Back Dialogue in OneStream that uses XFDataTable, and I need to display a sum total row at the bottom of the table, similar to how it appears in a Drill Down. Currently, my Drill Back table retrieves and displays data correctly, but there’s no built-in option to show a total row. I’d like to dynamically calculate the sum of a specific column (e.g., Amount) and append it as the last row in the table. Has anyone successfully implemented this? Would this require modifying the Business Rule handling the drill back or is there a UI setting that allows this? Appreciate any insights or sample code. Thanks in advance!

Hi, I've been looking into the audit trails for O#Forms and O#Import data. The audit trail for O#Forms data seems to be in good shape, with changes tracked in tables like DataEntryAuditCell and DataEntryAuditSource.For O#Import data, I've found some audit information in the staging area tables, such as StageArchivesInformation and vStageSummaryTargetData. However, this doesn't cover everything - for example, it doesn't account for data that's been imported but not yet loaded into the cube, or data imported using a business rule.Is there a way to get a more complete audit trail for O#Import data, that focus on the Cube data rather than Stage data?

Hi Folks,We have 12 forecast scenarios and 12 FX rate tables for each FC scenario.When we update the FX Rates in one table, it's upsetting the status in all other Forecast scenarios, but not Actual.We don't want other scenarios status getting affected when ever FX rates updated. and there is impact status rules exists in our application.Appreciate your advise. Thanks  

Hi, We're on 7.4.  Is there a way to extract a posted journal from one application so that I can easily load it to another application.  This would be super useful for investigating issues.  At present, we can easily find imported data files, and load these into our test app. But I can't see any way to extract journals in the same way.  The only options seem to be extracting a .csv file,  which has the information but is not formatted in a way that can be loaded again.

Is it possible to format point labels in the BI Designer, in terms of text color and outline? For example, I'd like to remove the outline around the label, make the text bold and color black. Thanks!  

Originally posted by Francisco BassolsHello, I am trying to create a report showing the audit trail of which users performed specific actions, as load data, process cube, certify steps or lock/unlock a period from the workflow. While the dashboard "WF_WorkflowStatus_RPTAR" (from the administrator solution tools) but it only shows the status (e.g. Completed, Locked) but there is no trace of who performed the lock action. I've looked in the tables "TaskflowStepLog" and "WorkflowLock" from the application database as in the tables "TaskActivityStep" and ''TaskActivity" from the os_framework2 database, but with no luck.  Do anyone knows where to find this information or could provide some guidance on it? This kind of information is sometimes requested during audits and would be handy to be able to retrieve it from the system. Thanks in advance, Francisco

Hi all, I am trying to upload data to the text field Text3 in a UD2 dimension. I have been looking around in the available functions in the OneStream excel add-in, but I am not sure which one is the best for this. I tried the function  XFSetCell, however this function saves data to the amount field based on the Parameters supplied. I only need to upload a string of text to the Text 3 field of a UD2 member: Thank you all for your help!      

Hi, I'm trying to block input to UD3 None (for example) using the Cube setting in Data Cell Conditional Input,  but only for accounts that have a certain UD3 Constraint. Basically, I had to add None into the constraint for some rule logic,  but I don't want anyone to be able to enter data there by mistake. I normally test the Member Filters of blocking rule by just putting the Filter into a Quick View, but I am struggling with this one.  This is what I have: A#PL.Base.Where(UD3Constraint = MyUD3Constraint_1) But that does not work.  I think the issue is that the UD3 Constraint can vary by Cube, rather than being a strictly defined property of the member.  Not sure if it's possible to define the Cube in the Where clause? Any ideas welcome!

Hello - I have a dashboard with 6 buttons across the top - each one is set to display a different cube view. The time dimension for 4 of the CVs are set to workflow time, where the other 2 I want the users to be able to select a period from a list, because these 2 are designed to show historical variance commentary. I set up a member list parameter with the time periods and added it to the two cube views. Now when I open the dashboard, the prompt automatically appears for every CV. I checked and couldn't find a way to only have this prompt appear for the two cube views. What settings do I need to enable or disable for my dashboard so 4 out of the 6 run off workflow time, but when a user clicks a button for one of the 2 others, the time period prompt appears?

When using a second display monitor connected to my laptop the  Drag and Drop  of dimensions in Spreadsheet  Quickviews  does not work - when I place the Onestream applicatrion page  on this second monitor.  if i switch back to having the OneStream application QV on my laptop screen -  i have full functonality on moving dimensions into columns or rows in Qv's Any similiar exeriences with this ?   ( audio/visual setting on second displays)?)  best regards    Chris 

Hi everyone. I would like to know if there is a way to display only a certain number of rows in an SQL TABLE EDITOR, as I do not see a way to set it up as in a query, for example. SELECT TOP 5 * FROM Table; I would appreciate it if you could assist me with this.

How do l start the process of importing a  .csv file into onestream

Hello, We currently print out a book to our general managers every quarter and our reports formatting seemingly changed without us changing. We use double underlines as our totals and previously it worked fine, but this quarter it looks like a solid line, but when you zoom in, you can see it's a double line. Is there any way I can fix this? I've tried changing the ReportBottomLine1Thickness and ReportBottomLine2Thickness size, but with no luck. Any suggestions? Thanks, Will

Hello,i've installed the SIC and it's Online in the "smart integration connector part" as you can see: in the error log i have this error:Summary: Smart Integration Connector Gateway Server Heartbeat has timed out for 'mantu_database_connector'. Current timeout: '5'. Last Reported Error Time: '9/25/2024 7:16:56 AM' UTC.and in the "system configuration part" i have created the a custom database which in i can see that the Mantu_database_connector is offline: if anyone knows what's the error and how to solve your help will be much appreciated.Thanks

Hi,I need to check in a Table View if certain column values are dirty and I've noticed that when you call the IsDirty() function on any decimal type column (and this only happens on that type), it always returns 'true' even though no changes took place.Because of this i need to manually parse the value and check if the originalValue is different from the current value.At this point I was wondering if this behaviour is intended or not, it seems odd that IsDirty() returns the correct value for every type of value BUT a decimal one.Any clarification on this matter is appreciated, thanks in advance. 🙂

Do we have any way of restricting the Unbalanced Journals in OneStream? I read about the Journal Event Handler but don't see that BR in my application. 

Hello,  Is there any Intercompany Report set up training and/or documentation with examples of report detail for the different Intercompany Reports on the Application Reports dashboard?  Thanks!  

I want to load OneStream application data to external database. And there is an existing connection to the target external database. But it gives me below error, could you please help? No idea what is wrong. BTW, "FDH_DEV" is SIC external database connection.   'Build a data table with one test line Dim TestTbl As New DataTable TestTbl.Columns.Add("Tmt", Type.GetType("System.String")) TestTbl.Columns.Add("SEnt", Type.GetType("System.String")) TestTbl.Columns.Add("TEnt", Type.GetType("System.String")) TestTbl.Columns.Add("SAct", Type.GetType("System.String")) TestTbl.Columns.Add("SActD", Type.GetType("System.String")) TestTbl.Columns.Add("TAct", Type.GetType("System.String")) TestTbl.Columns.Add("TActD", Type.GetType("System.String")) TestTbl.Columns.Add("SFlw", Type.GetType("System.String")) TestTbl.Columns.Add("TFlw", Type.GetType("System.String")) TestTbl.Columns.Add("SIc", Type.GetType("System.String")) TestTbl.Columns.Add("TIc", Type.GetType("System.String")) TestTbl.Columns.

Hello,I am currently working on the Business Rule WorkflowEventHandler to update a custom table when certain tasks are manually completed in a workflow. The scripts shown in the screenshot are located in the section where Case Is = BREventOperationType.Workflow.UpdateWorkflowStatus, with the following condition: If NOT args.IsBeforeEvent Then.I want to trigger the function after the current workflow is fully completed. However, despite testing various syntax alternatives, the function consistently executes before the workflow is fully completed.For example, when I initiate the last step of the current workflow, the function is always triggered at line 141. For context, this issue occurs when the workflows consist of multiple tasks. The final task varies depending on the workflow—it may end with Import, Confirm, or another task.Below are the syntaxes I tested but without success.Could you please help me resolve this issue?Thanks 

Recently we upgraded to 8.5 and I found the back/forward buttons missing from the top left corner of the screen. We jumped a few versions so not sure when this was removed. Can anyone tell me when this happened? I cannot find anything in the release notes. I have some dashboards built to use this back button so I will have to update them.

Wondering how we can zero-out the translated FX noise in a local (Euro) base entity that has the accumulated FX noise showing up in USD after the entity has all of its local currency balances zeroed out.   We have some adjustment USD sibling entities to this Euro entity in question but entering an offset in that entity does not remove the translated USD amount.  If we set the properties to Is Consolidated = False, would this completely remove that entity from consolidated history (if we were ever to go back and reconsolidate the system)? Has anybody encountered this and what did they do? Thanks. Mike B

Hello, I have a defined a dynamic dashboard based on an SQL table component. The goal is to create dynamic dashboards based on this table. In the last column of this dashboard, I have a parameter which drives a selection based on 2 values: Manual, Predictive. My dynamic dashboard run as expected except for the last part, which I would like to have as a Radio Button Selection and should reflect what is defined in the table.     My question is : is there a way to define what would be the selection of the radio button based on a dynamic dashboard business rule ? Regards,