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,
The only commonality amongst all the fact tables is the date, can I just have one dimension table (date key) and link all the fact tables to it? Or do I need to create another dimension? Thanks
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,