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.
Explanation:
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.
might modify the question to “adding a new dimension to an existing fact table”