One Date Dimension

[smilingjohn]

Hi All,

Please find the attchment of the QVW file . 

I have three date fileds(IssueDate , DeliveredDate and CLosed Date ) in my fact table and i need to have one common dimension field f week from "IssuedDate" . how can i achive this ? 

Thanks

[jwjackso]

We use the Canonical Date model by Henric. 

[smilingjohn]

I amram confused  with this as I have only one table with multiple dates . 

[jwjackso · Accepted solution]

If your 3 dates are on 1 fact table, you will create a bridge table between the fact table and the master calendar.

Fact(key) -> Bridge (key,canonical date, date type)->master calendar (canonical date,date type)

Number of close on a date, chart dimension of canonical date and expression would be

=Count({<DateType={'CloseDate'}>}key)