Secure Data Using Multiple Characteristics in SAP BusinessObjects Explorer

  • by YatKwai Kee, Lead Architect, Business Analytics/BI
  • Vasu Sattenapalli, Independent SAP BI Solution Architect
  • August 13, 2010
Design and populate information spaces for authorizations and use the personalization feature in SAP BusinessObjects Explorer to overcome the single authorization object limitation. In this example, the business scenario required authorization on two characteristics. This is not possible to do with standard authorization settings available in the SAP BusinessObjects Explorer index maintenance screen.
Key Concept
SAP BusinessObjects Explorer is a data exploration and discovery tool that is part of the SAP BusinessObjects BI solutions. This tool empowers users to identify trends, outliers, and contributors of the dataset they are analyzing with optimal response time in an intuitive and simple user interface. An advantage of using SAP BusinessObjects Explorer over other SAP NetWeaver BW tools is the Google-style search functionality across the data fields and metadata.

On a recent project we needed to develop an information space that enables users to explore the point-of-sale (POS) data. The data needed to be secured using characteristics ZPOSGBU (global business unit) and ZCOUNTRY (country of sales). The authorization settings available in SAP BusinessObjects Explorer maintenance (transaction RSDDTPS) only allow you to secure data using one characteristic. We provide a workaround solution using the personalization feature, which allows you to secure data on any number of characteristics as needed.

To be able to explore the POS data, you need to configure the POS MultiProvider YSD_M17 for data exploration using SAP BusinessObjects Explorer. This MultiProvider has two InfoObjects, ZPOSGBU and ZCOUNTRY, which are authorization relevant.

YatKwai Kee

YatKwai Kee is a highly successful BI/data warehousing architect with a proven track record in implementing large-scale BI and data warehousing projects. He is currently working as the lead architect in the business analytics/BI area at Newell Rubbermaid. He is responsible for the end-to-end SAP BusinessObjects implementation — including SAP BusinessObjects Web Intelligence, Xcelsius, and SAP BusinessObjects Explorer — on SAP NetWeaver BW. In addition, he is responsible for the SAP NetWeaver BW Accelerator implementation as well as performance tuning. Kee is a regular presenter at TechEd, ASUG, and SAPPHIRE on SAP NetWeaver BW Accelerator and SAP BusinessObjects topics. He is currently acting as a program chair in data management SIG for ASUG.

See more by this author

Vasu Sattenapalli

Vasu Sattenapalli is a senior SAP BI solution architect with extensive knowledge and experience in implementation of business intelligence solutions for Fortune 100 companies with global and complex business process. He is currently working as a consultant architect at Newell Rubbermaid. He was also a BI specialist in the implementation of SAP BusinessObjects Explorer for Newell Rubbermaid.

See more by this author


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.