OBIEE Online Training

OBIEE Online training by ex-Rittman Mead and Oracle trainer.
Contact :
Watsapp : +65-82830121
Training will be real time and more hands on.
Number of slots available : 2/5

Wednesday, August 22, 2012

Implicit Fact Column

A User may request a report where it may have only Dimensions and no Fact columns such as No of Customers in an Year or Product Category and Product Description. When these are requested the server may sometimes gets confused as from which fact table should it join to fetch the Data. So it joins to nearest fact table and pulls the data through it. So the result obtained may be different from what user is expecting.

So, to avoid this sort of confusion  We can create in a Dummy Fact table in a Physical Layer and Join all Dimensions to this Fact table in BMM Layer. Then in the Presentation Catalog we assign dummy fact table column as implicit fact column . So, Whenever a report on Dimensions are requested it joins through dummy fact table and fetch data.

No comments:

Post a Comment

Thank you

- Naveen