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

CrossJoin has no nulls when EnableNativeNonEmpty=true

    Details

    • Type: Bug
    • Status: Closed
    • Severity: High
    • Resolution: Duplicate
    • Affects Version/s: None
    • Fix Version/s: 3.0.5
    • 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

      The following MDX query returns a different result set depending on the setting of the mondrian.native.nonempty.enable property:

      WITH SET DataSet# AS 'Crossjoin(

      {Descendants([Customer_2].[All Customers], 2)}

      ,

      {[Product].[All Products]}

      )'
      SELECT

      {[Measures].[Unit Sales], [Measures].[Store Sales]}

      on columns,
      Hierarchize(

      {[#DataSet#]}

      ) on rows FROM [Sales]

      The customer dimension has a total of 10281 members with 5581 members being non empty. Using a CrossJoin you would expect the result set to have a row for all 10281 customers. However if the mondrian.native.nonempty.enable is set to true only 5581 rows are returned (using the same CrossJoin query). With the property set to false 10281 rows are returned as expected.

        Attachments

          Activity

            People

            • Assignee:
              jhyde Julian Hyde
              Reporter:
              rthar rthar
            • Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: