9. Retrieving External Data Sources | Learning SAP Business Objects Dashboards

Sign In Start Free Trial

Book Overview & Buying
Table Of Contents

Learning SAP Business Objects Dashboards

By : Taha Mahmoud

4.8 (6)

Learning SAP Business Objects Dashboards

4.8 (6)

By: Taha Mahmoud

Overview of this book

This book will help beginners to create stylish and professional looking dashboards in no time. It is also intended for BI developers who want to use SAP BO to facilitate BI in their organizations. No prior knowledge is required, however, you must have a basic knowledge of MS Excel and some analytical skills to build expressive business charts.

Preface

Preface

Why do we need dashboards?

What is a dashboard?

What this book covers

What you need for this book

Who this book is for

Conventions

Reader feedback

Customer support

Free Chapter

1. Getting Started with SAP BO Dashboards

1. Getting Started with SAP BO Dashboards

Introduction to SAP BO Dashboards

Installing SAP BO Dashboards

Exploring SAP BO Dashboards' capabilities

Getting to know the SAP BO Dashboards interface

Summary

2. Understanding the Dashboard Creation Process

2. Understanding the Dashboard Creation Process

Phases in the project

Determining the needs

Dashboard creation process

Preparing the dashboard workspace

Summary

3. UI Components

3. UI Components

Before we start

Adding our first chart component (pie chart)

Introducing other chart types

Adding a single-value component to our dashboard

Summary

4. Using Maps and Other Components

4. Using Maps and Other Components

Maps

Using maps

Using other SAP BO Dashboard components

Using other third-party plugins

Summary

5. Interactive Analysis with Dashboards

5. Interactive Analysis with Dashboards

Using traditional selectors

Displaying tabular data

Using advanced menus

Using other selectors

Using third-party selectors

Summary

6. Advanced Interactive Analysis with Dashboards

6. Advanced Interactive Analysis with Dashboards

Using the dynamic visibility feature

Grouping components

Using Containers

Using Alerts

Using the drill-down (Insertion) feature

Linking a dashboard to a Webi or Crystal report document

Summary

7. Styling Up

7. Styling Up

Using text dashboard components

Dealing with colors and themes

Using art and background components

Formatting the dashboard components

Summary

8. Exporting, Publishing, and Importing Dashboards

8. Exporting, Publishing, and Importing Dashboards

Exporting the dashboards file

Publishing dashboards

Importing dashboards

Summary

9. Retrieving External Data Sources

9. Retrieving External Data Sources

Using direct query

Using web services

Using Live Office

Using XML data

Summary

10. Managing Dashboard Security

10. Managing Dashboard Security

Understanding the SAP BusinessObjects security model

Applying object level security

Applying application level security

Applying row level security

Applying security best practices

Summary

11. Creating Mobile Dashboards

11. Creating Mobile Dashboards

Creating dashboards for smart devices

Developing a mobile SAP BO Dashboard

Publishing mobile dashboards

Accessing and using mobile dashboards

Introducing the main features of the SAP BI application

Summary

A. References

Supported excel functions

List of Built-in maps

Supported mobile components and connections

Index

Index

Using web services

We can also use web services to populate our dashboard with data. Web services are a common way of exchanging data between different systems. We can use one of the following web service to consume data retrieved from a web service:

Web service query: This will be created by Query As a Web Service Designer. This tool can be used to create web services based on a Universe.
Web service connection: This connection type can retrieve data from any standard web service.

Web service query

In this section, you will learn how to use Web Service Query to retrieve sales and quantity by product data, and use it in the Sales and Quantity by Product combo chart. But first, let's summarize the high-level steps required to accomplish this:

Learn how to use the Query As a Web Service Designer tool to create a web service query based on the eFashion Universe
Create the Web Service Query data connection in your dashboard to call this web service
Configure the Usage options for this connection

Let...

CONTINUE READING

83

Tech Concepts

36

Programming languages

73

Tech Tools

Unlimited access to the largest independent learning library in tech of over 8,000 expert-authored tech books and videos.

Innovative learning tools, including AI book assistants, code context explainers, and text-to-speech.

50+ new titles added per month and exclusive early access to books as they are being written.

Learning SAP Business Objects Dashboards

Search

Your notes and bookmarks