SAP ERP

SAP BO COURSE OUTLINE

Data warehousing/Dimensional modeling Practical Concepts

  • OLTP vs. OLAP
  • Types of OLAP
  • Dimensional modeling
  • Data mart/Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

Database Concepts needed for Data warehousing

  • Joins & Cardinality
  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

Architectural overview

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management
  • Information flow

Administration

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

Universe Design (UDT)

  • Understanding Business Objects Universes
  • Creating the Course Universe
  • Building the Universe Structure
  • Creating Dimension Objects
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Using Hierarchies
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Implementing Universe Life Cycle Mgmt
  • Maintaining & Optimizing Universes
  • Creating Universe from Other Data sources

Information Design Tool (IDT)

  • Understanding Business Objects Universes
  • Creating the Course Universe
  • Building the Universe Structure
  • Creating Dimension Objects
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Using Hierarchies
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Implementing Universe Life Cycle Mgmt
  • Maintaining & Optimizing Universes
  • Creating Universe from Other Data sources
  • Designing Universes on SAP HANA tables and views
  • Designing Universes on SAP HANA for COPA scenario, Sales Scenario, Procurement Scenarios

Web intelligence

  • Understand concepts of Web intelligence
  • Create Web Intelligence documents with Queries
  • Restrict data returned by a query
  • Design a report
  • Enhance the presentation of data in reports
  • Format a report
  • Calculate data with formulas and variables
  • Use multiple data sources
  • Analyze data
  • Manage and share Web Intelligence documents
  • Work with Advanced Query techniques
  • Work with calculation contexts
  • Create formulas with character & date string functions
  • Use "If" logic
  • Work with additional reporting techniques
  • Create hyperlinks

Crystal Reports

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

Dashboard Builder

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation
  • Connectivity with SAP Net weaver BI
  • Query as a Web Service

Widgets

  • Installing BI Widgets
  • Using BI Widgets to Access BI Content
  • working with widgets
  • BI Widgets Content Authoring Guidelines
  • Auto refresh of Widgets

Query as Web service

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

Import Wizard\Publishing Wizard

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

Live Office Reporting

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository