Application Build

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, I would like to create the Dashboard for the Adim which should display all the Current login users Details in the applications. Kindly help to achieve this development.   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  

Hello,  Let's assume we have an extensibility on the dimensions account with 2 cubes. When we need to export the dimension account, we are only able to export the accounts for the 1st cube, and the accounts for the 2nd one (two files). Is it possible to export the full account hierarchy (within a single file), with a field specifying the associated cube ? Thanks for your support, Harry

Hello, Got a question. We are trying to configure Smart Integration Connector. With respect to that can you please send us the list of IP address to whitelist for the Azure Relay of Onestream Thanks in Advance    

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?   

We are using the administrator solution tool Home Page Manager to set home pages for certain groups and it works fine when initially adding a user. When a user changes roles from one group to another, we are seeing that their home page is not updating. Shouldn't this update that users home page with the new home page of their new group?  

Hello Experts,  We have a requirement to derive account based on Data value. (If data value is Positive Asset Account , if negative Liability account)This has to be done for range of accounts. I am not sure if there a any functions to refer data value for row? (GetSource and GetTarget seem to be only for dimension data)Any ideas on how we can achieve this? Thanks In Advance,

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?

Hello Expert, Is it possible to make employee register fields mandatory? we want users to select certain required fields before committing save.  Let me know, thank you

Is it possible to update a users security group with a business rule? If I have them in Group A but want to add them to Group B without going to the system tab and updating their security manually can I update their groupings with a Business Rule? 

Hello Experts,I'm trying to automate an export of account hierarchy which is then used to replicate same hierarchy in another app/tool. However, when I export Metadata in XML (tried both via Business Rule or via Application>Load/Extract) , it doesn't capture information on order of arrangement among siblings.So, while loading XML extract to new app, by default all siblings are arranged in ascending order of their member names.Is there a way to capture this information when doing export? Thanks,Gaurav

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.     

Does anyone have information on how to get Data Cell Access (Slice) Security (henceforth DACS) to work when applying it to multiple UD dimensions?  The app has the entity and scenario security set.  Those are working fine.  If I put only one UD in the DACS, that also works fine.  The problem comes in when subsequent UD dimensions are added to the DACS.  It seems OneStream ignores the DACS and goes back to entity and scenario security. To add a bit more information, I have tried it multiple ways, with the multiple UDs in the same or different rows in the DACS setup.  It doesn't matter. Thank you.

Hello, We have a client who has requested the ability to use the alternate translation currency property on specific parent entities but then also to be able to pull that alternate currency in reports without changing the currency in the POV. For instance, the parent entity's currency is USD and it will be setup with EUR as an alternate translation currency in the equity pickup property section. The children of that parent entity are all EUR currency entities. In their reporting they would like to be able to show parent entity and children at the EUR without changing the Cons POV. The reporting could have multiple instances of this setup with different entities and currencies so setting the Cons to EUR wouldn't be an optimal solution. Ideally, they would like to set the consolidation to local for the whole report. We have alternate hierarchies setup but they would like to only worry about one member name for the parent and one hierarchy. Does anyone have any suggestions on how to achie

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?