cancel
Showing results for 
Search instead for 
Did you mean: 

How to use like selection in BW query

Former Member
0 Kudos

Hi,expert.

I have a DSO,it has three Objects,

ZIO_A, ZIO_B, ZIO_C

I want to create a query, in the query I want to use like selection, for example,the DSO has 3 records.

fields:.......... ZIO_A, ZIO_B, ZIO_C, ZIO_C.

records:.......10001, abcaa, 200.00, 4

.....................10002, abcaa, 300,00, 6

.....................10003, bcdee, 250.00, 5

I create an variable ZV_ZIO_B on the InfoObject ZIO_B,

when I input 'abc' on the query selection screen,I can get two records which have 'abc' string in the field ZIO_B value.

How to get this result,TKS.

Edited by: Bruce Wang on Jul 12, 2010 3:33 AM

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

If you are running report on Analyzer 7.x.

Just use the wild charatcters (*) for the same.

Put in selection screen "abc" for corresponing Info object slection variable.

I hope it will work.

Thanks,

S

Answers (2)

Answers (2)

Former Member
0 Kudos

TKS

Former Member
0 Kudos

How to input two select condition,both of them are like selection.for example, input 'abc' and 'bcd',the value which has 'abc' or 'bcd' will be selected.

Former Member
0 Kudos

Hi,

You may put abc;xyz.

Just separate both the both selection with ";"(semi colon) and use the wild chracters as per your need.

Thanks,

S

Former Member
0 Kudos

You may write ()abc();()xyz(); --> In one slection variable screen. (Do not put the bracket () sign as I am not able to write (*) on this page so using ()).

I hope this will help.

Thanks,

S