OneStream Platform Forums

Hi All, We are using the OneStream 'cloud' solution with the desktop application required to be installed to access the OneStream functionalities. We would like to perform load/performance testing for the application with 250+ users to check its performace under the load. Have anyone done performance or Load or Concurrency testing for OneStream cloud application which is accessed through OneStream desktop application? If you have done this testing before, please share the performance or load testing tool and protocol used for testing the desktop application of OneStream with cloud solution. Your help will be much appreciated. Thanks!

Hi ,We have DEV and PROD environment and we want users to have read-only option to cube views in PROD environment.  If we restrict the cube view group maintenance, users could execute the cube view  but not see how it defined. All options are greyed out like shown in below picture.Is it possible to have Read-only option for cube view in production?  

I've exported a configuration via Settings --> Configuration --> Export as denoted on the documentation page.  In my build, I've iterated through additional columns, accounts, formulas, etc.  The export appears to only include artifacts from my initial build and is omitting anything added after.  In the Configuration Header (see below), it's dated 5/4/2026, but I just exported the file today, 5/28/2026.  Am I missing a step or was this the intended design?  "ConfigurationHeader": { "ProjectCode": "PLN", "HelpAboutVersion": "PV900-SV120", "Version": "1", "ExportDate": "2026-05-04T13:10:33.8337549+00:00", "ExportedSchema": "plnb1", "TypeCode": "B", "TypeLabel": "Workforce Planning", "Instance": 1 },  

Hello, Trying to build a business rule to send an email once a button is pressed. The business rule that I'm trying to use is encrypted and I cannot get into it so I was trying to figure out a way to recall that business rule to check if a Lease change status to submitted. I read something about Referenced Assemblies, but I'm not fully sure if that's right or what I even code it as in my current business rule. This is the BR I'm trying to call into my current rule Thanks, Will

Hi,Anyone on Version 8 who's actually tried to use this 'enhancement' feature in Cube Views?  We requested this on Ideastream a long time ago with a lot of support. I can see this command is now available in the header format dialog; however, it would appear that the only thing it does is change the header from left justified to center view.  There does not seem to be a way to actually 'merge' column headers, despite the fact that it's called "MergeAndCenter". Even the system documentation appears to confirm this behavior. Someone please tell me I'm missing something here and it actually is possible to merge column headers, because we really really wanted this feature. Thanks

Hi,Is there a way to paste values from Excel into an empty cube view? I get read only cells with pink background. I tried already to use A#NoneAny help is appreciated.

Good afternoon,I'm encountering an issue and hoping someone could share how they've worked around this in the past.We have a task that runs over a finite number of Entities.  Historically the underlying Business Rule was kicked off via DM Step with Entity: E#Top.Base.  It's not exactly "Top" but something similar to hopefully capture all relevant Entities to this particular task.  The runtime was always a consideration as it also runs for all remaining periods within our current year.In an effort to reduce runtime we introduced a "Unique Entity" parameter.  This is defined by a Business Rule that runs and queries a source table to determine only the Entities that this particular task needs to be run on.  In practice this has greatly reduced runtime on the task.  Runs more than 2x faster.The problem:The source table that populates the list of "unique entities" is also updated within the same Data Management Sequence.  Something like:  1) Update so

 Hello OneStreamers,Good day!Could you please guide me on how to retrieve the Display Member Group for a UD dimension member?I am currently looping through UD1 members using a GetMembersUsingFilter function, and I would like to capture the Display Member Group associated with each UD member.Any guidance or suggestions would be greatly appreciated.Thank you in advance!

Is there an ability to organize a default order for the columns in LIM? I understand the user can customize the order, but we'd like to determine a starting order. Register Definition doesn't give the traditional arrows available to reorder. 

Hi everyone,I'm building a Balance Sheet report in the Text Editor. For various reasons, I have two separate CubeViews: one for Assets and another for Liabilities & Equity.I've placed both CubeViews inside a table within the Text Editor (one per cell, side by side), trying to display them in the classic balance sheet layout — Assets on the left, Liabilities & Equity on the right.However, I'm having trouble getting them to render correctly next to each other.Has anyone done this before? Is a two-cell table in the Text Editor the right approach, or is there a better/recommended way to place two CubeViews side by side in a single report?Any tips or examples would be greatly appreciated.Thanks! 

Is it possible to create rules in Visual Studio?

Hello,  I'm responding to audit requests regarding user task activities and found an active user which has no task activity logged. The user uses the Excel Add-in. What Excel activities are/aren't recorded on the Task Activity log? Is there a way to capture the Excel activities?  Thanks! 

Hi I am getting this error while processing calculation, and I could not find the cause of this issue.I have tried removing all my formulas and even filters just to check this but no success. 

I uploaded the XFJ Excel template with the "Balanced by Entity" Journal Type. However, OneStream set back the Journal Type as "Balanced" instead of "Balanced by Entity after I imported the template . "Is "Balanced By Entity" not the correct selection? Thanks,      

