Details

    • Type: Bug Bug
    • Status: Open
    • Priority: Severe Severe
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: Not Planned
    • Component/s: Native SQL
    • 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 query returns 3 members of the [Store Dimensions] (CA, OR, WA)

      WITH MEMBER [Measures].[COG_OQP_INT_t2] AS '1',
      SOLVE_ORDER = 65535
      MEMBER [Measures].[COG_OQP_INT_t1] AS '1',
      SOLVE_ORDER = 65535
      SELECT
       {{([Measures].[COG_OQP_INT_t1])},
       {[Measures].[Store Sales]},
       {([Measures].[COG_OQP_INT_t2])},
       {[Measures].[Store Cost]}} DIMENSION PROPERTIES PARENT_LEVEL,
       PARENT_UNIQUE_NAME ON AXIS(0),
       NON EMPTY {[Store].[Store State].MEMBERS}
                   DIMENSION PROPERTIES PARENT_LEVEL,
       PARENT_UNIQUE_NAME ON AXIS(1)
      FROM
       [Sales] CELL PROPERTIES VALUE,
       FORMAT_STRING


      In SSAS 2000 and 2005 this same query will return *all* of the [State].[Store State].members.

      This behavior is the same regardless of whether NativeNonEmpty is true or false. Prior to change 10641 if NativeNonEmpty was set to false Mondrian would match SSAS. After that change (which fixed 1722959) the non-NativeNonEmpty behavior was consistent with NativeNonEmpty, but both did not match SSAS.

      Bug 1722959 actually described the expected behavior and was not a bug.

      This is related to bug 1909516, which involves ValidMeasure() breaking after change 10641.

        Activity

        Hide
        Mondrian Importer User added a comment -
        {mkambol}, 08/26/2008: IP, Artifact Created: 198.91.4.14 |
        {willgorman}, 03/25/2009: IP, Comment Added: 64.132.248.34
        Show
        Mondrian Importer User added a comment - {mkambol}, 08/26/2008: IP, Artifact Created: 198.91.4.14 | {willgorman}, 03/25/2009: IP, Comment Added: 64.132.248.34
        Hide
        Mondrian Importer User added a comment -
        {willgorman}, 03/25/2009: partial fix in change #11972
        Show
        Mondrian Importer User added a comment - {willgorman}, 03/25/2009: partial fix in change #11972

          People

          • Assignee:
            Unassigned User
            Reporter:
            mkambol
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated: