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

ArrayIndexOutOfBoundsException when using 'count distinct'

    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

      Use a query with a measure based upon 'distinct count'
      and no measures, and you get an
      ArrayIndexOutOfBoundsException.

      Example query:

      select

      {[Measures].[Customer Count]}

      ON columns,

      {([Promotion Media].[All Media], [Product].[All Products])}

      ON rows
      from [Sales]
      where [Time].[1997]

      This can also happen if there are other measures, if
      those measures happen to be in the cache already.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 09/12/2003: status_id, 1 | {jhyde}

        , 09/12/2003: resolution_id, 100 |

        {jhyde}, 09/12/2003: assigned_to, 100 | {jhyde}

        , 09/12/2003: close_date, 0

        Show
        Mondrian Importer User added a comment - {jhyde}, 09/12/2003: status_id, 1 | {jhyde} , 09/12/2003: resolution_id, 100 | {jhyde}, 09/12/2003: assigned_to, 100 | {jhyde} , 09/12/2003: close_date, 0
        Hide
        Mondrian Importer User added a comment -
        {jhyde}

        , 09/12/2003: Logged In: YES
        user_id=312935

        Fixed in change 769.

        Show
        Mondrian Importer User added a comment - {jhyde} , 09/12/2003: Logged In: YES user_id=312935 Fixed in change 769.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: