Primavera Analytics Metrics

The following Primavera Analytics metric data can be displayed in columns of Oracle Enterprise Manager:

• Number of Projects: shows how many projects are in the Primavera Data Warehouse.
• Number of Resources: show the number of resources in Primavera Data Warehouse.
• Number of Rows in Spread Fact tables: shows the row count for all Fact tables.
• Number of Rows in History tables: shows the row count for all Historical tables.
• Number of Rows in SCD tables: shows the row count for all SCD tables.
• Number of projects marked for Activity level: shows the number of projects that have been assigned a history level in P6.
• OBI queries > 1 min: shows the number of times in which OBI queries take longer than one minute to process.
• # of partitions: shows the number of database partitions.