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

View Entire Topic
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