A customer needs to have a calculation done prior to aggregating the data. How would you accomplish this?

Question

Exhibit

Options

• ABy creating a derived measure by using the Logical Columns available
• BBy creating a derived measure in the Column Mapping dialog box by using the physical table columns.
• CBy creating a derived measure by using Logic Columns available and changing the aggregation type
• DBy creating a derived metric by using the Expression Builder
• EBy creating a derived metric by using the Calculation Wizard

• A
  9% (5)
• B
  84% (47)
• C
  2% (1)
• D
  4% (2)
• E
  2% (1)

Explanation

Note 1: OBIEE offers two calculation types for measure in the repository: 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.

No community discussion yet for this question.