OneStream Platform Forums

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.    

Hi, I am testing V 7.2.3 in our Dev environment. Production is still on 6.5. The security and user groups, data sources, and workflow profiles are identical between the two. I am able to import and validate TB's in the workflow, but several others are not able to Validate in the Dev environment. Has anyone else experienced this?  The validation message is "No Security Access", but the workflow profile and security groups are idential to prod. Thanks!

I created a new dimension member as a child of our direct_department member in UD2.  I have updated all of the transformation rules and mirrored the member properties of its siblings.  I have loaded this month's data which includes the new department and none of that department's data is showing up following the load/transform process.  I'm not receiving any errors either.  Has anyone experienced this or has an idea of where I can look to resolve the issue?

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!  

Hi experts, hoping someone can guide me.   Our P&L is recorded by Line of Business (UD2), however our balance sheet is recorded to UD2 None.  FPA has a requirement that they currently handle manually to "allocate" the balance sheet to the lines of business based on the percent of revenue.  Our partner initially achieved getting closer by using a dynamic formula on UD8.  This does not ultimately provide the accurate results at the consolidated level (due to nature of dynamic formula).  We believe we need to change this to a formula pass but it is proving to be challenging.   We are open to suggestions, using UD7 (tracking) or UD6 (reporting).  I am also open to creating a mini alt acct hierarchy since it really only needs to apply for a handful of summary level accounts.  (Coding examples would be so very appreciated!)  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

Hi,is there an easy way to setup a workflow step to run a data management sequence?I have an existing data mng sequence and I'd like users to run it from a workflow profile.Thank you

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?  

hey All, I have request to dump out all the imported source documents to a central location. Not sure if it is possible. Looking for some information on Where these files/documents are stored within OneStream is there a way to export these files using a BR              

Hi there, We need to see cube view figures which are rounded to an integer. Could you please advise how to round figures in cube view?  

I'm trying to execute a calc after an input data in a CV, when the user click in the OS default save button (giving the flexibility to use a DB, CV or Excel addin with the same CV) Is possible?

We're working on a solution, where users can enter and view a date through a Cube View using the Cell Type Date. The challenge is how OneStream handles date's (datetime) with time-zones. When a date is saved to the backend, it's converted to UTC time-zone. The Date component in the Cube View is also Time-Zone aware, so that it uses the local time of the user, to convert back from the backend UTC to local-time. The challenge with this is 2 fold: 1) Assuming we would calculate a rent for a given period. The user, based in CET time-zone, enters 2022-1-15 using the Gridview. This date is converted to 2022-1-14 as UTC (2022-1-14 23:00:00). Using a Custom Calculate method to calculate the rent from start (2022-1-15), now adds one day more, as the server time is UTC. (don't mention Daylight Saving Zone)  2) If another user, based in US Central, is reviewing data in the same Grid View (and same POV), this user will see a wrong date, as the server UTC date, is converted to this user's loca

Hi, we are implementing OS at present, and this is our first-ever project in OneStream; I need guidance on Business Rules. I am not sure what business rules we need to consider after and before we import the data from the Client system to match the client's legacy system data with OneStream numbers.Thanks,Preeti

Trying to understand a little more about this instance. This message appears when trying to run a period that has no data. Some questions have emerged around:Can we customize this message? (Thinking no, it is standard OOB message describing what is happening).What is happening? Does the data require consolidating in order to be leveraged? Under what circumstances would you receive this message relating to dashboards?