SAP BusinessObjects: Advanced Universe Design

Product type

SAP BusinessObjects: Advanced Universe Design

SAP Training
Logo SAP Training
Provider rating: starstarstarstar_halfstar_border 6.5 SAP Training has an average rating of 6.5 (out of 2 reviews)

Need more information? Get more details on the site of the provider.

Description

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 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.

Audience

  • The target audience for this course is anyone responsible for creating and designing universes using a BusinessObjects Enterprise XI R2 SP2 environment.
  • You will be most success…

Read the complete description

Frequently asked questions

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.

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 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.

Audience

  • The target audience for this course is anyone responsible for creating and designing universes using a BusinessObjects Enterprise XI R2 SP2 environment.
  • You will be most successful if you have experience working with BusinessObjects Designer.

Prerequisites

Essential
  • * Prerequisite Education:
  • To be successful in this advanced course, you must have working knowledge of:
  • SQL and relational database management systems concepts and structures
  • Familiarity with the metadata and logical structure of the databases in their organization
  • BusinessObjects Universe Designer
  • BusinessObjects Web Intelligence™ * Prerequisite Knowledge/Experience:
  • To satisfy the above prerequisites we recommend these courses available through Passport:
  • BusinessObjects XI R1/R2: Universe Design
  • BusinessObjects Web Intelligence XI R2: Report Design

Content

  • Lesson #1 - Universe Development Process
    • Understanding the metadata
    • Universe Development Cycle
    • Best practices for universe design
  • Lesson #2 - Universe Parameters
    • Data access files and connection parameters
    • BusinessObjects dynamic SQL parameters
    • Connection and user credential parameters
  • Lesson #3 - Advanced Objects Scenarios
    • Combining database functions in objects
    • Constructing relative date-time objects
    • Working with Transact_SQL functions
  • Lesson #4 - Complex Predefined Conditions, LOVs and Joins
    • Complex predefined conditions
    • Advanced LOVs
    • Advanced Join syntaxes
  • Lesson #5 - SQL Traps Revisited
    • Chasm Traps
    • Fan Traps
  • Lesson #6 – Extended Index Awareness and Derived Tables
    • Applying Index Awareness
    • Derived Tables

Notes

  • This training offering is based on BusinessObjects XI R2 Service Pack 2 (SP2).
  • Additional Education
    • Not applicable for this offering.
  • Applicable Certification
    • This course is not applicable to any Business Objects Certified Professional programs.

Popular tags

No tags submitted for this course yet

There are no reviews yet.

Share your review

Do you have experience with this course? Submit your review and help other people make the right choice. As a thank you for your effort we will donate $1.- to Stichting Edukans.

There are no frequently asked questions yet. If you have any more questions or need help, contact our customer service.