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
405

### 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
405

### 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
405

### 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...
4. ## Thread: 1:many relationship

by MatBailie
Replies
6
Views
1,545

### 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
977

### 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
2,019

### Does this link help? ...

Does this link help?

7. ## Thread: 1:many relationship

by MatBailie
Replies
6
Views
1,545

### 1:many relationship

I have a situation where Saiku sometimes displays an unexpected/undesirable value, until I re-run the exact same calculation.

It is where a fact table has a 1:many relationship with a dimension...
Results 1 to 7 of 7