Application Build

Hi everyone. I'm trying to add values to a SQL table, I have checked with several functions of the BRApi.Database, but none of them work for me. My code example:#The variablesDim sqlTest As String = $"INSERT INTO AllocationResults (Step, Amount, Annotation, SourceRule, DriverRule, Type, StepDesc, TargetRule, AllocRule, Generation, Cube, Entity, Consolidation, Scenario, Time, View, Account, Flow, Origin, Ic) VALUES (1, {Amount}, {Annotation}, {SourceRule}, {DriverRule}, {Type}, {StepDesc}, {TargetRule}, {AllocRule}, {Generation}, {Cube}, {Entity}, {Consolidation}, {Scenario}, {Time}, {View}, {Account}, {Flow}, {Origin}, {Ic})" Using dbConnApp As DBConnInfo = BRAPi.Database.CreateApplicationDbConnInfo(si)     BRApi.Database.ExecuteActionQuery(dbConnApp, sqlTest, False,True)End Using 

We leverage MS Azure single sign on for OneStream.It seems like lately we experienced an issue where users are not able to login using SSO.Is this a known bug with version 7.1.3.14022?The way the support team resolved it was do an IIS reset on the servers and disable/reenable SSO but we don't want to keep doing this.Thoughts???

Hi,We would like a particular user with authority over several accountants that have certified their accounts for that user to be able to uncertify (un-certify) those certain workflow profiles if any changes are required.At present, if the workflow has been certified the user gets a warning.. has not been granted access to application role 'UnlockWorkflowUnit' for application.So how do I grant them this access ? The only group they are not in is 'Administrators', but we do not want them to have full unlock/uncertify rights, but only for the selected entities which are under the parent that they have reporting responibilty for.Keywords Unlock and UnCertify Ancestors and Unlock Workflow Unit

Hi,   Does OneStream application has any App or link to access for Apple Mac book users ? We have many leaders in our organization using MacBooks, IPAD Pro etc.. they are not able to access Onestream application now. Any suggestions ? We have recently upgraded to OS 8.1 version. 

We are exploring pros and cons of enabling  Onestream access to our global users using Citrix / Azure virtual environment. Primary reason are, to reduce the .net installation in individual desktops, control excel temples from a central team etc..Could you please let us know if there any others who are using Onestream from a Citrix / centeral environment ? if yes, how is the performance impact of Onestream vs a normal desktop environment ? Do you have any learnings /feedbacks from their experience which you can share ?Any other items we should consider before taking this path of Citrix / Central Onestream access approach ?Thanks for your time and inputs. 

We are (officially) migrating our archived, pre 2020 data into OneStream (from our HFM archived environment) does anyone have experience with this, tips, and tricks? Our thoughts are only loading data into the entity and account dimensions since we won't need to transact as it's post-close/post-calculated data. Any advice or support would be amazing!

Hello,Is it possible on the same quickview to cross both Time and Scenario Filter?For example I need the cross of  :Time "2022" with scenario "ESTIMATE"Time "2023" with scenario "Planning_2023M10"But I have some datas on 2023 cross ESTIMATE I don't want to see.Attached what I have and what I need.Thank you! 

Hi,I've been using a data management step (part of an archival sequence) to copy data between Scenarios and archive data. It has worked well in the past but now I'm getting below error when I run the step."Error processing Data Management Step 'step_SeedForecastMonths'. Arithmetic overflow error converting numeric to data type numeric.The statement has been terminated. (SQL Error Number -2146232060, 8115, 3621)"Any ideas as to what would be causing this ? I verified the data and I seems like the copy did work for the period selected however the error message still pops up.  Thanks in advance!JT

Has anyone switched External Authentication from AzureSSO to OktaSSO?  How did that process go?  Was it seamless or were there user login issues? I'm trying to get ahead of this as my company is looking to convert all logins to OktaSSO.

Hello,We are doing an implementation and my client needs to be able to have one legal hierarchie and one management hierarchie, the twist is I need to be able to share the accounts between the two.Example:Legal parent     AccountManagement parent     Account (Shared)I can't use extensibility because the two hierachies share no similarity whatsoever, the only thing they share is GL accounts. In my Oracle days that would be a piece of cake, but for some reason I can't make it work in OneStream Accounts dimension.Thanks in advance 

Hi All,  For some reason, local entities are translating incorrectly to reporting entity - they are not using the FX rates given. The FX setting are to use scenario FX rate setting (see screenshot), not the cube.  When doing the recon - I identified the differences when translating (see screenshot). Additional, it's taking amount not reported in local entity, and reporting it to reporting entity.    What could be the problem?

Hi,sorry the basic question, I have noticed the Cube POV can be saved as a file (Save cube pov to favorites). However, I have not been able to do the opposite, to set the Cube POV from a file. How do I do that?Thank you

Does anyone know whether it's possible to modify the Excel journal upload template to force upload to multiple individual periods from that one file?If it's possible, can anyone provide a brief how-to for setting something like this up?  The request is to be able to upload this to a forecast scenario so it's really outside the normal parameters of a typical journal.I know one easier alternative is to create an _ADJ member and just load the data to that but that's not the ask from the team.Would be grateful for any advice.  Thanks

