Modelling Challenge Decisions on different levels

[bernhard0614]

Dear Community,

I am facing a modelling challenge adressed with multiple tables. I do have a project table linked to different project tasks and project events. There is the possibility that a message / decision is made on the project, on the projectTasks and on the events level. How do I link them correctly together, so that I can filter for Project A and display all decisions on all levels (projects, projectTasks, events)?

Many thanks in advance for your time and your input.

Best regards,
Bernhard

[lbendlin]

Make the join between Projekte and Events inactive as well. Then use measures and USERELATIONSHIP  to selectively activate the desired relationship path into the Messages fact table.