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!  

Hi Everyone,Has anyone worked on establishing an SFTP connection in extensibility rules using a PPK file? I am currently facing an issue where, despite setting the SshPrivateKeyPath property in the session options, I receive the error: "No supported authentication methods available (server sent: publickey)."Any insights or solutions would be greatly appreciated.Thank you,Mithun

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!

I have a custum tree hierarchy with multiselection,  It looks like this  Is there a way to format this component to open like this:  

I am implementing a BR that pulls a file from FTP. The file is encrypted so I need to decrypt it using a third party library. In order to decrypt it, I need to pass in a physical path to the PGP key provided. I uploaded the key to the Public folder share for now but cannot seem to find a way to get the actual physical file. Does anyone know if uploading a file to the share folder results in an actual file being created on the server or is it just stored as a BLOB in the database?  

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  

I have a cubeview with 1 Row = A#NetIncome.TreedescendantsInclusiveR. I would like to have the accounts collapsed, so that the report doesn't have all the accounts/rows expanded.I have set RowExpansionMode = CollapseAll, but it did not change anything and all rows are still expanded. Am I missing some other configurations?

Does anyone know if you can create an Excel spreadsheet from Business Rules? I do not mean a csv file - I need to create multiple sheets. The OpenXMLBuilder object doesn't seem to have anything with writing files. I don't want to use a third-party object as that would require an installation or download. Thanks for any suggestions.

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

Good DayI would like to know if it is possible to extract a table out of a DEV onestream app and then upload that table in a UAT onestream app? If not, are there any tools on marketplace which can assist in doing so?RegardsRehaan

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?

Hello,I am working in an 8.5 application and want to utilize Finance Custom Calculate services within a dashboard. My service factory is enabled at the Dashboard Maintenance Unit level of detail. I am trying to launch the custom calculate function via a dashboard button.Does anyone have example syntax for this? I figured OneStream would release documentation externally for this but was unable to locate any. Thanks! 

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

I used data management jobs to extract historical data from a legacy application and they are now sitting in file explorer and are split-out by period. I need to extract these files to load to a new application. I tried holding shift and control on my keyboard to highlight multiple files but I did not have any success. I believe this will need to done via business rule but I am unsure. Please let me know if I can provide any additional information.

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