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
Explanation:
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.
C
I would go with C
Its B
If you need calculation BEFORE aggregation, you use physical columns.
Otherwise, you use logical.
B
Best Practice from Oracle Bootcamp manual:
Use logical columns for calculation formulas that require an aggregation rule that is applied BEFORE the calculation.
Prior = preceding in time or in order; earlier or former; previous;Before.
So…
Logical: Aggregation BEFORE Calculation
Physical: Aggregation AFTER Calculation
The other way around…
Physical: Calculation BEFORE/PRIOR Aggregation
Logical: Calculation AFTER Aggregation
best practice is calculation on physical column before aggregation, and calculation on logical colum after agregation.
We came across a cool web page that you just may possibly appreciate. Take a appear in case you want.
Here are some hyperlinks to web-sites that we link to because we consider they may be really worth visiting.
the time to study or stop by the content material or web sites we’ve linked to beneath the
below youll find the link to some web pages that we consider you ought to visit
Sites of interest we have a link to
Here is an excellent Blog You may Obtain Interesting that we Encourage You
we came across a cool web page that you simply may enjoy. Take a appear for those who want
usually posts some extremely fascinating stuff like this. If youre new to this site
Sites of interest we’ve a link to
please stop by the web-sites we comply with, like this one, as it represents our picks through the web
we came across a cool web page which you may possibly get pleasure from. Take a search should you want
the time to study or pay a visit to the content material or internet sites we’ve linked to below the
Here are several of the websites we advocate for our visitors
The data mentioned within the post are a few of the most effective available
here are some hyperlinks to web-sites that we link to simply because we think they’re really worth visiting
the time to study or pay a visit to the subject material or web-sites we have linked to beneath the
that would be the finish of this post. Here you will discover some web-sites that we feel you will enjoy, just click the links over
we came across a cool site that you simply may well delight in. Take a appear in case you want
Sites of interest we’ve a link to