Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
We use the Canonical Date model by Henric.
I amram confused with this as I have only one table with multiple dates .
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)