Hi,I can figure out how to solve problem with cell format in column ShowCurrency=True (in Cube View) to work in Excel export? Any ideas how to fix this? I want to have it both in Excel and PDF export.  In Excel formatting I cannot see any settings that I can use. Maybe some kind of combination in ExcelNumberFormat that can be used? Currency is depended on accounts etc. Thanks for your help,Pia

Hello, With the new changes to the Stage and Transform tables in v9.x there has been a change to the tables with a new RuleIdentityId identity field and a parallel change to the TransformRuleInfo object. Is there any documentation or best practices for how to use the API to handle this new parameter and ensure adding rules dynamically via BR adheres to the new identity field requirements?

Hi OneStreamI am trying to add an XFBR from Assembly using the guide ´, and have tried various ways. I tried Current, and even adding the WSMU, and the whole workspace name as well, but to no luck.The data management and the assembly are both in the same workspace/DMU. I believe I am missing the correct way to add the XFBR. Can you please advise what the correct way is? Appreciate it. Thank you.  

When I am in a Cube View Extender BR, how can I access the name of the cube view itself? Not the Title, Page Caption, etc., but the actual name of the Cube View. Thank you!

Just looking for an Application database data model,  to help figure out how tables join together. Has anyone come across such a document, or created one that wouldn't mind sharing?.   I have never found one in the OS documentation    

Hello, I am trying to run a Business Rule located in a specific Workspace (VentaNeta) from a Data Management Step that lives in the Default Workspace.According to the OneStream documentation for cross-workspace references, the syntax should be:Workspace.MyWorkspaceNameOrNSPrefix.MyWsAssemblyName.MyShortBRNameIn my case, I configured it as:Workspace.VentaNeta.VN_Cube.ExtenderHelperHowever, when running the Data Management Sequence from the Default Workspace, it fails with this error:"Error processing Data Management Step 'GenerateUnassignedClientes'. Business Rule 'Workspace.VentaNeta.VN_Cube.ExtenderHelper' is invalid."Here is the strange part: If I move this exact same Data Management Step inside the VentaNeta Workspace and change the syntax to use Workspace.Current, it executes perfectly:Workspace.Current.VN_Cube.ExtenderHelperConfiguration details for the VentaNeta Workspace:Workspace Name: VentaNetaNamespace Prefix: VentaNetaIs Shareable Workspace: TrueMy goal is to keep this DM St

  Hi Is it possible to change the blue, green and red color? Is it possible to add a value     

Stop Fighting Your Equity Translation — Let HSR Do the Heavy LiftingA 5-minute read for anyone who's ever stared at a CTA movement and whispered: “Where did that come from?”_____________________________________________________________________________The consolidation problem we all knowIt’s day 4 of close.Consolidation runs clean. FX looks fine. Then someone opens the equity rollforward.“Why is acquired share capital moving again?”The entity was acquired years ago at a historical acquisition rate, but the system is retranslating equity at current closing FX every month.CTA absorbs the movement.Auditors ask questions.Finance posts manual journals.Everyone loses time.This is the classic Historical Spot Rate (HSR) challenge.The design principleThe goal was simple:Freeze selected equity accounts at acquisition FX rates while keeping the standard OneStream Software translation engine intact.No new cube.No custom dimensions.No complicated override framework.Just:metadata tagging,controlled F

Hi OS Community.  has anyone encountered this error when logging into OneStream? "Another user is already logged into the application on this client. That user must log out of their external identity provider before you can log in." I ran into this issue today with a user and wanted to see if anyone has experienced the same thing and found a fix.  Any help or suggestions would be greatly appreciated. Thank you! Edit: I found a similar post from past [ Unable to Login into OneStream]  where it was suggested to log out of the organizational SSO account, but just wondering if there's a permanent fix or root cause of this.

Hello!  We have a missing underscore in a combo box and I'm not exactly sure why... Here's what shows:  Here's how entities are set up:  Anyone see this before? Seems related to this one which says it's resolved in 7.1.3 but I'm not seeing that: Underscore in member name not displaying in multiselect listbox | OneStream Community

While building the hierarchy using codes, In the Entity Dimension hierarchy "EntityH1", I have a base member as "MyBase". Below code is successfully creating a new child member as "T2" under Parent "MyBase".I am able to set the Text1 property. Can please some one help to suggest how to set Currency property to select a particular currency (Let's take "SGD")'Set the Dimension Type as EntityDim objMemberPk As New MemberPk(DimType.Entity.Id, DimConstants.Unknown)'Update Dim Name accordinglyDim objDim As OneStream.Shared.Wcf.Dim = BRApi.Finance.Dim.GetDim(si, "EntityH1")'Create New MemberDim objMember As New Member(objMemberPk, "T2", "T2 Entities", objDim.DimPk.DimId)'Create VaryingMemberProperties objectDim objProperties As New VaryingMemberProperties(objMemberPk.DimTypeId, objMemberPk.MemberId, DimConstants.Unknown)'Create new member info object for new memberDim objMemberInfo As New MemberInfo(objMember, objProperties, Nothing, objDim, DimConstants.Unknown)'Modify some member properties