Details
-
Type:
Bug
-
Status:
Closed
-
Priority:
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])
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])
user_id=312935
Fixed in change 3906.