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