Description

Duration

5 Days

30 CPD hours

This course is intended for

The primary audience for this course are Application Consultants, Data Consultants/Managers, Developers, Program/Project Managers, and System Administrators.

Overview

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 deploy SAP BusinessObjects universes.In this course you learn how to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools.

This five-day course is designed to give you the comprehensive skills and in-depth knowledge needed to create SAP BusinessObjects universes using the SAP BusinessObjects Information Design Tool.

Basic SAP BusinessObjects Universe Design

Describing Universes

Defining the Components of a Universe

Data Connections

Defining connections

Data Foundations

Creating Data Foundations

Using Joins

Business Layers

Accessing Data through the Business Layer

Integrating the Business Layer Components

Validating Objects

Creating Measure Objects

Creating Shortcut Joins

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

Data Restrictions

Defining Data Restrictions

Applying Mandatory Data Restrictions

Applying Optional Data Restrictions

Lists of Values (LOV)

Providing a List of Values

Parameters

Illustrating Runtime Parameters

Object @functions

Using Object @functions in Queries

Applying the Aggregate Awareness Optimization Method

Using Other @ Functions

Navigation Paths

Defining Drill Down Navigation Paths

Derived Tables

Creating Derived Tables

Key Awareness

Defining Numeric Keys

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

Universe Optimization

Optimizing Universes Using Parameters

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

SQL Clause Processing Problems

Determining How the Order of SQL Clauses Affects Data Returned

Detecting Ambiguity Caused by SQL Requests Run Against Joined Tables

Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables

Identifying Fan Traps

Resolving Ambiguity Caused by SQL Requests Run Against Joined Tables

Outer Join Problem Resolution

Resolving an Ambiguous Outer Join Using @AggregateAware

Universe Creation from Different Data Sources

Identifying the Different Data Sources

Creating an OLAP Universe

Creating a Multi-source Universe

Shared Projects

Using Shared Projects

Manipulating Other Designers' Resources

Universe Conversion

Converting Existing .unv Universes

Translation

Deploying Universes in Different Languages

Course Images

BOID10 SAP BusinessObjects Information Design Tool

By Nexus Human

Booking options

Highlights

Description

About The Provider

Tags

Reviews