SAP Designer 3.1

Abstract:
This class is a combination of instructor-led lecture, discussions, and demonstrations with a heavy emphasis on hands-on workshops to teach BusinessObjects 3.0/3.1 basic Designer 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 BusinessObjects 3.0/3.1 semantic layer as an interface to the data in a data warehouse, data mart, or database.

Duration:
2 Days

Objectives:

  • 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

Topics:

  • Repository Architectures
  • Creating a Repository
  • Version Control Alternatives
  • Detecting and Resolving Traps
  • Building Intelligent Objects
  • Row Level Security
  • Object Security Access Level
  • Restricting Data
  • Schema Swapping
  • Business Objects – System Variables
  • Handling Null Values
  • Case Statements
  • Using Native Database SQL within Objects
  • Designing and Implementing an Object External Strategy
  • Using the Universe Parameter File
  • Using Contexts and Aliases
  • Implementing Aggregate Awareness
  • Creating Predefined Conditions
  • Setting Cardinality
  • Creating Joins
  • Detecting and Resolving Loops
  • @ Functions
  • Equi/Outer/Theta Joins
  • Dimensions/Details/Measures
  • Classes and Objects
  • Universe - Semantic Layer

Prerequisites:

  • BusinessObjects 3.0/3.1 Desktop Intelligence Basic Reporting
  • Business Objects XI R2 Webintelligence Basic Reporting
  • Advanced SQL Skills
  • Advanced Database Skills
  • Basic SQL Skills
  • Basic Database Skills
  • Basic Windows Operating System Skills