Forum Discussion
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 be working but can anyone please advise? I have daily sales data with multiple rows where products have been aggregated and targets tables, but they don't have much to link on other than date.
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,
4 Replies
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,
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,
