Further Details
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 & Maintaining Universes
Lesson #17 Creating Universes From Metadata
• Creating A Universe From An Xml Metadata File
Guide price
£450+VATpp |