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