Conditional Slicer

[yvswamy]

Hi

How to create a Conditional slicer as below which is from Relational model. I manged to get that when both dimensions are there in Cross tab but not able to succeed when they are not there in the crosstab. I need to filter the query. Please help me.

IF (DIM#1 = 'ABC' ) THEN
   ( DIM#2 = 'X')
ELSE
   (DIME#2 in ('Y', 'Z')

[BigChris]

If it's not in the crosstab then a slicer wouldn't work anyway (at least, that's the way I've always understood things).

[Drisya]

If it helps.

(DIM#1 = 'ABC' and DIM#2 = 'X') or (DIM#1 <> 'ABC' and DIME#2 in ('Y', 'Z'))

[yvswamy]

HI BigChris,

Thank you for your quick reply.  Even if the dimensions are not there in the cross tab, Slicers work without any problem and I have been doing it. Only problem is I am not able to do it conditionally.

Is there any other alternative for my problem.

Appreciate your time.

Thank you.

[yvswamy]

Hi Drisya,

Thank you for your quick reply.

Slicers will not accept AND OR conditions.


Thank you.

[New_Guy]

Hi

How to create a Conditional slicer as below which is from Relational model. I manged to get that when both dimensions are there in Cross tab but not able to succeed when they are not there in the crosstab. I need to filter the query. Please help me.

IF (DIM#1 = 'ABC' ) THEN
   ( DIM#2 = 'X')
ELSE
   (DIME#2 in ('Y', 'Z')

Hi,

I am assuming this is a DMR model as you said it is relational and you are using slicers. Slicers wont work in a row by row basis conditionally. When you said that you got it working when you placed this 2 dim's in the crosstab, Do you mean that you got the slicer to work or just the data item to work.

Good luck
New guy

[yvswamy]

Hi New_Guy,

As you rightly said its a Dimensional Cube.

Slicers are not working. I just added the data Items to the cross tab to get the desired output.

Let me know if there is any other solution to my problem.