Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Table Structure :
T1 T2 T3 T4 T5 five tables
T1 T2 T3 - Daily dates tables
T4 - Weekly
T5 - Monthly
AJ
Concantenating the fact data into a single fact table is usually the best way to solve this sort of problem, so you need to have a very compelling reason for doing it the way you propose. You would differentiate between the different data sets by using one or more grouping fields - for example, you could use a field TableGroup, with possible values T1, T2, T3... then use set analysis to select the correct data for the charts. This solves the problem with synthetic keys, data loops and multiple copies of attribute and calendar tables that you are likely to need,
Ultimately, this would lead to a simpler solution, simpler expressions, simpler operation and simpler maintenance.
But perhaps you have a good reason....
Regards
Jonathan