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
- 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
Course based on software release:
SAP BusinessObjects BI Platform version 4.3
Course notes and announcements:
In this course you explore the fundamental principles and common advanced options of SAP BusinessObjects universe design by creating relational universes. NOTE: This course is applicable for customers on the SAP BusinessObjects BI Platform version 4.2 or higher.
This is a SAP CERTIFIED Course. Your course will include Full Class Delivery of the comprehensive standard SAP curriculum agendas, SAP Certified Instructor, Demonstration and Presentation, Student Hands on exercises, Access to SAP Hosted servers/training environment, and SAP Certified participant guides.
With virtual live classroom training you get comprehensive training from SAP experts using seamless over-the Web connectivity. The same content delivered in SAP's traditional "brick and mortar" classrooms is presented during virtual live classroom deliveries. As in SAP's traditional classrooms, SAP virtual live classroom stresses hands-on learning providing each registered student with exclusive access to live SAP systems throughout each course. Each Virtual Live class is taught by a SAP Certified Instructor and will include an e-book student guide for you to download and keep. CPE Credits are currently available only for publicly scheduled courses delivered live at SAP locations and our Authorized Education Partner locations. CPE Credits are not available for virtual live classroom sessions.
Not finding any suitable dates? Contact us for additional available dates: training@dunnsolutions.com
