SAP BI BO security

[former_member186356]

Hi Gurus,

I have 3 question to BO Security.

Task. In a company we have 500 sales people with different hierarchy.  Like GM, under him Divisional manger, under him, sales manager, under him sales reps etc. This will be a hierarchy coming from SAP BW. Also the Info cube has the sales employee number information.

Question1

Objective is, when each employee run the report, he should be able see records belongs to his employee ID. But when his manager/supervisor runs the report he should be able to see records Belong to him and his subordinate employee data as well.

How to implement this scenario in SAP BI BO combination. We are in BO 4.X environment, BW 7.3.

Option 1). There is no universe, if you connect Bex to BOBJ tools Via BICS connections.

If there is no universe, it has to be done at the BEx level.

Option2) Connecting to BW cubes via relational connection. I believe in this case we cannot use bex

Via relational (OLAP) connection .So therefore Bex authorization variables are not support6ed.

Question2

No of user’s access: In BO we have CPU licenses and BW is based on number of users.

The back end is SAP BW. Front end is all BOBJ tools. Since we have CPU license. So there will not be any limit on the number of users on the BOBJ side.  BW license is based on no of users (I believe we have 50).  If we have 300 BO users and wanted to implement the above reporting requirements, do we have to buy additional licenses or is there any way to pass the system ID to get all data from BI and display related information in BO. Like it happens in Process chain. 

Question3 : Right tool

We have the drill down reporting where at first it display the higher level numbers and once if we click on the link it should go to next page and shown detail information . Which BOBJ tool is best for this kind of analysis? I know this  Can be done in WEBI. But I want the expert opinion.

Electronics	5000	TV	2000
Land	2000	DVD	500
Home deco	400	Lap top	2000
Key board	500

You help is highly Appreciated.

Thanks

Magge

[former_member189638]

If you have the security in SAP BW then the same can be leveraged in SAP BO as well...You don't need any additional security at BO side.

If your reports are at detailed granularity and pulls huge volume of data then alwayd go for WebI..if the reports are only at summarized for then you can opt for Xcelcius as well.

[Former Member]

Hi,

As you asked in question -2.  The BW licences not required for BO Users. All the BO users can use Dashboard , Crystal Reports, Webi  reports without having user id in BW.  Only developer / Administrator require BW Licence for creating connections etc.

Regards,

Anand Mehrotra.

[former_member186356]

Thank you Rakesh & Anand for your answers.

Anand,

I believe even though you enable the SSO, the authentication is checked in SAP BW backend,

So I believe you have to have the BW ID created for each user. If it is non-SAP data base line

Sql I believe it's correct that you do not need the users to be created.

Could you please explain more when you het chance.

For my question-3, I just wanted to know which of the BOBJ tool will work better when you

Drill down or drill through (like WEBI, explorer, analysis etc.) because as we know we had

Lot of issues with these tools earlier.

Thanks

Magge