Application Build

Hi OneStream, Please let me know when shall Core Platform Architect certification exam become GA? In the exam portal i still see OCP - LA certification exam. Thank you,

I've created a form template and assigned it to a workflow profile. However, each time I access that workflow profile, I have to manually click on the form to open it. Is there a way to set a default form template so that it opens automatically when a user navigates to that specific workflow profile?

Hi, I've created an XFBR String Service file, and I would like to reference other (also XFBR String Service) files to break up the XFBR rule to manageable pieces. I keep running into compile issues. Any insights would be helpful. Thanks. Here are the screenshots of what I have: -Main XFBR String Service file (referenced in the Service Factory): -The secondary XFBR String Service file I'm calling & error: 

Dear Community Members,Due to my error in the initial definition of culture codes I ended up with two es-MX local language options in the dim library.I removed the es-MX culture code. One of the two options went away in the DimLibrary, but the second one persists.Then i removed all descriptions from the MemberDescription table where CultureCode = es-MX.  Still the DimLibrary shows Spanish AND even more surprising shows the Spanish descriptions.Which leads me to believe that those descriptions are cached somewhere?Any tips?  My ultimate goal is to have es-MX culture code and local descriptions. But only one Spanish in the DimLibrary.SystemConfig (this is a locally hosted client) only has en-US definedMemberDescription Table has only Englishbut DimLibrary still has Spanish descriptions but only where defined before. Other members that never had a local translation do not show Spanish (Mexico), see Scenario Actual below.Thanks in advance

Does anyone have any information/advice on testing applications in OneStream? Are there gotcha's or must test items?

Hi, is there a way to copy the list of all functions displayed after args.cubeview.?  

Hi,  I am in the process of testing security for applications. I have view dimension library access, I do not have manage meta data access. I have added security groups to access and maintenance groups for which i only have access to "Access group". I cannot edit any members, which is correct based on my security, but i am trying to understand the reason why the meta data is not greyed out? It appears as normal, and i can edit, but when i try save the changes, it says i do not have access. Which is great, it means it works. I was just expecting it to be greyed out like for example cube views. Just curious as to why meta data isnt greyed out as well? Would appreciate any feedback

I have an AIP (annual incentive plan) input form whose input range from 0 to 2. Can I create formatting rules to restrict users from entering any number beyond the mentioned range?

I need to automate a process of Extracting certain Dimension Descriptions into a Comma Delimited text file for exporting into PowerBI.  The application extract puts it into an XML format, and I need it into a comma delimited file.  Any suggestions?

Hi All,In your OneStream implementation, how many environments do you have?  Dev, UAT and Prod?Or do you also have Pre-Prod environment that is common in ERP systems?Also, in the UAT environment do you also have copy of data so that when testing happens or developers need to test the changes - there is enough sample data to test?Would you consider brininging data from Prod, randomize it and load into UAT env so that UAT env data at all intersections as Prod?Thanks!

Hi! We are trying to control the size increase in our production application. We know the growth comes from: Stage tables that allow users to drill down and back onto source data. Data records Audit tables (they can grow a lots if they are recording continuous changes to rules, data for example) Logs which will impact Framework database growth (task activity and error logs, will vary depending on the detail login set in BR, DM and on the system configuration as well as your retention policy) Load transactional data, which will increate your data units and data records unnececarily, which BIBlend should be used for this type of data load instead of loading it to the finance cube. We have analyzed it and we realized the StageAttributeTable and other stage tables has a significant size. Has ayone performed databse maintenance by deleting data from the stage tables? Is it possible to do that while keeping the cube data intact and workflows completed? Any ideas or best practices regarding

Hi everyone, I have a business rules that is triggered through a dashboard. This Business rule is looking at a True/False parameter. How do I add the parameter to the dashboard and with a dropdown list showing the valid values (true/false) that can be used to save the value to the parameter? Thanks in advance,

Data Management Access SecurityPlease share your expertise to set up a Cube's Data Cell Access Security / Slice Security to limit data read access as outlined below: Dimension: U1# - GeographyTotal_Geography = Child 1 + Child 2 = Total / Top         North_America = Child 1 / NA         International = Child 2 / Int'l Slice Security: Access Level - Read Data by Geography - in a CV and a QVTotal_Geo_Data = Read Total data | Read NA data and Read Intl data         NA_Data = Read NA data | no data access = International and Total         Intl_Data = Read Int'l data | no data access = North America and Total TY for your practical advice - SMEs. U1 Dim: Geography.  

Hi, I'm seeing this error for a user that has been setup in OneStream. We've attempted to exit out of the application and run it, but the same error message persist. So far no one else is experiencing a similar issue. Has anyone experience this issue? Would it be simply a configuration issue? Thanks  

