sdom100
asked on
DateTime Dims In SSAS OLAP
Hi,
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.
Many thanks
S.
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.
Many thanks
S.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.