Introduction

BOXI training makes you an expert in Database Concepts Needed For Data Warehousing, Building Parameterized Reports, How Business Objects Enterprise XI 3.0, Compares with versions 5.x and 6.x, Migration concepts,….etc

Course Content

1.Data Warehousing Concepts 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

2.Database Concepts Needed For Data Warehousing

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

3.BOXIR3 Architecture

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

4.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 Value
• 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

5.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

6.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

7.Dashboard Builder

• Understanding Dashboard Manager
• Setting Up Dashboard Manager, Creating Metrics
• Automating Dashboards with Rules
• Creating Analytics
• Creating Personal Dashboards
• Creating Corporate Dashboards
• Building Dashboard Navigation

8.Xcelsius-Scorecard Builder

• 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 Universe
• Using Query as a web service and create Dashboard
• Use Live Office data and create Dashboard
• Use other connectivity components and create Dashboard

9.Migration From BO5.X To BOXIR3

• Migration fundamentals
• How Business Objects Enterprise XI 3.0, Compares with versions 5.x and 6.x, Migration concepts
• Import Wizard Concepts
• Understanding object migration
• Understanding user and group migration
• Migration planning and assessment
• After migration with the Import Wizard

10.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

12.Webi-Rich Client

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

13.Universe Builder & Query Builder

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

14.Query As Web Service

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

15.Voyager

• Getting Started with Business Objects Voyager
• Using Queries to Analyze Cube Data
• Using Charts to Visualize Data
• Selecting Members to Display in Crosstabs and Charts
• Sorting
• Filtering and Ranking Data
• Highlighting Exceptions in Data
• Saving and Sharing Voyager Workspaces

16.Security Implementation

• Creating Secured users & groupCreation 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