Skip to Content
0

in Plant selecting condition in webi

Jan 11, 2017 at 09:58 AM

14

avatar image

Hi Experts,

I have multiple plant select condition ,

in that if i select a particular plant i need to exclude some object only for that plant, rest of the plant's data should not change and that condition should not effect remaining plant.

Ex

Plant ID-- IN

CATEGORY --Y

If i select In plant Y should exclude and rest of the plant's should remain same .

Thanks in advance

Regards,

Vinay G

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
AMIT KUMAR
Jan 11, 2017 at 10:24 AM
1

create two webi queries.

1) condition Plant is equal to IN AND Category equal to Y

second webi query

2) condition Plant is not equal to IN

Show 7 Share
10 |10000 characters needed characters left characters exceeded

Amit,

Thanks for your quick reply

Your answer is correct and

But is there any possibility in universe to do so

Regards,

Vinay G

0

These conditions are going to be static or prompt based?

0

static condition only

0

in that case you need to create two webi queries only.

or if you are looking universe level solution then you have to create multiple measure objects and need to specify the condition in where clause.

one measure object where Plant <> IN

Second measure object where Plant is equal to IN and Category equal to Y

0

No its not working

Thank you

0

if it was a dynamic filter means how can i write can you help me please

Regards,

Vinay g

0
Show more comments