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.

About Instructor

KudVenkat

Software Architect, Trainer, Author and Speaker in Pragim Technologies.

Reviews

SAP BO

Average Rating

0

0 ratings

5 1

Details

5 Stars
0
4 Stars
0
3 Stars
0
2 Stars
0
1 Stars
0

ADD A REVIEW

Name
Email
Review Title
Rating
Review Content