Search This Blog

Monday, 26 November 2012

Implicit Fact Column in OBIEE

Often time you will come across scenario where in presentation catalog you have 2 or more fact tables and couple of dimensions. And not all the fact tables are joined with all the dimensions.
And when you just query the data out of dimension which is not joined to a fact table. It will give you an error like ..Can not navigate to the fact table.
Matter of fact is : Whenever you query the data just from the dimension it does not just read the data from dimension but it join that dimension with the fact and then get the data from dimension. Pretty weird huh…
So to resolve this what you will need an implicit column in presentation catalog so whenever you query data from dimension it goes through the table where you have defined an implicit column.
In BMM layer , create a dummy logical column and called it as implicit column , map that column to any number of your choice. Please refer the below screen shot.
Once you are done creating the implicit column. Double click on the presentation catalog and select the newly crated column.
Now if you query just a dimension tables- you will be just fine. ( Again it has to join in BMM and Physical where you have defined implicit column.)

No comments:

Post a Comment