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.
  • The implicit fact column must be based on the same fact around which the presentation catalog has been built. For example, if the presentation catalog contains information from the Order star, the implicit fact column must be based on the Order/Order-Item fact.
For example, if the ROW_WID column in the fact table is the primary key of that table, then the implicit fact column is a Count (ROW_WID).

1 comment: