Currently I'm having 2 fact tables and both of them have date data. Since I need to avoid looping, I created date dimension tables for each of them, and also a master calendar table. Currently I'm hoping to do selections on the master calendar via a filter pane, and by doing this, both 2 date dimension table would change. Is there a way I can achieve it?
Currently those 2 calendars are different, and I can link them up together. However, I still have one more fact table to connect. If I link them up together, I would have a loop. Therefore, in order to avoid, I wish to break up the date key into separate tables and perform lookup manually on charts.
For selection, I would like to have one calendar filter pane for users to select date range. Once the date range is selected, the selection will apply over the whole application.