02-04-2022 10:11 PM - last edited on 05-24-2023 11:47 AM by JackLacava
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 $$$$
02-05-2022 03:29 AM - edited 02-05-2022 03:31 AM
You can create a custom member list (in a financial business rule) for each dimension and call them with the selected entity as parameter.