Application Build

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

Does anyone know of any information related to the new VLWDataRecord tables that are new in OneStream 9.3?There is nothing in the release notes and nothing in the documentation. Teams are seeing issues with the Data Records tool on the system tab. The vDataRecordAll View excludes those tables (and there is no vVLWDataRecordAll view at all). Has anyone tested solutions that may access data tables more directly (like FDX) to see if there are issues? Does anyone know how OneStream is choosing where to store data? It appears that some data is going to the new tables, but some data remains in the old tables.We have some nervous team members and nervous clients looking to upgrade, but unsure of the implications of this change. Honestly, I can’t blame them, since fundamentally changing the database schema for how your cube data is stored in OneStream without any information is a bit nerve-wracking. We’d appreciate any conversation related to this topic so the community has a better idea what

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

Hello to everyone. Does anyone know how to build in Excel Add-ins for Task Manager? Our OneStream version is 8.2.2.16127? Guidance for this version provides the step-by-step instructions how to set up Add-ins for Word and PowerPoint, but not for Excel Add-ins.  Our Task Manager version is PV800 SV100. If to be very specific, we are looking for the opportunity to install Excel Add-Ins to link the preparation status from excel file to particular task in Task Manager. For example, if we have the excel file somewhere outside OneStream (on Sharepoint), and when the work done inside this file, we can push built-in "Complete" button in this file. The completion status from this file automatically forces the change in the preparation status in Task Manager for this task, which is linked to this file through the action type functionality in Task Manager.  Does it sound real? Could it be potentially implemented from technical point of view?   Thank you in advance fo

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.

Where can I download CPM Express? I checked the Marketplace but couldn’t find it there. Is it available for partners yet?

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