in Plant selecting condition in webi

[gunduvinay]

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

[amitrathi239 · Accepted solution]

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

[gunduvinay · Accepted solution]

Amit,

Thanks for your quick reply

Your answer is correct and

But is there any possibility in universe to do so

Regards,

Vinay G

[amitrathi239 · Accepted solution]

These conditions are going to be static or prompt based?

[gunduvinay · Accepted solution]

static condition only

[amitrathi239 · Accepted solution]

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

[gunduvinay · Accepted solution]

No its not working

Thank you

[gunduvinay · Accepted solution]

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

Regards,

Vinay g

[amitrathi239 · Accepted solution]

if this is dynamic or static this is the solution in my mind to tackle this.use two queries in webi is simple stright forward solution.