Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / 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.
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What are the important aggregation usage indicators?
What is ?filling? of aggregate?
what are the reports used from business content in sap bw project?name them and what was the requirement?
what are the Info Cubes developed in a sap project? Name them and what is the requirement
What are the advantages of BW 3.x web server (WAS)?
What are extractors? Name a few which are used commonly in the sap bw?
What is the ?$? as an authorization value?
How would you debug web reports?
what are the drawbacks of ods?
Give examples of data sources that support remote cubes?
What is a content extraction?
What is sap bw/bi? What is the purpose of sap bw/bi?
What is the use dso in bw system? What kind of data is stored in dsos
What is an infocube?
What is write optimized dso?
