Home » Oracle » 1z0-591 » How would you accomplish this?
A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?
A. By creating a derived measure by using the Logical Columns available
B. By creating a derived measure in the Column Mapping dialog box by using the physical table columns.
C. By creating a derived measure by using Logic Columns available and changing the aggregation type
D. By creating a derived metric by using the Expression Builder
E. By creating a derived metric by using the Calculation Wizard
Correct Answer: B
Explanation/Reference:
Note 1: OBIEE offers two calculation types for measure in the repository:
logical
physical
You can define calculations in either of the following ways:
* Before the aggregation, in the logical table source.
* After the aggregation, in a logical column derived from two other logical columns. For example: sum(col A) * sum(col B)
Note 2: A measure column is a column unlike the baseline column that has a default aggregation rule defined in the Aggregation tab of the Logical Column dialog in the repository.
Measure columns always calculate the aggregation with which they are defined.
Measures need to be defined in a logical fact. Any column with an aggregation rule is a measure.
Download Printable PDF. VALID exam to help you PASS.
|
|