PMO Reports: Data Warehouse Schema

ccppmop1591
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:
 
Clarity
/Reports/Administration/Data Warehouse Schema
 
Path:
 /ca_ppm/reports/administration/CSK_ADM_DataWarehouseSchema
 
Data Source:
 
Clarity
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 
Classic PPM
 
Language
ppmUserLanguage
Hidden
Not applicable
Yes
Passed through 
Classic PPM
 
User ID
ppmUser
Hidden
Not applicable
Yes
Passed through 
Classic 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
Clarity
.
 
Report Security
 
There is no security inside the report.