Hitachi Vantara Pentaho Community Forums
Results 1 to 4 of 4

Thread: Mondrian and Aggregates

  1. #1
    Join Date
    Jun 2007
    Posts
    128

    Default Mondrian and Aggregates

    Hi,

    I need some help that will solve my problem.I posting to the forum but I didn't get any replies.Please if anybody has some solution please help me.

    Actually I created aggregate table for my fact table .But mondrain is not fetching data from aggregate table.How can we make mondrian to use aggregates.I even fooloed the naming convention agg_facttablename.

    Please help me.

    Tahnks
    Sreelatha

  2. #2
    wgorman Guest

    Default

    The documentation for aggregate tables is located here:
    http://mondrian.pentaho.org/document...ate_tables.php

    After working through the documentation, if you are still having problems, please post your mondrian schema and we can take a look.

    Good luck!

    Will

  3. #3
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I am following the mondrian documentation .
    I am totally lost and confused.
    Actually I created foodmart database and using foddmart.xml .
    But now I would like to use my own mysql database.Then how can I create xml for that.Before using the cube designer to create cube do we need to create that schema?
    I haven't created the schema file but created cubes on database and they are working fine and the data is fetched from base table.
    Now I would like to enable aggregate matching .So do we need to create a mondrian.jar with updated properties ?

    Thanks
    Sreelatha

  4. #4
    Join Date
    Jun 2007
    Posts
    128

    Default

    Hi,

    I looked the documentation and added

    mondrian.rolap.aggregates.Use=true
    mondrian.rolap.aggregates.Read=true

    in pentaho-solutions/system/mondrian.properties.
    Is that what should be done to make mondrian choose aggregat tables or anything else should be done?
    How can we know whether mondrian is using aggregates or not ?
    Please I need help in making mondrian using aggregate tables.

    Thanks
    Sreelatha

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.