Ability to Join The Project Costing Commitments Real Time and The Procurement - Purchasing Real Ti

Neil Kaufman

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