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
How many types of info sources are there? What are they?
what is virtual kef figures? what are the uses and in which case supposed to be use?
You want to convert bex query global structure to local structure. How would you do that?
What is the use of infocube in bw system?
What are the proposal options available?
Will customers continue to receive support for older versions of sap bw?
How are dimensions optimized?
What is authorization processing type?
What are the steps to do the extractig data from r/3.
What is the transaction to maintain services?
What is partition of an infocube?
Which transaction on R/3 shows the transactions with pending processes for update?
What is extended star schema?
What does rollup do?
What is geographical information in the sap bw and for what purpose it is used commonly?