How to create a direct database query with OTBI?

Within Oracle Fusion OTBI go to New > Analysis and click on Create Direct Database Query:

image

Within the Editor the connection Pool information needs to be entered:

image

The following connection pools can be entered:

  • HCM – ”HCM_OLTP”.”Connection Pool”
  • CRM – “CRM_OLTP”.”Connection Pool”
  • FIN and PROC – “FSCM_OLTP”.”Connection Pool”

Please note: when copying&pasting the connection pool names, there may be an issue with the double quotes and you may need to re-type the double quotes.

After that, a query may be entered for direct database execution on the Oracle Fusion Cloud (bundled) Database (identified by the Connection pool supplied before):

image

For a listing of all Physical Tables please refer to (only available for HCM): https://cloudcustomerconnect.oracle.com/posts/ac54c31fcf

This contains a Excel mapping with the Physical OTBI Tables:

image

 

For a full support note please refer to: How To Create A Report with Direct Database Query in OTBI/OBIEE Analysis, Who Can Access Direct Database Query (Doc ID 2141412.1)

For a similar approach using BI Publisher please check:  Creating a BI Publisher Report using SQL Query in Oracle Fusion HCM Cloud

To check the general TechNote for OTBI and Fusion HCM, please refer to: Oracle Fusion HCM: Resources for Oracle Transactional Business Intelligence (Doc ID 2023155.1)

Advertisements

1 thought on “How to create a direct database query with OTBI?

  1. When copying & pasting the Connection Pool from WordPress to BICS, the double quotes might not be correct. You may need to replace with a manual entering of the double quote ” from the keyboard..

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.