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

bw data authorisation issue

Hi all,

Please give the solution regarding the bw data authorisation.Actually i want to give authorisation on i am sharing my view how i want to restrict the there are 50 software engineer they have its own data above all the software engineer there are 3 or 4 team lead and above all the teal lead manager are i want to restrict like the each software engineer able to see only his data and the teal lead will able to see all the software engg. that are under him.same thing foe manager.i need the authorisation in this format.for this i have tried Using dso thing where i ahve uploaded the excel in dso with the mapped when the user logged in the system they have appear a selection screen where they put his report accesing id.and after that they will able to fetch data from infoobject.even after the loading the data on dso i have genraten the authorisation using rsecadmin transaction.but its still not working they are showing more that one report.if any one has solution please help me. requirment in my project.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Nov 14, 2009 at 06:55 AM


    What kind of data you want to restreict to s/w engineer and team lead. Please mention your charcteristics. For example you want to restrict it by 0EMPLOYEE charachetristics.

    Then make this char. as authrization relevant through RSD1 t-code. And mention this char. as auth. varaiable in your BW report.

    Best Regards


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 16, 2009 at 05:12 AM

    1. Create the Info Object: - Employee Details e.g.: -ZEMPDTL

    2. All the employee data upload to the ZEMPDTL Info Object

    3. Use the RSECADMIN Transaction code.

    4. Create the Analysis Authorization for each employee

    e.g.:- ZEMP_SE01 to ZEMP_SE50

    a) Restrict ZEMPDTL info cube using Analysis Authorization e.g.:- ZEMP_SE01 Value

    Authorization each employee number single intervals (I EQ SE01).

    5. Create the Analysis Authorization for team lead

    e.g.:- ZTEAMLEAD_ALL (give me full Access)

    6. Create 51 roles and assign 51 Analysis Authorization (ZEMP_SE01 to ZEMP_SE50 and ZTEAMLEAD_ALL) each one


    7. Each software engineer and team lead has access in role based access in BW system.

    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.