Uploaded image for project: 'Pentaho Analysis - Mondrian'
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-677

Aggregate Tables not working with Dimension with Parent Child Hierarchy

    XMLWordPrintable

    Details

    • Notice:
      When an issue is open, the "Fix Version/s" field conveys a target, not necessarily a commitment. When an issue is closed, the "Fix Version/s" field conveys the version that the issue was fixed in.

      Description

      • I have set up a number of aggregate tables and explicitly defined these in the schema using AggPattern.
      • One of my shared dimensions has a parent-child hierarchy (with a closure table).

      Every time I drill into this specific dimension with parent-child hierarchy - mondrian ignores all aggregate tables and runs SQL on the underlying fact table.
      If I drill into any other dimension without parent-child hierarchy - mondrian uses the appropriate aggregate tables.

      As an experiment - if I eliminate only the parent-child hierarchy, mondrian uses the aggregate tables.

        Attachments

          Activity

            People

            Assignee:
            Unassigned Unassigned
            Reporter:
            acimi A L
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: