A customer needs to create a product share calculation. What are the two ways that they would
get the revenue for all products to use in the denominator?
A.
Create a derived measure by using the addition function that adds each product value together.
B.
Create a derived measure based on Revenue that has the Level Total Product selected on the
Level Tab of the Logical Column Dialog.
C.
Create a derived measure based on Revenue that has all the levels selected on the Level Tab
of the Logical Column Dialog except Total Product.
D.
Create a derived metric by using the Expression Builder.
Explanation:
Note: A level-based measure is a column whose values are always calculated to a specific level of
aggregation.
The calculation of this measure is independent of the query grain and used always the
aggregation grain of the logical column.
Level-based measures allow :
* to return data at multiple levels of aggregation (the query grain and the level-based column grain)
with one single query
* to create share measures (percentage), that are calculated by taking some measure and dividing
it by a level-based measure. For example, you can divide salesperson revenue by regional
revenue to calculate the share of the regional revenue each salesperson generates.
I would say A and B, answer C makes no sense to me….
Even I agree, it should be A and B.
I believe it should be A &_B
Official answer is correct .
the biggest problem with B is that it talks about setting the content level of the level based measure to total for product dim . In this case product dimension will be ignored and there will be no leveling of data in fact based on Product dim .
D is incomplete does not go in details at all.
B) is correct, C) is incorrect, please refer to
http://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1221/rpd/rpd.html
creating level-based measure -> creating level based measure, we can see, a new measure on the Total level is displayed within the logical dimension.
A) is correct as well, sum(all physical product value) can perform aggregation as well.
how t implement A) in obiee 11g?
surely it is A.
http://erptree.com/oracle-r12-online-trainings/