Since 2010, OraERP is a Oracle Forums, Community of Oracle Professionals including Fusion/Cloud Application Consultants, Enterprise Architects, ERP Cloud, HCM Cloud, CX Cloud and OCI Experts, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Digital Architect, PaaS Experts, IaaS, OCI Architects, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple. Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips .
Thread Rating:
  • 9 Vote(s) - 3.44 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Business Intelligence EE error
12-03-2014, 08:02 PM,
#1
Oracle Business Intelligence EE error
Getting following error, help require ............
BUSINESS MODEL Core:
[39008] Logical dimension table Clients has a source Client Company(W_ORG_D) that does not join to any fact source.
[39008] Logical dimension table Need Last Discussion (W_LOV_D) has a source Need Last Discussion (W_LOV_D) that does not join to any fact source.
[39008] Logical dimension table Recovery Date (W_DAY_D) has a source Recovery Date (W_DAY_D) that does not join to any fact source.

BUSINESS MODEL Usage Tracking:
[39008] Logical dimension table Calendar has a source NQ_CALENDAR that does not join to any fact source.

BUSINESS MODEL Core New:
[39008] Logical dimension table Clients has a source Client Company(W_ORG_D) that does not join to any fact source.
[39008] Logical dimension table Need Last Discussion (W_LOV_D) has a source Need Last Discussion (W_LOV_D) that does not join to any fact source.
[39008] Logical dimension table Recovery Date (W_DAY_D) has a source Recovery Date (W_DAY_D) that does not join to any fact source.
Reply
12-04-2014, 08:53 PM,
#2
RE: Oracle Business Intelligence EE error
Please review this MOS note:
Error: "[39008] Logical dimension table COMPONENT_CODE has a source 'XYZ' that does not join to any fact source." Importing Essbase Cube Into Repository (Doc ID 746919.1)
Reply
01-09-2017, 05:03 PM,
#3
RE: Oracle Business Intelligence EE error
I got this business model error.
[39008] Logical dimension table MyDimension has a source MyDimensionSource that does not join to any fact source.

Is anyone helping me to get out this problem?
Reply
01-09-2017, 11:20 PM,
#4
RE: Oracle Business Intelligence EE error
(01-09-2017, 05:03 PM)If you get the warning: OBIEE Error 39008: Logical dimension table XXX has a source that does not join to any fact sources. Check if there is physical and logical join exits and the granularity between dimension and fact tables are same. Wrote: The Content Level of DIM and FACT LTS should be same as the logical join occurs at the same grain.
Another trick to fix the above error, is to change the logical level to column in fact table LTS under content tab aggregation content, group by section.
[Image: 39008-1.jpg?w=438&h=134]
Change the logical level to Column in all the fact tables. Click ok and check the global consistency check.
[Image: 39008-2.jpg?w=432&h=111]
All the 39008 error will be gone. Again revert back the aggregation content, group by to Logical level, save the RPD and once again check the global consistency check, you should not see such warnings.
Reply


Possibly Related Threads…
Thread Author Replies Views Last Post
  error starting discoverer 10g Arshad Ch 1 3,135 12-25-2014, 11:26 PM
Last Post: Hassanmalik
  Flash demo on Location Intelligence in Oracle BIEE 11g admin 0 4,057 03-15-2011, 09:12 PM
Last Post: admin



Users browsing this thread: 2 Guest(s)