US and Worldwide: +1 (866) 660-7555
Results 1 to 4 of 4

Thread: PostgreSQL 9.3 materialized views as aggregates

  1. #1
    Join Date
    Apr 2013
    Posts
    14

    Default PostgreSQL 9.3 materialized views as aggregates

    Hello everybody!

    We 're trying to use materialized views (just implemented in PostgreSQL 9.3) as cube aggregates. But Mondrian can't see them, no traces of that views in logs.
    If I create regular view over materialized and switch schema to it - it works.

    What can be the cause of a problem?

    Pentaho BI Version - 4.8.1.GA.51480

  2. #2
    Join Date
    Apr 2013
    Posts
    14

    Default

    I thought problem was in old JDBC driver, but, for example, Kettle sees all materialized views through the same driver version...

  3. #3
    Join Date
    Jan 2013
    Posts
    472

    Default

    Mondrian queries database metadata to determine what tables and views are are available. I bet it's not picking up the list of materialized views.

  4. #4
    Join Date
    Apr 2013
    Posts
    14

    Default

    I wonder, if this bug was fixed in Mondrian version 5?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •