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 metric by using the Expression Builder.
B.
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.
C.
Create a derived measure by using the addition function that adds each product value
together.
D.
Create a derived measure based on Revenue that has the Level Total Product selected
on the Level Tab of the Logical Column Dialog.
Explanation:
C) D)
D)
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.
How to implement C)?
Here are a number of the websites we suggest for our visitors.