How to have two Time Dimensions without creating two different tables?

[SQLUser]

Hi,<br><br><b>Tool(s): Microsoft OLAP Server (SP2), Knosys Proclarity, HOLAP structure for cube</b><br><br>I have a scenario, where I have 2 time columns in my fact table and they both contain different values for each fact row. <i>For example, OriginDate and DropOutDate.</i><br><br>The client would like to view the cube and be able to select the dimensions separately (obviously!)<br><br>Presently, I have two (identical) physical tables for Time(hierarchy:yr, quarter, month, day). The foreign keys have been created from the 2 columns to their respective tables and it works fine.<br><br>Earlier, when I had a single table and created foreign keys in the fact table(for both time columns) linking to the same primary-key column(surrogate) of the Time table, the processed cube showed values only for one of the time dimensions.<br><br>Is it possible (at all?) to have a single time dimension table OR do we &quot;HAVE TO&quot; create multiple tables for each time dimension???<br><br>Thanks in advance!<br>bb<br><br>