• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 775
  • Last Modified:

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.
0
sdom100
Asked:
sdom100
1 Solution
 
nicolasdiogoCommented:
hi,

for your dateTime columns i would suggest to spilt them as date and time.
if you keep them as dateTime, you will find your reports will be too fragmented for users to make much sense of this data.
with date & time as in two columns for each one that you currently have, your users will be able to crosstab them and use this data easier.
alternatively drop the time althougether from these three columns.

please see this suggestion as it is valid in your case:
http://www.experts-exchange.com/Database/OLAP/Q_22685550.html

if you need further information, just ask.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now