Improve Business Reporting on Your RAR Data Using Data Mart Functionality

  • by Massimo Manara, SAP Security Consultant, Aglea s.r.l.
  • Andrea Cavalleri, SAP Security Consultant, Aglea s.r.l.
  • January 13, 2011
Reporting can be challenging when technical information is not presented in a user-friendly way, causing business users to ignore it or misread it. Overcome these challenges in the risk analysis and remediation (RAR) component of SAP BusinessObjects Access Control by using the data mart feature included in Support Packages 9 and 10. Discover the customizing to make this feature work, as well as helpful links and an example of a report in one tool.

Data mart is a capability released in Support Package 9 for SAP BusinessObjects Access Control’s risk analysis and remediation (RAR) and compliant user provisioning (CUP) capabilities. It allows you to export SAP BusinessObjects Access Control tables into another reporting tool. (For more information, see SAP Note 1369045.) With this feature, SAP BusinessObjects Access Control can use the extraction, transformation, and loading (ETL) process to fill some RAR and CUP tables (all tables that start with GRC_DM_) and allow you to read and then correlate the data of these tables.

Using the data mart feature allows you to better involve the business in the analysis, remediation, mitigation, and continuous compliance phases of risk management by representing the more technical data in the classical output of RAR as a business-readable layout created by you. We’ll show you how to configure the data mart feature in your RAR system and how to connect it to a reporting tool, using Microsoft Access as an example. We’ll start with a general data mart job process and move through the steps from there.

Note
The data mart feature is only available in the RAR interface, but can use information from both RAR and CUP tables. We focus mostly on RAR information in this article, but mention CUP when applicable.
 

Massimo Manara

Massimo Manara is an SAP-certified security and compliance consultant at Aglea s.r.l. (www.aglea.com), the only Italian company whose core business is SAP security and compliance. He has nearly 10 years of experience in IT security and a bachelor’s degree and master’s degree in security computer science and on SAP projects.

See more by this author

Andrea Cavalleri

Andrea Cavalleri is an SAP-certified security and compliance consultant. He founded Aglea s.r.l. in 2003. He has 12 years of experience in IT and more than 15 years experience as developer in Visual C++ and Microsoft Access. Andrea has been team leader in more than 30 SAP security projects and is a teacher for SAP Italy courses since 1999.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.