Boid10 en Col15 Ilt Fv Co a4

BOID10 SAP BusinessObjects Information Design Tool

.

. COURSE OUTLINE

. Course Version: 15 Course Duration: 5 Day(s)

SAP Copyrights and Trademarks

© 2014 SAP SE. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE. The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. ●

Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

●

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POWER6+, POWER6, POWER5+, POWER5, POWER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.

●

Linux is the registered trademark of Linus Torvalds in the U.S. and other countries.

●

Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

●

Oracle is a registered trademark of Oracle Corporation

●

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

●

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix Systems, Inc.

●

HTML, XML, XHTML and W3C are trademarks or registered trademarks of W3C®, World Wide Web Consortium, Massachusetts Institute of Technology.

●

●

Java is a registered trademark of Sun Microsystems, Inc. JavaScript is a registered trademark of Sun Microsystems, Inc., used under license for technology invented and implemented by Netscape.

●

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer, StreamWork, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE in Germany and other countries.

●

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company.

●

Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary. These materials are subject to change without notice. These materials are provided by SAP SE and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

© Copyright . All rights reserved.

iii

iv


Typographic Conventions American English is the standard used in this handbook. The following typographic conventions are also used.

This information is displayed in the instructor’s presentation

Demonstration

Procedure

Warning or Caution

Hint

Related or Additional Information

Facilitated Discussion

User interface control

Example text

Window title

Example text


v

vi


Contents xi

Course Overview

1

Unit 1:

1 1 3

Lesson: Describing Universes Lesson: Defining the Components of a Universe Unit 2:

3 5

Unit 3:

Unit 4:

Unit 5:

Unit 6:

15

Data Restrictions Lesson: Defining Data Restrictions Lesson: Applying Mandatory Data Restrictions Lesson: Applying Optional Data Restrictions

Unit 7:

13 15

Loops in a Data Foundation Lesson: Resolving Loops with Joined Tables Lesson: Resolving Loops Using Aliases Lesson: Resolving Loops Using Contexts Lesson: Detecting Contexts Lesson: Editing Contexts Lesson: Testing Contexts Lesson: Resolving Recursive Loops

11 11 11 13

Business Layers Lesson: Accessing Data through the Business Layer Lesson: Integrating the Business Layer Components Lesson: Validating Objects Lesson: Creating Measure Objects Lesson: Creating Shortcut Joins

9 9 9 9 9 9 10 11

Data Foundations Lesson: Creating Data Foundations Lesson: Using Joins

7 7 7 7 7 9

Data Connections Lesson: Defining Connections

5 5 7

Basic SAP BusinessObjects Universe Design

Lists of Values (LOV) Lesson: Providing a List of Values

Unit 8:

Parameters Lesson: Illustrating Runtime Parameters


vii

17

Unit 9:

17 17

Lesson: Using Object @functions in Queries Lesson: Applying the Aggregate Awareness Optimization Method

17

Lesson: Using Other Functions

19

Unit 10:

19 21

23

Unit 11:

Unit 12:

Unit 13:

Unit 14:

Unit 15:

33 33 33 33 33

Universe Optimization Lesson: Optimizing Universes Using Parameters

Unit 16:

31 31 31 31 31 31 32 33

Universe Management with Data Foundation and Business Layer Views Lesson: Managing a Universe using the Data Foundation View Lesson: Managing a Universe using the Business Layer View

29 31

Key Awareness Lesson: Defining Numeric Keys

27 27 29

Derived Tables Lesson: Creating Derived Tables

25 27

Navigation Paths Lesson: Defining Drill Down Navigation Paths

23 25

Relative-Time Objects Lesson: Creating Relative-Time Objects

21

viii

Object @functions

Universe Deployment and Security Lesson: Deploying a Universe Lesson: Securing a Published Universe Lesson: Creating Data Security Profiles Lesson: Creating Business Security Profiles Lesson: Assigning Security Profiles to Users Lesson: Identifying the Priority of Security Settings Lesson: Updating a Published Universe

Unit 17:

SQL Clause Processing Problems Lesson: Determining How the Order of SQL Clauses Affects Data Returned Lesson: Detecting Chasm Traps Lesson: Resolving Chasm Traps Lesson: Identifying Fan Traps Lesson: Resolving Fan Traps


35

Unit 18:

35

Outer Join Problem Resolution Lesson: Resolving an Ambiguous Outer Join Using @AggregateAware

37

Unit 19:

37 37 37 39

Lesson: Identifying the Different Data Sources Lesson: Creating an OLAP Universe Lesson: Creating a Multi-Source Universe Unit 20:

39 39 41

43

Shared Projects Lesson: Using Shared Projects Lesson: Manipulating Other Designers' Resources

Unit 21:

41 43

Universe Creation from Different Data Sources

Universe Conversion Lesson: Converting Existing .unv Universes

Unit 22:

Translation Lesson: Deploying Universes in Different Languages


ix

x


Course Overview

TARGET AUDIENCE This course is intended for the following audiences: ●

Application Consultant

●

Data Consultant

●

Developer

●

Project Manager

●

System Administrator


xi

xii


UNIT 1

Basic SAP BusinessObjects Universe Design

Lesson 1: Describing Universes Lesson Objectives

After completing this lesson, you will be able to: ●

Discuss universes

Lesson 2: Defining the Components of a Universe Lesson Objectives


Identify local projects


1

Unit 1: Basic SAP BusinessObjects Universe Design

2


UNIT 2

Data Connections

Lesson 1: Defining Connections Lesson Objectives


Define data connections


3

Unit 2: Data Connections

4


UNIT 3

Data Foundations

Lesson 1: Creating Data Foundations Lesson Objectives


Create data foundations

Lesson 2: Using Joins Lesson Objectives

After completing this lesson, you will be able to:

●

Use joins

●

Create an equi-join

●

Create an outer join

●

Create a theta join

●

Create column filters to restrict data


5

Unit 3: Data Foundations

6


UNIT 4

Business Layers

Lesson 1: Accessing Data through the Business Layer Lesson Objectives


●

Access business layer data

●

Create a business layer

●

Populate the business layer

Lesson 2: Integrating the Business Layer Components Lesson Objectives


●

Add business layer folders

●

Create business layer dimension objects

●

Create time dimension objects

●

Create attribute objects

Lesson 3: Validating Objects Lesson Objectives


Verify business object accuracy and integrity

Lesson 4: Creating Measure Objects Lesson Objectives


Create a measure object

●

Create a delegated measure object

Lesson 5: Creating Shortcut Joins


7

Unit 4: Business Layers

Lesson Objectives


8

Create shortcut joins


UNIT 5

Loops in a Data Foundation

Lesson 1: Resolving Loops with Joined Tables Lesson Objectives


●

Identify loops

Lesson 2: Resolving Loops Using Aliases Lesson Objectives


●

Resolve loops using aliases

Lesson 3: Resolving Loops Using Contexts Lesson Objectives


Resolve loops using contexts

Lesson 4: Detecting Contexts Lesson Objectives


●

Detect contexts

Lesson 5: Editing Contexts Lesson Objectives


●

Edit contexts

Lesson 6: Testing Contexts Lesson Objectives


9

Unit 5: Loops in a Data Foundation


Test contexts

Lesson 7: Resolving Recursive Loops Lesson Objectives


●

10

Resolve recursive loops


UNIT 6

Data Restrictions

Lesson 1: Defining Data Restrictions Lesson Objectives


Define data restrictions

Lesson 2: Applying Mandatory Data Restrictions Lesson Objectives


Apply restrictions to objects

●

Apply restrictions using an alternative method

●

Restrict by inferring matching data between tables

Lesson 3: Applying Optional Data Restrictions Lesson Objectives


●

Restrict data using a filter object


11

Unit 6: Data Restrictions

12


UNIT 7

Lists of Values (LOV)

Lesson 1: Providing a List of Values Lesson Objectives


●

Define a list of values

●

Use the list of values editor

●

Create static lists of values

●

Create lists of values based on business layer objects

●

Associate a list of values with a business object


13

Unit 7: Lists of Values (LOV)

14


UNIT 8

Parameters

Lesson 1: Illustrating Runtime Parameters Lesson Objectives


●

Use parameters to restrict data


15

Unit 8: Parameters

16


UNIT 9

Object @functions

Lesson 1: Using Object @functions in Queries Lesson Objectives


Identify object @functions

Lesson 2: Applying the Aggregate Awareness Optimization Method Lesson Objectives


Set up aggregate awareness

Lesson 3: Using Other Functions Lesson Objectives


Use the select function

●

Use the where function

●

Use the variable function

●

Use the execute function


17

Unit 9: Object @functions

18


UNIT 10

Relative-Time Objects

Lesson 1: Creating Relative-Time Objects Lesson Objectives


Create relative-time objects


19

Unit 10: Relative-Time Objects

20


UNIT 11

Navigation Paths

Lesson 1: Defining Drill Down Navigation Paths Lesson Objectives


Define a navigation path


21

Unit 11: Navigation Paths

22


UNIT 12

Derived Tables

Lesson 1: Creating Derived Tables Lesson Objectives


●

Use derived tables


23

Unit 12: Derived Tables

24


UNIT 13

Key Awareness

Lesson 1: Defining Numeric Keys Lesson Objectives


●

Apply key awareness


25

Unit 13: Key Awareness

26


UNIT 14

Universe Management with Data Foundation and Business Layer Views

Lesson 1: Managing a Universe using the Data Foundation View Lesson Objectives


Manage a universe using the data foundation view

Lesson 2: Managing a Universe using the Business Layer View Lesson Objectives


Manage a universe using the business layer view


27

Unit 14: Universe Management with Data Foundation and Business Layer Views

28


UNIT 15

Universe Optimization

Lesson 1: Optimizing Universes Using Parameters Lesson Objectives


Use connection configuration parameters

●

Use query script parameters

●

Explain best practices for universe design


29

Unit 15: Universe Optimization

30


UNIT 16

Universe Deployment and Security

Lesson 1: Deploying a Universe Lesson Objectives


●

Document universes

●

Deploy a universe

Lesson 2: Securing a Published Universe Lesson Objectives


Secure a published universe

Lesson 3: Creating Data Security Profiles Lesson Objectives


Define data security profiles

Lesson 4: Creating Business Security Profiles Lesson Objectives


Define business security profiles

Lesson 5: Assigning Security Profiles to Users Lesson Objectives


●

Assign security profiles to users

Lesson 6: Identifying the Priority of Security Settings


31

Unit 16: Universe Deployment and Security

Lesson Objectives


Describe security setting priorities

Lesson 7: Updating a Published Universe Lesson Objectives


32

Update a published universe


UNIT 17

SQL Clause Processing Problems

Lesson 1: Determining How the Order of SQL Clauses Affects Data Returned Lesson Objectives


Analyze SQL traps

Lesson 2: Detecting Chasm Traps Lesson Objectives


Identify chasm traps

Lesson 3: Resolving Chasm Traps Lesson Objectives


Resolve chasm traps

Lesson 4: Identifying Fan Traps Lesson Objectives


●

Identify fan traps

Lesson 5: Resolving Fan Traps Lesson Objectives


Resolve fan traps


33

Unit 17: SQL Clause Processing Problems

34


UNIT 18

Outer Join Problem Resolution

Lesson 1: Resolving an Ambiguous Outer Join Using @AggregateAware Lesson Objectives


Resolve an ambiguous outer join


35

Unit 18: Outer Join Problem Resolution

36


UNIT 19

Universe Creation from Different Data Sources

Lesson 1: Identifying the Different Data Sources Lesson Objectives


Identify data sources for universes

Lesson 2: Creating an OLAP Universe Lesson Objectives


Create an OLAP universe

Lesson 3: Creating a Multi-Source Universe Lesson Objectives


●

Create a multisource universe

●

Use calculated columns

●

Use federated tables


37

Unit 19: Universe Creation from Different Data Sources

38


UNIT 20

Shared Projects

Lesson 1: Using Shared Projects Lesson Objectives


Explain the role of shared projects

Lesson 2: Manipulating Other Designers' Resources Lesson Objectives


Describe the purpose of project synchronization

●

Update shared projects


39

Unit 20: Shared Projects

40


UNIT 21

Universe Conversion

Lesson 1: Converting Existing .unv Universes Lesson Objectives


Convert published .unv universes


41

Unit 21: Universe Conversion

42


UNIT 22

Translation

Lesson 1: Deploying Universes in Different Languages Lesson Objectives


●

Deploy a translated universe


43

Boid10 en Col15 Ilt Fv Co a4

Recommend Documents