My Oracle Support Banner

Unifier Staging Tables Utilized By The Analytics Publication For Usage With Data Warehouse / Analytics (Doc ID 2338537.1)

Last updated on APRIL 30, 2018

Applies to:

Primavera Unifier Cloud Service - Version 17.11.0.0 and later
Primavera Analytics Cloud Service - Version 17.11.0.0 and later
Information in this document applies to any platform.

Goal

The purpose of this document is to define what staging tables are utilized by the Analytics publication within Unifier for integration with Primavera Data Warehouse / Primavera Analytics. 

For example:
1. Login to Unifier
2. Select Company Workspace > Analytics node
3. For the business objects listed (Business Processes, Cash Flow, Cost Sheet, P6 Summary Sheets, Shells, Space Manager, Vendors), what Unifier tables are populated to hold the data?

This information is provided for informational purpose only. 

  • Direct updates to the tables (for example, updating directly through SQL*Plus or SQL Developer) are not supported. 
  • Data population in the staging tables are supported through the Analytics publication process within Unifier only.

For context around the Analytics integration with Unifier:

  1. Browse to the Unifier OTN site:  https://docs.oracle.com/en/industries/construction-engineering/primavera-unifier/index.html
  2. Click the documentation library link for your release of Unifier.
  3. In the Unifier OTN for your release, expand Administration
  4. Select the Administrator Guide link, and open within HTML or PDF.
  5. Within the Administrator Guide, browse to: Unifier Administrator Mode > Unifier and Other Oracle Applications > Unifier and Primavera Analytics

Solution

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.