US and Worldwide: +1 (866) 660-7555

Search Forums:

Type: Posts; User: MatBailie; Keyword(s):

1. Thread: How To Implement A "Per Hour" Measure?

by MatBailie
Replies
5
Views
381

In terms of using a virtual cube to solve this;...

In terms of using a virtual cube to solve this; Our main fact tables would have Dimensions A..Z plus a Date Dimension, plus a Time Dimension, then an additional cube would just have the Date and Time...
2. Thread: How To Implement A "Per Hour" Measure?

by MatBailie
Replies
5
Views
381

Thanks for your thoughts, and yes it's seemingly...

Thanks for your thoughts, and yes it's seemingly trickier than I possibly thought.

Indeed the fact table does already have such a foreign key. Unfortunately it's not quite as simple as at first...
3. Thread: How To Implement A "Per Hour" Measure?

by MatBailie
Replies
5
Views
381

How To Implement A "Per Hour" Measure?

I've been trying to work out a way of calculate values on a "per hour" basis.

For example:
- We have a Date Dimension with levels { (Everything), Year, Quarter, Month, Day Of Week, Date }
- We...

by MatBailie
Replies
6
Views
1,381

Hi Mark, Thanks for taking the time to look at...

Hi Mark,

Thanks for taking the time to look at this. I've posted the issue in Saiku.

Did you run your tests with or without my work-around? The reason that I ask is to begin to evidence the...
5. Thread: day is 0400 to 0400 of next day in cubes

by MatBailie
Replies
6
Views
947

Our current practice is to have two or more...

Our current practice is to have two or more foreign_keys in our fact table, both of which point to the Date/Time dimension table.
- The UTC Date/Time - Categorical, not disrupted by day light...

by MatBailie
Replies
4
Views
1,957