Configuring the Application for Unifier Data Source
For a Unifier 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 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:
| ||
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:
| ||
Enable Unifier EVM | Controls the usage of Unifier Earned Value Management data. Select any of the following values:
| ||
Store Unifier History | Controls Unifier history tables. Select any of the following values:
| ||
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:
| ||
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:
| ||
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:
| ||
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:
|
Last Published Thursday, December 14, 2023