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:
- Accessing BEx Query Designer
- Creating a New Ad Hoc Query
- Adding Key Figures
- Adding Characteristics
- Adding Free Characteristics
- Adding Filters
- Adding Variables
- Saving the Ad Hoc Query
- Running the Ad Hoc Query
- Ad Hoc Query Results
Modifying a Basic Ad Hoc Query
Concepts covered in this guide are as follow:
- Saving a Query as a New Query
- Adding a Formula
- Adding a Restricted Key Figure
- Running the Ad Hoc Query
- Ad Hoc Query Results
- Bookmarking Bookmarking the Ad Hoc Query/Results
Modifying a Basic Ad Hoc Query
Adding Confidential InfoObjects
Concepts covered in this guide are as follow:
- Saving a Query as a New Query
- Adding a Confidential InfoObject
- Running the Ad Hoc Query Without a Query Without a Security Variable
- Adding a Security Variable Variable
- Running the Ad Hoc Query with a Query with a Security Variable
- Ad Hoc Query Results