Recent Discussions
Combo box cell type not working in Excel
I am working on in OneStream V9. I have a workspace cube view with a combo-box cell type. The cube view works fine in the application, but when I open the same cube view using the Excel add-in the combo-box drop down is not active. Any ideas on what I should check? Thanks.
Security: Question - Control access to a Scenario
Hi all, I'm hoping someone can see what I'm doing wrong here. First a question: Is Scenario access cube specific? Let's say I have 4 cubes. Currently all 4 cubes give a user access to all Scenarios. If I restrict access to a specific scenario for that user in one cube, does that restriction apply across all cubes? I would assume No - am I wrong? I've been trying to set up restricted scenario access to a group of users in a certain cube. I don't want to touch overall security for the Scenario because there are multiple regions that need access. I've tried to set this up via Slice security (Data Access directly on the Cube) by using a Where clause in the Scenario definition for every group identified in the Data Access (i.e. Planning.Base.Where(Name DoesNotContain X). This doesn't appear to be working. The User themself, has access to multiple cubes and there is no restriction to that scenario in those other cubes. So is it all or nothing? Like do I have to go into the slice security for EVERY cube and restrict access to that scenario in order for this to work? Can't think of another way to resolve this but to modify the Scenario access for every Data Access group in every cube will be a lot of work. Hopefully my question makes sense and thanks in advance for any guidance here.
Dynamic Member addition in version 9
We are looking for some help in direction to build dynamic member addition to a dimension using extensible business rule in version 9.0 We have tried to use the code that is used in earlier versions which uses declaration like "Dim newMember As New Member" but it does not work anymore in version 9 as it gives error when assigning values to newMember.Name property and some search suggests that we now need to use "Dim newMember As New MemberEx" Using this declaration results in error compiling the business rule. We are looking for some help/direction on this.
Need to reset import validate load step via BR
Hi, I am trying to load the data from a file into the cube (import validate load steps) via Business Rule and while I am able to load it successfully. I am not sure how to reset it if the job fails in between. For instance: Data pulled from the file gets failed at validate step due to some transformation rule issue. Now if I trigger the rule again , it will not do anything as import step is already completed. I need it to reset clear the cache from stage and redo the load process again when the business rule is triggered. Can you please assist? Below is the code being used
Hybrid Scenario – Pre-Aggregated Member Setup for Entity Summarization (V8.4)
Hi Team, I’m working on a Hybrid Scenario setup where the goal is to copy data from a source scenario to a management (MGT) scenario. This allows the MGT team to work with the data independently, using their own workflow with high-level access. So far, the base data copy works well. However, I want to summarize entity data in the target scenario so that users only see Entity parent nodes, while maintaining visibility of all other 17 dimension members (Account, UD1-UD8, etc.). To achieve this, I tried creating a dummy parent member (Entity X) in a new Entity dimension that mimics the top-level parent from the legal entity hierarchy (Entity Y). My intention was to use this structure in the Pre-Aggregated Members field in the Hybrid Scenario configuration, effectively copying: Entity X = Entity Y Unfortunately, this method worked successfully in Version 7.4, but does not appear to function as expected in Version 8.4. Maybe in version 9.0 +, we can successfully configure pre-aggregated entity mappings for Hybrid Scenarios? Can we customize this to version 8.0 and above? Would appreciate any advice or examples from the community if you’ve made this work in your applications. Thanks in advance! Chris
Issue with Zero Input Not Triggering Calculations in OneStream
Hi all, I’ve encountered an issue in OneStream where inputting a value of 0 does not trigger any calculations, while entering 0.1 or any other non-zero value works as expected. From what I understand, this seems to be related to Zero Suppression, which may be preventing the system from storing or processing the zero value. However, I’d like to confirm if this is standard behavior, or if there’s a recommended best practice for handling zeros in data input and calculations (e.g., in cube views or business rules). Thanks!
Data Import of prices with average result
Hello, In our planning solution I'm looking for a change to plan with less detail. We import transfer prices on material level, but now we want to plan on product level which includes several materials. During transformation the items with the same dimensionality are being combined and show a total value, but for these prices I would need a simple average. Example below: Imported values: After transformation the original UD4 is replace by the product member which is imported on Flow, because some UD4's remain unchanged: I would need to have the simple average (871.48 + 880.82)/2 = 876.15. Is there a simple setting for this, i can't find it, any other suggestion would help also. kind regards Ben
