You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Cross-Application, Cross-Subject Area OTBI Analysis

Received Response
edited Sep 19, 2016 6:18PM in Reporting and Analytics for ERP 2 comments


Ability to include cross-application analysis within one PPM dashboard


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.


Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!