We provide online course about BOID10 Information design Tool. This 5 day instructor-led course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Design Tool.
This course will prepare you to:
• This course is designed to give you the comprehensive skills needed to work with the Information Design Tool. The Information Design Tool enables designers to extract, define, and manipulate metadata from relational and OLAP sources, to create and delpoy SAP BusinessObjects universes. In this course you will create a relational universe based on a standard relational database.
Course based on software release:
• SBOP BI Platform 4.3
Course version: 018
Course outline:
Module 1 - Basic SAP BusinessObjects Universe Design:
• Describing Universes
• Defining the Components of a Universe
Module 2 - Data Connections:
• Defining Connections
Module 3 - Data Foundations:
• Creating Data Foundations
• Using Joins
Module 4 - Business Layers:
• Accessing Data through the Business Layer
• Integrating the Business Layer Components
• Validating Objects
• Creating Measure Objects
• Creating Shortcut Joins
Module 5 - Loops in a Data Foundation:
• Resolving Loops with Joined Tables
• Resolving Loops Using Aliases
• Resolving Loops Using Contexts
• Detecting Contexts
• Editing Contexts
• Testing Contexts
• Resolving Recursive Loops
Module 6 - Data Restrictions:
• Defining Data Restrictions
• Applying Mandatory Data Restrictions
• Applying Optional Data Restrictions
Module 7 - Lists of Values (LOV):
• Providing a List of Values
Module 8 - Parameters:
• Illustrating Runtime Parameters
Module 9 - Object functions:
• Using Object functions in Queries
• Applying the Aggregate Awareness Optimization Method
• Using Other Functions
Module 10 - Relative-Time Objects:
• Creating Relative-Time Objects
Module 11 - Navigation Paths:
• Defining Drill Down Navigation Paths
Module 12 - Derived Tables:
• Creating Derived Tables
Module 13 - Key Awareness:
• Defining Numeric Keys
Module 14 - Universe Management with Data Foundation and Business Layer Views:
• Managing a Universe using the Data Foundation View
• Managing a Universe using the Business Layer View
Module 15 - Universe Optimization:
• Optimizing Universes Using Parameters
Module 16 - Universe Deployment and Security:
• Deploying a Universe
• Securing a Published Universe
• Creating Data Security Profiles
• Creating Business Security Profiles
• Assigning Security Profiles to Users
• Identifying the Priority of Security Settings
• Updating a Published Universe
Module 17 - SQL Clause Processing Problems:
• Determining How the Order of SQL Clauses Affects Data Returned
• Detecting Chasm Traps
• Resolving Chasm Traps
• Identifying Fan Traps
• Resolving Fan Traps
Module 18 - Outer Join Problem Resolution:
• Resolving an Ambiguous Outer Join Using AggregateAware
Module 19 - Universe Creation from Different Data Sources:
• Identifying the Different Data Sources
• Creating an OLAP Universe
• Creating a Multi-Source Universe
Module 20 - Shared Projects:
• Using Shared Projects
• Manipulating Other Designers' Resources
Module 21 - Universe Conversion:
• Converting Existing .unv Universes
Module 22 - Translation:
• Deploying Universes in Different Languages
Notes:
This course will include presentation, explanation, and system demonstrations by the instructor. There will be a focus on hands on activities.
Target audience:
• Application Consultant
• Data Consultant / Manager
• Developer
• Program / Project Manager
• System Administrator
• Technology Consultant
Prerequisites:
Essential:
• Working knowledge of SQL and relational, also OLAP database management systems, concepts, and structures.
• Basic knowledge of reporting with SAP BusinessObjects Web Intelligence.
• OLAP database management concepts, systems and structures
Recommended:
• SAP BusinessObjects Business Intelligence 4.0
• SAP BusinessObjects Information Design Tool BI 4.0