Home » Oracle » 1z0-591 » When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?
When adding a new dimension to an existing logical table, what is the significance of the Logical Level setting in the Logical Table Source properties?
A. It defines the granularity of the dimension.
B. It determines the actual value of the dimension.
C. It creates a new session variable.
D. It creates a foreign key relationship.
Correct Answer: A
Explanation/Reference:
OBIEE – Grain (Level of summarization)
Grain definition in the context of OBIEE.
The following list describes the different grains in navigating a query:
* Aggregation grain. The grain of the aggregate source of from a level based metrics
* Query grain. The grain of the request.
* Time Series grain. The grain at which the time series function aggregation is requested.
* Storage grain. The query in the example can be computed from daily sales or from monthly sales, or from quarterly sales.
Note:
The aggregation grain is defined in the content tab of the logical table source.
When the query grain match the aggregation grain of a logical table source, this one is used to create the physical query.
|
Download Printable PDF. VALID exam to help you PASS.
|
 |
