Building form based on Selected member

NaseerMubashir
New Contributor

Hi All, Happy Friday, I am building a form and in my cube view I am giving option of selecting Entity, Based on entity I need to show two Dimensions  in the detail, we don't have any connection between these dimension. I can not update the Text field of entity because there are many to many relationship, One entity can have multiple project and ICP, so based on selected entity I need to show all related projects and ICPs so user can adjust the data.

Selection - Entity

Projects   -     ICP    $$$$

1 REPLY 1

ChristianW
Valued Contributor

You can create a custom member list (in a financial business rule) for each dimension and call them with the selected entity as parameter.