Where can I find the tables in the DWH?

Products

• Clarity PPM SaaS

Issue/Introduction

The schemas can be found for each version of Clarity under Reference/Clarity Advanced Reporting and Database Schema Index.

On this link you will be able to download the various schemas.

 

Here is the link to the 15.9.3 version

https://techdocs.broadcom.com/content/dam/broadcom/techdocs/us/en/dita/ca-enterprise-software/business-management/clarity-project-and-portfolio-management-ppm/ccppmop1593/assets/1591_Postgres_Database_Schema.zip

In addition there is a Jaspersoft report you can run and can filter for specific tables as well. That report information is found in the documentation under

Advanced Reporting with Jaspersoft / PMO Accelerator Advance Reporting Content / PMO reports: Administration Reports - -

The Data Warehouse as well as the Clarity schemas are available here.

 

Environment

Release : 15.9.3

Component : CLARITY JASPERSOFT

Resolution

Schemas can be found in the documentation