HenningOneStream EmployeeJoined 4 years ago621 Posts493 LikesLikes received98 SolutionsView All Badges
ContributionsMost RecentMost LikesSolutionsRe: Custom Consolidation Custom consolidation rules are not a good fit for the described purpose. That would bring along added complexity and impacting performance for something that can be solved easily by different means. ...Re: Custom Consolidation Hi, just create an alternate hierarchy in the entity dimension without entity A and give your restricted user only access to this alternate hierarchy. Seems like the easiest option to me. Re: Changing StoreType of a DataCell The storage type is dependent on how the data was 'created'. Entered manually = Input, posted as a journal = Journals, calculated = Calculation, etc. So if you want to have a certain storage type f...Re: Help Needed Moving a Scenario Member Hi, why not just do it manually? Right-click on the scenario member and select "Copy Selected Members". Then right-click on Hierarchy (as in Root), and select "Paste Relationship (Move)". That wil...Re: Automatic update of Metadata in OneStream? Full automation of the entity dimension also depends in my view on the type of use. Planning, Management reporting,... ? I guess I have less issues with that (if that aligns with the security and w...Re: Cubeview Cell Range Hi, do you mean integer or decimal values? For Integers, this is an easy solution: E.g. in your columns, make those a Combo Box Cell Type and refer to a List Parameter. This parameter can ...Re: Account Attribute: In Use versus Allow Input In addition to using the InUse setting, have you considered setting up an alternative hierarchy? E.g. adding a suffix to all existing parent accounts ("_pre2025") and create a new hierarchy without t...Re: How to stop a BR from updating a Certified Entity Hi, in your rules, you just check if the workflow data unit of the respective entity is certified (i.e. locked) and do not run the seeding from Actual for the locked ones. You can use e.g. this: ...Re: Mass modification of a Metadata member attribute Agreed. Use Regular Expressions (or RegEx) for a "smart" find and replace if needed. Or you just find and replace the prior property that is in the file, e.g. Text6 and replace it with Text6 and Te...Re: How do I clean a scenario before copying data from another scenario? in the member formula. Yes, from what I see, you do not need any additional logic such as data buffers. Maybe something to clear the durable data as rhankey suggested. You can use the scenario member formulas if you wa...