Pentaho Analysis - Mondrian

• Type: Bug
• Status: Open
• Priority: Severe
• Resolution: Unresolved
• Affects Version/s: None
• Fix Version/s: Future Release
• Component/s: Native SQL
• Labels:

  None

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.

• Assignee:

  Unassigned User

  Reporter:

  mkambol

• Created:

  26/Aug/08 6:07 PM

  Updated:

  06/Apr/09 3:10 PM