bw data authorisation issue

[Former Member]

Hi all,

Please give the solution regarding the bw data authorisation.Actually i want to give authorisation on bw.here i am sharing my view how i want to restrict the user.like 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 there.so 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 id.like 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.

[Former Member]

Hello,

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

Imran

[Former Member]

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

role.

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