Configuration Settings for Unifier Data Source

For a Unifier data source, set up the configuration properties for STARETL runs and OBIEE settings as follows:

  1. Sign in to the Primavera Analytics Administration Application:

    http://<host>:<port>/p6rdb

  2. In the sidebar, select icon Status.
  3. In the Home menu, select a staretl<id> or a <Custom Name of a data source>.
  4. In the sidebar, select icon Config.
  5. For a Unifier data source, set the following properties and then select Save:

Configuration Property

Description

In the Configurable Settings section, setup the following properties:

Custom Name for Datasource

Enter a name for the data source for identification purposes. For example, Unifier Production Data.

Disable Rebuild Index

Controls rebuilding of indexes in the cloud database.

Select any of the following values:

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

Degree of Parallelism for Rebuild Index

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

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..

Enable Unifier EVM

Controls the usage of Unifier Earned Value Management data.

Select any of the following values:

  • True: Populates the cloud database with EVM data.
  • False (default): Does not populate the cloud database with EVM data. Results in improved performance.

Store Unifier History

Controls Unifier history tables.

Select any of the following values:

  • True (default): Keeps the history tables running.
  • False: Disables all history tables.

If Store Unifier History is set to True, you can set the history levels for the following:

Use P6 project Name for Unifier Project

Controls the source that will be used for naming a Unifier project.

Select any of the following values:

  • True: if the Unifierproject ID is identical in P6 and Unifier, then the project name from P6 will be used for the Unifier project.
  • False: Uses the project name from Unifier.

Unifier BP Data History Level

Controls BP history level.

Select the frequency of BP history tables as Week or Month to capture the history of BP dimensions.

Note: History Level is applicable only for history fact tables like W_BP_HIST_F and W_BP_LINE_HIST_F.

Unifier Level Data History Level

Controls level history (FMRE).

Select the frequency of BP history tables as Week or Month.

Unifier Cash Flow and Cost Sheet Data History Level

Controls the cash flow history and cost sheet history tables.

Select the frequency of history tables as Week or Month.

Unifier Space Data History Level

Controls space history tables. Set this value to Month.

Enable Unifier Slowly Changing Dimensions

Controls the capability to see how business process has changed over time. A business process history can then be generated weekly or monthly. When you select Refresh All, it overwrites all previous history and only the latest history data is made available. Use this setting for Project / Shell, BP and BP Line Items and BP UDFs to generate reports based on historical data.

Select any of the following values:

  • True: Captures history for all projects and business processes. This includes non-dynamic Business process related dimensional data, and dynamic dimensional data for Business process (UDFs) metadata.
  • False: Disables business process history

Unifier Project Shell History Level

Controls project shell history levels. Select the frequency of BP history tables as Week or Month.

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.

Unifier Base URL

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

OBIEE Cache Purge

Controls the clearance of OBIEE cache entries.

Select any of the following values:

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

Send Email Notification On

Enter the e-mail IDs of the personnel to be notified regarding the status or issues with the STARETL runs.. Also select the type of events for which they are 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.


Last Published Friday, July 5, 2024