Advertisement

09.17.2007 at 11:31PM PDT, ID: 22835241
[x]
Attachment Details

Building Time Dimension from an fact Table in SQL 2005 AS

Asked by bluebellgroup in OLAP, SQL Server 2005, Microsoft Visual Studio Express

Tags: time, dimension, 2005, sql, table

Dear EE members,

     We have a warehouse database (in SQL Server 2005) and currently we are trying to build a simple cube out here just for testing.  SQL Server 2005 comes with the tool BI Development Studio and that's what I am using to build cube.

     Currently I have a problem in building a time-dimension for my cube.  We have a fact table, called "sales", which holds the time in this format "yyyymmdd". So an example for a row in the sales table is like
20060101, Apple, 10, 5

     It will be great if anyone can tell me in detail how i can create a Time-dimension out of this? All i need is just simple dimension with a hierarchy like Year -> Month -> Date.

Thanks.
Start Free Trial
 
Keywords: Building Time Dimension from an fact T…
Title
1 DOA Cube ?
2 Learning Oracle's BI
3 Data warehousing
4 Job market for sql server 2000/2…
5 SQL Server cube to Excel - memory/…
6 Using OLAP and BI Beans
 
Loading Advertisement...
 
[+][-]09.18.2007 at 12:33AM PDT, ID: 19910839

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.18.2007 at 01:05AM PDT, ID: 19910948

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.18.2007 at 03:16AM PDT, ID: 19911479

At Experts Exchange, members can ask their questions to thousands of technology professionals, also known as Experts. Experts compete and collaborate to answer those questions by leaving comments like this one.

Start your 7-day free trial to view this Expert Comment or ask the Experts your question.

 
[+][-]09.18.2007 at 04:30AM PDT, ID: 19911752

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
[+][-]09.18.2007 at 04:50AM PDT, ID: 19911879

View this solution now by starting your 7-day free trial. Setting up your free trial is quick, easy, and secure. We will return you to this solution, unlocked, when you're done.

 

About this solution

Zones: OLAP, SQL Server 2005, Microsoft Visual Studio Express
Tags: time, dimension, 2005, sql, table
Sign Up Now!
Solution Provided By: PFrog
Participating Experts: 2
Solution Grade: A
 
 
[+][-]09.18.2007 at 06:08AM PDT, ID: 19912385

Often, when Experts are collaborating with members who have asked questions, they will request additional information about the problem. Askers respond with an author comment like this one.

Start your 7-day free trial to view this Author Comment or ask the Experts your question.

 
 
Loading Advertisement...
20080716-EE-VQP-32 / EE_QW_2_20070628