OneStream Platform Forums

Is there any way to read data from Onestream cube (.csv/.txt/Data Table) and push it to external system using external Web API connection (Not Onestream Rest API, SFTP)? Is it possible to do it using SIC?

We use the REST api to retrieve balances from our accounting consolidations in onestream.   I've noticed that for the current year, these account balances can be retrieved quickly. But for prior years, it takes a lot longer to retrieve them.  For example, I can run cubeviews against the 2024 data and get ten branches in about 80 seconds.  But if I run the exact same cubeviews against 2023 or 2022, then it gets increasingly slower (160 seconds for the same ten branches in 2022). Is there some reason on principal why the balance data would take so much longer to retrieve in past fiscal years?  Is the cubeview doing some sort of dynamic calculation to retrieve balances?  (maybe it is incrementally subtracting activity from balances in 2024, and that dynamic calculation takes longer as we report further back in time)? We are running OS 8.2.2.16127. The difference in execution time seems specific to G/L balances.  For G/L activity (the movement of the acco

Originally posted by Karen LiauHow do retrieve Account member description when using Spreadsheet XFGet info formula?

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. 

We tried to copy from test environment to development environment which failed. we emailed Onestream who gave the following response: 'Thank you for logging this request with us. It looks like the app copy failed out due to a lack of storage space in your Prd1 environment. You can view the applications in your Prd environment by using the System Diagnostic tool. The latest release of System Diagnostics (PV620 SV200) now allows cloud customers to see up-to-date information on all Application Database sizes and Elastic Pool used space from within the OneStream application, under Environment Analysis reports. This is now available on our Solution Exchange website: (https://solutionexchange.onestream.com/dashboard/home/browse)We can provide 2 potential solutions with this:1. Delete any applications that are no longer in use. You can do this by entering in a Service Catalogue request.2. Increase storage limit (which can incur costs)   We have couple of questions on the above: 1) how mu

Hi Community Is there any way that we can do to display currencies based on our entity through extensibility rules

  I tried to refresh cube view using macro, the cubeview connection parameter is not refreshing based on macro buttion is there any code to refresh delimited list parameter pop up after clicking the macro buttion So i can change the combination in the parameter and run. currently i am using the below code.    Set xfAddin = Application.COMAddIns("OneStreamExcelAddIn")If Not xfAddin Is Nothing ThenIf Not xfAddin.Object Is Nothing ThenCall xfAddin.Object.RefreshXFFunctionsCall xfAddin.Object.RefreshCubeViewsCall xfAddin.Object.RefreshXFFunctionsCall xfAddin.Object.RefreshQuickViews'Call xfAddIn.Object.SubmitXFFuntions'Call xfAddIn.Object.RefreshXFFunctionsForActiveWorksheetEnd IfEnd If

How can I change my dates(month,year) in my reports based on cube views. I want to modify directly on the reports. Could someone please help me with that? Or how to create to POV bar (screenshots in where is located)

How are the Debit and Credit inputs treated when using an account set as Account Type Balance on a Journal?  Are debits positive and credits negative?

Hi I'm currently reviewing the functionality of the Narrative Reporting and need some guidance with it. Per the option to insert content within a document, I have managed to get a Cube View to be active within the doc but cannot get a report component to generate?  I also managed to get the XFCell reference to work. The following is what I have used for a CV generation, which works fine: However, the actual syntax provided does not match what actually needs to be applied for it to work in the doc (i.e. see below provided syntax): Is there a list of what full syntax should be used for each of the categories listed in the Insert Content option? I've tried to use the same as the CV generation for a Report Component but that doesn't appear to work (as follows): {DOCVARIABLE "{XF}{Application}{Report}{rpt_FSR_BS_8_8_1}" "" ""}   Any help with this would be much appreciated?   Thanks

What is the simplest way to remove zero data from the application? This could be both calculated and user loaded data. Hoping this will improve performance. 

Hello. When importing an application from an older version of OneStream XF into the latatest version of OneStream XF in CloudI received an error message regarding the "DataManagement.xml" file. It wasn't admitting the <dataManagementProfiles> section of the file. So I had to remove it fromt he XML file to load sucessfully the application. Then when I entered the application (using the OneStream client), I saw in the screen that we didn't have a section for DataManagemente Profiles (neither a button to craeate them). Are they still in use? (so we should open a Ticket to get the issue checked by OneStream Technical Support)Or are they an outdated type of artifact that no longer exist in the newest version of OneStream XFSupport?Thanks in advance

