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?

Question

Exhibit

Options

• AIt defines the granularity of the dimension.
• BIt determines the actual value of the dimension.
• CIt creates a new session variable.
• DIt creates a foreign key relationship.

• A
  76% (16)
• B
  5% (1)
• C
  5% (1)
• D
  14% (3)

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

No community discussion yet for this question.