PMO Reports: Data Warehouse Schema

The Data Warehouse Schema report displays the columns of tables and views in the Data Warehouse (DWH) schema. The report includes the column data types, nulls constraints, and comments. The report is grouped by the database table or view. The following image shows the Data Warehouse Schema report with columns and comments.
ccppmop143
The Data Warehouse Schema report displays the columns of tables and views in the Data Warehouse (DWH) schema. The report includes the column data types, nulls constraints, and comments. The report is grouped by the database table or view. The following image shows the Data Warehouse Schema report with columns and comments.
Image displaying the Data Warehouse Schema report with columns and comments
Report Prerequisites
Verify that you have completed the following prerequisites before you run this report:
  • The
    Load Data Warehouse
    job must be run before you run this report. If the Data Warehouse is not populated, the report displays a message that there are no matching records. Also, the report parameter does not display options.
Report Properties
The following values list the report properties:
Name:
Data Warehouse Schema
Resource ID:
CSK_ADM_DataWarehouseSchema
Description:
Administration (PMO Accelerator)
Folder:
CA PPM/Reports/Administration/Data Warehouse Schema
Path:
/ca_ppm/reports/administration/CSK_ADM_DataWarehouseSchema
Data Source:
CA PPM Data Warehouse Bean Data Source
Report Parameter Options
The following table lists the report parameter options.
Prompt Text
Parameter Name
Type
Input Control Name
Input Control Resource ID
Mandatory
Default Value
Data Warehouse Table
dataWarehouseTable
Multiple-select
Query
Data Warehouse Table
dataWarehouseTable
No
UI Theme
ppmUserUITheme
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through
Clarity Project and Portfolio Management (PPM)
Parameter Lookup Values
There are no parameter lookup values for this report.
Parameter Explanations
The following list describes the parameters:
  • The Data Warehouse Table parameter allows you to determine which tables or views display on the report.
Report Fields and Calculations
The report is grouped by the database table or view and displays the columns available to each table or view. The columns on the report include: column, definition, nulls, and comments. The Nulls report column displays Yes when the NOT NULL integrity constraint is specified for the database column, otherwise it displays No.
The report includes custom fields and objects that are marked as Data Warehouse enabled in CA PPM.
Report Security
There is no security inside the report.