Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

SSAS 2008 - Hourly Sales Cube

2 posters

Go down

SSAS 2008 - Hourly Sales Cube Empty SSAS 2008 - Hourly Sales Cube

Post  blynch Tue Jun 19, 2012 10:53 am


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.


Posts : 18
Join date : 2011-10-16

Back to top Go down

SSAS 2008 - Hourly Sales Cube Empty Two dimensions

Post  ganley 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.


Posts : 2
Join date : 2013-11-06

Back to top Go down

Back to top

- Similar topics

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