Creating a filter in BEx Query

[Former Member]

    Hi All,  I am new to BEx.

Is it possible to create a filter in BEx query, to use it in webi report. like how we will create filters in universe designer for webi reports.

[Former Member]

Hi David,

Can you please check below SCN link which talks about your issue and your requirement.

This should help which filter and where in bex query you need to create which will be available in Webi report.

http://scn.sap.com/thread/3615907

Regards,

Amit

[sapna_jgurudutt]

Hi,

You can create filter in BW BEx query by using BEx Query Designer.

In Query Designer, you will find two area displayed for filter selection. One is Characteristic Restrictions area to the left which is the fixed filter pane and second is the Default Values area to the right which is the dynamic filter pane.

Please refer the following link regarding how to define filter in BEx Query Designer:

http://help.sap.com/saphelp_sm71_sp08/helpdata/en/42/fcf20384631a71e10000000a422035/content.htm

Please refer the following link regarding working with filters:

http://help.sap.com/saphelp_sm71_sp08/helpdata/en/46/027ef96fd33d54e10000000a155369/frameset.htmHi,

Thanks & Regards,

Sapna

[ccc_ccc]

Hi Kumar,

Yes , BEx support filter/restrict data.

• Global filter -> we can filter specific data like company code 0101
• Local filters -> for only for specific key figures
• Create variables -> user can enter values

Please give me more details.

Thank you,

Nanda