Application Build

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. 

Hello, I added a new register field and now I am getting this error in the LIM WFP register. Confused because the register fields named in the error are all of ‘data type’ string already and I don’t see a field for ‘display format’ like what is mentioned in the error. Never had this problem before, but I recently upgraded the solution. Do I need to update the column format in some fashion instead of leaving it blank like in previous versions? That said, I don’t see a string format available in the dropdown list...Best,David

Hi Is it possible to extract the O#DirectElim data in OneStream? I have tried this with CubeView and also data management extract job but nothing coming. I could get the data for O#Elimination and also in QuickView for this POV.  Thank you, PM

Hi All. I am saving a data in register manually, but it won't push through. I am getting a new error I have not encountered before. Can you please enlighten me why I am getting this error? Thank you. 

HiI have an assembly1 with generic functionality which can e.g. be triggered via DMs in assembly1.I can see the DM in the task scheduler however I have not found a way to trigger it from another assembly2 via a button action ‘Data Management Sequence’. If I run it I get the error Unable to execute dashboard server task for component 'btn_...'. Data Management Sequence 'TEST_DM_IN_ASSEMBLY1' is invalid.Has anyone a solution?

I've been going through some training material on DCS for a use case that requires frequent changes in a dimension (UD3 - SKU). Because of this, I'm considering dynamic dimensions where the SKU can be written and generated via code. Unfortunately, I haven't found anything that supports writing data from a cube view. I've only found material that says the "Dynamic Cube" needs to have the share and edit feature turned on.Question - Is it even possible to create a cube, use a dynamic dimension as one of its dimensions, write allocation calcs to allocate data to SKU level and be able to modify that data using cube views?If not, what is the best way to handle this use case without having to create another non-dynamic SKU dimension.

In LIM WF model, I have created register with only 7 fields, Start Date, End Date, Entity, Employee id, Position id, FTE and Base Salary.Created two accounts FTE and Base Salary to copy data to people cube.Now when I am trying to add row, it is not adding any data in but its not showing in register. If i check database table I can see data.Earlier I have uninstalled LIM and WF multiple times to check if the issue gets resolved but still in same place. Any help will be good.  

Hi Folks,  Wondering if anyone has built a BR or query to compile a list of Users and their Default Home Page.  I know its in the UserAppSettings.xml File within File Explorer under Internal/User, and you can set individuals through the Admin Solution Tools, however I have not found a good way to See what is already set without going to each user individually (that would not be very practical). Appreciate any help! Stephanie

Hi Folks,  Wondering if anyone has built a BR or query to compile a list of Users and their Default Home Page.  I know its in the UserAppSettings.xml File within File Explorer under Internal/User, and you can set individuals through the Admin Solution Tools, however I have not found a good way to See what is already set without going to each user individually (that would not be very practical). Appreciate any help! Stephanie

Is there any way to calculate Headcount where I will use start Data and end date of Current period. If the difference is more than 1 then my HC is 1, I cannot use current period end date in Formula, I tried IIF (DateDiff(month, start date, Current Period)>1,1,0) but it is not giving me any result

Hi all,I'm wondering if there's a way to incrementally load a TreeView.I know how to load it in one shot but what if it's supposed to contains a lot of data ? Is there a way to load it incrementally, when a node is clicked (loading the leafs belonging to the node itself and the 1st level nodes under the clicked one) ? Thanks in advanceFabioG 

Hi all!  Anyone know of the best way to report on security changes made to an entity? I can't seem to figure out the right table or the right member property that shows the security updates made to a member so any direction would be greatly appreciated!  Full disclosure - also have a OS support ticket out there and patiently waiting :) 

I'm trying to help a user load some data for an LRP scenario, but the the years 2027 through 2030 are showing as read-only. All workflows are open, unlocked, and not started for those years, I am an admin, so it's not a security issue,  I created a quickview below to show the locked periods: Here's the settings for the scenario: When I look at the cell status for one of the read-only cells, I see this:   For extra information, my colleague did perform a DM job that copied data from another scenario into this one for 2027 - 2030 specifically, which are the periods that are read-only.  Any insight as to how to fix this so that users can enter data into 2027 - 2030 in this scenario? TIA, Louis

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 },  

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

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 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.  

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    

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

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

Hello,  When we refresh a lower environment from our production environment (app copy), the target environment's System Parameters/Secrets are refreshed from the production System Parameters/Secrets. These secrets contain connection strings to another platform and are environment specific. They must remain static. (Fortunately, I export them before a refresh and then re-import them after.)   There must be a better way! Does anyone else have this issue? If so, is exporting/importing the System Parameters the only way to keep System Parameters with their correct environments? Thanks!   

Hi OneStream,I am utilizing the XFBR String Service to add my time filter in my data management job. Before moving to assemblies, I have tested the rule via Business Rule XFBR, and it works. However, when using the XFBR string service, I am having difficulty making it work, as the string I am adding to the time filter is most likely incorrect. I have tried the different approaches based on documentation, but to no avail.Can you please advise how I can fix the issue? 

I'm receiving the following error when trying to add additional Register Definitions.  During the build, I've added new Register fields as requirements evolve but now am facing this error when running the Update button.  Has anyone run into this issue and resolved it?   Error executing Workspace Assembly Service class 'Workspace.PLNB1.CustomEventHandler_PLN.WsAssemblyFactory'.Invalid column name 'PayGroup'. Invalid column name 'Location'. Invalid column name 'EmpStatus'. (SQL Error Number -2146232060, 207, 207, 207). User Interface Stack Trace: at OneStream.Client.Api.DashboardsAjaxServiceReference.DashboardsAjaxServiceClient.StartExecuteSelectionChangedServerTaskCompressed(SessionInfo si, Boolean isSystemLevel, Guid primaryDashboardID, Guid embeddedDashboardID, Guid componentID, PageInstanceInfo pageInstanceInfo, XFSelectionChangedServerTaskInfo serverTaskInfo) at OneStream.Client.SharedUI.DashboardWcfHelper.ExecuteSelectionChangedServerTaskAsync(SessionInfo

In consolidation system in the month after close example if we close April , May should show reversal of April. Please see below screen shots of how system is should show up and how it is showing. We tried clearing base data through data management. Any ideas would be helpful. Normally  However the system is doing