SAP Business Objects BI

Course Content

Unit 1:Data warehousing/Dimensional modeling/ SAP BW 7.3 Concepts

• OLTP vs. OLAP
• Types of OLAP
• Multi Dimensional Modeling Of SAP BW 7.3
• SAP BW 7.3 Cubes, DSO’s ,Multi Providers, Infosets
• Business Explorer (Bex) Queries in BW 7.3 system as Data sources
• Data Flow in BW 7.3 and Activating Business Content Cube

Unit 2: Database Concepts needed for Data warehousing

• Joins & Cardinality
• Views/Materialized Views
• Date/Time Functions

Unit 3: BOBI 4.2 Architecture

• Architectural overview
• Client tier components
• Application tier components
• Intelligence tier
• Processing tier
• Data tier
• Security management
• Information

Unit 4: 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

Unit 5: Universe Designer Tool(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
• Designing Universes on SAP HANA tables and views
• Designing Universes on SAP HANA for COPA scenario, Sales Scenario, Procurement Scenarios

Unit 6: 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
• Creation of Web intelligence report with auto scheduling
• Creation of Corporate dashboard for Supply chain mgmt/Banking Domain
• 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
• SUse “If” logic
• Work with additional reporting techniques
•  Create hyperlinks
• Designing Webi reports Based on BEX query as Source.
• Designing Webi Reports Based on SAP HANA UNX universes.

Unit 7: Crystal Reports 2011

• 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
• Depreciation Forecast.
• Designing Crystal reports i reports Based on BEX query as Source
• Designing Crystal reports Reports Based on SAP HANA UNX universes

Unit 8: Dashboard Design Tool

• Creating a Model
• Adding Interactivity to a Model
• Creating a Connected Model
• Connect to Crystal Reports data and create Dashboard
• Connect to Web intelligence report data
• Create Dashboard
• Connect to Business Objects Universes
• Using Query as a web service and create Dashboard
• Use Live Office data and create Dashboard
• Use other connectivity components and create Dashboard
• Designing Dashboard reports Based on BEX query as Source using QUERY BROWSER
• Designing Dashboard reports Based on SAP HANA UNX universes QUERY BROWSER

Unit 9: Query as Web service

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

Unit 10: BO Analysis 4.2

• Get Started with Business Objects Analysis BW 7.3, SAP HANA as Source.
• Creating Analysis Workspace using OLAP EDITION, BO analysis MS EXCEL,MS PPT.
• Using Charts to Visualize Data
• Selecting Members to Display in Crosstabs and Charts
• Sorting, Filtering, and Ranking Data
• Highlighting Exceptions

Unit 11: BO Explorer 4.2

• Creating Information Spaces based on SAP HANA Analytical view, Spread sheets, UNX Universes.
• Exploring the data Based on Information Spaces.

Unit 12: Widgets

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

Unit 13: Administration

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

Unit 14: Security Implementation

• Creating Secured users & group
• Creation secured connections
• Creation of Secured objects
• Creation of security at Table, Column & row level
• Creation of secured restriction set and mapping to users or groups

Unit 15: OLAP Universe

• Creation of OLAP Universe by connecting to an Info cube
• Updating the OLAP Universe (Cube)
• Creating the Custom Hierarchies in OLAP Universes.
• Accessing multiple info cubes to create an OLAP Universe

Unit 16: 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

Unit 17: BO-SAP Integration/Edge Series

• Understanding BO-SAP Integration kit
• Configuring single sign on authentication
• Creating SAP Authentication in BO
• Importing the roles of SAP into BO
• Entitlement settings of SAP & BO System

Unit 18: SAP Webi/Dashboard Reporting

• Creation of Web intelligence reports using Info cube & BW Query

Unit 19: Installation of BOXI 4.0 suite with System/Audit/Performance mgmt Polestar/Business Explorer

• Creating Polestar Reports
• Configuring Pole star with BO System

Unit 20: SAP Business Objects Certification Guidelines

• Sample questions on Business Objects Certified Professional – Business Objects Web Intelligence certification
• Sample questions on Business Objects Certified Professional – Business Objects Crystal Reports certification