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

Combined closure and aggregate tables doesn't work

    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.
    • Browser:
      Mozilla Firefox 9.0.x
    • Operating System/s:
      Windows XP

      Description

      In the Mondrian document, it refers to that we can combine closure and aggregate tables with a trick in Mondrian's internal.
      Now that i have a cube with structure like the below.
      Cube: [Touch_Access_D]
      Dimensions: [DIM_WAP_FUNC_ADD], with level [WAP_FUNC_OP_LEVEL] – a parent-child hierarchy
      Fact Table: FACT_TOUCH_ACCESS_D(op_id,pv)
      Closure Table: WAP_FUNC_OP_LEVEL_closure(id,parent_id,depth)
      aggregation table: AGG_TOUCH_ACCESS_OP_PARENT(PV_COLUMN,PARENT_COLUMN,FACT_COUNT)

      then , i create a aggregate like this:
      <AggPattern pattern="AGG_TOUCH_ACCESS_OP.*" ignorecase="true">
      <AggFactCount column="FACT_COUNT">
      </AggFactCount>
      <AggMeasure column="PV_COLUMN" name="[Measures].[pv]">
      </AggMeasure>
      <AggLevel column="PARENT_COLUMN" name="[WAP_FUNC_OP_LEVEL$Closure].[parent_id]" collapsed="false">
      </AggLevel>
      </AggPattern>

      while executing it , i received the error log like "The Hierarchy 'WAP_FUNC_OP_LEVEL$Closure' does not exist" and can't view the cube.

        Attachments

          Activity

            People

            Assignee:
            project admin Triage
            Reporter:
            pdeng pdeng
            Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: