Oracle Analytics and AI

subin sebastian

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

Gayatri Chappalli-Oracle

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