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

Subscribe Email Alerts

If you wish to receive email alerts when new articles, videos or interview questions are posted on PragimTech.com, you can subscribe by providing your valid email.