|
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
6. Using Lists of Values
Working with LOVs in Universe Designer
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. Aggregate Awareness
Aggregate Awareness and universes
Applying aggregate awareness to objects
13. Derived Tables
Using derived tables
14. Linking Universes
Understanding linked universes
Creating links between universes
15. Universe Security
Setting access restrictions on a universe
16. Universe Management
Documenting, deploying and maintaining universes
|
