The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.
Forum Discussion
How to place multiple UD1 members in Account dimension UD1 constraint
Hello OneStream experts:
Thank you for the helps in the past. I have a quick question about place UD1 members in Account dimension UD1 constraint
For example: In my account metadata dimension: I have 2 accounts
4001-Sale_IceCream
4002-Sale_Donut
In my UD1 product dimension: I have 4 products all under one parent product
Product_1,Product_2,Product_3,Product_4
I want to place Product_1, and Product_3 to the UD1 constraint in account 4001-Sale_IceCream's UD1 constraint field. But OneStream only allow me enter one product member in that filed. I can only enter Product_1 but cannot enter both Product_1 and Product_3 in the field.
Thank you so much in advance to help me get through this issue.
3 Replies
KarlTOneStream Employee
This is done in OS by creating alternate constraint hierarchies as assigning these to the Constraint field.
Another solution to create a lot of alt structure is using ConditionalInputResultType.NoInput. You can have a biz rule for No Input tied to the cube, where you use test property from Account member equal to product text field. If not, ConditionalInputResultType.NoInput.
KarlT Thank you for your reply. But I have many accounts and Products combination. It is quite difficult to create alternate constraint hierarchy.
