OneStream Platform Forums

Hi,  I am just wondering, is this a limitation of OneStream? Does the column member filter support only two levels? Are we unable to add additional levels beyond this? Thank you to those who will share their inputs.  

The dashboard visibility is set to "Always" and the security access group is set to "everyone". If I select the dashboard in Oneplace to open, it brings me this error. Could this be related to the workflow not being set accordingly (permissions, data, etc)?  

I am trying to build a cubeview to enter yearly rates in cubeview for forecast scenario. Is there any way I can do that? Idea is to enter rates during budget and use to for all forecast months instead of loading by periods.  

 Hello, has anyone come across this message using Report Viewer? The export function is not an option when selecting the "View Report" icon. 

I am running into an issue with putting together intercompany reports. Basically, if an entity has an intercompany partner that is not a consolidating entity, no elimination would occur at the parent (as expected). However, this pair would still show up on my IC matching report. Has anyone dealt with this type of issue with the IC reporting and has any tips to put me in the right direction?

Hi Everyone. The issue is that I want to run the following Process, but upon execution, I receive the error shown below the code. I do not understand this error because a WFProfile is correctly sent in wfChildClusterPK, specifically 'PLP ARGENTINA.Export to Cube'. This Workflow does have an assigned entity, so I do not see what could be causing the error in this process. Dim pcProcessInfo As ProcessCubeProcessInfo = BRApi.DataQuality.Process.ExecuteProcessCube(si, wfChildClusterPk, StepClassificationTypes.ProcessCube, False) ' Summary: Business Rule error. DataQualityEventHandler. Unable to execute Business Rule 'DataQualityEventHandler'. Error processing Data Management Step 'CLEAR_PLP_WF'. Invalid parameter. Entity Filter, E#Root.WFProfileEntities. I am executing this process in another WFProfile because I want to create a complete workflow for everyone. However, the current process is the one causing this error.

We are on OS v7.4 and moving over to OS v8.5. We have both versions up and running as we move over. While running QVs using the Spreadsheet module within the app and setting the Data Style to "Comma [0]" in both, it appears correctly in v7.4 with negative numbers displaying as (100) but in v8.5 it shows as -100. Same thing if we pick "Currency [0]". (see screenshots below) Is there a chance that the default style didn't make it into OS v8? OR, is there a place/menu to modify this default style without creating a Custom style? We noticed this happening in version 8.4 as well, but we upgraded to 8.5 and it is still having this issue. Thanks!Currency [0] 

Hi Our YE reporting pack is based on a book which retrieves a Word document (table of contents etc.) followed by a number of CVs (financials). The page references in the table of contents is static. I would like to Supress Zeros in all the CV, which would place the CVs on different pages, depending on which entity runs the book. Therefore, I would like to explore if there is a way to use dynamic page references, e.g. by putting a reference to which page a certain CV would be placed. For reference, we are currently on v7.3 but upgrading to v8.5 within long. Thanks in advance!

Hello, I am new to building cubes in OS, I am attempting to build a calculated column based on data from two other columns, I have created a nested member which correctly brings in all the data. When I attempt do use GetDataCell I return errors that it cannot find my named Column. In the screenshot you can see the member filters (highlighted are the same rows) Here you can see the output when I run the cube view. Please let me know if I cannot reference in this way and how I may solve the problem

I would like to know more about this workaround. In our company, some users utilize the PDF view option to send their reports, not only within the company but also for SOX controls. Therefore, it is important for us to continue using the PDF view in OneStream 7.4v. Questions: Does this workaround impact only dashboards, or does it also affect Cube View reports? We have only been given the option to remove PDF. Is there a possibility of an upgrade to continue using PDF?   Thank you! Laura 

In the data record tables in the database, there are status code columns. For example. Here are what those status codes mean: Status (Stored Bits) Existence Type Storage Type 16 NoData StoredButNoActivity 17 IsRealData StoredButNoActivity 18 IsDerivedData StoredButNoActivity 32 NoData Input 33 IsRealData Input 34 IsDerivedData Input 37 IsDerivedData StoredButNoActivity 48 NoData Journals 49 IsRealData Journals 50 IsDerivedData Journals 64 NoData Calculation 65 IsRealData Calculation 66 IsDerivedData Calculation 80 NoData Translation 81 IsRealData Translation 82 IsDerivedData Translation 96 NoData Consolidation 97 IsRealData Consolidation 98 IsDerivedData Consolidation 113 IsRealData DataCellDetail 144 NoData DurableCalculation 145 IsRealData DurableCalculation 146 IsDerivedData DurableCalcula

Hello, I wonder if there are customers who use the OneStream solution "Security Audit Reports" in a non self hosted environment? We use OneStream as SaaS customers and we need to audit the security settings. Setup instructions for "Security Audit Reports" are written for self hosted environments. Furthermore I wonder, if anyone uses "Security Audit Reports" in production directly as it is very inconvenient to have this solution running in Dev (and for SaaS customers, there is no Dev environment available by standard). RegardsMartin

