Pentaho Analysis - Mondrian
  1. Pentaho Analysis - Mondrian
  2. MONDRIAN-321

CrossJoin has no nulls when EnableNativeNonEmpty=true

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • 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.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {willgorman}

        , 01/11/2008: Logged In: YES
        user_id=160824
        Originator: NO

        Julian/Will to investigate further in late Jan.

        Show
        Mondrian Importer User added a comment - {willgorman} , 01/11/2008: Logged In: YES user_id=160824 Originator: NO Julian/Will to investigate further in late Jan.
        Hide
        Mondrian Importer User added a comment -
        {avix}

        , 10/15/2008: This will probably be fixed with bug #1961163

        Show
        Mondrian Importer User added a comment - {avix} , 10/15/2008: This will probably be fixed with bug #1961163
        Hide
        Julian Hyde added a comment -
        Show
        Julian Hyde added a comment - Note that bug 1961163 = http://jira.pentaho.com/browse/MONDRIAN-412
        Show
        Jake Cornelius added a comment - http://jira.pentaho.com/browse/MONDRIAN-412

          People

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

            Dates

            • Created:
              Updated:
              Resolved: