11-27-2007 11:41 AM
Hi ALL
I have a situation where my company has created to 2 different User Id's for a single User. The reason is One User Id wil have access to all the Bex reports & the Other Id has access to BI reports basically this Id will login through portal.
The problem here is that the Single User needs to login into the system using different Id's into the same server.
The design was due to the access restriction implemented is differently in BEX & BI.
Do you guys have any ideas or solutions for getting the two id's merged, but still have the access restricted has before.
regards
Naveen Murthy
11-27-2007 12:33 PM
Hi Naveen,
You really need to re-evaluate your design if you are currently using 2 ID's for reporting for a single user to provide adequate control!
If you can elaborate on what part of the design is causing the problem then we may be able to recommend alternatives which will allow you consolidate while providing the required restriction.
12-10-2007 12:22 PM
Hi ALL
The problem of here we face is that. The BW roles are designed on Comapany code specific giving users full access to all the Cost center.
Where has the BI roles are the reverse case, so how do i proceeed in consolidating the roles with this varying cases.
awaiting your response.
12-10-2007 1:36 PM
create a test user and assigen all roles of both users, ypu will probably see that the test user will have access restricted on the combination of the comapny restriction and the cost centre. Which means that the testuser will only see the info for costcentre as far it is in the company. So what is the problem?
12-10-2007 3:59 PM
Hi Naveen,
You will only have a problem if you are using Cost Centre as a restriction and you have entered * in it for one of your roles.
What is stopping you from creating a role that contains only the cost centres and comp codes that the users require?
If users have differing cost centre access needs for different areas of reporting then the reports should reflect this & maybe you need another cost centre relevant object developed & incorporated into the reporting setup. This way you could differentiate by type of report.