This is a test
- 310 pages
- English
- ePUB (mobile friendly)
- Available on iOS & Android
eBook - ePub
Creating Universes with SAP BusinessObjects
Book details
Book preview
Table of contents
Citations
About This Book
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.
Frequently asked questions
At the moment all of our mobile-responsive ePub books are available to download via the app. Most of our PDFs are also available to download and we're working on making the final remaining ones downloadable now. Learn more here.
Both plans give you full access to the library and all of Perlego’s features. The only differences are the price and subscription period: With the annual plan you’ll save around 30% compared to 12 months on the monthly plan.
We are an online textbook subscription service, where you can get access to an entire online library for less than the price of a single book per month. With over 1 million books across 1000+ topics, we’ve got you covered! Learn more here.
Look out for the read-aloud symbol on your next book to see if you can listen to it. The read-aloud tool reads text aloud for you, highlighting the text as it is being read. You can pause it, speed it up and slow it down. Learn more here.
Yes, you can access Creating Universes with SAP BusinessObjects by Taha M. Mahmoud in PDF and/or ePUB format, as well as other popular books in Computer Science & Entreprise Applications. We have over one million books available in our catalogue for you to explore.
Information
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 pro...
Table of contents
- Creating Universes with SAP BusinessObjects