Forum Discussion
Solved
Building relationships all based on date?
Hi, I've set up my report relationships like this but think it's probably wrong. I have one many to many relationship but not sure if I can link all the tables based on date. The visuals seem to ...
Hello aquamagreen,
Yes, You can have only one date dimension table (date key) and link all the fact tables (date column) to it.
Thank you,
Hi,
You need to identify the dimension tables and fact tables for your report. In your case Date table is dimension table with all the dates and it needs to be in relation with rest all of the fact tables.
So currelty you are creating a chain of relationships, instead of this, all the rest tables should be in relationship with the date table, creating a star like shape (star schema).
Your visual is working because the criteria must be getting fulfilled but when you will have more visuals and then need to be on different dates, then current setting will start incorrect numbers.
Thank you,