hour and time dim

Question

Post reply

hour and time dim

mesql-895214

SSChasing Mays

Points: 643
More actions
July 29, 2009 at 10:13 am

#212749

I have two time demission in my warehouse
One is the the time dim and the hour dim
In the time dim I have timeid, fulldate (2000-01-05 00:00:00.000) month
timeidFullDateAlternateKeyDayNumberOfWeekDayNameOfWeek
1 1900-01-01 00:00:00.0002Monday
22000-01-01 00:00:00.0007Saturday
32000-01-02 00:00:00.0001Sunday
42000-01-03 00:00:00.0002Monday
In the hour I have hourid, time(00:01:00:00) i have records for every minute ,
Hoursid time standard
1 00:00:00:00 am
2 00:01:00:00 am
3 00:02:00:00 am
4 00:03:00:00 am
Now I want to create a cube for sales and this is the requirements
The management want to know the sales by hour.. I can I achieve that in ssas… in my fact table of sales I have two key for both the hour and time demission

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

pshvets SSCommitted Points: 1850 More actions · Answer 1

I am not sure I understood your question. If you still have it, please re-state it.

Peter.

Jeff Moden SSC Guru Points: 1000539 More actions · Answer 2

mesql (7/29/2009)
I have two time demission in my warehouse
One is the the time dim and the hour dim
In the time dim I have timeid, fulldate (2000-01-05 00:00:00.000) month
timeidFullDateAlternateKeyDayNumberOfWeekDayNameOfWeek
1 1900-01-01 00:00:00.0002Monday
22000-01-01 00:00:00.0007Saturday
32000-01-02 00:00:00.0001Sunday
42000-01-03 00:00:00.0002Monday
In the hour I have hourid, time(00:01:00:00) i have records for every minute ,
Hoursid time standard
1 00:00:00:00 am
2 00:01:00:00 am
3 00:02:00:00 am
4 00:03:00:00 am
Now I want to create a cube for sales and this is the requirements
The management want to know the sales by hour.. I can I achieve that in ssas… in my fact table of sales I have two key for both the hour and time demission

It would probably be helpful if you showed folks what the sales table looked like.

As a side bar, I thought SSAS was supposed to make stuff like this easy to do.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
"Change is inevitable... change for the better is not".

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)
Intro to Tally Tables and Functions