Forum Discussion
Two Fact tables with different granularity
In this secnario, if you want both tables can be sliced by all dimensions, you need to combine these two tables together. Since you have "Invoice Date" and "Client" columns in both tables, you can crossjoin these two tables into one table based on those columns.
Regards,
Hi GilesWalker,
The reality is a little more complex! In fact, I have tried to summarize and focus the question on this issue. However, this is a sample of data where you can see clearly this different granularity levels:
Table Invoices:
Client No. Contract No. Invoice No. Invoice Date
200080 90003 .... (Day level)
200080 90054 .... (Day level)
Table Projects:
Client No. Project Code Activity Code Invoice Date
200080 P1 .... (Day level)
200080 P2 .... (Day level)
200080 P3 .... (Day level)
200080 P4 .... (Day level)
200080 P5 .... (Day level)
200080 P6 .... (Day level)
200080 P7 .... (Day level)
The relaltions between "dimension" and "fact" tables are always Many-to-One, both direction.
Thanks once again.
