why we make a relationship between duedatekey and datekey
why we make a relationship between duedatekey and datekey what's the purpose of doing this
1 answers ( 0 marked as helpful)
because in order to create Time Intelligence functions such as YoY, MoM we need to have a proper calendar table so we build one. Then we connect our calendar table to our fact table to be able to show the aggregations against various date/times.