Application Build

Has anyone else see any issues running the OneStream clients on Windows 11? We are testing OneStream on Windows 11 and we keep seeing the error message "The specified data could not be decrypted"  when attempting to access a few modules such as Cube Views, Dashboards, Business rules, etc.  I believe it's a .NET issue since the error can pop up in either the Desktop client, Web client and Excel Add-in.

Hello, We are currently seeing slow consolidation times after we copy data from one scenario to another. If we run a force consolidation in the source scenario the full year takes around an hour or so. When running the consolidation in the target scenario it is taking 4+ hours to complete. Both scenarios are using the same scenario type.Anyone have ideas on what could be causing this issue? Seems odd that the same data set would have such huge deviations in run times. This is the second quarter we have seen the issue.  Thanks for your help! Tim

Hi all,  I use the dashboard to trigger data import from external database. After successfull import I want to make the workflow step (type Workspace) complete by calling SetWorkflowStatus. Strange thing is that is does work when I directly call the Extensibility rule from Button, but it does not when I call the same rule from data management process. Do you know why this happens and how can this be bypassed?  Thanks for help! Pavel  

In developing applications, I prefer to group objects intuitively using standardized naming, alphanumeric sorting, and hierarchical grouping.  Dashboard parameters use the "Sort Order" property to sort, which for me adds unwanted cognitive load to a development process.I developed the code below to automatically sort and group parameters the way you would expect them to be sorted to get around the need to specify Sort Order. Implement as an extensibility rule and run it from the editor.  After the rule is run, copy, paste an existing parameter, then delete the pasted parameter to force a refresh of the list from the server.  Be sure to remove this code from your production applications. C# using System; using System.Data; using OneStream.Shared.Common; using OneStream.Shared.Database; using OneStream.Shared.Wcf; using System.Linq; using System.Text.RegularExpressions; using System.Threading.Tasks; using System.Collections.Generic; namespace OneStream.BusinessRule.Extend

We are currently building a simple form for Shipping Days that allows a user to input an entire year's worth of shipping days all at once. We want this to be a Periodic view to align with how the client thinks about shipping days for each month. We are entering the data into our Actual scenario, which has a Default View of YTD. The below screenshot shows the basic form structure and the YTD row is there for reference. The initial data entry worked great. However, if I go back to a previous period to change a periodic value, I want the new periodic value to update for that month and keep the remaining periodic values the same. However, changing a periodic value squeezes the difference into the next month to keep that month's YTD value the same. In the below screenshot, Cell (1) was changed from 23 to 18 in March 2022. The March 2022 YTD amount updated accordingly. However, the periodic amount in April 2022 (Cell (2)) automatically changed from 20 to 25 so that the YTD amounts for April

Hi Experts, I am trying to use a member filter based on the Text property. Here are the sample text property values: Member1  = PASSTHRU~[False]|IPL~[False] Member2  = PASSTHRU~[True]|IPL~[False] I wanted to filter the members that have " PASSTHRU~[True] " in the text property, i tried the filter below but it returned no results: U4#Top.Base.where(Text8 Contains PASSTHRU~[True]) I do get results if i use U4#Top.Base.where(Text8 Contains PASSTHRU~), but as soon as i add  " [ " character, it doesn't pull any members.  Any suggestion would be helpful. I tried all the below formats, nothing worked: U4#Top.Base.where(Text8 Contains 'PASSTHRU~[True]') U4#Top.Base.where(Text8 Contains [PASSTHRU~[True]]) U4#Top.Base.where(Text8 Contains PASSTHRU~[[True]])

Hi All, Is there a way to set up default workflow POV period each month for users instead of them going into the tool and changing the period .     Thanks in advance.  

My company is implementing a new ERP system and I need to map the new accounts into our old structure. I am fine with the transformation rules I simply extract out make changes and load back up all is done in our Dev environment. My issue is how do I download to add accounts in the dimension library, If i added manually it will take forever.    Thanks in advance Mark

Hi all, With the version 7 and above the switch between applications with the addin Excel requires to log off and log on. You cannot switch applications and stay connected. Admin team have to switch often between applications and this new mechanism is seen as a step backwards. Is it possible to restore the previous mechanism with the functionality: Change Application Thanks

Hi all, How do we calculate Data Unit in OneStream ? I know that the largest Data Units should never be above 2-3 million intersections. The sweet spot for OneStream is between 250,000 and 500,000 records. But what can be the maximum possible records in the given example we can have to avoid performance issue in OneStream ? Please consider these dimensions in OneStream. Thanks

Hi all, We are in the process of implementation. How to eliminate Share Capital of the subsidiary where Percent Consolidation (PCON) and Percent Ownership (POWN) is 100%  Thanks

Hello, Let's assume we have the entities in the dimension "Entity" and the Business Units in a UDx dimension . In this case, is it possible to trigger intercompany eliminations at Business Unit level ?  Thanks, Regards, Harry  

Hi, Can somebody please tell me the process/code of clearing multiple errors let's say 12 pages from Error Log in one go? There is a limitation in Administrator Solution Tools to delete logs prior to 30 days. I would really appreciate the help. Thanks  

