Merging two reports

User_O3GFE

Hi everyone,

I have two separate reports that I would like to run. Both run fine on their own, but when adding all the columns to one of the reports I get multiple errors and it will not work. I've watched many YouTube videos, specifically this one, Reporting using more than one Fusion OTBI subject area - YouTube

I did everything in this video. I have a measure that is in both subject areas and I submitted the dimensional SQL code. Below are the errors. Does anyone know what I can do or can reference another YouTube video?

Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 43119. [nQSError: 43119] Query Failed:

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 14025. [nQSError: 14025] No fact table exists at the requested level of detail: [left(Dim - AP Account.Concatenated Segments , 4)],[Dim - AP Transaction Status.Invoice Status Type Name],[Dim - AP Disbursement Details.Pay Doc Payment Document Name, Dim - AP Disbursement Details.Check Date, Dim - AP Disbursement Details.Status Meaning, Dim - AP Disbursement Details.Check Status lookup Code, Dim - AP Disbursement Details.Check Number],,

,,,,,Details,,,,,[Dim - AP Transaction Details.Invoice Number, Dim - AP Transaction Details.Type1099, Dim - AP Transaction Details.Invoice Entered Date, Dim - AP Transaction Details.Invoice Date, Dim - AP Transaction Details.Invoice ID Drill],,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,[Dim - Supplier Sites.Site Address Address Line 1, Dim - Supplier Sites.Site Address Postal Code, Dim - Supplier Sites.Site Address Address Line 2, Dim - Supplier Sites.Site Address Address Line 3, Dim - Supplier Sites.Site Address Address Line 4, Dim - Supplier Sites.Site Address City, Dim - Supplier Sites.Site Address State, Dim - Supplier Sites.Site Address Country],,

[Dim - Supplier.Supplier Number, Dim - Supplier.Supplier Name, Dim - Supplier.Tax Payer ID, Dim - Supplier.Tax Organization Type, Dim - Supplier.SupplierOrganizationTypeLookupCode],,,,,

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 14025. ,

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 14025.

Please have your System Administrator look at the log for more details on this error. (HY000)

State: HY000. Code: 14081. [nQSError: 14081] You may be able to evaluate this query if you remove one of the following column references: Dim - AP Disbursement Details.Check Date, Dim - AP Disbursement Details.Check Number, Dim - AP Disbursement Details.Check Status lookup Code, Dim - AP Disbursement Details.Pay Doc Payment Document Name, Dim - AP Disbursement Details.Status Meaning, Dim - AP Transaction Details.Invoice Date, Dim - AP Transaction Details.Invoice Entered Date, Dim - AP Transaction Details.Invoice ID Drill, Dim - AP Transaction Details.Invoice Number, Dim - AP Transaction Details.Type1099, Dim - AP Transaction Status.Invoice Status Type Name, Dim - Business Unit.Business Unit Key, Dim - Supplier Sites.Site Address Address Line 1, Dim - Supplier Sites.Site Address Address Line 2, Dim - Supplier Sites.Site Address Address Line 3, Dim - Supplier Sites.Site Address Address Line 4, Dim - Supplier Sites.Site Address City, Dim - Supplier Sites.Site Address Country, Dim - Supplier Sites.Site Address Postal Code, Dim - Supplier Sites.Site Address State, Dim - Supplier.Supplier Name, Dim - Supplier.Supplier Number, Dim - Supplier.SupplierOrganizationTypeLookupCode, Dim - Supplier.Tax Organization Type, Dim - Supplier.Tax Payer ID, left(Dim - AP Account.Concatenated Segments , 4)

