| Back to Questions Page |
| |
| Question |
How do you create a value set? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | 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.  |
| Vsu_vnaya |
| |
| |
| Question |
What is a template? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | A template is a document or file having a preset format,
used as a starting point for a particular application so
that the format does not have to be recreated each time it
is used.It is the basic structure on which you can fill your
application specific details.  |
| Vsu_vnaya |
| |
| |
| Question |
What is a restricted key figure and give an example? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | RKF'S CAN BE RESTRICTED BY ONE OR MORE CHARACTERSTICS
EXAMPLE:
RESTRICT
"SALES VOLUME" -----> KF
BY
"COMPANY CODE" = "001" 0R "002" OR "003"
 |
| Mahesh |
| |
| |
|
|
| |
| Question |
Can you create aggregate on ODS or multi provider? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | NO. AGGREAGTES CAN BE CREATED ONLY ON INFOCUBES  |
| Mahesh |
| |
| |
| Question |
What is delta update? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | DELTA UPDATE: IN THIS UPDATE ON THE NEWLY ADDED AND CHANGED
RECORDS WILL BE UPLOADED  |
| Mahesh |
| |
| |
| Question |
What is the percentage variance? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | Percentage variance is the ratio of variance or difference
between two operands. For ex if your estimated work hours on
a particular task is 8 hrs and the actual work hours s 10
hrs, the percentage variance is (8/10)*100. It is simply a
measure of the difference/variation.  |
| Vsu_vnaya |
| |
| |
| Question |
What are the table structures associated with ODS? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | New table
Active table
Change Log  |
| Mahesh |
| |
| |
| Question |
Can you disable cache? |
Rank |
Answer Posted By |
|
Question Submitted By :: Ravi |
|
I also faced this Question!! |
© ALL Interview .com |
| Answer | yes  |
| Mahesh |
| |
| |
|
| |
|
Back to Questions Page |