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 do not have access to this process unless you have purchased and are a licensed user of Oracle Project Analysis Collection Pack.

This process collects information from the Oracle Projects production summarization tables and loads it into dimension and fact interface tables. The process selects data based on the dimensions and measures you define when integrating Oracle Projects with Oracle Project Analysis Collection Pack. This collection process is incremental, which means it loads only information that changed since the last collection process was run.

By default, this process collects dimension and fact table information from the operating unit of the employee submitting the process.

Prerequisite

• Before you run the Collect Dimension and Fact Tables process, you must run the Update Project Summary Amounts process. If you fail to run Update Project Summary Amounts, this collection process will find no data to load into the interface tables.

Process Submission

Process Parameters

Dimension Table. If you enter Yes for the Collect Dimension Tables parameter, enter the name of the predefined or custom dimension table you want to populate or update. If you do not want to collect any dimension information, leave this field blank.

Collect Fact Tables. Enter Yes if you want the Collect Dimension and Fact Tables process to collect information for the fact interface table you select.

Fact Table. If you enter Yes for the Collect Fact Tables parameter, enter the name of the predefined or custom dimension table you want to populate or update.

From Project Number. If you enter Yes for the Collect Fact Tables parameter, enter the number of the project that you want the Collect Dimension and Fact Tables process to use as the low end of the project number range within which it selects projects to process. If you leave this parameter blank, the process selects all eligible projects whose project numbers come before the project number entered in the End Project Number process parameter. You can enter wildcards for this parameter.

Note: You do not need to enter a valid project number in the From/To Project Number fields. This allows you to enter a range that will limit the process to the projects whose information you want to load into interface tables without knowing the actual lowest and highest project numbers that will be selected. See: No List of Values for Project Number Range Parameter.

To Project Number. If you enter a value in the From Project Number field, enter the number of the project that you want the Collect Dimension and Fact Tables process to use as the high end of the project number range within which it selects projects to process. If you leave this parameter blank, the process selects all eligible projects whose project numbers come after the project number entered in the Start Project Number process parameter.