Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Critical Critical
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None
    • Labels:
      None

      Description

      Mondrian does not support multiple values in the slicer
      right now. Currently, if you provide a slicer with more
      than one member of the same hierarchy, it will slice on
      only the last one. Until we support multiple values, we
      should give an error.

      The following query works correctly (it is not a 'multiple
      slicer', because there is only one member of each
      hierarchy):

      select {[Measures].[Unit Sales]} on columns,
       {[Store].children} on rows
      from [Sales]
      where ([Gender].[M], [Time].[1997].[Q1])

      The following query appears to work, but gives the
      wrong result; we should give an error:

      select {[Measures].[Unit Sales]} on columns,
       {[Store].children} on rows
      from [Sales]
      where {[Time].[1997].[Q1], [Time].[1997].[Q2]}

      Incidentally, you can express the query using a
      calculated member, and get valid results, as follows:

      with member [Time].[1997].[H1] as
        'Aggregate({[Time].[1997].[Q1], [Time].[1997].[Q2]})'
      select {[Measures].[Unit Sales]} on columns,
       {[Store].children} on rows
      from [Sales]
      where ([Time].[1997].[H1])

        Activity

        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 06/15/2005: priority, 5 |
        {jhyde}, 06/22/2005: assigned_to, 100 |
        {jhyde}, 07/31/2005: status_id, 1 |
        {jhyde}, 07/31/2005: close_date, 0 |
        {sf-robot}, 08/15/2005: status_id, 4 |
        {sf-robot}, 08/15/2005: close_date, 1122776902
        Show
        Mondrian Importer User added a comment - {jhyde}, 06/15/2005: priority, 5 | {jhyde}, 06/22/2005: assigned_to, 100 | {jhyde}, 07/31/2005: status_id, 1 | {jhyde}, 07/31/2005: close_date, 0 | {sf-robot}, 08/15/2005: status_id, 4 | {sf-robot}, 08/15/2005: close_date, 1122776902
        Hide
        Mondrian Importer User added a comment -
        {jhyde}, 07/31/2005: Logged In: YES
        user_id=312935

        Fixed in change 3906.
        Show
        Mondrian Importer User added a comment - {jhyde}, 07/31/2005: Logged In: YES user_id=312935 Fixed in change 3906.
        Hide
        Mondrian Importer User added a comment -
        {sf-robot}, 08/15/2005: Logged In: YES
        user_id=1312539

        This Tracker item was closed automatically by the system. It was
        previously set to a Pending status, and the original submitter
        did not respond within 14 days (the time period specified by
        the administrator of this Tracker).
        Show
        Mondrian Importer User added a comment - {sf-robot}, 08/15/2005: Logged In: YES user_id=1312539 This Tracker item was closed automatically by the system. It was previously set to a Pending status, and the original submitter did not respond within 14 days (the time period specified by the administrator of this Tracker).
        Hide
        Gretchen Moran added a comment -
        Temporary open to allow setting the resolution field.
        Show
        Gretchen Moran added a comment - Temporary open to allow setting the resolution field.
        Hide
        Gretchen Moran added a comment -
        Bulk changed the resolution field from NONE to FIXED in order for JIRA to report properly.
        Show
        Gretchen Moran added a comment - Bulk changed the resolution field from NONE to FIXED in order for JIRA to report properly.

          People

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

            Dates

            • Created:
              Updated:
              Resolved: