Link to home
Start Free TrialLog in
Avatar of sdom100
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.
ASKER CERTIFIED SOLUTION
Avatar of nicolasdiogo
nicolasdiogo
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial