Business Objects

Prerequisites

Course duration:

4 days

Course outline:

Introduction

Introduction to Data Warehousing
Principles of Dimensional Modelling
The Time Dimension and implementing Date Requirements
Fact Table properties and implementing Measures
Implementing Aggregate Tables
Implementing Multiple Fact Tables
Implementing solutions to Tracking History requirements
Implementing Recursive Relationships
Advanced Designer surgery to answer delegate questions about their own environments; Approach to Data Warehousing projects; Data Quality and Data Loading issues
End of Course Challenge to recap the key points of data mart design and implementation using

Fundamentals and Overview

Activate Business Objects to log, find, open, view, and refresh reports.
How to build and run simple queries to retrieve data through a universe, and how to use the drag- and-drop report manager to interactively create new reports.
Set up query conditions to limit the data returned from the underlying database.
Build a single document that includes blocks of data from different data sources and different universes.
How to create the different block formats to view reports in ways that are most appropriate to your data.
Use the "slice and dice" feature, set variables, and set alerts and group values in a report.
Use the drill function to analyze your data.
Formatting for printing, add breaks to financial reports and tables, apply view/hide conditions,
Use the report map, and apply advanced printing controls.

Architecture and Deployment

Business Objects product line architecture and how the products are related.
How to allocate a Business Objects repository or multiple repositories while building a Business Objects solution.
Understanding the client/server and distributed environments.
Deployment scoping and hardware sizing to address sizing, scaleability, configuration,
Access and security administrative tools for a safer system.
A standard step-by-step guide deployment procedure to ensure a successful deployment

Designer

Introduction to Designer and the key concepts underlying Business Objects and the universe- development process.
Create a file in which to build, name, and set a connection between the universe and it's underlying database.
Adding tables to the structure and ways to customize working with tables.
How to add joins between tables, and the different types of join commands available.
Creating and testing classes and objects to organize the universe.
How to create measure objects and verify correct results in querries.
How to identify loops in the structure of a universe and the tools used in resolution.
Methods used to limit the scope or extent of queries for end users.
How to use @ function.
The purpose of hierarchies for data analysis in the user module, and how to provide the hierarchies that end users need.
The ways to modify the universe with pre-calculated aggregates from summary tables.
The purpose behind including contexts in a universe, and how to use contexts and other techniques to resolve chasm traps and fan traps.

Supervisor

Introduction to the concept of the repository and its structure, the different types of users, and various ways of issuing commands.
How to create a repository for a Business Objects deployment, and the different domains that make up a repository.
Setting up groups and users for a Business Objects deployment, organizing and changing user properties.
How to define the access users have to the commands in the user, Designer, and Supervisor modules of Business Objects.
How to create a distributed repository with more than one universe or document domain, and when more than one repository is useful.
Allocating universe and document domains to groups of users and designers, as well as, how to export a universe from the Designer module.
How to allocate universes to groups and configure the universes on a group-by-group basis with the different configuration changes you can make.

REPORTING

INTRODUCTION TO WEB INTELLIGENCE