Monday, 24 September 2012

Benefits or Use of Implicit Fact Column in OBIEE

Setting an Implicit Fact Column has two benefits,
  1. An implicit fact column help BI Server choose the join path when multiple join paths are available between facts and dimensions.
  2. When a report is generated only from dimension tables, it will result in an error as an Analyses should always consist of at least one fact or measure.To overcome this error we define an implicit fact column. This ensures that a fact is always included in the SQL generated by BI Server.

No comments:

Post a Comment

Related Posts Plugin for WordPress, Blogger...