This discussion is archived
1 Reply Latest reply: Jul 19, 2012 11:46 AM by Hussein Sawwan-Oracle RSS

39008 error in OBIEE

950572 Newbie
Currently Being Moderated
I get the belo warningmesage which is not consistent. I have 7 warnings realted to this kind of issue.


WARNINGS:




WARNINGS:


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.
  • 1. Re: 39008 error in OBIEE
    Hussein Sawwan-Oracle Employee ACE
    Currently Being Moderated
    Please see these docs.

    Error: "[39008] Logical dimension table COMPONENT_CODE has a source 'XYZ' that does not join to any fact source." Importing Essbase Cube Into Repository [ID 746919.1]
    DAC: Inactive tables (W_PERSON_D; W_ORG_D) and missing from Oracle Business Analytics Data Warehouse [ID 963369.1]

    Thanks,
    Hussein

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points