SSAS 2008 - Hourly Sales Cube

[blynch]

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.

[ganley]

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.