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

Some queries against Virtual cubes can give wrong results when dimensions don't fully join

    Details

    • Type: Bug
    • Status: Closed
    • Severity: Urgent
    • Resolution: Fixed
    • Affects Version/s: 3.5.x (4.8.2 GA Suite Release), 5.0.0 M1
    • Fix Version/s: 7.0.0 GA
    • Component/s: None
    • Labels:
    • 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.
    • Sprint Team:
      BB-8

      Description

      Queries which involve a mix of partially applicable dimensions can give wrong results. E.g.

      with member [Measures].[allW] as
      '([Measures].[Unit Sales], [Warehouse].[All Warehouses])'
      select NON EMPTY Crossjoin(
      [Warehouse].[State Province].Members, [Product].[All Products].children)
      ON COLUMNS,

      { [Measures].[allW]}

      ON ROWS
      from [Warehouse and Sales];

      returns an empty set, even though it should return a list of warehouses / products.

      Attaching a write-up with more detail.

        Attachments

          Issue Links

            Activity

              People

              • Assignee:
                AKarneichyk Alena Karneichyk (Inactive)
                Reporter:
                mcampbell Matt Campbell
              • Votes:
                4 Vote for this issue
                Watchers:
                15 Start watching this issue

                Dates

                • Created:
                  Updated:
                  Resolved: