I have two fact tables Order and Quotes. I have two dates for each fact table (Order date and Quotes date). I have a requirement where in i have to create a bar chart for no.of Orders and no.of Quotes with quarter as dimension. Since i have two different Quarters(Order Qtr and Quotes Qtr) i am not able to show correct values in the chart.
I want to use a quarter dimension which is common to both the fact tables. Is there any way to create a common calender for both dates(Orders date and Quotes date)?
