How do you create a value set?

Question Posted / ravi

1 Answers
4908 Views
I also Faced
E-Mail Answers

How do you create a value set?..

Answer / vsu_vnaya

1. You are in the Reporting Agent function area of the
Administrator Workbench. Choose Value Sets in the navigation
window of the Administrator Workbench.

2. On the left side of the Reporting Agent Scheduler, you
can see the available characteristics as well as the
Reporting Agent settings that are assigned to them. You can
create a new setting in the following ways:

* Select the required characteristic and choose New
Settings using the context menu. The New Reporting Agent
Setting dialog box 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 appears.

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

The following information is displayed on the General tab page:

* The functional area of the setting is Precalculation
of Value Sets.

* After the setting has been saved for the first time,
under the Last Changed On/By group header the system
displays details of the last person who changed the setting
and the time this change was made.

* Under the Setting is Used in Packages group header,
the system displays information about the packages in which
the setting is used, and how they are scheduled. This
information can only be displayed if you have defined the
setting and assigned one or more scheduling packages to it.

4. 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. Input help is
available for this.

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

5. 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 that has been precalculated in the background
corresponds to a query with the following properties:

§ The key figure structure is in the columns.

§ The characteristic that you have selected in the Reporting
Agent setting is in the rows. All other characteristics are
removed from the query.

The precalculated value set displays the value of a variable
of type Precalculated Value Set from 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.

As a result of background processing, you can use the
precalculated value set in a characteristic variable. You
create a characteristic variable in the Query Designer by
using the variable wizard. You determine that the variable
represents a precalculated value set in the Details step.
The value of this variable is the technical name of the
Reporting Agent setting. You enter the technical name in the
Default Values step. The variable can be ready for input and
you can select different value sets in the variable screen
at the query runtime.

You can also enter variables of type Precalculated Value Set
in the variable screen manually by entering the technical
name of the Reporting Agent setting.