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

BW Analysis Authorization Issue

here is a scenario


Info provider: ZHRPYO01 (standard DSO) within this DSO there is a characteristic which is set as authorization relevant – 0EMPLSGROUP

Roles assigned: ZS:BW-DAT-SAL-PAYROLL-1

Query technical name: SECURITY_TEST_2 built on top of the DSO ZHRPYO01.

Authorization objects in the role ZS:BW-DAT-SAL-PAYROLL-1:

S_RS_AUTH – ZEMPL1

S_RS_COMP- all access

S_RS_COMP1 – all access

S_RFC – all access

Analysis authorization ZEMPL1 details:

0TCAACTVT – all access

0TCAIPROV - 0EMPLSGROUP, ZHRPYO01

0TCAKYFNM – all access

0TCAVALID – all access

Based on the above technical details, when I run RSRT and execute the query “SECURITY_TEST_2” I get the below error message. If I assign 0BI_ALL the query runs without any issue. What am I missing ?

aa2.png (10.7 kB)
Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2015 at 05:23 AM

    Hi Rahul,

    Since the characteristic "0EMPLSGROUP" is auth relevant, make sure you maintain the same in the Analysis Authorization ZEMPL1.

    So your Analysis Authorizaiton ZEMPL1 will look like below

    0TCAACTVT – all access

    0TCAIPROV - ZHRPYO01

    0TCAKYFNM – all access

    0TCAVALID – all access

    0EMPLSGROUP - ( * or : etc., depending on how you want to restrict).


    If 0EMPLSGROUP is not a restricted field, you cna give * else you may give only " : " value.



    Thanks,

    Kalpana.

    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.