Business Objects - Universe Designer

Enquire About This Course

This 2 day course will provide you with all the skills needed to efficiently create and maintain Universes for Business Objects, allowing you to easily access and run reports.

This course is for individuals who need to design, build, document, maintain and distribute Business Objects Universes.

Course Content:

Lesson #1 Understanding Business Objects Universes

• Understanding How Universes Allow Users To Query Databases Using Their Everyday Business Terms

Lesson #2 Creating The Course Universe

• The Course Database And Universe
• Creating A Universe

Lesson #3 Building The Universe Structure

• Populating The Universe Structure
• Defining Joins In A Universe

Lesson #4 Creating Dimension Objects

• Understanding Classes And Objects
• Creating Classes And Objects

Lesson #5 Creating Measure Objects

• Understanding Measure Objects
• Creating Measure Objects

Lesson #6 Using Lists Of Values

• Working With Lovs In Designer
• Creating A Cascading Lov

Lesson #7 Resolving Loops In A Universe

• Resolving Loops Using Aliases
• Resolving Loops Using Shortcut Joins
• Resolving Loops Using Contexts

Lesson #8 Resolving SQL Traps

• Resolving Chasm Traps
• Resolving Fan Traps

Lesson #9 Applying Restrictions On Objects

• Restricting The Data Returned By Objects

Lesson #10 Using Functions With Objects

• Using @ Functions

Lesson #11 Using Hierarchies

• Working With Hierarchies

Lesson #12 Aggregate Awareness

• Applying Aggregate Awareness To Objects

Lesson #13 Derived Tables And Indexes

• Using Derived Tables
• Applying Index Awareness

Lesson #14 Linking Universes

• Creating Links Between Universes

Lesson #15 Securing Universes

• Setting Access Restrictions On A Universe

Lesson #16 Managing Universes

• Documenting Universes
• Deploying and Maintaining Universes

Lesson #17 Creating Universes From Metadata

• Creating A Universe From An Xml Metadata File

Click here to download:

Business Objects - Universe Designer

Enquire About This Course