Recent Discussions
Write Data to Dynamic Dimensions
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.xfgethelp2 days agoNew Contributor II35Views1like0CommentsLookup Drivers in LIM is not working
Hi All, I'm working with Line Item Modelling to implement workforce solution and trying Lookup drivers for one of the calculations. Lookup drivers doesn't seem to work at all. Has anyone tried and whether its working? The lookup driver that i defined doesn't fetch & return anything while using in calculation (formula) though it returns data while i preview it under Lookup drivers. Any help on this would be much appreciated. Thanks in advance. Cheers - Ramesh.rameshkumarsiva11 days agoNew Contributor33Views0likes0CommentsPOV Actions
Hi all, I've found a different behavior between 8 and 9 releases of OneStream, related to the "Change Workflow" POV Action on a ComboBox component. In a Dashboard I have 2 combo boxes with the ebove mentioned Action: Select Scenario => Set WFScenario Select Time => Set WFTime In rel 8, when I select values in the combo, things works as expected: the WF variables changes and I DON'T exit from my dashboard. In rel 9 (9.2.0.18004), whenever I change one of the combos, the current dashboard lose the focus and I get redirected to the Workflow page. Why this behavior has changed ? Is there any workaround ? TIA FabioGFabioG13 days agoContributor II22Views0likes0CommentsTabbed Dashboard
Hi, I have Dashboard with tabbed embedded reports. for example, MainDashboard - Tab1, Tab2, Tab3. Everything works fine when the user clicks on Tab of their choice for the fiscal year 2026. For Historical data I would like to show the same report for with changed tab. for example, MainDashboard - Tab1, Tab2, Tab4 for the he fiscal year 2025. If the user changes the Scenario from 2026 to 2025 or vice versa the dashboard report tab3/tab4 shows/hide based on FY. How can I achieve at the workflow level? Any help will be appreciated. Thanks.navdy1 month agoNew Contributor27Views0likes0CommentsInconsistent File Opening from Dashboard → File Explorer (Windows Client)
Hi everyone, I’m hoping to check if anyone has experienced something similar. We have a dashboard that directs users to folders in File Explorer. The navigation itself works as expected and correctly opens the folder location. However, users are experiencing inconsistent behavior when trying to open files from there — sometimes the files open normally, and other times nothing happens (no error message). If users navigate directly through File Explorer and open the same file, it works without any issues. This is happening in the OneStream Windows desktop application (not browser), and permissions don’t appear to be the issue since access works normally outside the dashboard. Has anyone encountered similar behavior when launching files from a dashboard? If so, was this a known issue or did you find an effective workaround? Appreciate any insights — thank you!Eve_Pereira1 month agoNew Contributor II17Views0likes0CommentsCube View Stored Data
Hi, How can I store data in a cube view cell that comes from a business rule linked via a DM step I want this cell to become 75, if I input 50 on the white cell. Is this related to a cube view property or a business rule?jaideepk261 month agoNew Contributor17Views0likes0CommentsXFBR in a parameter
Can we use an XFBR in a parameter like this and then use the parameter name in a DM step?jaideepk261 month agoNew Contributor20Views0likes0Commentsparent child relationships limited to one hierarchy
This is a problem I run into off and on that's always been annoying but easy enough to work around... until now. When working in a QuickView, for example, I click on the Up Arrow (for Parents) and I get all parents, not just the parent in the hierarchy I'm actually working with. In the most literal interpretation, I can see why this happens. In principle, I think I ought to be able to control this behavior either by the Parent filter or through the addition of a field that lets me choose my current hierarchy. But, in a QuickView, I'm working with one member at a time so it's not the end of the world to just remove the irrelevant parents and maybe do a little manual editing of the member filter if it gets too messy and I really want to keep the QV for future use. The problem comes when using the Grid View set to Display Parent Child Relationships with a member filter to display the descendants within a key hierarchy. I get every parent child relationship for every hierarchy. There's no good way to filter them. They are too numerous to filter by hand. It's just a useless soup sandwich of a dataset. Am I missing something obvious? Am I missing something not-at-all obvious? Perhaps I'm using a completely stupid approach and there's another way to get a nice, concise list of parent/child relationships for a hierarchy.photon1 month agoContributor38Views0likes0CommentsAutomated User Provisioning: Best approach to sync Users & Security Groups?
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! MadihaMadihaBouankoud2 months agoNew Contributor II52Views0likes0CommentsProcess around InUse flag for master data
What do you use as guidelines to flip the "inuse" flag on accounts or entities? Do you wait until the entity balances are brought to zero in your source or some other trigger? What considerations do you make around any immaterial translation values? Interested to hear what your company is doing - thanks so much! -NicoleNicoleBruno2 months agoValued Contributor23Views0likes0Comments