Multiple date dimensions

[#1]

Hello,

I have a situation where I am stuck for now:

I have product units that are loaded every month (one year data).

Of these units I am upoading a file that the loaders give of delayed units with a delay date column.



I want a metric (not perfect but best I can do) of no of delayed units as a 5 of total units loaded.

the loaded date and delayed date are distinct dimensions though since a unit delayed in Dec 10 can be loaded in Jan 11.

The key is the unit number itself and I have made the join on it.



Any help appreciated.

Kiran