Configuring the Application for P6 EPPM Data Source
For a P6 EPPM data source, set up the configuration properties for STARETL runs and OBIEE settings as follows:
- Sign in to the Primavera Analytics Administration Application:
http://<host>:<port>/p6rdb
- In the sidebar, select Status.
- In the Home menu, select a staretl<id> or a <Custom Name of a data source>.
- In the sidebar, select Config.
- For a P6 EPPM data source, set the following properties and then select Save:
Configuration Property | Description |
---|---|
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:
Note: The Primavera Data Warehouse can use two additional financial periods. To add additional financial periods, submit a Service Request to My Oracle Support. |
ODI LoadPlan Auto Restart | Controls restart of all real-time ODI Load plans. Select any of the following values:
|
Enable Resource Assignment Period Actuals | Controls the display of past period actuals for resources. Select any of the following values:
Note: The Primavera Data Warehouse can use two additional financial periods. To add additional financial periods, submit a Service Request to My Oracle Support. |
Enable Relationship load | Controls the ETL from processing activity relationships. Select any of the following values:
|
Turn off all History, keep Slowly Changing Dimensions | Controls history tables. Select any of the following values:
Note: Slowly changing dimensions (SCDs) will continue to be captured at the project level without the history tables.
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:
|
Turn off Resource and Role Limits | Controls resource and role utilization scripts. Select any of the following values:
|
Enabled Spread Snapshot History | Controls the use of spread snapshot history in the advanced analytics dashboard. Select any of the following values:
|
Use project filter in data source 1 | Selects filtered projects only. Select any of the following values:
|
Include Inactive Resources | Controls resource filtration. Select any of the following values:
|
Enable Slowly Changing Dimensions and Spread History | Controls the creation of slowly changing dimensions (SCDs) and spread history. Select any of the following values:
|
Load all Hierarchy Codes | Builds code hierarchies. Select any of the following values:
|
ODI Log Level | Controls the level of detail included in the ODI log files. Select any of the following values:
|
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. Note: Immediate project updates are focused more on the specific scheduling areas of the project – costs, dates, durations. They are geared towards outages or scenarios where live updates are required for short length projects. Immediate project updates should be used sparingly only for a small select group of projects. Not all projects should be set to Immediate, this can have side effects on update frequency and performance. If a project is completed Immediate updates should be turned off. 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, setup the following properties: | |
Mail Prefix | Customize the text that will be displayed in the subject line of email notifications that are sent regarding the status of ETL runs. For example, enter Analytics for status updates on ETL runs in Primavera Analytics. |
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:
|
Send Email Notification | Enter the e-mail IDs of the personnel to be notified regarding the status or issues with the STARETL runs.. Also select the events for which you wish to be notified:
|
Related Topics
Configuring P6 Codes for each Data Source
Configuring P6 EPPM UDFs for each Data Source
Adding Additional Financial Periods
Last Published Thursday, December 14, 2023