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')
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).
If it helps.
(DIM#1 = 'ABC' and DIM#2 = 'X') or (DIM#1 <> 'ABC' and DIME#2 in ('Y', 'Z'))
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.
Hi Drisya,
Thank you for your quick reply.
Slicers will not accept AND OR conditions.
Thank you.
Quote from: yvswamy on 09 Jun 2017 03:40:41 AM
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
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.