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

• Work with Advanced Query techniques
• Create formulas with character & date string functions
• Use “If” logic
• Work with additional reporting techniques
• Create ranking
• Create alerter
• Create breaks reports
• Create sections reports
• Create section wise graphs
• Create drill reports
• Create data syncronisation reports
• Create reports with subqueries
• Create report combined operators

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

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
• Creating subreports
• Createing group reports
• Creating group reports with options
• Publishing reports

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 and
• 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
• Creating_a_chart_from_ranges
• Creating_a_chart_from_series
• Creating_a_chart_in_anticipation_of_future_data
• Creating_a_what_if_visualization
• Using_maps_as_selectors

SAP Webi/Dashboard Reporting

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