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,
aquamagreen , Two Fact should not join with each other, here target, Daily_anci and trading data should join with common tables. and you should analyze them with help from the Date and other dimensions
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,
