Skip to Content

Authorization to restrict shown values in query designer

Hi guys,

Just want to ask the needed authorization object so that users creating queries will only see the "authorized" values when restriction an infoobject?

For example:

I have an infoobject 0COMP_CODE with values:

1000

2000

3000

4000

5000

User A is authorized only to see the company codes for 1000 and 2000..

So when user A wanted to restrict the 0COMP_CODE in the query designer, he/she must only see the values 1000 and 2000 in the list..What authorization object do I need to implement this?

Thank you..

Loed

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Mar 16, 2016 at 03:21 PM

    the authorization object is S_RS_AUTH which in turn is 'filled' with objects maintained in RSECADMIN. These are called 'Analysis Authorizations'.

    Google any of these terms to get a lot of info on how it works.

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 16, 2016 at 06:33 PM

    Hi Loed,

    To achieve this requirement you need to create analysis authorization to restrict company code values and its should assign to particular user.

    Bex query create restrict comp code with variable to by authorization type so that whenever user will execute report he or she will see only data of company code for which he is authorized.

    Comp_code is already authorization relevant.

    If you do not know how to create analysis authorization please take help from security team or let us know.

    Regards,

    Ganesh Bothe


    auth.PNG (44.7 kB)
    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 16, 2016 at 09:06 PM

    Hi Loed,

    Pls refer below link, it may helpful.

    https://scn.sap.com/thread/3866655

    Regards,

    Hitesh

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 17, 2016 at 05:06 AM

    Hi Ganesh and Hitesh,

    Similar with Tom's suggestion above..

    However, my problem is not about authorization when running the query but when CREATING THE QUERY..

    I already tried ANALYSIS AUTHORIZATION (see link below)..I think it only applies when running the queries..But when creating a query, user can still see other values when restricting an infoobject which he/she is not authorized..

    http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0b7acf2-6121-2e10-5591-eaec182d9315?quicklink=index&…

    Regards,

    Loed

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Mar 30, 2016 at 01:14 AM

    Hi guys,

    Any idea about this?

    Thank you..

    Loed

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Apr 30, 2016 at 03:17 PM

    Hi guys,

    Any help on this?

    Thank you..

    Loed

    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.