Follow Our FB Page << >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...

How do you create a value set?

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


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

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

More SAP BW (Business Warehouse) Interview Questions

Can you explain about start routines how you used in your project give me an example?

0 Answers  

What is the use of setup table?

1 Answers  

explain return tables. How do start routine and return table synchronize with each other?

0 Answers  

How can we stop the Collapse process in process chain.

2 Answers   IBM,

what are the pre requisites for BI content installation?

1 Answers   Cap Gemini,

process chain is running I have to stop the process for 1 hour after that re runn the process where it is stopped? in multiprovider can I use aggregations

0 Answers   Rockwell, TCS,

What are extractors?

0 Answers  

Can you tell something about the data ware-house hierarchy?

0 Answers  

What is the alpha check execution program?

0 Answers  


0 Answers  

remodeling is applied only on info cube? why not dso/ods?

0 Answers   Rockwell, TCS,

What are the data targets supported by open hub?

3 Answers  

  • SAP Basis Interview Questions SAP Basis (1260)
  • SAP ABAP Interview Questions SAP ABAP (3937)
  • SAPScript Interview Questions SAPScript (236)
  • SAP SD (Sales & Distribution) Interview Questions SAP SD (Sales & Distribution) (2695)
  • SAP MM (Material Management) Interview Questions SAP MM (Material Management) (902)
  • SAP QM (Quality Management) Interview Questions SAP QM (Quality Management) (99)
  • SAP PP (Production Planning) Interview Questions SAP PP (Production Planning) (523)
  • SAP PM (Plant Maintenance) Interview Questions SAP PM (Plant Maintenance) (252)
  • SAP PS (Project Systems) Interview Questions SAP PS (Project Systems) (138)
  • SAP FI-CO (Financial Accounting & Controlling) Interview Questions SAP FI-CO (Financial Accounting & Controlling) (2753)
  • SAP HR (Human Resource Management) Interview Questions SAP HR (Human Resource Management) (1179)
  • SAP CRM (Customer Relationship Management) Interview Questions SAP CRM (Customer Relationship Management) (432)
  • SAP SRM (Supplier Relationship Management) Interview Questions SAP SRM (Supplier Relationship Management) (132)
  • SAP APO (Advanced Planner Optimizer) Interview Questions SAP APO (Advanced Planner Optimizer) (90)
  • SAP BW (Business Warehouse) Interview Questions SAP BW (Business Warehouse) (896)
  • SAP Business Workflow Interview Questions SAP Business Workflow (72)
  • SAP Security Interview Questions SAP Security (592)
  • SAP Interfaces Interview Questions SAP Interfaces (74)
  • SAP Netweaver Interview Questions SAP Netweaver (282)
  • SAP ALE IDocs Interview Questions SAP ALE IDocs (162)
  • SAP Business One Interview Questions SAP Business One (110)
  • SAP BO BOBJ (Business Objects) Interview Questions SAP BO BOBJ (Business Objects) (388)
  • SAP CPS (Central Process Scheduling) Interview Questions SAP CPS (Central Process Scheduling) (14)
  • SAP GTS (Global Trade Services) Interview Questions SAP GTS (Global Trade Services) (21)
  • SAP Hybris Interview Questions SAP Hybris (132)
  • SAP HANA Interview Questions SAP HANA (700)
  • SAP PI (Process Integration) Interview Questions SAP PI (Process Integration) (113)
  • SAP PO (Process Orchestration) Interview Questions SAP PO (Process Orchestration) (0)
  • SAP BI (Business Intelligence) Interview Questions SAP BI (Business Intelligence) (174)
  • SAP BPC (Business Planning and Consolidation) Interview Questions SAP BPC (Business Planning and Consolidation) (38)
  • SAP BODS (Business Objects Data Services) Interview Questions SAP BODS (Business Objects Data Services) (49)
  • SAP BODI (Business Objects Data Integrator) Interview Questions SAP BODI (Business Objects Data Integrator) (0)
  • SAP Ariba Interview Questions SAP Ariba (8)
  • SAP Fiori Interview Questions SAP Fiori (45)
  • SAP EWM (Extended Warehouse Management) Interview Questions SAP EWM (Extended Warehouse Management) (58)
  • Sap R/3 Interview Questions Sap R/3 (150)
  • SAP FSCM Financial Supply Chain Management Interview Questions SAP FSCM Financial Supply Chain Management (101)
  • SAP WM (Warehouse Management) Interview Questions SAP WM (Warehouse Management) (31)
  • SAP GRC (Governance Risk and Compliance) Interview Questions SAP GRC (Governance Risk and Compliance) (63)
  • SAP MDM (Master Data Management) Interview Questions SAP MDM (Master Data Management) (0)
  • SAP MRS (Multi Resource Scheduling) Interview Questions SAP MRS (Multi Resource Scheduling) (0)
  • SAP ESS MSS (Employee Manager Self Service) Interview Questions SAP ESS MSS (Employee Manager Self Service) (13)
  • SAP CS (Customer Service) Interview Questions SAP CS (Customer Service) (0)
  • SAP TRM (Treasury and Risk Management) Interview Questions SAP TRM (Treasury and Risk Management) (0)
  • SAP Web Dynpro ABAP Interview Questions SAP Web Dynpro ABAP (198)
  • SAP IBP (Integrated Business Planning) Interview Questions SAP IBP (Integrated Business Planning) (0)
  • SAP OO-ABAP (Object Oriented ABAP) Interview Questions SAP OO-ABAP (Object Oriented ABAP) (70)
  • SAP S/4 HANA Finance (Simple Finance) Interview Questions SAP S/4 HANA Finance (Simple Finance) (142)
  • SAP FS-CD (Collections and Disbursements) Interview Questions SAP FS-CD (Collections and Disbursements) (0)
  • SAP PLM (Product Lifecycle Management) Interview Questions SAP PLM (Product Lifecycle Management) (0)
  • SAP SuccessFactors Interview Questions SAP SuccessFactors (33)
  • SAP Vistex Interview Questions SAP Vistex (0)
  • SAP ISR (IS Retail) Interview Questions SAP ISR (IS Retail) (28)
  • SAP IdM (Identity Management) Interview Questions SAP IdM (Identity Management) (0)
  • SAP IM (Investment Management) Interview Questions SAP IM (Investment Management) (0)
  • SAP UI5 Interview Questions SAP UI5 (59)
  • SAP SCM (Supply Chain Management) Interview Questions SAP SCM (Supply Chain Management) (51)
  • SAP XI (Exchange Infrastructure) Interview Questions SAP XI (Exchange Infrastructure) (49)
  • SAP Cloud Platform Interview Questions SAP Cloud Platform (34)
  • SAP Testing Interview Questions SAP Testing (89)
  • SAP SolMan (Solution Manager) Interview Questions SAP SolMan (Solution Manager) (63)
  • SAP MaxDB Interview Questions SAP MaxDB (116)
  • SAP GUI Interview Questions SAP GUI (15)
  • SAP AllOther Interview Questions SAP AllOther (329)