Email Us   Phone : 503-259-0312   
  Home    |    Instructor-led Training    |    Online Training     


Contact Us   -   Why Choose Wintrac   -   Clients    

Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Microsoft technologies
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Introduction to Business Objects XI Designer
Overview:

This course utilizes an instructor-led lectures and discussion format coupled with progressive hands-on exercises designed to illustrate the following topics in BusinessObjects XI environment; role of Universes, universe design principles methodology, locating required tables, using Joins, depict usage of classes and objects, understand List of Values concept, creating advanced objects like conditional and interactive objects, defining Universe hierarchy via classes and objects and Universe distribution and incorporating Supervisor settings in our design

Audience:

IT professionals that will be designing, creating, documenting, maintaining and deploying BusinessObjects XI Universes for their clients.

Prerequisites:

Student should be familiar with basic Windows concepts and be able to function efficiently in Windows 2000/XP environment. Each student should have completed Introduction to Data Warehousing or understand the basic role of a Data Warehouse structures.


Objectives

  • Understand the role of BusinessObjects Universes.
  • Illustrate the critical path for designing and developing BusinessObject Universes.
  • Define the capabilities of Universe parameters.
  • Incorporating the usage of table Joins.
  • Understand the role of Classes and Objects.
  • Illustrate the use of @ functions in Universe creation.
  • Use of the List of Values to increase product usability.
  • Define the role of hierarchies in Universe creation.
  • Illustrate techniques for query optimization within Universe design.
  • Understand the process of Universe deployment.
  • Utilize Supervisor to define groups and users
  • Defining and controlling Universe parameters: SQL, data and row restrictions, table mappings and command restrictions
Class Format

Lecture and Lab

Course duration:

3 days

Course outline:

BusinessObjects Designer
  • Client role
  • Data Warehouse
  • Data utilization by users
  • Warehouse data: real-time, reconciled, derived, changed and metadata
  • Using a data warehouse
  • BusinessObjects environment
  • Role of the BusinessObject universe
  • Integrating data warehouse to BusinessObject universe
  • Universe design principles
  • Defining metadata layer
  • Universe components
  • Schema support
  • User/Client segmentation
  • BI stakeholders
Alias & Contexts
  • Fact vs Lookup tables
  • Loops
  • Loop detection
  • Cardinality detection
  • Defining Alias
  • Using alias with SQL
  • Resolving loops with an alias
  • Create Alias with Designer
  • Alias detection
  • Defining Contexts
  • Context impact on SQL
  • Ambiguous Queries
  • Inferred Queries
  • Create Contexts in Designer
  • Context vs Alias
Tables and Columns
  • Initiating Designer
  • Online vs Offline mode
  • Designer interface panel
  • Classes, Objects & Filters
  • Designer toolbar
  • Universe creation process
  • Database connections
  • Built-in strategies
  • SQL query options
  • Table browser
  • Manipulate Table entries
  • Join properties and options
Classes & Objects
  • Defining Class, Object and Condition operations
  • Create new Class
  • Class properties
  • Subclasses
  • Object creation
  • Object properties
  • Use of WHERE clause
  • @Prompt
  • @Script
  • @Select
  • @Variable
  • @Where
  • Measures
  • List of Values
  • Condition creation
External Strategies
  • Defining Strategies
  • Built-in and External strategies
  • Building SQL strategy files
  • Flat file strategy file
  • Stategy output formats
  • Join strategies
  • Applying external strategies
Aggregrate Awareness
  • Definition
  • Methodology
  • Aggregrate aware objects
  • @Aggregrate_Aware
  • Object analysis
  • Compatible objects
Table Joins
  • Defining Joins
  • Supported Join types
  • Cardinality
  • Building Joins w/ Designer
  • Using Detect
  • Candidate joins
  • Manual join operations
  • Editing joins
  • Formula bar
  • Equi-join creation
  • Theta join
  • Outer join
  • Detect join cardinalities
  • Integrity checks
Multidimensional Analysis
  • Definition
  • Time hierarchy
  • Time limitations
  • Drill-through components
  • DTS Manager
  • Universe Drill-through service (UDS)
  • UDS Maps
  • Candidate joins
  • Manual join operations
Supervisor operations
  • Security
  • User Types and Profiles
  • Adding users
  • User properties
  • Adding groups
  • Universe properties
  • Table mappings
Universe Maintenance
  • Saving updates
  • Enterprise vs workgroup
  • Print options
  • Repository distribution
  • File distribution
  • Exporting
  • Importing

 
About us
Contact us
Careers at Wintrac
Our Clients
Why Wintrac


Register for a free training CD-ROM drawing
Refer a client or instructor and earn $$$


Wintrac Inc.
16523 SW McGwire Ct.
Beaverton OR 97007
 
Wintrac, Inc. All rights reserved.                                                                               Site Map   |   Terms of Use   |   Privacy Policy