What are the two ways that they would get the revenue for all products to use in the denominator?

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 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.



Leave a Reply 7

Your email address will not be published. Required fields are marked *


Mario

Mario

I would say A and B, answer C makes no sense to me….

Prashant Basa

Prashant Basa

Even I agree, it should be A and B.

Ashish

Ashish

I believe it should be A &_B

sid123

sid123

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.

Leo Yu

Leo Yu

how t implement A) in obiee 11g?