Authorization privileges between BW4HANA and HANA database

[LCA_AnalystBI]

We are setting for our company all the security task that we need in order to fill the requeriments.

We are facing some problem casuistic, we have for the different users(200) 6 differents infoobject that are relevant of authorization. For each infoobject we have 100 possible different values.

The purpose of this its to consume this privilege in HANA database by Analytical privileges so we need to replicate the authorization created in BW on our HANA layer.

The way that we are creating this scenario is one row for each combination,(screenshot)

Is there any other way to set this because we are going to have thousands of rows.

#BW4HANA #ANALYTICALPRIVILEGE