SAP BO 4.0 relational universe on SAP BW data - Data security Consideration

[Former Member]

Hello SAP BI Experts,

Scenario:

Data security associated with user profiles is defined in the BW layer using Analysis Authorizations (example: restrictions by company code, profit center associated with user idu2019s).

If SAP BO 4.0 is the reporting application operating on top of BW (Using a relational universe) u2013 are there any potential options to read BW data layer security other than using Bex query based u201Cauthorization variablesu201D?

Thanks in advance,

Mangesh

[Former Member]

Hello Mangesh,

You can utilize the data level authorization of BW system only along with SSO in universe.

1. You have to use SAP authentication as default in BO (your BW System as source)

2. Enable SSO in Universe connection

So when the user running the report, the user information of BO (BW system username) will be passed to universe connection. Report will refresh with that user only, that means he can see only his data could be the company / profit center he belongs to.