I new to obiee 11g. I want to create logical tables in BMM layer.
After i want to give joins to them in BMM.
I dont know, how to create logical tables & how give joins to them in obiee 11g?.
Please help me.
Thanks in advance,
The new logical table is a right click on the BMM itself, for the join you generally do it in the Business Model Diagram (again a right click on objects).
It's maybe better if you start from some kind of tutorial to at least have a global overview of what is done where (business layer vs. physical layer etc.).
Have a look at what Oracle has available: Oracle BI EE 11g
And probably this one can be a good start: https://apexapps.oracle.com/pls/apex/f?p=44785:24:0::NO::P24_CONTENT_ID,P24_PREV_PAGE:9787,2