Hello, In the SQL table editor component, we can define namely the Schema Name, Table Name, Table Column Names, Where Clause and Order By Clause : However, I am using a Table that has encrypted data, so I would need to use my symmetric key when loading the table. For that, I need to write an SQL statement beforehand : OPEN SYMMETRIC KEY MyKey DECRYPTION BY CERTIFICATE MyCertificate; and a CLOSING statement : CLOSE SYMMETRIC KEY MyKey;  However, the SQL table editor component doesn't allow to add these fields. --> Is it possible to add these statements when the SQL table editor opens ? Could it be done with a business rule ? More generally, how can we handle encrypted data ? Regards,

Out of curiosity, are there any folks out there that have opted to have some "Generic" users/licenses versus specific named users in their environments? A couple of places where I think a generic would be relevant is when giving auditors view only access to the application. If there is a team of 3-4 auditors who need view only, would it not make sense to just create 1 generic user?On the flip side, what are big reasons people choose to go the named user route besides the obvious ones of audit trail for data loads and form completions and workflows?Just trying to get an idea of how popular generic users truly are when I personally have only seen the named user route. 

Hi all,How do you handle preventing users from accidentally loading data via an excel XFSetCell or QV submission to O#Forms/O#BeforeAdj on a scenario that’s locked on the workflow in OS? I’ve submitted this via OS support and there’s an enhancement request for “Requesting option to prevent users from submitting data in Excel via XFsetcell or QuickView” but there’s no workaround that they can provide. Our FP&A users load all data via excel and they’re generally educated enough to know what dimensions to change, but sometimes the communication doesn’t go out timely enough from corporate FP&A to stop loading adjustments (though the scenario is locked promptly on the workflow) and so we run into this issue. Any thoughts or feedback would be welcomed! Thanks!

Client has a requirement to manage percent ownership data on a monthly basis and also use Organization by period. They would like to use a form for that. Is there a way to take the data from the form to Percent ownership type property so that we can still maintain the Org by period.

Hi, we received the following error message in OneStream on some of our scheduled data management tasks; these tasks load workflows by pulling data from an Azure system."Summary: Execution Timeout Expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.Operation cancelled by user. (SQL Error Number -2146232060, -2, 0). The wait operation timed out"My understanding is that the this indicates that OneStream cancelled the operation (and failed the task) as Azure took too long to respond. How would I go about preventing this issue for the future? 

Are there any standard integrations or connectors for OneStream and CyberArk?CyberArk is a tool that stores credentials and logs/records user sessions when performing ad hoc maintenance, patch installations, bug fixes, configuration changes, etc., that require elevated administrative access.We would like to use this tool for OneStream when promoting changes into our production environment, and our IT organization is wondering if there are standard connectors between CyberArk and OneStream. 

Hi, looking for experience and OS counterparts for support to automate ( plugging it directly in OneStream from source) FX Data Feed. Concern currency is USD.Which source are used - OANDA, Eurpean central bank or other sources? How does this work to get actual closing Rate, YTD Rate and for information purpose monthly average rate in the system?Actually we are loading every month from ECB into csv, working in excel - convert from Euro into USD for each currency, closing, YTD and average and than loading - set cells - into OneStream.Thank youAngelika 

HiWe have a requirement where users need access to all entities in the organisation but only for a specific set of accounts.Currently we have a simple security model where users are restricted by Entity. I was hoping that I could create a Cell Data Access Security rule that will give them access to entities outside of their group for the specific set of accounts, but it feels as though the Entity access overrules the Cell Data Access Security?To be clear I have Group A and Group B, restrictions  defined below.Group A :- Full access to all Group A Entities- Additional access to Group B Entities (for specific set of accounts) Group B :- Full access to all Group B Entities- Additional access to Group A Entities (for specific set of accounts) 1. Is it possible to grant access as I have described and am I just doing something wrong?2. If the approach I am taking isn't the correct one, what is the best way to implement this kind of logic? Thanks,Mark

Hi, I am looking at the Splash Berlin landing page and was looking for some guidance as to how to create the 2 lines of buttons at the top of the page as I'm trying to create a landing page at present. Thanks for any advice.   

This feels like it should be easy, but I'm struggling to get it working correctly... We're trying to build-out a variance scenario where folks can enter data to bridge their forecast to actual. Our set-up is similar to the variance set-up in GolfStream where we've created a variance scenario, a few dedicated variance accounts (Sales, EBITDA, etc.) and then flows to house the different drivers of the variance (e.g., volume, mix, etc.).Where we're struggling is with the View set-up. We would like to have users enter variances for MTD activity only, but we want the MTD data entered to total up to a YTD number (i.e., enter discrete values for January, February, and March, but then be able to use V#YTD in a report to get the total of the Jan/Feb/Mar variances entered for a given account/flow combination). I've tried setting the scenario up for MTD, and the form works fine for the first month we tested. However, when we open the form that's we've created for a subsequent month we get the val

In the case of a parallel hierarchy the status of the entity changes if the data is modified on the scope of another hierarchy,Example: Entity A is 100% owned by parent A, and 90% owned by parent B; we enter the scope with Parent A on the 1st of the month, we launch the consolidation with scope A and the entity has an ok status; on the 20th of the month we load the scope with parent B; the status of the entity is changed under parent A as the scope data is entered in local and the parent becomes a partner.How can we ensure that the status of A does not change under parent A after changing scope B? THANKS

I'm having trouble setting up local OneStream Server in my system.