pre-define filter for query in a BEx Report

[Former Member]

Hi all experts, I have a question, I have created a report with WAD and Query Designer, and I need a pre-define filter for different user or different role. Anyone knows where should I set this pre-define filter to the query ? In the WAD itself, or must do it in backend ? My scenario is, lets say User A login to this report, he will have value A, B, C as filter value in characteristic Z, User B login to this report, he will have value D, E, F as filter value in characteristic Z. Perhaps you guys can understand what I trying to say.

[Former Member · Accepted solution]

Hi,

You can set a customer exit variable on characteristics Z. the value for Variable is populated in customer exit written in CMOD using I_STEP = 1.

You also need to maintain a mapping table for value of characteristics Z to user. Now if user A checks the Report, using the sy-uname you lookup to the mapping table and get the corresponding values of characteristics Z and populate the default value of the variable or straight away restrict it in the query by not making it ready for input.

Hope it helps....

Regards,

Umesh

[Former Member]

hi, thanks for the helps, it really helped me... thanks again

[Former Member]

Hi Experts, I have another question again, is it possible to create a template or maybe a button in my existing template report for user to save the filter value into the table ? Because I want to make it flexible, so user can change their default filter value on their own. Is it possible to communicate with the backend table from my WAD template report ?

[Former Member]

Hi,

It is not possible to Is communicate with the backend table from your WAD template report.

What you try out is the personilzation option available at the varible selection screen in WAD Reports. It is the icon loacated just to the left of the varaible name in the selection screen.

Using this option user can set the default values he requires while executing thi reports....

Hope this helps ....

Regards,

Umesh.

[Former Member]

Hi, Thanks again for replying to my topic, but for this option, it is not practical according to my customer, since it is not possible to view it from other pc. I have a question here, is it possible that I create a BSP page, then from the BSP page store the pre define filter to the table? Or is it possible that I create a button in my WAD template, after user have chosen their filter value, click on the button, and links to a BSP page and do the storing process? I'm not sure how to do it yet, but I wonder whether it is possible, then I will try to research on it if it is possible to do so. Once again, Thanks

Regards,

Sky

[Former Member]

Hi sky,

I Think you can create the BSP page, and from it store the default value which user enters in a table by trigeering a event or something. And then refer this table while populatng the default variable again for the user in WAD report.

But to link WAD to BSP is bit tricky.never came across such a scenario.

Do keep us posted about how you go about it...

Regards,

Umesh.

[Former Member]

Hi Umesh,

Now my problem is, how do I make a drop down box in BSP similiar to filter pane in WAD, so the user can select their desired filter value from the BSP and save back to the table, and I will do the loading part by using the method you mentioned above. Do you have any idea how to make the filter pane in BSP? For linkage between WAD and BSP, I think I will try to put a open new window javascript in the script item and put in the BSP URL. I know that this idea looks dumb and not practical, but this is the only idea I can think of.

Regards,

Sky

[Former Member]

any experts here have any idea ?

[Former Member]

Hi,

Use an exit variable for the characteristic Z. It will read the user id (sy-uname) and return the required list of values for Z.