Home » Oracle » 1z0-591 » Which option is not an example of a level-based measure?
Which option is not an example of a level-based measure?
A. Regional Revenue
B. Sales
C. Brand Cost
D. Employee Salary
Correct Answer: C
Explanation/Reference:
Note 1: 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.
Note 2: To create a level based measure as the amount sold by region, you can:
* make a copy of the Amount Sold logical column
* and then
/ drag the logical column into its hierarchy level
/ or set the aggregation grain in the level tab of the logical column property.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
