|
1. Introduction to Universe Design
Understanding how universes allow users to query databases using their everyday business terms
2. Creating the Course Universe
The course database and universe
Creating the universe
3. Building the Universe Structure
Populating the universe structure
Defining joins in a universe
4. Dimension Objects
Understanding classes and objects
Creating classes and dimension objects
5. Measure Objects
Understanding measure objects
Creating measure objects
Delegated Measures
6. Using Lists of Values
Working with LOVs in Universe Designer
Creating a cascading LOV
Creating a List of Values
|
7. Understanding and Resolving Loops
Understanding loops
Resolving loops using aliases, shortcut joins and contexts
8. SQL Traps
Understanding SQL traps and universes
Detecting and resolving chasm traps
Detecting and resolving fan traps
9. Restrictions and Condition Objects
Restricting the data returned byobjects
10. Using Functions
Using @ Functions
11. Using Hierarchies
Understanding hierarchies and universes
Working with hierarchies
12. Derived Tables
Using derived tables
13. End-of-Course Challenge
End-of-course challenge exercise
|