Please have your System Administrator look at the log for more details on this error. (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1',ENABLE_DIMENSIONALITY=1;SELECT 0 s_0, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Date" s_1, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice Entered Date" s_2, "Payables Invoices - Transactions Real Time"."- General Information"."Invoice ID" s_3, "Payables Invoices - Transactions Real Time"."- Invoice Line Details - Income Tax and Withholding Information"."Type1099" s_4, "Payables Invoices - Transactions Real Time"."- Reference Information"."Payment Status Name" s_5, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 1" s_6, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 2" s_7, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 3" s_8, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Address Line 4" s_9, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address City" s_10, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Country" s_11, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address Postal Code" s_12, "Payables Invoices - Transactions Real Time"."- Supplier Site Location Details"."Site Address State" s_13, "Payables Invoices - Transactions Real Time"."Business Unit"."Business Unit Name" s_14, "Payables Invoices - Transactions Real Time"."Business Unit"."Default Legal Entity Name" s_15, "Payables Invoices - Transactions Real Time"."Supplier"."Supplier Name" s_16, "Payables Invoices - Transactions Real Time"."Supplier"."Supplier Number" s_17, "Payables Invoices - Transactions Real Time"."Supplier"."Tax Organization Type" s_18, "Payables Invoices - Transactions Real Time"."Supplier"."Tax Payer ID" s_19, "Payables Payments - Disbursements Real Time"."- General Information"."Invoice Number" s_20, "Payables Payments - Disbursements Real Time"."- Other Information"."Pay Doc Payment Document Name" s_21, "Payables Payments - Disbursements Real Time"."- Payment Information"."Check Date" s_22, "Payables Payments - Disbursements Real Time"."- Payment Information"."Check Number" s_23, "Payables Payments - Disbursements Real Time"."- Payment Information"."Payment Status" s_24, "Supplier - Supplier Real Time"."- Income Tax"."Federal Reportable" s_25, "Supplier - Supplier Real Time"."- Income Tax"."Supplier Income Tax type" s_26, DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."Business Unit"."Business Unit Name") s_27, DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."Supplier"."Tax Organization Type") s_28, DESCRIPTOR_IDOF("Payables Payments - Disbursements Real Time"."- Payment Information"."Payment Status") s_29, left("Payables Invoices - Transactions Real Time"."- Distribution Combination"."Concatenated Segments",4) s_30, "Payables Invoices - Transactions Real Time"."- Invoice Amounts"."Invoice Amount" s_31, "Payables Payments - Disbursements Real Time"."- Invoice Installment Amounts"."Payment Amount" s_32, "Payables Payments - Disbursements Real Time"."- Payments Accounting"."SLA Unrounded Accounted Amount Credit" s_33 FROM "Payables Invoices - Transactions Real Time" WHERE ((DESCRIPTOR_IDOF("Payables Invoices - Transactions Real Time"."Business Unit"."Business Unit Name") = 300000028208707) AND ("- Reference Information"."Payment Status Name" IN ('Fully paid', 'Partially paid'))) FETCH FIRST 250001 ROWS ONLY

Christian Berg-0racle

Looking at what you posted I see no indication as to the fact that you're really working on "reports".

"Reports" are objects created and managed by BI Publisher.

OBIEE / OAS Answers creates and manages "Analyses".

Technically and technologically two different things.

User_O3GFE

@Christian Berg-0racle Hi thank you for the response. You are correct I am working on analyses and not reports. I am still not sure what to do

Christian Berg-0racle

You can't just randomly combine subject area content. The error message is very clear: The engine isn't capable of navigating the dimensionality across a fact table. The model (RPD) simply doesn't support what you are trying to do.

You'd need to clean and correct the RPD first to make this work.

Christian Berg-0racle

@User_O3GFE Did you give up on this topic or was it resolved?

User_GV5MG

https://community.oracle.com/tech/apps-infra/discussion/comment/16822534#Comment_16822534

Hi Christian, How to make it work when you don't have admin rights?

From what I understood, columns from different tables in the subject area can't be combined due to not being mapped together in the repository. Is my understanding correct?

Secondly, Subject Areas are not the module, right? how can I know all the modules and tables through OBIEE?

Christian Berg-0racle

Simple: You don't because you can't.

It's like asking how to change the performance of your car when not having access to the engine, the gearbox, the chassis or anything.

"not being mapped together" is basically correct, but the details are a bit more elaborate - just ask @Gianni Ceresa

And I don't understand what you mean by "Module". What's a "module" to you in this context?