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

NPE aggregating distinct-count measure in virtual cube

    Details

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

      Executing the following MDX
      with member [Warehouse].[x] as 'Aggregate([Warehouse].members)'
      member [Measures].[foo] AS '([Warehouse].[x],[Measures].[Customer Count])'
      select

      {[Measures].[foo]}

      on 0 from [Warehouse And Sales]

      throws NullPointerException at RolapAggregationManager.generateMultiSQl(), line 426.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {shishir_das}

        , 08/21/2007: IP, Artifact Created: 125.18.63.163 |

        {jhyde}, 08/21/2007: IP, Comment Added: 66.92.12.96 | {jhyde}

        , 08/21/2007: assigned_to, 100 |

        {jhyde}, 08/23/2007: IP, Comment Added: 66.92.12.96 | {jhyde}

        , 08/23/2007: status_id, 1 |

        {jhyde}, 08/23/2007: resolution_id, 100 | {jhyde}

        , 08/23/2007: summary, cube.getStar() throws NullPointerException |

        {jhyde}

        , 08/23/2007: close_date, 0

        Show
        Mondrian Importer User added a comment - {shishir_das} , 08/21/2007: IP, Artifact Created: 125.18.63.163 | {jhyde}, 08/21/2007: IP, Comment Added: 66.92.12.96 | {jhyde} , 08/21/2007: assigned_to, 100 | {jhyde}, 08/23/2007: IP, Comment Added: 66.92.12.96 | {jhyde} , 08/23/2007: status_id, 1 | {jhyde}, 08/23/2007: resolution_id, 100 | {jhyde} , 08/23/2007: summary, cube.getStar() throws NullPointerException | {jhyde} , 08/23/2007: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}

        , 08/21/2007: Logged In: YES
        user_id=312935
        Originator: NO

        Cube.getStar() is expected to return null if the cube is virtual - which is the case here. But of course in that case, generateMultiSql shouldn't be calling it.

        Thanks for the nice testcase - that helps a lot - I'll take a look.

        Show
        Mondrian Importer User added a comment - {jhyde} , 08/21/2007: Logged In: YES user_id=312935 Originator: NO Cube.getStar() is expected to return null if the cube is virtual - which is the case here. But of course in that case, generateMultiSql shouldn't be calling it. Thanks for the nice testcase - that helps a lot - I'll take a look.
        Hide
        Mondrian Importer User added a comment -
        {jhyde}

        , 08/23/2007: Logged In: YES
        user_id=312935
        Originator: NO

        Fixed in change 9806, will be in mondrian-2.4.2.
        Changed summary; was "cube.getStar() throws NullPointerException".

        Show
        Mondrian Importer User added a comment - {jhyde} , 08/23/2007: Logged In: YES user_id=312935 Originator: NO Fixed in change 9806, will be in mondrian-2.4.2. Changed summary; was "cube.getStar() throws NullPointerException".

          People

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

            Dates

            • Created:
              Updated:
              Resolved: