Creating Universes with SAP Business Objects电子书

Creating Universes with SAP BusinessObjects

Table of Contents

Creating Universes with SAP BusinessObjects

Credits

About the Author

About the Reviewers

www.PacktPub.com

Support files, eBooks, discount offers, and more

Why subscribe?

Free access for Packt account holders

Instant updates on new Packt books

Preface

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Downloading the example code

Errata

Piracy

Questions

1. Introduction to BI and the Semantic Layer

What is Business Intelligence?

Business Intelligence concepts

The knowledge pyramid

Hindsight, insight, and foresight

BI and DWH

BI reporting tools architecture

The one-tier architecture model

The two-tier architecture model

The three-tier architecture model

What is a semantic layer?

Introduction to Universes and the Information Design Tool

History of SAP Business Objects

Summary

2. Aligning BI Solutions with Business Demands

Northwind

The BI Maturity Model

Configuring and setting up Northwind's database

Getting the Northwind sample database

Creating the ODBC Connection

The Northwind data model

Dimensional modeling terminologies

Order information

Inventory information

Summary

3. Creating Our First Universe

Information Design Tool

The main features of the IDT

The Information Design Tool interface

Local Projects

Repository Resources

Security Editor

Project Synchronization

Check Integrity Problems

Creating your first Universe step by step

Creating a new project

Creating a new data connection

Creating a new Data Foundation

Creating a new Business layer

Saving and publishing the NorthWind Universe

Finding help while creating a Universe

The Universe wizard

Cheat Sheets

Summary

4. Creating the Data Foundation Layer

Working with data connections

The relational connection

The OLAP connection

Building the Data Foundation layer

Types of Data Foundation

Single Source

Multisource-Enabled

Physical tables and views

Alias tables

Derived tables

Using the @Prompt functionality in a derived table

Nested derived tables

List of derived tables

Joining tables

Cardinality

Key types

A primary key

A foreign key

Join types

Equal joins

Theta joins

Outer joins

Self joins

Data Foundation menus and functions

Detecting joins

Detecting cardinalities

Detecting the row count

Refreshing the structure

Managing families

Save the view as an image

The search panel

Auto-arranging tables

Controlling the Data Foundation display

Insert View

Data Foundation visualization

Data Foundation object manipulation

Insertion

Table manipulation

Add to View

Edit

Merge

Delimit

Set Case To

Replace by

Detect

Change Qualifier/Owner

The table's values and display

Count Rows

Show Table Values

Select Related Tables

Highlight Related Tables

Display

Centre on Selection

Show Local Dependencies

Highlight Aliases

The table's basic functions

Summary

5. Creating the Business Layer

Gathering requirements

The Business layer's main window

The left panel

The Properties panel

The Data Foundation panel

Business Layer

Managing Business layer views

Showing/hiding the search panel

Expand and collapse all

Display Options

Inserting objects

Business objects

Folders

Dimensions

Main properties

SQL Definition

The Select property

The Where property

The Extra Tables property

Keys

Controlling advanced properties

Access Level

Objects can be used in

Database Format

List of Values

Display

Source Information

Custom Properties

Attributes

Measures

Difference between the database and projection functions

Filters

How to create a filter

Filter properties

Summary

6. Testing Your Universe

The Universe development life cycle

Initiation

Planning and design

Implementation and development

Quality assurance and testing

SIT

UAT

Closing

Using the Check Integrity wizard

Queries in the Business layer

Summary

7. The Data Foundation Layer – Advanced Topics

Design concepts

Information systems

Online transactional processing

Online analytical processing

The DWH schema types

The snowflake schema

The star schema

The relational model

Advanced design techniques of Data Foundation

Alias tables

Context

The shortcut join

Advanced Data Foundation properties

Description

SQL Options

Summary

Parameters

SQL design traps

The fan trap

Solving a fan trap

The chasm trap

Solving the chasm trap using context

Solving the chasm trap using an alias table

Loop

Fixing the loop using the shortcut join

Fixing the loop using context

Fixing the loop using an alias table

Summary

8. The Business Layer – Advanced Topics

List of values

List of values based on a dimension object

List of values based on the query panel

List of values based on a custom hierarchy

Static list of values

List of values based on custom SQL

Navigation paths

The default navigation path

The custom navigation path

Index awareness

Primary keys

Foreign keys

Aggregate awareness

Inserting aggregated tables

Defining the aggregated objects

Detecting the aggregation navigation

Common business objects' specific functions

@Aggregate_Aware()

@DerivedTable()

@Prompt()

@Select()

@Variable()

@Where()

Multilingual Universes

Advanced Business layer properties

Description

Summary

Change Data Foundation

Parameters

Summary

9. Data Security and Profiles

Understanding the security model

Working with the Security Editor

Universes / Profiles

Users / Groups

Understanding Data Security Profiles

Connections

Controls

SQL

Rows

Tables

Understanding Business Security Profiles

Create Query

Display Data restriction

Filters

The security matrix

Summary

10. A Multiuser Development Environment

Working with projects

Local projects

Creating a local project

Opening a local project

Deleting a local project

Shared projects

Creating a shared project

Renaming and deleting a shared project

Synchronizing projects

Promotion and the life cycle management console

Promoting a Universe from one environment to another

Promoting NorthWind using the LCMBIAR file

Promoting NorthWind using the Live to Live method

The Upgrade Management Tool

Converting UNV to the new Universe UNX extension

Summary

Index