Saturday 5 July 2014

Implicit Fact column in OBIEE

An  Implicit fact column is used when we have multiple fact tables and the report is generated only from dimension tables. 
A user may create a report where it have only dimensions and not a single fact measure. when these are created BI server has multiple join paths available between dimensions and facts so it joins to nearest fact table and pulls the data hence results obtained might be different from what user is expecting.To overcome this we can create a Implicit fact column.This Implicit fact column shows the join path for the BI server.
at

1 comment:

  1. Doris M. Bennett16 March 2021 at 00:17

    Wow what a Great Information about World Day its very nice informative post. thanks for the post. try this

    ReplyDelete

Subscribe to: Post Comments (Atom)

A fatal error occurred while processing the request. The server responded with: FOProcessor cannot run without a valid TMP directory. Please check if TMP directory exist and write enabled.

When attempting to export a Dashboard to Excel the following error message in sawlog is found: A fatal error occurred while processi...