Hello, A client recently asked if it’s possible to create an 'exception cube view' based on an existing main one. The main cube view includes both positive and negative amounts across rows and columns. The client specifically wants the exception report to display only the negative values. To address this, I created a UD8 dynamic calc member that returns the U8#None value if it's negative and returns nothing if U8#None is positive. I then applied this new UD8 member to a copy of the main cube view, ensuring suppression is enabled. While this works well for smaller reports, the performance suffers with larger reports due to the nature of dynamic calculations. I also applied the classic formatting where positive amounts are transparent but it leaves the report with a lot of rows and columns that have the text transparent. Any other ideas on how this can be achieved?

I am using a below code to display Intersection Error. The code works perfectly fine- except for one thing. The problem is when the error is - Invalid Member Name.Entity,2010 It only outputs- "Invalid Member Name" (may be because it gets period) Is there a way to update below code to also show Entity ,2010-  instead of just 'Invalid Member Namr' ***************************************************************** Guid gWFid = si.WorkflowClusterPk.ProfileKey;                     int idScenario = si.WorkflowClusterPk.ScenarioKey;                     int idTime = si.WorkflowClusterPk.TimeKey;                       using (DbConnInfoApp dbConnApp = BRApi.Database.CreateApplicationDbConnInfo(si))                     {                    

We have lot of workflows by entities, for each entity we need to add another workflow step(Import). and each workflow has different security groups. here, how can i updated the new workflow step at a time at one go. Can you please suggest us some easy ways to update the same. Thank you, Shiva Prasad.

Happy Wednesday,  I'm trying to automate our account recs module. I have been successful in automating the data load.  But I'm trying to figure how to call that "process" within my extensibility rule.  I tried to trace back the rule that executes the process recons. What I found was a DB Extender rule (RCM_SolutionHelper), that is been referenced within a button component. Wondering if there is a way to call that function.   Would appreciate any ideas.   Best, Mustafa A   

How to create a financial report? What tools do i need to create one in the platform

Hi everyone, We have a cube view with three rows structured as follows: Row1: E#Parent1.Children:U1#Member1 Row2: E#Parent1.Children:U1#Member2 Row3: Variance between two columns. To handle this, I created an XFBR that dynamically generates a string based on the number of children for the user-selected parent (Parent1 as a parameter). The generated string will look something like this: GetDataCell(CVR(Row1,1) - CVR(Row2,1)), GetDataCell(CVR(Row1,2) - CVR(Row2,2)), and so on. We have three columns in the same cube view: two data columns and one text column. The text column uses the U8 member as a dynamic calc member, which returns a string. In the variance row for the text column, I'm getting a blank instead of a string. I’ve tried different row override methods using XFBR and XFCell, but haven’t had any success. I suspect that GetDataCell might be causing the issue, but I wanted to ask for some guidance. Has anyone encountered this problem, or does anyone have any suggestions? Your inp

Does any know if its possible to create a dashboard label with vertical orientation where the text is rotated 90 degress and the letters from the bottom up?

Hi all, We have experienced that in our application, at specific times of high workload where many processes are executed simultaneously, some tasks in the workflow that involve loading data into the cube remain in the ‘Running’ state for hours. I wonder how to find the cause of this issue, which seems to be a performance problem during periods of high workload. Thank you.

Does anyone know how to display Workflow status in a Cube View or a Dashboard? I would like to create a report that would show the status of a particular step within a subset of workflows. I am thinking of a more formatted presentation of the information available in the "Dependent Status" grid available in the "parent" workflow "Certify" grid. More specifically I would like to create a report showing the status of all "Flash Report" steps in the attached screenshot. Thank you in advance and best regards. Yan

I have a CV with a row definition A#A111:U1#XYZ:U2#ABC:U3#LMN, A#A111:U1#XYZ:U2#ABC:U3#OPQ Please note U3 is LMN and then OPQ.  This definition is generated by a BR.I am trying to color a row in the CV if the U3 member is say "OPQ".I was able to format the color based on U3(using RowE1MemberName conditional formatting) but had to make U3 the first Row Header by saying "Use Default Row Headers" false and setting U3 as Header1. Want to see if there is some way of saying that without making the U3 as the first row header.  Thanks, JS     

I keep getting this error I checked the time and scenarios rules it looks right.

Hello community, We have a Custom Calculate DM job that clears data by account and flow via parameter selection that works well. Our client wants to know if it is possible to select multiple base accounts at once to clear the data. The parameter options such as member filter does not allow selecting more than one account so I'm hoping, if this is possible, that maybe someone has used multiple NameValuePairs to achieve this via two parameters of the same dimension somehow. Throwing ideas that may or may not be good out here. Thanks in advance!    

Hi Team, Is there a way to lock and unlock the scenarios through Dashboards?Followed to the above question, can we load FX rates through Dashboards? Best RegardsLucky