Abstract:
This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach Business Objects XI Universe Design concepts. Topics to be covered include universe creation, creating database connections, joins, classes and objects, hierarchies, loop resolution, contexts, table aliases, aggregate awareness, viewing table keys, creating predefined conditions, restrictions, universe maintenance, and universe distribution/documentation.

Audience:
This class is designed for technical analysts who are required to create the Business Objects XI semantic layer as an interface to the data in a data warehouse, data mart, or database.

Duration:
2 Days

• Create and Maintain Universes
• Detect Join Cardinality and Connect Database Tables
• Create Classes and Objects within Hierarchies
• Define Dimensions, Details, and Measures
• Resolve Loops and Traps Using Contexts and Aliases
• Create Predefined Conditions
• Use Business Objects Reporting Tool to Test Universes and SQL Creation

• Resolving Fan and Chasm Traps
• Restricting Data
• Using Contexts and Aliases
• Implementing Aggregate Awareness
• Creating Predefined Conditions
• Setting Cardinality
• Creating Joins
• Detecting and Resolving Loops
• @ Functions
• Equi/Outer/Theta Joins
• Lists of Values
• Dimensions/Details/Measures
• Classes and Objects
• Universe - Semantic Layer

• Business Objects 5x Foundations
• Basic SQL Skills
• Basic Database Skills
• Basic Windows Operating System Skills