Call : (+91) 968636 4243
Mail : info@EncartaLabs.com
EncartaLabs

SAP BusinessObjects - Information Design Tool

( Duration: 5 Days )

The SAP BusinessObjects - Information Design Tool training course will provide 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 will learn to use data from different source systems (SAP and non-SAP) with the SAP BusinessObjects BI client tools.

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

This SAP BusinessObjects - Information Design Tool workshop is aimed at:

  • Application Consultants
  • Data Consultants / Managers
  • Developers
  • Database Administrators
  • System Administrators
  • System Architects
  • Technology Consultants

COURSE AGENDA

1

Basic SAP BusinessObjects Universe Design

  • Describing Universes
  • Working with Local Projects
2

Data Connections

  • Defining Connections
3

Data Foundations

  • Creating Data Foundations
  • Using Joins
4

Business Layers

  • Accessing Data through the Business Layer
  • Integrating the Business Layer Components
  • Validating Objects
  • Creating Measure Objects
5

Loops in a Data Foundation

  • Creating Loops on the Data Foundation
  • Resolving Loops Using Aliases
  • Resolving Loops Using Contexts
  • Resolving Recursive Loops
6

Data Restrictions

  • Defining Data Restrictions
  • Applying Mandatory Data Restrictions
  • Applying Optional Data Restrictions
7

Lists of Values (LOV)

  • Defining a List of Values
  • Associating a List of Values to a Business Layer Object
8

Parameters

  • Creating and Using a Parameter
9

Object @functions

  • Using @Functions in SQL
  • Using the @AggregateAware function
  • Using the @Select Function
  • Using the @Where Function
  • Using the @Execute Function
  • Using the @Variable Function
10

Navigation Paths

  • Defining and Creating Navigation Paths
11

Shared Projects

  • Using Shared Projects
  • Manipulating Other Designers' Resources
12

Universe Deployment

  • Deploying a Universe
13

Universe Management with Data Foundation and Business Layer Views

  • Managing the Data Foundation Using Views
  • Managing the Business Layer Using Views
14

Universe Optimization

  • Optimzing Universes
15

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
16

SQL Traps

  • Defining SQL Traps
  • Identifying a Chasm Trap
  • Resolving a Chasm Trap
  • Identifying a Fan Trap
  • Resolving a Fan Trap
17

Universe Creation from Different Data Sources

  • Identifying Different Data Sources
  • Creating an OLAP Universe
  • Creating a Universe from a BEx Query
  • Creating a Multisource Universe
  • Creating and Using Federated Tables
18

Extending the Data Foundation with Derived Tables and Calculated Columns

  • Creating and Using Derived Tables
  • Creating and Using Calculated Columns
19

Ambiguous Outer Join Resolution

  • Resolving an Ambiguous Outer Join
20

Linked Universes

  • Defining and Creating a Linked Universe
  • Special Considerations of Linked Universes
  • Managing Core Universes
  • Prioritizing the Display of Tables Common to Multiple Core Data Foundations
  • Including a Core Universe
21

Universe Conversion

  • Converting Existing .unv Universes
22

Universe Translation

  • Deploying Universes in Different Languages
23

Advanced Data Manipuliation in the Business Layer

  • Using SQL to Manipulate Data

Encarta Labs Advantage

  • One Stop Corporate Training Solution Providers for over 6,000 various courses on a variety of subjects
  • All courses are delivered by Industry Veterans
  • Get jumpstarted from newbie to production ready in a matter of few days
  • Trained more than 50,000 Corporate executives across the Globe
  • All our trainings are conducted in workshop mode with more focus on hands-on sessions

View our other course offerings by visiting https://www.encartalabs.com/course-catalogue-all.php

Contact us for delivering this course as a public/open-house workshop/online training for a group of 10+ candidates.

Top
Notice
X