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

VirtualCube SegmentArrayQuerySpec.addMeasure assert

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Medium
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None
    • 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

      If one creates the virtual cube:

      <VirtualCube name="Sales vs Warehouse">
      <!--
      <VirtualCubeDimension name="Time"/>
      -->
      <VirtualCubeDimension name="Product"/>
      <VirtualCubeMeasure cubeName="Warehouse"
      name="[Measures].[Warehouse Sales]"/>
      <VirtualCubeMeasure cubeName="Sales"
      name="[Measures].[Unit Sales]"/>
      </VirtualCube>

      (not Time commented out) and then runs:

      select

      { [Measures].[Warehouse Sales], [Measures].[Unit Sales] } ON COLUMNS, {[Product].[All Products]}

      ON ROWS
      from [Sales vs Warehouse];

      one gets the assert exception:
      Caused by: mondrian.olap.MondrianException: Mondrian
      Error:Internal error: assert failed
      at
      mondrian.resource.MondrianResource$_Def0.ex(MondrianResource.java:1027)
      at mondrian.olap.Util.newInternal(Util.java:886)
      at mondrian.olap.Util.assertTrue(Util.java:867)
      at
      mondrian.rolap.agg.SegmentArrayQuerySpec.addMeasure(SegmentArrayQuerySpec.java:110)
      at
      mondrian.rolap.agg.AbstractQuerySpec.nonDistinctGenerateSQL(AbstractQuerySpec.java:90)
      at
      mondrian.rolap.agg.SegmentArrayQuerySpec.generateSqlQuery(SegmentArrayQuerySpec.java:84)
      at
      mondrian.rolap.agg.AggregationManager.generateSql(AggregationManager.java:198)
      at
      mondrian.rolap.agg.Segment.load(Segment.java:251)
      at
      mondrian.rolap.agg.Aggregation.load(Aggregation.java:130)
      at
      mondrian.rolap.agg.AggregationManager.loadAggregation(AggregationManager.java:71)
      at
      mondrian.rolap.FastBatchingCellReader$Batch.loadAggregation(FastBatchingCellReader.java:284)
      at
      mondrian.rolap.FastBatchingCellReader.loadAggregations(FastBatchingCellReader.java:154)
      at
      mondrian.rolap.RolapResult.executeBody(RolapResult.java:239)
      at
      mondrian.rolap.RolapResult.<init>(RolapResult.java:157)
      at
      mondrian.rolap.RolapConnection.execute(RolapConnection.java:330)
      ... 6 more

      On the other hand if the Time dimension is not
      commented out, then there is not assert error
      but "Unit Sales" is zero.

      The junit test file VirtualCubeTest.java can be
      used to see this.

        Attachments

          Activity

            People

            • Assignee:
              Unassigned
              Reporter:
              emberson emberson
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: