Hitachi Vantara Pentaho Community Forums
Results 1 to 7 of 7

Thread: Mondrian and agregate tables Missing documentation

  1. #1
    Join Date
    Aug 2006
    Posts
    141

    Default Mondrian and agregate tables Missing documentation

    I've been working arround the aggregate tables over mondrian, using Aggregation Designer. And untill now I've can't make it work. No matter if use the schema that generate Aggregation Designer, if use my own schema, if change the names of aggregation tables to match with mondrian's rules or if change mondrian's properties.

    The only thing that I can see, mondrian try to find aggregation tables, something like agg.+ XXXXXX

  2. #2

    Default

    May be you are to check parameters in mondrian.properties:

    # Allow the use of aggregates
    mondrian.rolap.aggregates.Use=true
    mondrian.rolap.aggregates.Read=true

  3. #3
    Join Date
    Aug 2006
    Posts
    141

    Default

    Yes I do, and also test all alternatives
    mondrian.rolap.aggregates.Use=false
    mondrian.rolap.aggregates.Read=true


    or

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

    and also

    mondrian.rolap.aggregates.Use=false
    mondrian.rolap.aggregates.Read=false


    The result was only than over mondrian.log I can see something

    mytable1 agg.+"Fact table name"
    mytyable2 agg.+"Fact table name"

    It is that mondrian try to list all tables over my db but can't find agg_"Fact table name"

    I work with PostgreSQL and Tomcat7

  4. #4

    Default

    Oops

    Than I cannot think better than renewing JDBC driver for PostgreSQL and trying to set quoting for table names on this connection.
    Sorry, nothing more comes to mind right now.

  5. #5
    Join Date
    Aug 2006
    Posts
    141

    Default

    Thanks, I'll try and comment on what I find
    Last edited by karlose; 02-26-2013 at 09:25 AM.

  6. #6
    Join Date
    Aug 2006
    Posts
    141

    Talking it works

    Finally the problem was another, I don't know why but the server don't was updating the solution repo, it was working with a version of my schema without the aggregation tables definition.

    I can now see that the server is looking the aggregate tables and evaluate it for use.

    Now I will work to design some aggregation.

  7. #7

    Default

    Oh, yes. I renew cubes by pressing Refresh button on files browser in PUC.

Tags for this Thread

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.