Book Image

SAP Business Intelligence Quick Start Guide

By : Vinay Singh
Book Image

SAP Business Intelligence Quick Start Guide

By: Vinay Singh

Overview of this book

The SAP BusinessObjects Business Intelligence platform is a powerful reporting and analysis tool. This book is the ideal introduction to the SAP BusinessObjects Business Intelligence platform, introducing you to its data visualization, visual analytics, reporting, and dashboarding capabilities. The book starts with an overview of the BI platform and various data sources for reporting. Then, we move on to looking at data visualization, analysis, reporting, and analytics using BusinessObjects Business Intelligence tools. You will learn about the features associated with reporting, scheduling, and distribution and learn how to deploy the platform. Toward the end, you will learn about the strategies and factors that should be considered during deployment. By the end, you will be confident working with the SAP BusinessObjects Business Intelligence platform to deliver better insights for more effective decision making.
Table of Contents (14 chapters)
Free Chapter
Section 1: Introduction to SAP Business Intelligence
Section 2: Data Visualization, Analysis, and Reporting
Section 3: BI Platform Features and Deployment

Creating a BEx query to directly access SAP BW as a data source

You can again use the sample data from eFashion that we have downloaded earlier. We will refer the dataset from eFashion, you can choose cube of your own that is available in your system:

  1. Start BEx Query Designer and connect to the SAP BW system when asked to provide login credentials.
  2. Create a new BEx Query using the Info Provider eFashion cube. Move the characteristic store (technical name = EF_STORE) to the Rows section.
  3. Use the basic key figures, amount sold (EFAMTSOLD) and quantity sold (QTY_SOLD), in the Columns section.
  4. Save the query in the role folder.
  5. Execute the query in the BEx Web Analyzer to view the data and see if it is correct.
  6. Make the necessary changes in the BEx query definition to enable users of your report.
  7. To select the data related to specific countries states (EF_STATE). Save the query and...