SAP Business Intelligence Reporting Guides

This article contain guidelines step by processes for

• How to create a basic ad hoc query in BEx Query Designer using the Financials InfoCube
• How to modify an existing ad hoc query and add features to the basic query
• How to add Confidential InfoObjects and Security Variables to the ad hoc query

Creating a Basic Ad Hoc Query

Concepts covered in this guide are as follow:

1. Accessing BEx Query Designer
2. Creating a New Ad Hoc Query
3. Adding Key Figures
4. Adding Characteristics
5. Adding Free Characteristics
6. Adding Filters
7. Adding Variables
8. Saving the Ad Hoc Query
9. Running the Ad Hoc Query
10. Ad Hoc Query Results

Creating a Basic Ad Hoc Query

Modifying a Basic Ad Hoc Query

Concepts covered in this guide are as follow:

1. Saving a Query as a New Query
2. Adding a Formula
3. Adding a Restricted Key Figure
4. Running the Ad Hoc Query
5. Ad Hoc Query Results
6. Bookmarking Bookmarking the Ad Hoc Query/Results

Modifying a Basic Ad Hoc Query

Adding Confidential InfoObjects

Concepts covered in this guide are as follow:

1. Saving a Query as a New Query
2. Adding a Confidential InfoObject
3. Running the Ad Hoc Query Without a Query Without a Security Variable
4. Adding a Security Variable Variable
5. Running the Ad Hoc Query with a Query with a Security Variable
6. Ad Hoc Query Results

Adding Confidential InfoObjects