OTBI link Receivables Customer Real Time to Transactions Real Time

Question

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

Bhaskar Konar · Answer

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,

Siddhant Aggarwal-Oracle · Answer

Hi All, Any updates on this ?

RVW · Answer

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