Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

How do you create a value set?

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


Please Help Members By Posting Answers For Below Questions

what is direct schedule and what is meta chain

2463


What is the ?$? as an authorization value?

2107


How do you enter documents?

1943


Explain the usage of geo-coordinates ?

1012


What is a content extraction?

2134


Which datastore object is used?

994


is there is any book that covers all topics of BI 7.0 and the navigation steps for bi 7.0 and pdf of 7

1908


What are the 3 sap defined dimensions?

982


What are the different categories of infoobjects in bw system?

917


When coding the ABAP transfer rule, what are the important variables you make

2251


How can I configure the workflow so that when the deadline is missed the workflow step is simply skipped?

902


What do you mean by start routines

927


What is the format of LO data sources?

2036


How do I separate development from the production environment?

839


What is data flow in bw/bi?

959