Application Build

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

Hi all, does anyone knows about the limits of using the Direct Load method? Like # of rows, memory, parallel loads, or something else. Thx for advance

Hello,  I am new to OneStream. While adding dimension items below the root, it seems I may have inadvertently broken something. As a result, I am unable to view the dimensions—highlighted in yellow region below. Clicking ‘OK’ on the dialog shown in the screenshot did not restore access to those dimensions. I’m unsure how to rectify this or reset it back to normal. Appreciate any inputs on this. Thanks

When migrating Financial Close Applications from On Premise to The Cloud , how much testing is required or recommended post migration e,g checking excel report retrievals to verify data as before , key close processes ,data loads , currency settings , etc ? 

What's the best way to load historical data to accounts that have extended accounts under them in OS. For example in our current system we have data in Corporate accounts and we recreated them in OneStream but in OneStream we also extended those accounts to have regions local GL accounts under Corporate accounts.   Current system only has amounts in Account2 but in OneStream going forward data will be loaded to regions local accounts (LocalGL100, LocalGL200, LocalGL300)

Hi All - I have a quick question on Periodic Data Load for Balance Sheet. If I load Periodic data to BS accounts, will it calculate YTD automatically? or we need to write a formula to get the YTD value. Any Input would be appreciated ? Thanks      

Hi Community, do we have a onestream admin copilot? i recently came across copilot for azure sql database and was really impressed by DBA capabilities. I was wondering if OneStream has similar product that let us administrators use a chat based interface to figure out why our cubeviews/formulas or data load processes are running slower and recommendations to fix that. Currently we go through system generated or developer generated logs to figure what is causing the issue and go through documentation and use experience to modify artifacts, it would be great if we have azure sql copliot like feature to help admins.

Hello,  Wondering if there was a way to carryforward V#Annotation inputs on BalanceRecurring Account Types (or any other Account Types) similar to how a V#Periodic input is carried forward on BalanceRecurring.  For example, we have the users selecting a text string in a data cell and would like that data cell to be carried forward when saved. When we click save on this BalanceRecurring Account, the text string doesn't carry forward months because no value is being stored at V#Annotation. V#Annotation:   However, we can change the parameter to have the value of a MemberID (Integer) which stores the value at V#Periodic and displays the String. At V#Periodic, this carries forward that string which is our end goal. V#Periodic: Due to the nature of the tables supporting these custom dropdowns, we would prefer to be at V#Annotation and carrying forward text strings that way. Has anyone encountered this or have solution to carryforward V#Annotation inputs?    

Hi, I'm new to OneStream and wondering if this Account rollup is possible using inherited Account dimensions? Cube 1 is the Main cube and needs to show all Accounts, but the Cube2&3 should only show & operate on a subset of Accounts within this Hierarchy Thanks for your help! Sincerely,David

Hi, Can OneStream work on Mac OS? If so, how?

Originally posted by Steve Davis How do I save a Member to the root of a dimension (as a child of Hierarchy)? I have tried the SaveMemberAndRelationshipInfo method, but this gives me the error:  Error creating parent-child relationship.  Invalid Parameter. child, [CHILDNAME].  

Hi, I have  this workbook with 2 spreadsheets. 1. A tableview retrieving data from a Custom table. 2. A sheet with a lot of formulas to calculate some numbers.  When I try to copy a cell or range of cell from the second sheet it gives an error saying ' DocumentModel.IsCopyCutMode is false'. This happens only in OneStream Spreadsheet window not in excel add-in.   Any idea what could be the reason and how can it be resolved? Thanks

Originally posted by Eric Osmanski 6/12/2017 Any one have an example of getting a list of users in a security group not attached to a Workflow?

Is there any way for me to rename different scenario types(from the 24 scenario types) and also add a new one?

New to onestream and doing some training and have sandbox env to play around with it. I have questions on the cube design and extensibility.  I am trying to extend account and product dimension to fit to my three cubes even though level of entity will be the same in two diff cubes. How would I go about? e.g I want to reallocate my salary based on NetSales.Can I have two account dimensions? I cant think of how I am going to do allocation. Or I just need one cube & have everything in their but that will decrease performance, I guess.