Forum Discussion

SimpleLove's avatar
SimpleLove
New Contributor III
5 months ago

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.

 

Metadata
  • DavidW's avatar
    DavidW
    New Contributor II
    6 days ago

    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.

  • SimpleLove's avatar
    SimpleLove
    New Contributor III
    5 months ago

    KarlT Thank you for your reply. But I have many accounts and Products combination. It is quite difficult to create alternate constraint hierarchy.

  • KarlT's avatar
    KarlT
    Contributor III
    5 months ago

    This is done in OS by creating alternate constraint hierarchies as assigning these to the Constraint field.