Application Build

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?

Hi,  at the moment we are migrating OS from v6 to v8. The logon procedure in V6 and V8 is SSO, while login in V6 on there is a small pop-up window to choose an account for OS. This pop-up automatically closes after the choice. In V8 the button External provider sign in is not there, instead via logon it opens a full window that does not close automatically.  is there are solution to get this full web-page closed in v8?   thanks,

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,

Is there an easy way to bulk delete members in OneStream?

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.

Hi Team, I am trying to build  a Stored calc. My account type is "Revenue" & Formula type is "Formula Pass 11". Here, if i give full combination (All Dimensions) data is sending from  Source to designation. and one more thing if i give any variables Data is not sending  from source to Destination. can you please help us how to make the calc as dynamic since i am giving all combinations.

Hi there,We've developed rules that works properly in actuals with monthly frequency. Is there a way to use the same rules in other frequencies? I tried to link them to a budget scenario with yearly tracking frequency (Scenario property), but they are applied at the end of the year (for instance 2022) instead of each month. This behavior is kept even after changing to Monthly frequency, or "Member Filter" using "T#|WFYear|.Base". Is there a filter on the time from the WF itself?Ideally, we'd like to keep the actuals conf rules as they are.Thank you for the help.Regards

Hey Team, I’ve observed that users are currently able to load data via Excel/Spreadsheet tools (Quick View / XFset) beyond the defined Workflow Time Period range for any scenario. This behavior persists even after setting the following Application General Properties to False: Allow Loads Before Workflow View Year Allow Loads After Workflow View Year Despite these settings, the restriction does not seem to be enforced, and users can still submit data outside the intended time range. Could you please advise if there are additional configurations or security settings required to fully restrict data loads outside the Workflow Time Period—especially when using Excel-based tools? Any guidance or best practices would be greatly appreciated. Best regards,Yogesh Kumar Goyal