Hi Everyone, I'm trying to use SQL with Onestream but don't know where to start , this is what l want to do in Onestream with SQL  create tables in Onestream, load data , modify data and keep them up-to-date. Demo will help me a lot.

Hello, I am facing a problem in making dynamic names for BI-viewer. I have a data adapter with Command type as Cube view. I am using this adapter in BI-viewer. I want to make the column names similar in cube view.  For example, in my scenario I have columns changing according to the time.  but here it will show as Col0Value, Col1Value. As per cube view headers, Col0 is 2024M1 and Col1 is 2024M2 and this will change according to time updated for next periods. It will not be same every time. How to get the same names as per cube view into BI-viewer column list.     

Hi all, I am trying to divide 3 different rows in one Getdatacell formula and I am getting an error saying this: Is this even possible?  If not, is there another solution?

Hi,  Is the below comment possible in cube view?  

Good morning, I have an issue with my Balance sheet report. When I look at my Retained earning CY_NI it is not equal to my P&L for q4. Not sure what to do.    

Hello,Is there a way to remove the blank row between the title and subtitle when exporting to excel. Below are the settings I have and the outcome:Thank you!!

Hello, I am using a textbox to input a date, and its action property is linked to a parameter with the type set to "Input Type." When running the dashboard, the user wants today's date to be populated as the default value instead of manually entering a date. Has anyone tried using the Date function with the input parameter type for this purpose? thank you!  

Hello All, OS experts - Greetings ! I am trying to complete the following code to extract the year and month from a given date. To help with validation and debugging, I've enabled BRAPI.ErrorLog.LogMessage to display the variable outputs in the error log. However, for some reason, it is not displaying any values in the error log. I would greatly appreciate any insights into what might be wrong with the code. Here is the code I am working with: Dim vDate As String = args.NameValuePairs.XFGetValue("Date")' e.g., "01/01/2025" (MM/DD/YYYY format) ' Log the retrieved Date for debuggingBRAPI.ErrorLog.LogMessage(si, "vDate: " & vDate) ' Ensure vDate is not null or empty before proceedingIf Not String.IsNullOrEmpty(vDate) Then    ' Extract the year (last 4 characters) from vDate and convert to an integer    Dim vYear As Integer = CInt(vDate.Substring(6, 4))    BRAPI.ErrorLog.LogMessage(si, "vYear: " & vYear)     ' Extract the month (first 2 chara

When creating a dashboard in the default workspace you are able to pass dashboard parameter values to the data management sequence through the parameter section of the execution script:You can also use an Input Value parameter and create an extender process to populate the Input Value and then retrieve that value for a DM sequence or BR.However, when using user defined workspaces, I have only been able to successfully pass parameter values from a dashboard using a literal value (process on combo box executes a rule to populate a literal value with the most recent user selection, literal value is read by DM and BR processes).The issue with this literal value process is that the value is left at the value from the last execution of combo box selection so it requires the user to change the value to some other value, then reset the value to ensure the literal value has a valid stored value.Additionally, this process if being used by multiple users, may cause confusion if two users are chan

For starters, we're on 8.2.1.In reviewing some automation rules that were written by my predecessors, I've been trying to move away from the Harvest folder batch processing. ...mostly, because I don't want to deal with cleaning up the clutter it leaves in the filesystem.In most cases, it's trivial to switch to BRApi.Import.Process functions and I've done this successfully but I find that running the Process Cube from a BR acts a bit weird. BRApi.DataQuality.Process.StartProcessCube and BRApi.DataQuality.Process.ExecuteProcessCube both start the process just fine and the process does exactly what it should. However, both methods only start the process and immediately move on to the next instruction. I can't seem to evaluate them for failure, duration, or anything else as they both instantly and always return that they finished successfully. Question 1: Both functions seems to behave identically and incorrectly (or at least unintuitively and undesirably for me in this case.) Other than t

Hi all, I am working on the 445 calendar and 2025 started on a Wednesday so into my Actual Data dashboard I do need to load the last 2 days of 2024. I have those days in the load file but they do not show up in the dashboard.  In the CV I am using this set up: T#2025.base.remove(2025W53).  Looking forward to any tips :)  

Hello OneStream Community,I am working with a Cube View where I need to display the Income Statement data for the end of every year (December). The data should show up as the beginning balance for the January month in the subsequent year. To achieve this, I used a Row Override1 member filter with the formula T#povprioryearm12.The Cube View includes four dimensions: Entity, Division, Cost Center, and Accounts. However, I am experiencing slow loading times when the view is being accessed. it is not exporting to Excel to validate.I would like to know if there are any best practices or strategies for improving the performance of the Cube View in this scenario. Are there specific optimizations I should consider for the member filter, the dimensions, or the Cube View configuration to reduce loading times?Any advice or recommendations would be greatly appreciated!Thank you in advance!

Hi, everyone, We have a lot of confirmation rules assigned to workflow. Could you please advise is it possible to hide passed confirmation rules in order end user can see only failed/warning confirmation rules list?