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

Joining two subject areas in fusion SCM OTBI

Received Response
41
Views
1
Comments
subin sebastian
subin sebastian Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

Need to build a dashboard in order to fetch the below information as shown attached. Please let us know how can we achieve the same. Like on hand related information we are getting from Inventory Balance Real Time subject area but how to fetch the remaining columns like invoice related information, pending PO’s and GRN

IMG_0739.jpeg


Answers

  • Gayatri Chappalli-Oracle
    Gayatri Chappalli-Oracle Rank 3 - Community Apprentice

    Hi ,


    Create two Analysis

    1. Item with Onhand Details
    2. Item with Invoice , Pending PO'S

    You can create a common Dashboard prompt and pass Item No to both Analysis in One Dashboard to View as one Page of Information

    Choose to Perform Interaction or Drill down between two ANalysis and achieve this solution in case if two subject areas do not have common dimensions and measures