Skip to main content
S
SimpleLove
Newcomer
October 28, 2024

How to place multiple UD1 members in Account dimension UD1 constraint

  • October 28, 2024
  • 3 replies
  • 0 views

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

K
OneStream Employee
KarlTOneStream Employee
OneStream Employee
October 28, 2024

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

    S
    SimpleLoveAuthor
    Newcomer
    October 28, 2024

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

    D
    DavidW
    Newcomer
    March 25, 2025

    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.

      Terms & ConditionsAccessibility statement