Creating Universes with SAP BusinessObjects

Create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool

Creating Universes with SAP BusinessObjects

Progressing
Taha M. Mahmoud

Create and maintain powerful SAP BusinessObjects Universes with the SAP Information Design Tool
$10.00
$54.99
RRP $32.99
RRP $54.99
eBook
Print + eBook
$12.99 p/month

Get Access

Get Unlimited Access to every Packt eBook and Video course

Enjoy full and instant access to over 3000 books and videos – you’ll find everything you need to stay ahead of the curve and make sure you can always get the job done.

+ Collection
Free Sample

Book Details

ISBN 139781782170907
Paperback310 pages

About This Book

  • Gain all the skills needed to achieve your business intelligence goals by linking your business, data, and people using SAP BusinessObjects
  • Master the SAP Information Design Tool to create a universe and explore its resources such as the connection, data foundation layer, and business layer
  • Learn to use a business case supported with illustrated diagrams that will help you to build robust universes

Who This Book Is For

This book is aimed at both new developers as well as experienced developers. If you are a new SAP BusinessObjects universe developer who is looking for a step-by-step guide supported with real-life examples and illustrated diagrams, then this book is for you. If you are a seasoned BusinessObjects universe developer who is looking for a fast way to map your old experience in universe Designer to the newer Information Design Tool, then this book is for you as well.

Table of Contents

Chapter 1: Introduction to BI and the Semantic Layer
What is Business Intelligence?
Business Intelligence concepts
BI reporting tools architecture
What is a semantic layer?
Introduction to Universes and the Information Design Tool
History of SAP Business Objects
Summary
Chapter 2: Aligning BI Solutions with Business Demands
Northwind
The BI Maturity Model
Configuring and setting up Northwind's database
The Northwind data model
Summary
Chapter 3: Creating Our First Universe
Information Design Tool
Creating your first Universe step by step
Finding help while creating a Universe
Summary
Chapter 4: Creating the Data Foundation Layer
Working with data connections
Building the Data Foundation layer
Joining tables
Data Foundation menus and functions
Controlling the Data Foundation display
Data Foundation object manipulation
Summary
Chapter 5: Creating the Business Layer
Gathering requirements
The Business layer's main window
Business Layer
Business objects
Summary
Chapter 6: Testing Your Universe
The Universe development life cycle
Using the Check Integrity wizard
Queries in the Business layer
Summary
Chapter 7: The Data Foundation Layer – Advanced Topics
Design concepts
Advanced design techniques of Data Foundation
SQL design traps
Summary
Chapter 8: The Business Layer – Advanced Topics
List of values
Navigation paths
Index awareness
Aggregate awareness
Common business objects' specific functions
Multilingual Universes
Advanced Business layer properties
Summary
Chapter 9: Data Security and Profiles
Understanding the security model
Working with the Security Editor
Understanding Data Security Profiles
Understanding Business Security Profiles
The security matrix
Summary
Chapter 10: A Multiuser Development Environment
Working with projects
Promotion and the life cycle management console
The Upgrade Management Tool
Converting UNV to the new Universe UNX extension
Summary

What You Will Learn

  • Leverage SAP BusinessObjects Universes to facilitate your Business Intelligence goals
  • Explore the Information Design Tool, which brings speed and efficiency to reporting
  • Build a robust Data Foundation layer
  • Make a business-oriented Universe
  • Test your Universe and discover issues
  • Use the security profile editor to secure your Universe
  • Develop Universes in a multiuser development environment

In Detail

Creating a Universe using SAP BusinessObjects is your ultimate guide to mastering the development of BusinessObjects Universes using the SAP Information Design Tool. You will find many hands-on exercises as well as hints and best practices within this guide.

The book starts with an introduction to Business Intelligence and where BusinessObjects Universes fit into the big picture. Then, we will go through the Universe creation process. You will then learn how to create a Data Foundation (physical layer) and how to establish a new relational database and OLAP connection. Following this, you will learn how to create a Business layer. You will also learn how to handle security using user profiles and how to use functions such as @Aggregate_Aware(). This is a must-have book for any SAP BO Universe developer and will act as a reference for beginners and experts alike.

Authors

Table of Contents

Chapter 1: Introduction to BI and the Semantic Layer
What is Business Intelligence?
Business Intelligence concepts
BI reporting tools architecture
What is a semantic layer?
Introduction to Universes and the Information Design Tool
History of SAP Business Objects
Summary
Chapter 2: Aligning BI Solutions with Business Demands
Northwind
The BI Maturity Model
Configuring and setting up Northwind's database
The Northwind data model
Summary
Chapter 3: Creating Our First Universe
Information Design Tool
Creating your first Universe step by step
Finding help while creating a Universe
Summary
Chapter 4: Creating the Data Foundation Layer
Working with data connections
Building the Data Foundation layer
Joining tables
Data Foundation menus and functions
Controlling the Data Foundation display
Data Foundation object manipulation
Summary
Chapter 5: Creating the Business Layer
Gathering requirements
The Business layer's main window
Business Layer
Business objects
Summary
Chapter 6: Testing Your Universe
The Universe development life cycle
Using the Check Integrity wizard
Queries in the Business layer
Summary
Chapter 7: The Data Foundation Layer – Advanced Topics
Design concepts
Advanced design techniques of Data Foundation
SQL design traps
Summary
Chapter 8: The Business Layer – Advanced Topics
List of values
Navigation paths
Index awareness
Aggregate awareness
Common business objects' specific functions
Multilingual Universes
Advanced Business layer properties
Summary
Chapter 9: Data Security and Profiles
Understanding the security model
Working with the Security Editor
Understanding Data Security Profiles
Understanding Business Security Profiles
The security matrix
Summary
Chapter 10: A Multiuser Development Environment
Working with projects
Promotion and the life cycle management console
The Upgrade Management Tool
Converting UNV to the new Universe UNX extension
Summary

Book Details

ISBN 139781782170907
Paperback310 pages
Read More