- 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
- 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.
- Application Consultant
- Data Consultant / Manager
- Database Administrator
- Developer
- Developer Consultant
- System Administrator
- System Architect
- Technology Consultant
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
Price:
£3,680 GBP
Course Code:
BOID10
Duration:
4 days
Delivery Method:
Virtual, Classroom
