DATA WAREHOUSING

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

DATABASE CONCEPTS

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

UNIVERSE DESIGN

• 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

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

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

DESKTOP INTELLIGENCE

• Introduction to desktop intelligence
• Scope of analysis
• Report creation
• saving the reports in the local repository
• publishing the report
• Report conversion (desktop) to (Webi)

WEBI-RICH CLIENT

• Installing Web Intelligence Rich Client
• Web Intelligence Rich Client working modes
• Launching Web Intelligence Rich Client
• To set user preferences in Web Intelligence Rich Client
• Working with documents
• Working with universes in Web Intelligence Rich Client
• Accessing Web Intelligence from Info View
• Working with queries in Web Intelligence Rich Client
• Working with reports

UNIVERSE BUILDER & QUERY BUILDER

• Universe Builder basics
• Building universes from XML metadata sources
• Updating XML metadata source universes
• Exporting a universe to an XML file format

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

IMPORT WIZARDPUBLISHING 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

OVERVIEW OF SAP BO 4.0

• Comparison of SAP BO 3.x & 4.x