Skip to Content
0
May 22, 2020 at 04:29 PM

Questions about BW query authorization to limit user display by fields and field values

45 Views

Hi, Experts:

We are on SAP BW release 731. We have a new multi-provider M013 and have couple of queries built on M013. We need to create a new authorization role to meet the following requirements:

  1. Allow users to access only the queries built on new multi-provider M013.
  2. Not allow user to display characteristic field named “RT” with characteristic field named “Employee ID” unless with additional existing authorization role “FRA_OT” is also assigned.
  3. Not allow user to display characteristic field named “Wage Type” unless with additional existing authorization role “FRA_WT” is also assigned.
  4. Not allow user to display characteristic field named “RC” under hierarchy node value “3SEC” unless with additional existing authorization role “FRA_SRF” is also assigned.

I am having trouble to meet requirement 2 to 4. I guess something to be done to the role and to the queries on the new cube. Would you please let me know how to meet these requirements?

Thank you very much!

Jenny