Abstract: Described herein is a framework for providing data model views with complex calculation capability. In accordance with one aspect, the framework receives a request to calculate target results. An object in an application layer may be invoked to perform complex calculation to generate intermediate results. The intermediate results are stored in a global temporary table. A data model view in a database layer may then be invoked to calculate the target results based on the intermediate results retrieved from the global temporary table. The calculated target results are then returned.

Abstract: Described herein is a framework for providing data model views with complex calculation capability. In accordance with one aspect, the framework receives a request to calculate target results. An object in an application layer may be invoked to perform complex calculation to generate intermediate results. The intermediate results are stored in a global temporary table. A data model view in a database layer may then be invoked to calculate the target results based on the intermediate results retrieved from the global temporary table. The calculated target results are then returned.

Abstract: Methods and system are disclosed that generate forecasting information by aggregating data. In one aspect, an enterprise application may receive a request for a requisition from an operational process. A commitments management application associated with the enterprise application may generate commitment corresponding to the requisition. Data such as operational data, planning data and document data may be aggregated from different data stores. A report including the aggregate data may be generated that may provide forecasting information for an enterprise.