Forum Discussion

bernhard0614's avatar
bernhard0614
Frequent Visitor
2 years ago

Modelling Challenge Decisions on different levels

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

 

Need Help

1 Reply

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    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.