How to add fusion custom object into OTBI — Oracle Analytics

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

How to add fusion custom object into OTBI

Received Response
41
Views
2
Comments
Suresh0522
Suresh0522 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

An custom object(custom api) was build in cloud Solicitation modules, we want to extract the data from the custom object into on prem data warehouse

and also add this column into existing OTBI subject area.

This custom api stores the data into hz_ref_entities table. Is there an View object for this table?

Answers

  • John Hung-Oracle
    John Hung-Oracle Mod

    Hi, To better serve you, please post this question in the Sales forum or Report and Analytics for Sales forum. Thank you.

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics Coach
    edited Aug 29, 2024 8:02AM

    Hi WJOEV,

    You cannot add custom column to a subject area in OTBI.

    Oracle Transactional Business Intelligence (OTBI) is packaged up in Oracle Fusion Cloud Applications hosted as a Software as a Service. Our vendor Oracle does not give us the administrator privileges to edit the subject areas in the metadata repository database (RPD).

    The only presentation columns we can add to subject areas are by running the biextender scheduled process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" to bring in Key/Extensible/Descriptive Flexible Fields KFF/EFF/DFF that we have configured as BI Enabled.

    For more information see

    Oracle Fusion Cloud Applications
    Creating and Administering Analytics and Reports
    F97246-01 24C

    https://docs.oracle.com/en/cloud/saas/applications-common/24c/faacc/run-the-import-scheduled-process.html

    You can review the data lineage to the subject areas to see what is mapped for use

    https://cloudcustomerconnect.oracle.com/posts/14fdef6ab1

    To "bulk" extract data to an external data warehouse have a look at using a cloud extract in BICC

    Oracle Fusion Cloud Applications
    Creating a Business Intelligence Cloud Extract
    F97245-01 24C

    https://docs.oracle.com/en/cloud/saas/applications-common/24c/biacc/index.html

    To see if a view object exists for your data follow the links in chapter 1 to go to the data lineage sheets

    Review Database Lineage Mappings and View Objects
    https://docs.oracle.com/en/cloud/saas/applications-common/24c/biacc/review-view-object-to-database-lineage-mappings.html#u00180690