Details
-
Type:
Bug
-
Status:
Open
-
Priority:
Critical
-
Resolution: Unresolved
-
Affects Version/s: None
-
Fix Version/s: Future Release
-
Component/s: None
-
Labels:None
Description
With NON EMPTY (mondrian.rolap.nonempty) behavior set to true the following mdx return no result. The same mdx returns valid result when NON EMPTY is turned off
===================
WITH
MEMBER Measures.Calc AS '[Measures].[Profit] * 2', SOLVE_ORDER=1000
MEMBER Product.Conditional as 'Iif(Measures.CurrentMember IS Measures.[Calc], +
Measures.CurrentMember, null)', SOLVE_ORDER=2000
SET [S2] AS '{[Store].MEMBERS}'
SET [S1] AS 'CROSSJOIN({[Customers].[All Customers]},{Product.Conditional})'
SELECT
NON EMPTY GENERATE( {Measures.[Calc]},
CROSSJOIN( HEAD( {([Measures].CURRENTMEMBER)},
1
),
{[S1]}
),
ALL
)
ON AXIS(0),
NON EMPTY [S2] ON AXIS(1)
FROM [Sales]
===================
I have written a unit test and identified a possible fix for this. Please see the attached patch.
Any ideas for a better fix?
-Ajit
===================
WITH
MEMBER Measures.Calc AS '[Measures].[Profit] * 2', SOLVE_ORDER=1000
MEMBER Product.Conditional as 'Iif(Measures.CurrentMember IS Measures.[Calc], +
Measures.CurrentMember, null)', SOLVE_ORDER=2000
SET [S2] AS '{[Store].MEMBERS}'
SET [S1] AS 'CROSSJOIN({[Customers].[All Customers]},{Product.Conditional})'
SELECT
NON EMPTY GENERATE( {Measures.[Calc]},
CROSSJOIN( HEAD( {([Measures].CURRENTMEMBER)},
1
),
{[S1]}
),
ALL
)
ON AXIS(0),
NON EMPTY [S2] ON AXIS(1)
FROM [Sales]
===================
I have written a unit test and identified a possible fix for this. Please see the attached patch.
Any ideas for a better fix?
-Ajit
{ajit_joglekar}, 09/10/2007: File Added, 244984: changelist9867.tar.gz |
{jhyde}, 09/10/2007: IP, Comment Added: 64.81.57.79 |
{jhyde}, 09/10/2007: assigned_to, 100 |
{ajit_joglekar}, 09/11/2007: IP, Comment Added: 125.18.63.213 |
{jhyde}, 09/12/2007: IP, Comment Added: 66.92.12.96 |
{jhyde}, 09/12/2007: assigned_to, 312935 |
{willgorman}, 01/11/2008: priority, 5 |
{willgorman}, 01/11/2008: assigned_to, 100