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

Search Forums:

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

Search Forums: Search took 0.12 seconds.

  1. Replies
    5
    Views
    357

    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. Replies
    5
    Views
    357

    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. Replies
    5
    Views
    357

    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. Replies
    6
    Views
    1,286

    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. 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...
  6. Replies
    4
    Views
    1,926

    Does this link help? ...

    Does this link help?

    http://forums.pentaho.com/showthread.php?65993-Support-for-non-additive-and-semi-additive-measures
  7. Replies
    6
    Views
    1,286

    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