Prerequisites:
Essential
- * Prerequisite Education
- BusinessObjects XI R2: Universe Design, and/or BusinessObjects XI
- 3.0/3.1: Universe Design
- BusinessObjects™ Web Intelligence XI R2: Report Design, and/or
- BusinessObjects™ Web Intelligence XI 3.0/3.1: Report Design
- * Prerequisite Knowledge/Experience (To be successful, you must be
- familiar with:)
- The metadata and logical structure of the databases in your
- organization
- BusinessObjects Web Intelligence report building
- Using BusinessObjects Universe Designer
- Using and working with SQL and relational database management
- systems concepts and structures
- The BusinessObjects Central Management Console
Recommended
- None
Audience:
- The target audience for this course is anyone responsible for creating and designing universes using Universe Designer, using BusinessObjects XI 3.0/3.1.
- The learners who attend the course will be most successful if they have experience in working with Business Objects Universe Designer.
- New features covered in the XI 3.0/3.1 course that are not applicable to BusinessObjects XI R1/R2 learners include:
- Creating universes from stored procedures and JavaBeans
- Creating, modifying, and updating universes from OLAP data sources using the enhanced OLAP functionality in Universe Designer
Goals:
- This two-day instructor-led advanced course is designed to give you the comprehensive skills and in-depth knowledge needed to design universes in BusinessObjects™ Universe Designer.
- The business benefit of this course is that you will learn best- practice methodology for creating universes that respond to your reporting requirements.
- Through well-designed universes, report designers and business users will be able to create reports without having to know anything about the underlying data source or structure.
Content:
- Reviewing Universe Design Concepts
- Use your universe design and BusinessObjects Universe Designer knowledge to solve business problems
- Describe the course universe, database data, and structure
- Working with Aggregate Awareness
- Define aggregate awareness
- Apply aggregate awareness to objects
- Designing Advanced Objects
- Combine database functions in objects
- Construct relative date-time objects
- Creating Complex Predefined Conditions, LOVs, and Joins
- Create complex predefined conditions
- Work with advanced LOVs
- Work with advanced join syntaxes
- Securing Universes
- Define connection and user credential parameters
- Work with Central Management Server (CMS) universe security
- Work with table mapping
- Implementing Universe Life Cycle Management
- Move content from development to production
- Maintaining and Optimizing Universes
- Optimize universes
- Apply foreign key index awareness
- Apply best practices for universe design
- Creating Universes from Other Data Sources
- Create a universe from an XML metadata file
- Create stored procedure and JavaBeans universes
- Work with OLAP universes
Notes:
- Additional Education
- Not applicable for this offering.
- Applicable Certification
- This course is not applicable to any Business Objects Certified Professional programs.
- Additional Information
- Contact your SAP Education Representative.
