SAP BW Analysis Authorizations on the ADSO data?

[sameer_mehta]

Hi All,

I would like to understand, if it is possible to have the SAP BW Analysis Authorization concept on the ADSO data i.e. without creating the Composite provider or query?

There is an external system connected to BW which directly access the ADSO tables to retrieve the data. It is required to enable the data authorizations on the ADSO data.

Thanks.

[EmanuelGraves]

You can implement row-level security directly on the data within the AD SO. This can be achieved by adding authorization-related fields to your data model and using user exits or customer exits to filter data based on the user's authorization. However, implementing row-level security at the ADSO level may require custom development and can be complex to maintain.

[sameer_mehta]

Thanks Emanuel for your response. Could you please also provide the name of the user exits you are referring?

[EmanuelGraves]

Of course, these are the most common ones: start routine, end routine, expert routine, authorization variable exits. It's important to note that the specific user exits available may vary depending on your SAP BW version and system configuration. Additionally, implementing row-level security using user exits requires custom development and thorough testing to ensure proper enforcement of security policies while maintaining performance.

[EmanuelGraves]

Hope that it's useful.