1 Reply Latest reply: Jul 19, 2012 1:46 PM by Hussein Sawwan-Oracle RSS

    39008 error in OBIEE

    950572
      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
          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