Cross-Application, Cross-Subject Area OTBI Analysis
Summary
Ability to include cross-application analysis within one PPM dashboardContent
I have a requirement to build a Project Portfolio Management dashboard in OTBI. Most of the content in the dashboard comes from Projects subject areas such as Budgets, Forecasts, and Costs. Therefore prompts and drilldowns to further Projects details works as desired. There is an additional requirement to include comparisons of purchase orders issued vs purchase order invoice payments by project. The Projects subject areas do not contain this detailed information. It is contained in the Procurement and Payables subject areas.
I can create a comparison using an analysis based on a union of two dissimilar subject areas (Procurement and Payables). However, the main dashboard prompt that selects the individual Project Number to display in the individual dashboard analyses is not passing into this newest analysis. So all the Project based analyses in the dashboard show the one Project Number's data but this new analysis shows ALL Project Numbers' data - no Project Number filtering is taking place based on the dashboard prompt. I've read that prompts cannot be used in Union analyses, so that could be part of the problem.