BOID10 - SAP BusinessObjects Information Design Tool Training

• SBOP BI Platform 4.3

Essential

• Working knowledge of SQL and relational database management systems, concepts, and structures

Recommended

• Basic knowledge of reporting with SAP BusinessObjects Web Intelligence or equivalent knowledge of how universes are used by the various SAP BusinessObjects analytics tools

• Application Consultant
• Data Consultant / Manager
• Database Administrator
• Developer
• Developer Consultant
• System Administrator
• System Architect
• Technology Consultant

• This course will prepare you to:
• This course is designed to give you the necessary skills needed to work with the Information Design Tool.
• The Information Design Tool enables designers to define and manipulate metadata from relational sources to create and deploy SAP BusinessObjects universes.
• In this course you learn how to use data from a relational database system to design universes to be used with the SAP BusinessObjects BI client tools.

• Basic SAP BusinessObjects Universe Design
• Describing Universes
• Working with Local Projects
• Data Connections
• Data Foundations
• Creating Data Foundations
• Using Joins
• Creating and Using Derived Tables
• Business Layers
• Accessing Data through the Business Layer
• Integrating the Business Layer Components
• Creating Measure Objects
• Testing Objects
• Universe Deployment
• Loops in a Data Foundation
• Creating Loops on the Data Foundation
• Resolving Loops Using Aliases
• Resolving Recursive Loops
• Resolving Loops Using Contexts
• Data Restrictions
• Defining Data Restrictions
• Applying Mandatory Data Restrictions
• Applying Optional Data Restrictions
• Lists of Values
• Defining a List of Values
• Associating a List of Values to a Business Layer Object
• Parameters
• Navigation Paths
• SQL Traps
• Defining SQL Traps
• Identifying a Chasm Trap
• Resolving a Chasm Trap
• Identifying a Fan Trap
• Resolving a Fan Trap
• Object @ Functions
• Using @ Functions in SQL
• Using the @Aggregate_Aware Function
• Using the @Select Function
• Using the @Where Function
• Using the @Execute Function
• Using the @Variable Function
• Universe Management with Data Foundation and Business Layer Views
• Managing the Data Foundation Using Views
• Managing the Business Layer Using Views
• Universe Security
• Securing a Deployed Universe with Security Profiles
• Creating and Assigning Universe Security Profiles
• Identifying the Priority of Security Settings
• Updating a Deployed Universe
• Linked Universes
• Defining and Creating a Linked Universe
• Managing Core Universes
• Including a Core Universe