Goals

  • Describe how security is implemented in SAP BW.
  • Implement and manage security in an SAP BW environment.

Audience

  • Application Consultant
  • System Administrator

Prerequisites

Essential

  • ADM940 or previous SAP security experience in SAP ERP.

Recommended

Course based on software release

  • SAP BW 7.4

Content

  • SAP Business Warehouse (BW)
    • Identifying SAP BW Architecture and Administration Tools
    • Creating and Modifying SAP Business Explorer (BEx) Queries
  • Security Components
    • Comparing Transactional and Analytical Security Needs
    • Differentiating Between Standard and Analysis Authorizations
    • Protecting Data with Analysis Authorizations
    • Identifying the Prerequisites for Analysis Authorizations
  • Standard Authorization Objects for Reporting Users
    • Creating Standard Authorizations for Reporting Users
  • Special Authorization Objects for Reporting Users
    • Creating Analysis Authorizations for InfoProvider Data
    • Enabling and Disabling the InfoArea Structure
    • Identifying the Differences Between the Handling of Workbooks and Queries in Roles
  • Analysis Authorizations
    • Creating Analysis Authorizations for Specific InfoProvider Data
    • Creating Analysis Authorizations for Specific Characteristic Values
    • Creating Analysis Authorizations for Aggregated Values
    • Creating Analysis Authorizations for “”Not Assigned”” Values
    • Creating Analysis Authorizations for Display and Navigational Attributes
    • Creating Key Figure Authorizations
    • Creating Hierarchy Authorizations
    • Adding Variables to Authorizations
  • Maintenance of Authorizations
    • Maintaining Authorizations
  • Data Access for Administrators and Users
    • Securing Data Access for Administrators
    • Assigning Role-Based Authorizations using Templates
    • Tracing Performance Issues
    • Setting Up System Communication Security
  • Migration of Reporting Authorizations to Analysis Authorizations
    • Migrating Reporting Authorizations to Analysis Authorizations
  • SAP NetWeaver Portal
    • Managing SAP NetWeaver Portal Access for SAP BW Users
    • Publishing SAP BW Content in the SAP NetWeaver Portal
  • SAP BusinessObjects Business Intelligence (BI) Platform + Integrating SAP BW Security into the SAP BusinessObjects BI Platform
    • Managing SAP BusinessObjects BI Platform Access for SAP BW Users
  • Additional Topics in SAP BW
    • Differentiating Between Planning Tools
    • Identifying the Interaction Between Planning and Other SAP BW Activities
    • Preventing and Troubleshooting Performance Issues
    • Generating Structural Authorizations from SAP ERP Human Capital Management (HCM)