Hello,I have a button which is fed from a List Box seen belowUpon clicking this button, I would like Users to navigate to another Dashboard where the label component and cube view open with this button selection.Are supplied parameters the way to accomplish this? If so, what are the correct configurations to achieve this.Thanks for your help! 

Hello everyone, I hope you are doing well!I’m having an issue with an Excel extraction of my data rows through drilldown. I have a French profile and my Excel is set to French, so when I have separators with spaces, it extracts the amounts in a strange format.Have you encountered this problem before?Thank you very much!

Hi, After we recently upgraded to V8.5 , it seems the slice security has stopped working. Can anyone suggest what would have gone wrong? Cube Data Access Security for Entity is True The parameters are set as  User is in group and Data cell in the Filter -> Apply access and stop (Read Only) User is in group and Data cell is not in the Filter -> Apply access and continue (No access) User is NOT in group and Data cell is not in the Filter -> Apply access and continue (No access) In the Account filter , am passing 1 account say Sales but when am checking the access , user is able to access all the accounts. There is no other security available in this particular base cube other than this    

Hi everyone, I’m interested in learning how other organizations are leveraging OneStream to track inflation and other account-related metrics. Currently, our approach involves using the Account dimension to explicitly separate inflation impacts for specific expense categories. For example: FOOD_BEV – Food & Beverage Expense INFL_FOOD_BEV – Inflation related to Food & Beverage Expense These inflation rates are externally calculated and loaded via XFD uploads. To support different reporting views, we load the data into three separate accounts: _PER – Monthly _QTR – Quarterly _ANN – Annual We also use a view dynamic account without a suffix, which adjusts based on the selected view. Exploring Alternative Approaches I’m considering whether using a User Defined (UD) dimension might offer more flexibility. For instance: Keep the account as FOOD_BEV Use the UD to switch between metrics like: "Dollars" (actuals/estimate) "Inflation" (loaded via XFD) "Per Guest" (dynamically calcu

Hi Team, Based on Business requirement we have created Stored Calc for Account(A#KPI_GSS_OP_IN_AFT_TAX_ROIC_WIP). But while running the Force Consolidation Step at Parent entity level getting the below error. and consolidation working fine at entity base level and data is sending from source to Destination. Can you please help us on the below issue.  

Hello, We want to review both our Management and Stat reporting on a monthly basis. The 2 approaches we are considering using are: employ an Audit / Nature UD to build the separate views by adjustments layered over the local GAAP import.                      or use a separate Scenario for each view with the Local GAAP data being fed into each scenario. One of the main differences between the two views would be pre-acquisition TBs for newly acquired companies being included in the management view for comparative purposes. Would be Interested to hear anyone's feedback or suggestions - thanks!  

We're trying to reduce the size of a large table in OS (about 650GB). Our initial idea was to copy the rows to a new table and then rename it, but the insert process takes too long due to the size and ends up timing out. Deleting records from the table itself seems risky and take's similar duration.  Has anyone dealt with something similar? Would appreciate any tips or suggestions for a faster and more efficient approach. Thank you! 

Hello OneStream Community, For our upcoming budget cycle, we want to create an inputsheet where the Time dimension is displayed in columns, with each month (January through December) as a separate column. Our current data sources are configured with the time dimension in rows, and I'm struggling to set up the data source to handle a matrix layout. I've tried using data transformations and source dimensions, but I haven't been able to make it work. Has anyone dealt with a similar scenario and can provide a clear method for configuring the data source and mappings correctly? Any guidance would be greatly appreciated! Thank you, Jasper

My colleagues in OneStream, have you seen this error before? Since this is the first time I’ve come across it in a standard load scenario with everything else validating, I thought I’d share here to compare notes. Any insights on what could be “behind” this error in practice would be really helpful for building a knowledge base around less common OneStream load errors.While running a data load in OneStream, I encountered an "Invalid Cube Name" error. What made this surprising is that all the usual suspects checked out fine:Workflow setup was validated.Data sources were reviewed.Transformation rules were checked.Rules on members who call cubes were also confirmed.Cube mappings looked correct.Despite all of these checks, the error still occurred.This message is unusual because it doesn’t typically appear if the metadata, cube structure, or mappings are aligned. In most cases, it points to something deeper in how OneStream is resolving the cube context for the workflow profile or the enti

Hello Team,I am unable to open the OneStream application and getting "Application cannot be started" error after downloads.Expecting solution as soon as possible.Thank you.Regards, Praveen

Is it possible to do a live character count using a text box and label component inside of a business rule that counts characters as they are being typed into a text box component that is used in a dashboard? The contents of this text are written to a relational table but as for the character count, I want to do that live BEFORE I write the contents to a relational table. This is on an 8.4 application.