Categories
- All Categories
- 5 Oracle Analytics Sharing Center
- 11 Oracle Analytics Lounge
- 191 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.4K Oracle Analytics Forums
- 5.9K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 66 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
Ability to Join The Project Costing Commitments Real Time and The Procurement - Purchasing Real Ti
Organization Name
Crown Castle
Description
We need the ability to report on Project Commitments/Purchase Order Amounts/Invoice Amounts in one Dashboard
When we join The Project Costing Commitments Real Time and The Procurement - Purchasing Real Time Subject Areas as well as the AP Invoice Subject Areas. The Analyses created with multiple subject areas will not error out but will return erroneous results as the result of a cartesian product.
Use Case and Business Need
Users need that ability to report on Project Commitments / Purchase Orders and AP Invoices in a single analyses. Crown Castle's Business relies heavily on reporting on open commitments. A Dashboard has been created that is being utilized by a large portion of the business and without the ability to report properly on Project Commitments / Purchase Orders and AP Invoices the Dashboard loses its reliability.
We have created LSQL to work around portions of this defect but it is very slow, cumbersome to maintain and does not meet all the business requirements
Original Idea Number: 02a9abcd30
Comments
-
Costing and Purchasing - an obvious combination that is needed.
1 -
Agreed, many industries would benefit from the level of visibility into project PO commitments that this would enable. So many other OTBI areas can join where there's a common dimension, why not these two?
Glen
1 -
Have you looked at Budgetary Control as a possible source?
0