• SAP BI – Introduction to SAP Netweaver 2004s ( 7.0 BI) system

1. Overview
2. BI System upgrade and migration of dataflow from BW 3.x to BI 7.0
3. Transformation & UoM conversions
4. Write routines in transformations and debugging routines
5. DTP & DTP Error handling
6. Concepts – Bi Integrated planning, BI Accelerator and Analysis Process Designer ( APD )

• SAP BI – Data Warehousing ( DW )

1. Overview, Positioning & Fundamentals of Data Warehousing
2. Objects in the BI DW layer
3. Data Acquisition & Transformation from SAP Source Systems
4. Data Acquisition from other systems
5. Business Content
6. Other Info Providers
7. Administration of Data Targets
8. Introduction to Query Performance Optimization

• SAP BI – Reporting & Analysis

1. Introduction to BI Enterprise Reporting
2. Get to know BEx Query Designer
3. Key Figures, Characteristics, Variables, Exceptions and Conditions
4. BEx Analyzer
5. Enterprise Portal Integration and Document integration
6. Report-Report-Interface
7. Managing Query Objects
8. Business Content
9. Further SAP BI Reporting Tools
10. Information Broadcasting

1. Overview of Data Staging in SAP BI-BW Content - Content installation
2. LO Extraction
3. CO-PA extraction
4. Generic Extraction
5. Delta Mechanism & Management
6. Transferring / loading data from flat files
7. Data Mart Interface

1. InfoProvider modeling and administration for performance
2. Optimize and monitor query performance and data acquisition performance
3. Aggregates and roll up
4. Transport Management for BI Objects
5. Process chains – Development & monitoring

1. Authorizations – Setting up for reporting, standard roles and templates
2. Securing data access for administrative tasks in BI, connected source systems
3. Security requirements in SAP BI

Ref: SDN Wiki
Author: Sudhakar Mohan

How to create Info Object level( Characteristic Value ) Authorization for a Reporting User in BI 7.0

Scenario: There are 5 sales organizations and we are going to restrict a reporting user ( TEST ) to access only 2 sales organization data out of the 5. In this eg.1000 and 2000 are the sales organizations of the user TEST for which we are going to give access.So whenever the user TEST executes thereport,he will only be able to see the Sales organisations 1000 and 2000 in the report.

Step - 1: Mark the InfoObject Authorization Relevant & Activate it.

Step - 2: Go to Tcode - RSECADMIN
Under Maintenance - Enter the name of the Authorization Object and click Create Authorization.
Insert Sales Organization Info object as shown below. Also included the other SAP recommended objects 1.0TCAACTVT, 2.0TCAIPROV and 3.0TCAVALID.

Maintain the Values for these Objects. Select 0Salesorg and click Details.
Eg: Values 1000 and 2000 are maintained for Sales Organisation

Note : Also include all Authorisation Relevant Objects which are used in that infoprovider in addition to the above additional 3 objects otherwise you may get "No Authorisation" error when you execute the query.

Step - 3 : Tcode - RSU01 Assign User to Authorisation Object
Enter the name of the user to be assigned with the authorization object and click the change button.
The select the relevant authorization object and save.

Note : 0BI_ALL is the authorization object to access all the info objects which are authorization relevant.

Step - 4: Create Authorisation Variable in Query Designer
Create an Authorization Variable - Variable with Processing by Authorisation in Query Designer as Below for Sales Organisation.
Restrict the Sales Organisation with the Authorisation Variable and execute the query.