SSAS 2008 - Hourly Sales Cube

View previous topic View next topic Go down

SSAS 2008 - Hourly Sales Cube

Post  blynch on Tue Jun 19, 2012 10:53 am

Hello,

I have built a couple of successful cubes and attribute hierarchies.

We can successfully drill-down from Year -> Quarter -> Month -> Day either by Calendar Year, Fiscal Year or a Week Hierarchy.

Now we want to add Hourly Sales analysis for a cube, it can be in its own cube.

I can extract the Hour of Day from the fact transaction time stamp, but I am unsure how to constrain this in SSAS.

I do not need to go to minute or second, hourly sales is the lowest grain I'll need, though the FactSales table goes to a lower grain.

I have DimDate with a grain of day, and now have created a DimHour with 24 rows, one for each hour.

Any tips on this? What am I missing here?

Thank you for your time and insights.


blynch

Posts : 18
Join date : 2011-10-16

View user profile

Back to top Go down

Two dimensions

Post  ganley on Fri Nov 08, 2013 4:51 am

You seem to have the correct idea. You will need to create two different dimensions one for date and another for hours.
But in your fact table you will need to split the date into two different measures so you can link them.
Example original date 08/11/2013 09:00 so you will have date measure 08/11/2013 and time measure 09:00.

ganley

Posts : 2
Join date : 2013-11-06

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum