I am currently creating an OLAP cube in SQL Server 2005 Analysis Services.
In my source data there are 3 DateTime columns (Started, Finished, Other)
I want to model these as dims in my cube and believe should do so using a RolePlaying Time dimension.
I have created a Time dimension but it just seems to hold date info.
Could someone please advise me how to go about solving this in an end to end fashion.