1 2 Previous Next 17 Replies Latest reply: Jul 18, 2010 6:10 AM by 631713 RSS

    Illegal cross join within the same dimension caused by incorrect subject ar

    582574
      hi!

      Imagine the following BMM:

      There is one Logical Dimension Table "Service Account" with the following LTS:

      - LTS "D_SERVICE"
      - LTS "D_SERVICE_CLASS"
      - LTS "D_SERVICE_STATUS"

      This Logical Tabe "Service Account" joins (One-to-many) with several Fact Tables (other Logical Tables).

      In the Physical Layer the joins for the "Service Account" LTS are:
      - One-to-many between D_SERVICE_CLASS and D_SERVICE
      - One-to-many between D_SERVICE_STATUS and D_SERVICE

      The problem is that when I build a report in Answers using only the following columns of the Logical Table "Service Account":

      - Service Class Desc (which exists in the Logical Table "Service Account" and in the Physical Table D_SERVICE_CLASS)
      - Service Status Desc (which exists in the Logical Table "Service Account" and in the Physical Tabl D_SERVICE_STATUS)
      - MSISDN (which existis in the Logical Table "Service Account" and in the Phsyical Table D_SERVICE)

      the following error appears:
           
      Estado: HY000. Código: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 14065] Illegal cross join within the same dimension caused by incorrect subject area setup: [ (select * from prd.D_SERVICE where SOURCE_SYS in ('ARBOR','PPB') and DW_SERV_ST_ID in (100000003,100000009)) as T1836, D_SERVICE_CLASS T1916] with [ D_SERVICE_STATUS T1948] (HY000)

      SQL emitido: SELECT "SERVICE ACCOUNT"."TLC MSISDN9" saw_0, "SERVICE ACCOUNT"."IWS Service Class Desc" saw_1, "SERVICE ACCOUNT"."TLC Service Status Desc" saw_2 FROM "VFPT - Upgrade Siebel" WHERE "SERVICE ACCOUNT"."TLC MSISDN9" = '917330340' ORDER BY saw_0, saw_1, saw_2

      Help, please!


      Thanks.
        1 2 Previous Next