Monday, October 8, 2012

Implict Fact Column in OBIEE



Implict Fact Column in OBIEE


- 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 created 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