SAP BO

SAP BO Course Content

Main Areas in the Syllabus:

• 1. Introduction to SAP and SAP Business Objects.
• 2. SAP HANA introduction.
• 3. Universe designing by using Information Design Tool.
• 4. Detail Reporting by using Web Intelligence Rich Client.
• 5. Chart & Dashboards creation by using Design Studio.
• 6. Database – SQL as complimentary.
• 7. Testing and Performance Tuning techniques with real time examples.
• 8. Resume Preparation.
• 9. Project Explanation.
• 10. Walk through on Real Time scenarios.
• 11. Report Assignments.

Database:

• 1. Introduction to SAP HANA.
• 2. In-memory Database.
• 3. Column Store and Row Store Tables.
• 4. Data Types.
• 5. SQL Statements .
  • a. DDL – Data Definition Language .
  • b. DML – Data Manu placation Language .
  • c. DQL – Data Query Language.
  • d. DCL – Data Control Language.
  • e. TCL – Transaction Control Language.
• 6. Joins
• 7. Constraints.
• 8. Functions
• 9. Views
• 10. Materialized Views.
• 11. Sub Queries .
• 12. Set Operators.

Data Warehousing and Data Modeling:

• 1. Data Warehousing Architecture.
• 2. Data Marts.
• 3. Granularity
• 4. OLAP and OLAP.
• 5. Multi Dimension Modeling.
• 6. Dimension Tables .
• 7. Fact Tables.
• 8. Types of Dimension Tables.
• 9. Slowly Changing Dimension Tables.
• 10. Schemas
  • a. Star Schema.
  • b. Snow Flake Schema
  • c. Galaxy Schema.
• 11. Types of Measures.

Universe Designing ( Information Design Tool ).

• 1. What is Universe .
• 2. Creating Local Project.
• 3. Connection
  • a. Creating Local Connection.
  • b. Connection to SAP HANA
  • c. Connecting to SAP Bex and Info Provider.
  • d. Publishing Local connection.
  • e. Creating Shortcut Connection .
• 4. Data Foundation.
  • a. Creating Data Foundation.
  • b. Designing Data Model .
  • c. Defining Joins .
  • d. Handling Loops by using Alias and Context.
  • e. Derived Tables.
  • f. Calculated Columns.
  • g. Families , Views , Refresh Structure
• 5. Business Layer.
  • a. Creating Data Foundation
  • b. Folder & Sub Folders
  • c. Objects (Dimension , Attributes & Measures )
  • d. Filters ( Native and Business )
  • e. Index Awareness
  • f. Aggregate Awareness.
  • g. Aggregate Navigation.
  • h. @Prompts
  • i. Parameters
  • j. Lovs ( Static , Custom SQL & Business Layer )
  • k. Queries.
  • l. Navigation Paths .
• 6. Other Options.
  • a. Converting .UNV to .UNX
  • b. Securities ( Data Profile and Business Profile)
  • c. Check Integrity.
  • d. Testing Universe.
  • e. Performance Tuning .
  • f. Project Sharing and Synchronization.

Web Intelligence Rich Client:

• 1. Creating reports on SAP HANA
• 2. Creating reports on SAP Bex Reports.
• 3. Report Filters ( Filters , Ranking , Input Control & Filter Bar)
• 4. Drill Reports & Scope of Analysis.
• 5. Hyperlink Reports.
• 6. Breaks , Sections & Aggregate Functions.
• 7. Sort .
• 8. Conditionals .
• 9. Merge Dimensions.
• 10. Context operators ( ForALL , ForEach and In )
• 11. Complex Formulas writing.
• 12. Query Filters , Sub Queries , Custom SQL.
• 13. Report level prompts .
• 14. Edit Query , Refresh Report & Purge Data.
• 15. Document, Report , Block & Charts.
• 16. Tables ( Vertical , Horizontal , Cross Tab and Forms )
• 17. Cells ( Blank & Predefined)
• 18. Charts ( Column , Bar , Line , Pie & Other Charts ).
• 19. Publishing the report .
• 20. Download and taking report backup.
• 21. Testing and Tuning the repots.
• 22. Walkthrough on Real Time reports.
• 23. Report Assignment.

SAP BO Design Studio :

• 1. Create an application
• 2. Add a Data Source to an Application
• 3. Add an Analytic Component to an application.
• 4. Set up Component as a Filter
• 5. Display Static and Dynamic text in an Application.
• 6. Add an image to an Application.
• 7. If / Then / Else statement
• 8. Add a Dimension Filter to an Application.
• 9. Add a Filter Panel to an Application.
• 10. Add a Hyperlink to an Application.
• 11. Connect to Universe Data sources.
• 12. Define the properties for a chart in an Application.
• 13. Select multiple components in design mode.
• 14. Bookmark an Analysis application.
• 15. Activate a Hierarchy for a data source.
• 16. Apply a member filter to a data source.
• 17. Apply a background filter to a Data Source.
• 18. Copy a data source in an Application.
• 19. Export data from cross tab to Excel.
• 20. start in SAP HANA mode.
• 21. Apply a grid layout in an application.
• 22. Add a Pop-up window to a Application.
• 23. Align and hide components in an Application.
• 24. Set up Display properties to a Cross tab.
• 25. Apply Conditional Formatting on charts.
• 26. Modify Chart Properties with scripting.
• 27. Upload a local Application to the BI Platform.
• 28. Performance tips
• 29. Best Practices.
• 30. Responsive Design.