Reporting and Analytics for ERP

Get Involved. Join the Conversation.

Topic

    Paul Holmes
    AR Account Profile Class
    Topic posted September 4, 2019 by Paul Holmes, tagged Fusion Financial reporting, OBIEE Answers, OTBI, Reports 
    44 Views, 2 Comments
    Title:
    AR Account Profile Class
    Summary:
    Linking 2 AR Subject Areas.
    Content:

    The AR Account Profile Class is not available in the 'Receivables - Payment Schedules Real Time' subject area (19C) and it is only available in ''Receivables - Customer Real Time' subject area.

    I am struggling to include "Receivables - Customer Real Time"."Profile Class"."Account Profile Class" field into OTBI analytic where the main subject area is 'Receivables - Payment Schedules Real Time' (or even any other AR subject areas).

    I've tried ticking the Dimensionality box and clicking on Apply SQL in thee Advance tab; this doesn't work even though I has both dimension and fact fields included.

    I've tried applying new SQL via the "New Analysis" on the Advanced tab for the following two SQL test scripts and they both failed.  Can anybody help?

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT
       0 s_0,
       "Receivables - Payment Schedules Real Time"."Bill-to Customer Account"."Bill-to Customer Account Number" s_1,
       "Receivables - Payment Schedules Real Time"."Payment Schedules"."Entered Amount Due Original" s_2
       "Receivables - Customer Real Time"."Profile Class"."Account Profile Class" s_3,
       "Receivables - Customer Real Time"."Count"."Total Number of Accounts" s_4
    FROM "Receivables - Payment Schedules Real Time" LEFT OUTER JOIN "Receivables - Customer Real Time" ON "Receivables - Payment Schedules Real Time"."Bill-to Customer Account"."Bill-to Customer Account Number" = "Receivables - Customer Real Time"."Customer Account Details"."Customer Account Number"

    ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

    SELECT
    SubjectArea2.s2_1 s2_1,
    SubjectArea1.s_1 s_1,
    SubjectArea1.s_2 s_2,
    SubjectArea2.s_8 s_8
    FROM
    (
    SELECT
    "Receivables - Payment Schedules Real Time"."Bill-to Customer Account"."Bill-to Customer Account Number" s_1,
       "Receivables - Payment Schedules Real Time"."Payment Schedules"."Entered Amount Due Original" s_2
    FROM "Receivables - Payment Schedules Real Time"
    WHERE
    )SubjectArea1 LEFT OUTER JOIN
    (
    SELECT
    "Receivables - Customer Real Time"."Customer Account Details"."Customer Account Number" s2_1,
    "Receivables - Customer Real Time"."Customer Information"."Customer Name" s_8,
    "Receivables - Customer Real Time"."Profile Class"."Account Profile Class" s_9,
    "Receivables - Customer Real Time"."Count"."Total Number of Accounts" s_11
    FROM "Receivables - Customer Real Time"
    )SubjectArea2
    ON SubjectArea1.s_1 = SubjectArea2.s2_1
    ORDER BY s2_1

     

    Version:
    19C

    Comment