Home » Fusion Middleware & Colab Suite » Business Intelligence » BMM Layer (OBIEE 11g)
BMM Layer [message #588002] Wed, 19 June 2013 23:19 Go to next message
mary.yujin
Messages: 26
Registered: June 2010
Junior Member
I am a beginner in OBIEE. I have added 8 tables in physical layer and updated the physical diagram also. Tables are as follows

1) Group Master 2) Item Master 3) Requisition Master 4) Requisition Detail 5) Purchase Master 6) Purchase Detail 7) Material Receipt Master Cool Material Receipt Detail.

I just dragged Item Master to BMM Layer and then added group master to the logical table of Item Master and saved. When i checked the global consistency, i got error message "Logical table is not found"

Can you advise me ?
Re: BMM Layer [message #594146 is a reply to message #588002] Sat, 24 August 2013 00:36 Go to previous messageGo to next message
csreenivasg
Messages: 3
Registered: August 2013
Junior Member
As per your description, you have not created a logical join in the BMM layer. This could be a source of problem you mentioned.
Re: BMM Layer [message #594269 is a reply to message #594146] Tue, 27 August 2013 02:34 Go to previous messageGo to next message
mary.yujin
Messages: 26
Registered: June 2010
Junior Member
Already created Join in physical Layer. So again it is to be created in BMM layer. If yes, please advise me how to do that.
Awaiting your reply
Re: BMM Layer [message #594368 is a reply to message #594269] Wed, 28 August 2013 00:07 Go to previous messageGo to next message
csreenivasg
Messages: 3
Registered: August 2013
Junior Member
Yes, you need to build joins in BMM layer as well. Select all the tables of interest and go for generating joins based on a star schema (fact table directly joined to all dimension tables.) concept.
Re: BMM Layer [message #601354 is a reply to message #594368] Tue, 19 November 2013 23:31 Go to previous message
mary.yujin
Messages: 26
Registered: June 2010
Junior Member
Thank you
Previous Topic: Invoking BI Publisher reports
Next Topic: Can I force uppercase on dashboard prompt value entry?
Goto Forum:
  


Current Time: Thu Mar 28 11:23:18 CDT 2024