Application Build

I am working with two different Onestream clients and having login issue with one client. See attached picture of the error. I have tried clearing cache, restarting the machine multiple times. Any help to resolve this issue is appreciated.

I am new to OneStream and I am trying to find out how you retire an entity.  I have gone into the entity and tried to change the vary by scenario type but cannot get to where you would change to False for "In Use".  Any suggestions

My requirement is i need to provide few users(Admins) only oneplace and system tab access, and few users(Admin) i need to provide only oneplace and application tab access.Please any one give me detail steps on this, Thank you.

Hi! I just ran a parcel and didn't receive an email.  This has been working fine.  The log shows it was successful.  Email's not in junk folder either.  Do you know what else I can check? 

Hello, I am looking to build an Input Parameter and additional rule (if necessary) in which the User will be prompted to input the beginning of an Entity (eg. A123) and the Cube View will return all Entities in the rows which start with A123. (eg. A123_400, A123_500, A123_600). Has anyone created something similar to this? Thank you!

Hi All,   I need a same base member in different parent members in Account dimension and it should aggregate to their respective parents, do i need to create multiple base members or I can use the relation, can anyone suggest what is the best way to achieve it.   Thanks in Advance.

Hi, I have an Application table containing a number of attribute columns, a currency column (EUR,USD,TRY...) and an Amount column. The client wants a twin table that has all rows from the table 1, but with all values converted to euros. I already have a dashboard that shows table 1 with a button to refresh its content (pulling data from other Application tables). What is the best way of refresh table 2? I was thinking of creating an extensible rule to update table 2 on demand, but I have noticed I cannot use the api.fxrates in there... Thank you

Dear OneStreamers! Building and maintaining an OneStream application can be done in many ways, but I would like to hear how you have approached the challenge of managing the build process, hereby testing, deployment etc. I would like to hear input around:Build Process:What tools/methods make your build process a breeze?Any automation gems? Version Control:Git, SVN, or something else? How?Share your repo structuring magic and any branching/merging tips.Visual Studio / Visual Code?Testing/Quality Assurance:Testing? Automation, frameworksCI/CD Integration:How do you deploy between applications/environments?Challenges and Wins:What hurdles have you faced in this realm?Any game-changing solutions?Thanks for any input. Maybe we can gather some wise words

Hi, I have created dashboard with multiple dashboard group. Is there a way for me to disable some of the groups and shoiw  what is relevant in Oneplace by security to the end user? In this case- I want to only keep DS01_Cube data and not DS02_Period_Filter   Thanks    

Hi everyone,I have a case in my hand I'd like to get your opinions on. I have an 12 period application already built so custom time dimension is not an option.The request is:1. The client wants the P12 results to be available for reporting but the P13 results will be final results for the year.2. They use P13 just like any period. There will be data load, journaling, data inputting and consolidating.I have an option in mind to handle this but let me know your comments and/or any other suggestions you can think of.Building a dashboard that would run a data management job to push the data from Actual scenario to Actual_P12 scenario to archive the data there. After doing that they can override P12 data in the Actual scenario with P13 data. If I'll go with this option I want that copied data locked and not changing even if they run a consolidation. Can you let me know how I can do that? 

Hi, I am creating a new entity, but the currency is not available under the settings Currency option. How can I create or add a currency in this specific setting field? Thanks!  

I ran an import which was stuck on parsing data, I clicked on Cancel Task, but it has been stuck on 'Cancelling By User' task status for over an hour.Any solutions to cancel the task? I am unable to rerun the task as it is still "running"

HI All,Good morning.Could you please share the documentation on 'Auto translate Currencies option' in entity properties. Also, how it works in below mentioned scenario.Scenario:  I have parent A and Children B both are tagged with Default currency 'CAD', but I want to translate Base and parent to USD in this case can I set Auto translate Currencies option to USD to convert data to USD without changing Parent A default currency to USD.Thanks in Advance. Thanks,Sandeep 

Hello ! I would like to use a data buffer that would read data from another Scenario than the one set in my data management job, is it possible ? Right now, I have a simple formula that should retrieve data from scenario S#Simul while I'm running the business rule from a data management which is set on S#Actual, but it returns nothing :   Dim dbr_keys As DataBuffer = api.Data.GetDataBufferusingformula("RemoveZeros(FilterMembers(S#Simul:V#Periodic:AEAccount1:F#None:I#None:O#Forms:U2#None:U3#US:U4#None:U5#None:U7#HO:U8#None:F#None, U6#C4.Base))",,False)dbr_keys.LogDataBuffer(api, "dbr_keys",100)   Is there a specific data buffer script to use in order to run on another data unit ?   Regards,

We have our main hierarchy that has intercompany eliminations working as they should. We also have 2 alternate hierarchies where one is eliminating as it should, and the other is not eliminating.  Consol -   Primary Hierarchy - Percent Consolidation 100Consol - Alternate hierarchy - Percent Consolidation 0  - Elimins not working at first common parent,Second Alt Hierarchy - Percent consol 100 - Eliminations working as they should.  

All,Is there a way to extract metadata(entity dimension) with just parent child relationship information and not all the application member properties  using the usual export process?

I am wondering where are the files in the Application Database Folder and System Database Folder physically stored? I am able to find the files under FileShare in the directory where OneStream is installed, but I cannot find the physical folder structure of the Application Database Folder and System Database Folder. Please advise. Thank you

Does anyone know how the "Has Data" field in an FX Rates CSV file is actually being used?   The Design and Reference Guide lists it as one of the columns in the file. I've only seen it extracted with a value of Yes in this column. What is its actual use?  Is it necessary for Loading FX Rates?  What does "No" mean, for that matter what does "Yes" mean?  

Hi, do you know where can I find the Forgot Password option? 

I need to copy one application to another, for that I am wondering if i need to go to the OneStream SQL server and extract a database ( or database schema), and if so how would i do this?The goal is to extract the entire data of an application to import it in another app

Hi All, I need to calculate the base members and roll up to Total member as shown in the below picture I tried using GetDataCell formula but am getting error, can anyone suggest how to do that.Please find the below snaps for your reference. Thanks in Advance.   

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.