Previous	Next		Contents	Index	Navigation	Glossary	Library

Attention: Oracle Project Analysis Collection Pack is not included in, but is additional to, the Oracle Projects product. You cannot use any of the features described in this section unless you have purchased and are a licensed user of Oracle Project Analysis Collection Pack.

Oracle Project Analysis Collection Pack provides multidimensional analysis capabilities for project data. You can create a data warehouse solution using these features in several ways:

• Integrate information in the interface tables provided by Oracle Projects with Oracle Applications Data Warehouse (OADW). OADW automates the design, implementation, and ongoing administration of an enterprise-wide data warehouse or a line-of-business, subject-oriented data mart.

• Access project data warehouse information directly from the interface tables using OLAP tools, such as the Oracle Relational Access Administrator, the Oracle Relational Access Manager, the Oracle Sales Analyzer, or the Oracle Express Analyzer

• Build a custom data warehouse by extracting project information from interface tables into flat files and uploading the information into the data warehouse. You can then analyze the information using OLAP tools, such as the Oracle Express Objects and the Oracle Express Analyzer.

• Analyze actual cost and commitments (including purchase orders, requisitions, and supplier invoices) by the standard dimensions predefined by Oracle Projects, as listed below

• Analyze budgets by the standard Oracle Projects dimensions

• Compare a project's actual costs and commitments with its budgeted costs by the service type dimension to aid in the future control of project costs

• Rank the top or bottom projects across all organizations in your company in terms of the comparison of actual costs and commitments to budgeted costs

• Compare actuals, commitments, and budgets across projects and organizations

• Perform product line analysis to the extent that you model product lines using project classes and categories

• Project

• Resource

• Project organization

• Expenditure organization

• Service type

• Time

• Budget type

• Expenditure type

• Operating unit (if you have implemented multiple organization support)

You can also disable some of the standard Oracle Projects dimensions to accommodate your company's business requirements. For detailed information about customizing your data warehouse data and metadata, refer to the Oracle Project Analysis Collection Pack Implementation Guide.

See Also

Oracle Applications Data Warehouse User's Guide

Oracle Project Analysis Collection Pack Implementation Guide