Application Build

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 all, Is it possible to exclude certain register columns for specific Groups?  For example, not requiring input or displaying an “Hourly Rate” column for full time salaried employees.  In this case an Employee Type is a separate register column identifying employees as full time, part time, or contract. Filter groups are set up by Employee Type and calculations only run for the relevant groups.In the case above, the Hourly Rate column could just be left blank, but how are others handling cases where there is a control list attached to a register column, but that register column is only applicable to some employee groups?  I would rather not have an “N/A” or similar option in the control list, which would allow this as a selection for employees who should have a “real” control list value assigned to them. TIA

Hi there,I am programming validation accounts, where I compare various data points in my application.For example:Depreciation Balance Sheet - Depreciation P&L = 0I am using now the “Formula for Calculation Drill Down” to visualize the different data points which are used in the formula - so far so good.BUT - I would like to include the “plus” and “minus” signs to make it obvious how the system is calculating the different arguments of the formula.Do you have an idea how I could get that? It could be a text string in the field “calculation script” for what I care, but it would be fantastic to have the signs line by line.  

Hey Community!The other day I was troubleshooting a data import against a set of Cubes that were created in a v9.3 environment, where my Quick View was returning no records even after verifying intersections and confirming the “Load Complete” status on the import. Naturally I went to use the Data Records tool to confirm if the data was truly loaded but no records were returned in the Tool (which led me on a wild goose chase). Lo and behold, even in cases where there were definitely records in the Cube, the Data Records Tool returned no records. So maybe I missed it in the release notes, or maybe it’s just this environment, but is the Data Records Tool meant to work with the new VLWDataRecord tables?Thanks! 

I'm on OneStream 9.3. I'm trying to drive the contents of a Dynamic Grid from a Combo Box selection, using a delimited (piped) parameter to modify the grid's output. The parameter doesn't seem to resolve correctly once it reaches the grid.What I've tried so far:Template Parameter / Text1 / Text2: the piped parameter never resolves. The grid renders the Default Value instead. If there's no default value, or if the default value is itself a piped value, I get either the raw default or the literal token with the pipes intact, e.g. |!Parameter!|.Bound Parameter: I can retrieve the parameter's name via args.Component.BoundParameterName, but I can't find a way to get the value assigned to it, so I have nothing to filter my list against.Question: in 9.3, what's the correct way to read the selected value of a delimited parameter inside a Dynamic Grid business rule so I can use the value to manipulate my dynamic grid? Is there a step I'm missing in how the parameter needs to be defined or refer

Hi everyone, We need to automate user creation and security group assignments in OneStream using data from an external Identity system. I have two main questions: Is it feasible to fully automate this without manual intervention? What is the best way to implement it simply (avoiding heavy middleware)? We are considering two solutions: Just-in-Time (JIT) via OIS, and SCIM. Does anyone know how we can set these up? What is the recommended "standard" approach for this? Thanks for your help! Madiha

Hi, We are currently attempting to exclude a specific entity from the main consolidation process for reporting purposes. This entity is no longer within scope, but we would like to keep it in its current position in the hierarchy to preserve historical data. We also need to continue importing data into this entity for reporting purposes. Our objective is to set the consolidation percentage to 0% so that it no longer consolidates going forward. After updating the Percent Consolidation to 0%, we are not seeing any impact. The entity continues to consolidate in the application. For context, the Ownership Type is set to Full Consolidation and the Consolidation Algorithm Type is set to Custom. Is this expected behavior? If so would you have any workaround solution ?Thank you for the feedback and help!

Hi folks,My suppression in my cubeview doesn't work. If I turn on any suppression (including 'invalid') the cubeview returns blank (no rows at all). It's a cube that's been loaded with dynamic data services and the data is showing as NotStored. I wonder if that could be the cause? Anyone else observe this or have any tricks? I've tried every combo of suppression option I can think of... I'm surprised it would return nothing even with only 'suppress invalid' checked..

Hello all,I have setup a dynamic cube that sources data from a table and creates dynamic dimensions as well.Works like a charm, but I have been playing around with the refresh times. In our use case, the users would input in a register → review data from dynamic cube in cube view (Using filters, etc) → back to register to make changes. Some pros/cons in this caseSetting a time for when the data and dimensions are updated would mean they had to wait for updates.Letting it run for every time the user updates the cube view, means that every filter change etc. would also trigger. Meaning a lot of unnecessary updates. Anyone has come up with a way where a user can push a button that then triggers a rerun of dimensions and data? This way, I can rely on cache when they are navigating the cube view, but they can actively request an update, when they have made changes.​@JackLacava, Thank you for a great presentation on the tech talk, really good stuff. There you also mention that there are solu

Hi OneStream team, Is it possible to use the derived output of formula 1 to be used by another formula?Is it also possible to migrate formulas to another application instead of recreating them? I tried extracting the whole workspace, however, it does not override the formulas. Also, when filtering register grid, will it possible to view data or filter for all pages?For instance, I have 10 pages and I filter cost center, it should filter the values from page1-10.Currently, it can only filter within the same page. Thanks for the assistance. :)

I am looking for suggestions or shared experience on connecting the close calendar / close map used in Task Manager with RCM / Account Reconciliation due date logic.In our OneStream application, Task Manager already uses a close map based on the corporate close calendar and workday schedule. I am trying to understand whether that same close calendar logic can be leveraged or referenced for Account Reconciliation due dates, instead of maintaining separate due date logic manually in RCM.I am still investigating whether this is driven by configuration, business rules, underlying tables, or another design approach behind the scenes.Has anyone successfully connected Task Manager close calendar/workday logic to RCM due dates or reconciliation timing? If so, I would appreciate any guidance on:Whether this was handled through configuration or custom business rules Whether Task Manager calendar information can be referenced directly by RCM Any limitations or maintenance concerns Recommended des

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.

Hi everyone, We're looking into the Allocations Management solution in OneStream for SG&A allocations and wanted to see if anyone is currently using it. If so, we'd love to hear about your experience. How has it worked for your allocation processes? Has implementation and maintenance been manageable? Are there any limitations, challenges, or lessons learned that you'd be willing to share? Thanks in advance!

Does anyone know if it’s possible to adjust the time zone within File Explorer? The Time Created and Time Modified columns show the time stamp in UTC time, and we’d like it to display in EST. Is it possible to make that change and if so, can anyone tell me how/where?  

Hi All, I would like to use parameter in my excel sheet which uses xfget function to retrieve data ; however couple of paramters work but movement I started adding more, e.g I would see Time value in entity drop down list. I tried in spreadsheet but it's working as expected but desktop it merges the value from multiple dimensions.Anyone knows is it a bug. I am using 9.2ThanksPranav

Hi All, Is there a way to revert the workflow within the solution?We are using the workspace step, and we cannot revert to add more rows to the grid because it remains green once an import has started.Hope to get insights.Thank you.

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. 

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