Oracle Transactional Business Intelligence Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› More Solutions› Oracle Transactional Business Intelligence Forum

Categories

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

Feasibility to fetch lookup values in OTBI reports

Received Response
443
Views
1
Comments
akash-mishra-a2a51b90
akash-mishra-a2a51b90 Rank 1 - Community Starter
in Oracle Transactional Business Intelligence Forum

We have a requirement to pull employee name in the OTBI report if the DFF field has employee number . Does OTBI support this scenario to fetch lookup values into the report?

Answers

  • Nathan CCC
    Nathan CCC Rank 7 - Analytics & AI Coach
    edited Jun 7, 2023 3:57PM

    Yes OTBI has the capability to get data from additional information fields. When you configure the descriptive flexible field you must set "BI Enabled" = True. You must also run the biextender scheduled process "Import Oracle Fusion Data Extensions for Transactional Business Intelligence" with parameter HCM so that the system can update the metadata repository database (PRD) to add the attribute presentation columns for the DFFs into all the subject areas so that you can use them in your logical queries. If the DFF is configured as a lookup then you will get both a code and a description presentation column created in the subject area. So expect the code presentation column will have the person number and the description presentation column will have the person name.