Hiding Characteristic values dynamically in BW query

402 Views

All,

We have a peculiar requirement regarding BW queries.

We need to suppress certain characteristics and key figures based on user access levels. The output still needs to be displayed but, some confidential data needs to be blanked out if the user does not have the corresponding access (we are even fine hiding the corresponding columns). Since we are on BI 7.0 version, we tried to use the Analysis Authorization... but, the number of characteristics that need this feature is large and would cause a maintenance nightmare for the security team.

We also explored using CMOD customer exit EXIT_SAPLRRS0_001 via query variables. The user exit seems to filter all the rows of the output instead of blanking out the characteristic values.

We had a quick look at the BAdI RSR_OLAP_BADI (Virtual Characteristics and key figures) and this seems to make it very complicated.

Any ideas on achieving this would be greatly appreciated.

Chandu.