Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, 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, Simple and Absolutely Free.

Thread Rating:
  • 3 Vote(s) - 3.67 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Oracle Business Intelligence EE error
#1
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
Thanks given by:
#2
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
Thanks given by:
#3
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
Thanks given by:
#4
(01-09-2017, 04: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
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  error starting discoverer 10g Arshad Ch 1 807 12-25-2014, 10:26 PM
Last Post: Hassanmalik
  Flash demo on Location Intelligence in Oracle BIEE 11g admin 0 2,230 03-15-2011, 08:12 PM
Last Post: admin



Users browsing this thread: 1 Guest(s)
OTech Talks, Lets Talk OPEN! Get Oracle Tutorials, Tips! Post a Question!