O'Reilly logo

Creating Universes with SAP BusinessObjects by Taha M. Mahmoud

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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:
    Index awareness
  4. Then click on View Script to display the ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required