Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 43 Oracle Analytics and AI Sharing Center
- 19 Oracle Analytics and AI Lounge
- 281 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 106 Oracle Analytics and AI Trainings
- 20 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Joining two subject areas in fusion SCM OTBI
subin sebastian
Rank 1 - Community Starter
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
0
Answers
-
Hi ,
Create two Analysis
- Item with Onhand Details
- 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
0