Book Image

Creating Universes with SAP BusinessObjects

By : Taha Mahmoud
Book Image

Creating Universes with SAP BusinessObjects

By: Taha Mahmoud

Overview of this book

Table of Contents (17 chapters)
Creating Universes with SAP BusinessObjects
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

Index awareness


Index awareness is a feature that will help the IDT use key columns while generating SQL queries to speed up data retrieval. The main idea of this feature is to use the available database index. A query based on an indexed database column will retrieve data faster than a normal column. To make it easier, let's take an example first and perform the following steps:

  1. Open the NorthWind Business layer and then navigate to the Business Layer tab from the left panel.

  2. Create a new Status Name dimension under the Orders folder.

  3. Go to the Queries tab from the left panel and create the following query:

  4. Then click on View Script to display the following SQL code generated by this query:

We can see the relation between the Orders, Customers, and Orders Status tables in the following figure:

As we can see, we have a filter on the status name to display the customer's information with new and invoiced orders only.

Now, let's have a closer look at our example. We have three tables in the FROM...