This content has been marked as final. Show 6 replies
You have to use Foreign key join in BMM layer. Looks like you are using complex join in BMM layer.
Appreciate if you mark as correct else let me know.
Edited by: Srini VEERAVALLI on Jan 18, 2013 10:47 AM
In OBIEE11g, in BMM.. the join icon seems to be for a Logical Join... In 10g there were 2 buttons.
Pls. how to include the FK join in BMM ?
Use menu for the same: Manage->Business Model and Mapping.
Thanks so much Srini for your kind reply!!
It shows the list of relationship.But ,the areas are grayed out in 11g to change the join relationship.
However, the column that we use for new physical join condition is calculated logical column.
Txs. Srini... I just would like to add... that to allow the Logical FK join, one should go to Tools > Options in adm tool and allow the FK join...
See you have to delete the existing join to create Logical foreign key join in BMM layer using Manage->Joins
You can go with joins with logical columns too.. works well.
If need send me an email with screenshots
@Antonio: Yeah.. that option need to check. I remember I've answered same question long back to some one.. the option was checked in my rpd and ignored to mention. Thanks for update back.
Edited by: Srini VEERAVALLI on Jan 18, 2013 11:21 AM