Skip to Content
author's profile photo Former Member
Former Member

pre-define filter for query in a BEx Report

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. 😊

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2008 at 09:15 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2008 at 09:17 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 13, 2008 at 10:17 AM

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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.