Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

OTBI link Receivables Customer Real Time to Transactions Real Time

Received Response
214
Views
4
Comments
3579558
3579558 Rank 1 - Community Starter
edited Oct 6, 2023 3:39PM in Oracle Transactional Business Intelligence

Hi-

Financials Receivables Cloud BI

Using the Real Time Subject Areas how can I get a list of all Customers & their Details (Sites, Accounts, Contacts, Addresses) and determine if each has any Transaction against it?

In OTBI or BI Answers I am including Customer - Name, Registry ID & Count Total # of Accounts and Transaction - Bill To Name, Bill To Number & Transaction Sum(Entered Amount) in the columns.   When I look at the query in Advanced I don't see a join between the two SA's in the WHERE clause, and the output corresponds to that.  When I try to force the join in Advanced - Apply SQL I get

Invalid SQL Identifier: "Receivables - Customer Real Time"."Customer Information"."Customer Number" = "Receivables - Transactions Real Time"."- Bill-to Customer Details"."Bill-to Customer Number"

When I add more of the details that I want in Customer, I get an error [nQSError: 14025] No fact table exists at the requested level of detail

The main purpose is data clean up;  for example we are trying to identify duplicate customers and determine if one or both have transactions in order to determine corrective action. 

Thanks-

Tara

Answers

  • Vinothkumar Somasundaram
    Vinothkumar Somasundaram Rank 1 - Community Starter

    We are also facing same issue. Any resolution you got

  • RVW
    RVW Rank 1 - Community Starter

    We are facing the same issue. Have you found a solution/work around?

  • Siddhant Aggarwal-Oracle
    Siddhant Aggarwal-Oracle Rank 1 - Community Starter

    Hi All, Any updates on this ?

  • Bhaskar Konar
    Bhaskar Konar Rank 8 - Analytics & AI Strategist

    Hi,

    Please find below the Best practices that need to be considered while developing a report using more than one subject areas.

    • You should have common dimension in the subject areas used in the report.
    • Add at least one Measure/Fact/Metric from each subject area on the report.
    • Click on the Advance tab of the Analysis report --> Scroll down till you see Advance SQL clause --> Check the Dimensionality check box --> click on Apply SQL button.
    • Go to the Results tab and test the results.

    Additional things that need to be considered:

    • You also need to consider the lowest grain at which the Subject Areas built.
    • More them one subject area reports are complex reports, apply proper filters on the report.
    • How to debug the issue:
      • create a simple report with one subject area, remember to add as many dimension columns from first SA and add at least one measure. Apply filters.
      • Add second subject area add required dimension columns and don't forget to add measure.
        (These Guidelines Apply to current FA/OTBI Custom Analysis requirements.)

    Please follow cross subject area guidelines as documented in : Creating and Administering Analytics and Reports > How Data Is Structured for Analytics

    https://docs.oracle.com/en/cloud/saas/applications-common/24d/faacc/how-data-is-structured-for-analytics.html#Columns

    Hope this help.

    Cheers,