A customer frequently queries multiple dimension tables without a measure. What needs to be defined in the presentation layer?

The correct answer is B. Implicit Fact Column. Metadata Repository Builder's Guide Setting an Implicit Fact Column in the Subject Area For each subject area in the Presentation layer, you can set an implicit fact column. The implicit fact column is added to a query when it contains columns from two or more dimension tables…

Developing the Presentation Layer of a Repository

Question

Options

ALogical Key
BImplicit Fact Column
CAlias
DLogical Column Name
ECustom Display Name

How the community answered

(33 responses)

A
12% (4)
B
79% (26)
C
3% (1)
E
6% (2)

Explanation

Metadata Repository Builder's Guide Setting an Implicit Fact Column in the Subject Area For each subject area in the Presentation layer, you can set an implicit fact column. The implicit fact column is added to a query when it contains columns from two or more dimension tables and no measures. The column is not visible in the results. It is used to specify a default join path between dimension tables when there are several possible alternatives or contexts.

Topics

#implicit fact column#dimension queries#presentation layer#no measures

Community Discussion

No community discussion yet for this question.

Full 1Z0-591 Practice