Defining the Value Set Setting (SAP Library

Defining the Value Set Setting

Use

The Reporting Agent enables you to fill pre-calculated value set variables with values for characteristic values in the background. Further to this, the pre-calculated value sets are available as variable values in BEx queries.

The following cases are typical applications of the execution of pre-calculated value sets:

when analyzing target groups since you can specify a fixed value.
when complex selections are involved such as with a Top n inquiry, used to strongly improve query performance.
In place of variables that are filled from a query event (replaced from a query event).

Prerequisites

The query must contain the characteristic that is the placeholder for the variables.

Procedure

You are in the Reporting Agent function area of the Administrator Workbench. Choose

Value Sets in the navigation window of the Administrator Workbench.

You can see the available

characteristics as well as the Report Agent settings

that are assigned to them. You have the following options to create a new setting:

Select the required characteristic and choose New Settings using the context menu. The "New Reporting Agent Setting" dialog box then appears.

The name of the selected characteristic is already pre-installed on the Parameter tab page under the Characteristic group heading.

Select Create New Setting. The "New Reporting Agent Setting" dialog box then appears.

Specify a technical name and a description for the Reporting Agent setting.

The following information can be found in the General tab page:

The functional area of the setting is Pre-definition of Value Sets.
Under the group header Last Change, the system shows- the first time after saving for the first time- the last person to have changed the setting and the time it was changed.
Under the group header Setting Used in Packages, the system displays information for packages where the setting is used, and their scheduling. However, this display is only possible if you have defined the setting and make assignments to one or more scheduling packages.

Choose the Parameters tab page to set parameters.

If you have not created the setting using the context menu for the characteristic, you need to enter the name of the characteristic for which you want to create the variable. Do this under the Characteristic group header. The input help function is available.

Under the Query group header, enter the name of the query whose result is to be saved as a pre-calculated value set. The input help function is available.

The system displays the following information about the query you have selected:

InfoCube (technical name, description)
Query (technical name, description)
(If required) variant

Save active . Under the Generated Value Sets group heading, the system returns the value set (technical name, description) and the table as a result.

A value set pre-calculated in the background exactly corresponds to a data bank table and displays the Pre-calculated Value Set variable value for the selected characteristic.

Result

After you have defined the Reporting Agent setting, you must assign this to a scheduling package and schedule the package as a job.

For more information see Processing a Scheduling Package.

The pre-calculated value set appears in the query definition as a variable that has already been filled with data for the selected characteristic. This results from the background run.