Configuring P6 EPPM Data Sources

In the Configurable Properties section, set up the following properties as required:

Custom Name for Datasource

Enter a name for the data source for identification purposes. For example, P6 EPPM Staging Data.

Enable Activity Period Actuals

Controls the display of past period actuals for activities.

Select any of the following values:

• True (default): Enables pay period actuals for activities.
• False: Disables pay period actuals for activities.

Note: Primavera Data Warehouse can use two additional financial periods. To add additional financial periods, submit a service request to Oracle Support.

ODI LoadPlan Auto Restart

Controls restart of all real-time ODI Load plans.

Select any of the following values:

• True (default): Auto restarts ODI load plans for a maximum count of 3 if an initial run fails.
• False: Manually restart is required for all real-time ODI load plans.

Enable Resource Assignment Period Actuals

Controls the display of past period actuals for resources.

Select any of the following values:

• True (default): Enables pay period actuals for resources.
• False: Disables pay period actuals for resources.

Note: The Primavera Data Warehouse can use two additional financial periods. To add additional financial periods, submit a service request to Oracle Support.

Enable Relationship load

Controls the ETL from processing activity relationships.

Select any of the following values:

• True (default): ETL runs will not process relationship loads.
• False: ETL runs will process relationship loads.

Turn off all History, keep Slowly Changing Dimensions

Controls history tables.

Select any of the following values:

• True: Turns off history tables.

Note: Slowly changing dimensions (SCDs) will continue to be captured at the project level without the history tables.

• False (default): Keeps history tables with SCDs.

Note: To delete SCD data for an effective date or a specific date range, contact Oracle Support with a service request.

Disable Rebuild Index

Controls rebuilding of indexes in the cloud database.

Select any of the following values:

• True (default): Does not rebuild indexes. Results in improved performance.
• False: Rebuilds indexes

Turn off Resource and Role Limits

Controls resource and role utilization scripts.

Select any of the following values:

• True: Turn the scripts off.
• False (default): Keeps the scripts running.

Enabled Spread Snapshot History

Controls the use of spread snapshot history in the advanced analytics dashboard.

Select any of the following values:

• True: Enables spread snapshot history.
• False (default): Disables spread snapshot history

Use project filter in data source 1

Selects filtered projects only.

Select any of the following values:

• True: Ensures the next ETL run includes only projects filtered with the ETLFILTER code = ‘’Y’.
• False (default): Does not user project filters

Include Inactive Resources

Controls resource filtration.

Select any of the following values:

• True: Ensures Primavera Data Warehouse tables will not filter out inactive resources.
• Note: If inactive resources are included, then spread data and other dimension tables will also be included. You may not need to process this extra resource assignment information.
• False (default): Filters out inactive resources.

Enable Slowly Changing Dimensions and Spread History

Controls the creation of slowly changing dimensions (SCDs) and spread history.

Select any of the following values:

• True (default) : Capture SCDs and spread history.
• False: Turn off (SCDs) and spread history.

Load all Hierarchy Codes

Builds code hierarchies.

Select any of the following values:

• True: Runs codes_hier.sql script and build code hierarchies with all codes that come from the source.
• False (default): Runs codes_hier_all.sql script and build hierarchies with codes from configStar.

ODI Log Level

Controls the level of detail included in the ODI log files.

Select any of the following values:

• Summary: Displays a summarized content in the log file.
• Detail (default): Displays detailed information in the log file..

Degree of Parallelism for Rebuild Index

Select the number of threads running in parallel for the rebuilding index process.

If you plan to use ODI for projects in real-time, set the following properties to poll for changes in project data in P6 EPPM. The minimum poll interval is 5 minutes, and the maximum is 1440 minutes for all poll interval settings listed below:

ODI Realtime Global Loadplan Poll Interval (in minutes)

Enter the frequency at which changes to global data is to be checked in P6 EPPM and captured in the data warehouse.

By default the poll interval for ODI Realtime Global load plan is set to 10 minutes.

ODI Realtime On Demand Loadplan Poll Interval (in minutes)

The ODI Realtime On Demand Loadplan Poll Interval checks for changes to projects whose Enable Publication flag is selected in P6 EPPM. This process runs when new projects are added and published to the data warehouse by triggering the ODI On Demand load plan to run for the selected projects and include it in the data warehouse.

Enter the frequency in minutes to check for changes to the Enable Publication flag for projects in P6 EPPM and send it to the data warehouse. By default the poll interval for running the On Demand ODI load plan is set to 60 minutes.

At each check, new projects with Enable Publication flag will be added to the data warehouse, and projects whose Enable Publication flag is disabled will be deleted in the data warehouse.

ODI Realtime Project Loadplan Poll Interval (in minutes)

The ODI Realtime Project Loadplan Poll Interval setting checks for changes in current projects in P6 EPPM. This configuration property checks those projects whose Data Warehouse Update Frequency (ODI Only) field is set as Immediate in the Project Preferences dialog box in P6 EPPM.

Enter the frequency in minutes to send changes directly to the data warehouse. By default the poll interval value is set to 1440 minutes (24 hours).

In the OBIEE Settings section set up the following properties:

P6 Base URL

Enter the URL in the following format: http://<host>:<port>/p6

OBIEE Cache Purge

Controls the clearance of OBIEE cache entries.

Select any of the following values:

• True: Clears the OBIEE cache
• False: Retains the cache entries.

Send Email Notification

Enter the e-mail IDs of personnel who are to be notified about STARETL run status or issues. Also select the events for which you wish to be notified:

• Failure: Email notifications sent only for failed ETL runs.
• Success: Email notifications sent only for successful ETL runs.
• Both: Email notifications sent for successful and failed ETL runs.