Hitachi Vantara Pentaho Community Forums
Results 1 to 1 of 1

Thread: Aggregate Table Behavior

  1. #1

    Exclamation Aggregate Table Behavior

    Hi,

    I'm having some real problems getting my aggregate tables to work the way I expect. I have two dimensions and two measures. The two dimensions only have one level.

    I've created 4 aggregate tables
    - one at thwith no dimensions
    - two with one dimension each
    - one with both dimensions

    My fact table is over 36 million rows so no queries can be done on it. I've read the documentation, set the mondrian properties, and confirmed from the log that the aggregate tables are getting read and used, but they are being used improperly. The selects are either going to the wrong aggregate table, or back to the fact table. I can't seem to determine why.

    Please help. I'm running the GA pre-installed configuration against an ORACLE db. My schema, action, and log are attached.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Privacy Policy | Legal Notices | Safe Harbor Privacy Policy

Copyright © 2005 - 2019 Hitachi Vantara Corporation. All Rights Reserved.