Error U9IM8TAC:OI2DL65P

997766

Hi,

I am facing issue in BI in HCM.

I am new to OBIEE. I am trying to join subject area - Work Relationship Details and Workforce Management - Absence Real Time

This is the error.

You may be able to evaluate this query if you remove one of the following column references: Dim - Absence Type.Absence Type Name, Dim - Assignment Absences Details.Approval Status, Dim - Assignment Absences Details.Approval Status Code, Dim - Assignment Absences Details.Date End, Dim - Assignment Absences Details.Date Start, Dim - Assignment Absences Details.Duration, Dim - Assignment Absences Details.UOM, Dim - Assignment Absences Details.UOM Meaning, Dim - Employee.Assignment ID, Dim - Employee.Employee Name, Dim - Work Relationship Details.Worker Number, Dim - Worker Location.Worker Location Name (HY000)

  Error Details

Error Codes: :U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 14025] No fact table exists at the requested level of detail: [,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Work Relationship Details.Worker Number],,,Dim - Absence Type Detail,[Dim - Assignment Absences Details.Date Start, Dim - Assignment Absences Details.Date End, Dim - Assignment Absences Details.UOM, Dim - Assignment Absences Details.UOM Meaning, Dim - Assignment Absences Details.Approval Status, Dim - Assignment Absences Details.Duration, Dim - Assignment Absences Details.Approval Status Code],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Employee Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,Employee Location Detail,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,]. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - Absence Type.Absence Type Name, Dim - Assignment Absences Details.Approval Status, Dim - Assignment Absences Details.Approval Status Code, Dim - Assignment Absences Details.Date End, Dim - Assignment Absences Details.Date Start, Dim - Assignment Absences Details.Duration, Dim - Assignment Absences Details.UOM, Dim - Assignment Absences Details.UOM Meaning, Dim - Employee.Assignment ID, Dim - Employee.Employee Name, Dim - Work Relationship Details.Worker Number, Dim - Worker Location.Worker Location Name (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Workforce Management - Absence Real Time"."Absence Type"."Absence Type Name" s_1, "Workforce Management - Absence Real Time"."Assignment Absences Details"."Approval Status" s_2, "Workforce Management - Absence Real Time"."Assignment Absences Details"."Date End" s_3, "Workforce Management - Absence Real Time"."Assignment Absences Details"."Date Start" s_4, "Workforce Management - Absence Real Time"."Assignment Absences Details"."Duration" s_5, "Workforce Management - Absence Real Time"."Assignment Absences Details"."UOM" s_6, "Workforce Management - Absence Real Time"."Location"."Worker Location Name" s_7, "Workforce Management - Absence Real Time"."Worker"."Employee Name" s_8, "Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Worker Number" s_9, "Workforce Management - Work Relationship Real Time"."Worker"."Assignment ID" s_10, DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Assignment Absences Details"."Approval Status") s_11, DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Assignment Absences Details"."UOM") s_12 FROM "Workforce Management - Absence Real Time" WHERE (DESCRIPTOR_IDOF("Workforce Management - Absence Real Time"."Assignment Absences Details"."Approval Status") IN ('APPROVED', 'AWAITING', 'DENIED', 'ORA_AWAIT_AWAIT')) FETCH FIRST 75001 ROWS ONLY

Simon.D

Seems like one of the fields you are adding to the query is giving you an error because it cannot be joined to the other subject areas fact table. I would remove each field one-by-one and re-run the query to find out which one is causing the problem. You may have to talk to a developer for this one though to solve it as the problem exists in the repository which you may not have access to.