SAP BO ONLINE TRAINING COURSE

SAP BO – 4.0

Data warehousing/Dimensional modeling

• OLTP vs. OLAP

Database Concepts needed for Data warehousing

• Joins & Cardinality

BOXI 4.0 Architecture

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

Information Design Tool

• 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

Universe Designer

• 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
• Creation of Web intelligence report with auto scheduling
• Format a report
• Calculate data with formulas and variables
• Use multiple data sources
• Analyze data
• Manage and share Web Intelligence documents

Introduction to Crystal Reports

•          Allows you to produce the report you want from virtually any data source.

•          Designed to help analyze and interpret important information.

•          Used to produce simple, complex or specialized reports

Competency of Crystal Reports

•          Create any report you can imagine

•          Can be used for windows as well as web based applications

•          Runtime Customization (Reports generated dynamically based on parameters/formulas)

Benefits of Crystal Reports XI R2

•          Improved usability

•          Expanded Application Development Capabilities

•          Integration with Business Objects Enterprise XI R2