I've had requests from our finance team about sharing entities from our "Top" cube into another. Our application is in a mature phase now and many of the entities from our top cube will be moving into cubes of their own.  Currently, we only have two options: Option1: Completely clear the entity, delete, and the create in the new cube and reload the data.  Option2: Rename the entity i.e "EntityA_Old" and create a new entity in the new cube with the old name "EntityA" It would be great if there were a better option

If a holiday falls within the duration of a closing period, is there a way to shift the Work Day (WD) due dates of the tasks for that Entity/Work Flow?  For example, we have a Mexican Entity with a WD due date on WD 4.  In May, there was a holiday on WD 1 (May 1st).  In our business, the Mexican Entity's due date to submit financials would be extended to WD 5 because of the holiday.    But since the due date did not fall on the actual holiday, the WorkDay due date in Task Manager still says WD4.    Is there a work around for this other than manipulating the holidays and creating a "dummy holiday" on WD4 so that the due date will extend the extra day to WD5?   

https://server/OneStreamApi/api/Authentication/LogonAndReturnCookie?api-version=5.2.0&appName=D&AzureTenantID=X&clientID=X&clientSecret=Xapplication/json 116candidate(s) found for the request path '/api/Authentication/LogonAndReturnCookie'Endpoint 'OneStreamWebApi.V520.Controllers.AuthenticationController.LogonAndReturnCookie with route pattern 'api/Authentication/LogonAndReturnCookie' is valid for the request path '/api/Authentication/LogonAndReturnCookie'Request matched endpoint 'OneStreamWebApi.V520.Controllers.AuthenticationController.LogonAndReturnCookie (OneStreamWebApi)'TokenExchange was not authenticated. Failure message: Unable to authenticate against internal users. Error: Unable to log on user. Azure did not provide a valid user name claim. (Claims presen

Hi, Can anyone guide me to push the file from OS export folder to AWS S3 bucket via business rule? Currently it is being taken care by power script. Wondering if it can be achieved by business rule?

Consolidation/Cube model can be set as YTD (Year To Date) or Periodic. In OneStream where do we set it up other than Scenario ?

Hi - not sure if this is the correction 'board'. OneStream Community,    We upgraded our on-prem OneStream 7.4.2 to 8.1.1 in our test environment.  We use SSO authenticating to external provider  GCCH.  Since upgrading the OS 8.1.1 application signon screen no longer fills in with the User name.  (please see screen shots).   This appears to be a BUG. Any insight is appreciated. Screen shot of our OS production – user name is filled in Upgraded our test OS from 7.4.2 to 8.1.1 – User Name is no longer filled in.

hello experts, we are using Actuals scenario with default view as YTD. Since it is YTD in nature, P&L accounts show reversal for next period (periodic view).we tried updating the property (see attached screenshot, updated highlighted to periodic) but still i'm seeing reversal for few entities. Pls see 2nd screenshot of data. Apr is the current month and May is the next month.  Can you please let us know if it is possible to avoid P&L reversal (periodic view) for next period by updating No Data Zero View for Non-Adjustment as Periodic for a scenario that has YTD as default view.     

Hi all, Due to requirement,the conso type we use is force consolidation,while doing which noticed that more time is taken during "Aggregate child entities" and that too for specific year (2024). When drilled through it,noticed there are huge number of data cells processed for each entity. Example: for entity A,scenario 2024_241_M2 and time 2024M2,possible member combinations along with other UD dimensions is expected to create data  cells in 1000s (at the max) but noticed there are around 40k plus data cells created that stores value 0.(E#A:S#2024_241_M2:T#2024M2:U1#A_001:U2#None:U3#None....U8#None stores 0) I tried to clear the invalid data cells using clearcalculateddata as well as using data buffer, but nothing worked.Im still able to see 40k plus data cells. Kindly suggest options that clears the data cells itself and remove the invalid member combinations. Thanks  

Hi, I want to block Consolidations in prior year Forecasts and Budgets, as these should always be static.  I've already locked all Workflows,  but I'm still worried that Admins can run consolidations from Cube Views, etc. I've tried using Data Access in the Cube,  but none of that seems to actually do anything.  For example, I tried adding a Data Cell Conditional Input rule that makes the prior year and Forecast scenario Read Only,  but this doesn't prevent Consolidations from running. Any ideas?

In our date description the Januari month shows the wrong year. The date notation is correct, but de description in incorrect. Eg 2022M1 has a description of Jan 2021. This if very annoying and confusing for users in combo boxes at dashboards.   I have pinned it down to the wrong fiscal year start date was entered when our application was set-up.  The first period of data in the system is 2019m12. In the time profiles this was interpreted to a fiscal year start date of 12/31/2019.  When I change the fiscal year start date 1/1/2019 in a test environment to, the issue with the wrong year description in January is resolved an at first glance there are no other issues popping up.  However, because the time profiles are such a basic setting, we are hesitant to adjust his.  Question:  1. do you have recommendations for specific test we should run, before changing this setting 2. are you aware of a work around how the specific January description can be adjusted

I am getting error on clicking on any of the artifact inside onestream application after i have logged in. For ex - If i click on dimension under application , it pops out that error. Strangely the error is happening only for me and not other users. Do you know of any Local onestream user data folder which can be deleted?    

Does anyone know how to delete Annotations? I have a DM step and no matter how I set it, it clears the numeric data but not the annotations. I see code to set an annotation value but do not see any code that will delete annotations.   Any thoughts?  Thank you, Bill