Question:What is Complex Join and Phyiscal Join in OBIEE?
Answer:
1.Phyiscal Join is used in phyiscal layer and Complex Join in BMM Layer.
2.We can not change any of the table columns of neither logical tables in the join and the expression pane is greyed out.
3.We are able to change the type of join from inner to outer joins.
4.This type of behavior is telling us that complex join is a logical join that OBIEE Server looks at to determine the relationship between logical tables,in other words,it is just a placeholder.
5.Complex Join will be not able to tell the server what phyiscal columns are used in joining,but it will be able to tell the server what type of join this going to be.
We need to look at physical join in the physical layer.
We are able to change the columns under both tables and able to define our own expressions.How ever we can not change the joining method unlike complex join.
This behavior is to help us to know that this is where we tell OBIEE how to join the actual tables by specifying the columns.
Question:Can I use complex join in Physical layer or can I use physical join in BMM Layer?
Answer:
Yes,we can do.
Lets look at complex join in Physical layer.
Although it doesnot happen frequently.It is sometimes needed.Lets say we have 2 tables,Promotion table and Contract date Dimesnion tables.
I want to join these two tables in such way so that only the dates that are still in contract should return.
Having Phyiscal Join in BMM Layer is also acceptable,how ever it is very rare to see that happen.
The purpose of having Physical join in BMM Layer is to override the physical join in physical layer.
It allows users to define more complex joining logic there than they could using physical join in Physical layer,in other words,it works similar to complex join Physical layer.Therefore,if we are already using complex join in Physical layer.
Answer:
1.Phyiscal Join is used in phyiscal layer and Complex Join in BMM Layer.
2.We can not change any of the table columns of neither logical tables in the join and the expression pane is greyed out.
3.We are able to change the type of join from inner to outer joins.
4.This type of behavior is telling us that complex join is a logical join that OBIEE Server looks at to determine the relationship between logical tables,in other words,it is just a placeholder.
5.Complex Join will be not able to tell the server what phyiscal columns are used in joining,but it will be able to tell the server what type of join this going to be.
We need to look at physical join in the physical layer.
We are able to change the columns under both tables and able to define our own expressions.How ever we can not change the joining method unlike complex join.
This behavior is to help us to know that this is where we tell OBIEE how to join the actual tables by specifying the columns.
Question:Can I use complex join in Physical layer or can I use physical join in BMM Layer?
Answer:
Yes,we can do.
Lets look at complex join in Physical layer.
Although it doesnot happen frequently.It is sometimes needed.Lets say we have 2 tables,Promotion table and Contract date Dimesnion tables.
I want to join these two tables in such way so that only the dates that are still in contract should return.
Having Phyiscal Join in BMM Layer is also acceptable,how ever it is very rare to see that happen.
The purpose of having Physical join in BMM Layer is to override the physical join in physical layer.
It allows users to define more complex joining logic there than they could using physical join in Physical layer,in other words,it works similar to complex join Physical layer.Therefore,if we are already using complex join in Physical layer.
