Repository Guide

10.5
- 10.5.7
- 10.5.6
- 10.5.4
- 10.5.1
- 10.4.0

Back Next

PowerCenter Reports

The PowerCenter repository is a relational database managed by the PowerCenter Repository Service. You can run reports on the PowerCenter repository to find out information such as the objects used in a mapping, sessions statistics, and version and deployment information.

The following table describes the PowerCenter Repository Reports:

Report Name	Report Folder Path	Report Description
All Object Version History	Public Folders\PowerCenter Repository Reports\Configuration Management\Object Version	Displays all versions of an object by the date the object is saved in the repository. This is a stand-alone report.
All Objects Used in a Mapping	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays source, targets and all transformations used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
All Objects Used in a Mapplet	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all transformations used in a mapplet by repository and folder. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
All Objects Used in a Mapplet	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This is a subreport in the Mapplet Composite Report. This report displays all transformations used in a mapplet by repository and folder.
Average Load Times (Last Month)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by repository and month, the average load times for all sessions from a particular folder , that ran during the prior month. This cached report is attached to the Monthly schedule, where it runs on the first day of every month.
Connection Usage	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the total number of executed sessions associated with each connection by repository. It also displays the type of connection, such as relational, FTP, and Queue. This is a primary report in an AW, attached to the Midnight Daily schedule.
Connection Usage Details	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays sessions associated with a particular connection by repository by folder. This report is the first node in the analytic workflow associated with the Connection Usage primary report.
Currently Active Sessions by Server	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the total number of sessions currently running by PowerCenter Server. This cached report is attached to the 5 Minute Refresh schedule, which refreshes every 5 minutes.
Deployment Details	Public Folders\PowerCenter Repository Reports\Configuration Management\Deployment	Displays, by group name, type, and creator, the details of the deployed objects by a particular deployment group. This report is the first node in the analytic workflow associated with the Deployment Group History primary report.
Deployment Group	Public Folders\PowerCenter Repository Reports\Configuration Management\Deployment	Displays deployment groups by repository.
Deployment Group History	Public Folders\PowerCenter Repository Reports\Configuration Management\Deployment	Displays, by group, deployment groups and the dates they were deployed. It also displays the source and target repository names of the deployment group for all deployment dates. This is a primary report in an analytic workflow.
Failed Session Run Details (Yesterday)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays session details, by repository and folder, for sessions that started yesterday and failed. This report is the first node in a workflow associated with the Failed Session Statistics (Yesterday) primary report.
Failed Session Statistics (Started Today)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by folder and repository, the total number of sessions that started today and failed. Rows rejected by the database or discarded by a business rule do not cause a session to fail. This is a primary report in an AW attached to an hourly schedule.
Failed Session Statistics (Started Yesterday)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the total number of sessions that started yesterday and resulted in failed statuses by repository by folder. A session can fail due to read login failure or custom select statement error.
Failed Session Target Details (Yesterday)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by repository by folder, target details for each target instance of a session which started yesterday and failed. This report is the second node in a workflow associated with the Failed Session Statistics (Yesterday) primary report.
Invalid Mapping Sessions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays sessions that are created for invalid mappings by repository and folder. This report is the first node in the analytic workflow associated with the Invalid Mappings primary report.
Invalid Mapping Statistics by Folder	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays the number of invalid mappings available in each folder. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Invalid Mapping Targets	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays targets in an invalid mapping by repository and folder. This report is the first node in the analytic workflow associated with the Invalid Mappings primary report.
Invalid Mappings	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays invalid mappings by repository and folder. This is a primary report in an analytic workflow.
Invalid Session List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays invalid sessions by repository by folder. This report is the first node in the analytic workflow associated with the Session List primary report.
Invalid Worklets	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays all invalid worklets by repository by folder.
Labels	Public Folders\PowerCenter Repository Reports\Configuration Management\Labels	Displays labels created in the repository for any versioned object by repository.
Mapping Composite Report	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This composite report consists of subreports that list the sources, targets, and transformations in a mapping. To generate this report, right click a mapping in the PowerCenter Mapping Designer and select View Mapping Report.
Mapping Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays, by repository and folder, labels associated with a mapping. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays mappings by repository and folder. It also displays properties of the mapping such as the number of sources used in a mapping, the number of transformations, and the number of targets. This is a primary report in an analytic workflow.
Mapping Lookup Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays Lookup transformations used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Lookup Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays Lookup transformations used in a mapping by repository and folder.
Mapping Mapplet Port Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays the source ports available in each mapplet and port details by repository folder and mapping. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping Mapplet Properties	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays the default or user-defined properties for all mapplets by repository, folder, and mapping. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping Mapplets	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays mapplets used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays metadata extensions associated with a mapping and the properties of the metadata extensions. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Object-Level Connections	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays all transformations from source to target in a mapping and how they are connected to each other. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Object-Level Connections	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This is a subreport in the Mapping Composite Report. This report displays all transformations from source to target in a mapping and how they are connected to each other.
Mapping Port-Level Connections	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays all transformations from source to target in a mapping and how they are connected to each other through ports. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Port-Level Connections	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This is a subreport in the Mapping Composite Report. This report displays all transformations from source to target in a mapping and how they are connected to each other through ports.
Mapping Shortcuts	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays mappings defined as a shortcut by repository and folder.
Mapping Source Field Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays column names for all sources by repository, folder, and mapping. It also displays properties of these columns such as datatype, precision, and length. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping Source Field Details	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This is a subreport in the Mapping Composite Report. This report displays column names for all sources by repository, folder, and mapping. It also displays properties of these columns such as datatype, precision, and length.
Mapping Sources	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays sources defined in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Statistics by Folder	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays the number of mappings available in each folder. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Mapping Target Field Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays column names for targets by repository, folder, and mapping. It also displays properties of these columns such as datatype, length, and precision. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping Target Field Details	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This is a subreport in the Mapping Composite Report. This report displays column names for targets by repository, folder, and mapping. It also displays properties of these columns such as datatype, length, and precision.
Mapping Targets	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays targets defined in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Transformation Port Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays ports in a transformation by repository, folder, and mapping. It also displays properties of the ports. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping Transformation Port Details	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This is a subreport in the Mapping Composite Report. This report displays ports in a transformation by repository, folder, and mapping. It also displays properties of the ports.
Mapping Transformation Properties	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays the default or user-defined properties for transformations used in a particular mapping by repository and folder. This report is the second node in a workflow associated with the Mapping List primary report.
Mapping Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays transformations used in a mapping by repository and folder. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Unconnected Ports	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays all unconnected transformation ports from source to target in a mapping. This report is the first node in the analytic workflow associated with the Mapping List primary report.
Mapping Unconnected Ports	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapping Report	This is a subreport in the Mapping Composite Report. This report displays all unconnected transformation ports from source to target in a mapping.
Mapping Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays all versions of a mapping by the date the mapping is saved. This report is part of the Mapping List analytic workflow.
Mapping with no Sessions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays mappings that do not have any sessions defined by repository and folder.
Mapplet Composite Report	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This composite report consists of subreports that list the sources and transformations in a mapplet. To generate this report, right click a mapplet in the PowerCenter Mapplet Designer and select View Mapplet Report.
Mapplet Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays, by repository and folder, labels associated with a mapplet. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays mapplets available by repository and folder. It displays properties of the mapplet such as the number of sources used in a mapplet, the number of transformations, or the number of targets. This is a primary report in an analytic workflow.
Mapplet Lookup Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all Lookup transformations used in a mapplet by folder and repository. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Lookup Transformations	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This is a subreport in the Mapplet Composite Report. This report displays all Lookup transformations used in a mapplet by folder and repository.
Mapplet Lookup Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all Lookup transformations used in a mapplet by folder and repository.
Mapplet Mapping Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all the mappings where a particular mapplet is used by repository and folder. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Mapping Dependency	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This is a subreport in the Mapplet Composite Report. This report displays all the mappings where a particular mapplet is used by repository and folder.
Mapplet Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all metadata extensions associated with a mapplet and the properties of the metadata extensions. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Port Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all source ports available in each mapplet and port properties. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Port Details	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This is a subreport in the Mapplet Composite Report. This report displays all source ports available in each mapplet and port properties.
Mapplet Properties	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays column names for all mapplet by repository and folder. It also shows properties of these columns such as datatype, precision, and length. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Shortcuts	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays mapplets defined as a shortcut by repository and folder.
Mapplet Source Field Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays column names for all sources by repository, folder, and mapplet. It also displays properties for these columns such as datatype, length, and precision. This report is the second node in a workflow associated with the Mapplet List primary report.
Mapplet Source Field Details	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	Displays column names for all sources by repository, folder, and mapplet. It also displays properties for these columns such as datatype, length, and precision. This report is the first node in a workflow associated with subreport Mapplet Sources.
Mapplet Sources	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays sources in a mapplet by repository and folder. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Sources	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This is a subreport in the Mapplet Composite Report. This report displays sources in a mapplet by repository and folder.
Mapplet Transformation Port Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays ports and port properties for the transformation used in a mapplet by repository and folder. This report is the second node in a workflow associated with the Mapplet List primary report.
Mapplet Transformation Port Details	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	Displays ports and port properties for the transformation used in a mapplet by repository and folder. This report is the first node in a workflow associated with subreport Mapplet Transformations.
Mapplet Transformation Properties	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays the default or user-defined properties for transformations in a particular mapplet by repository and folder. This report is the second node in a workflow associated with the Mapplet List primary report.
Mapplet Transformation Properties	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	Displays the default or user-defined properties for transformations in a particular mapplet by repository and folder. This report is the first node in a workflow associated with the subreport Mapplet Transformations.
Mapplet Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays transformations used in a mapplet by repository and folder. This report is the first node in the analytic workflow associated with the Mapplet List primary report.
Mapplet Transformations	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Designer Mapplet Report	This is a subreport in the Mapplet Composite Report. This report displays transformations used in a mapplet by repository and folder.
Mapplet Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays all versions of a mapplet by the date the mapplet is saved. This report is part of the Mapplet List analytic workflow.
Metadata Extensions Usage (Mapping and Mapplet)	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Metadata Extensions	Displays, by repository by folder, reusable metadata extensions used by any object. It also displays the counts of mapping and mapplet objects using that metadata extension.
Metadata Extensions Usage (Source, Target and Transformation)	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Metadata Extensions	Displays, by repository by folder, reusable metadata extensions used by any object. It also displays the counts of source, target and transformation objects using that metadata extension.
Metadata Extensions Usage (Workflow, Worklet and Session)	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Metadata Extensions	Displays, by repository by folder, reusable metadata extensions used by any object. It also displays the counts of workflow, worklet and session objects using that metadata extension.
Scheduler (Reusable) List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays all the reusable schedulers defined in the repository and their description and properties by repository by folder. This is a primary report in an analytic workflow.
Scheduler (Reusable) Workflow Association	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays all workflows using a given reusable scheduler by repository by folder. This report is the first node in the analytic workflow associated with the Scheduler (Re-usable) List primary report.
Server Load (Yesterday)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the total number of sessions that ran and the total session run duration for yesterday by server by repository. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Server Load by Day of Week	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the total number of sessions that ran and the total session run duration for any day of week in any given month of the year by server by repository. For example, all Mondays in September are represented in one row if that month had 4 Mondays.
Session Components	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays, by repository by folder, components included in a workflow, such as pre- and post-session commands and failure and success emails. This report is the first node in the analytic workflow associated with the Session List primary report.
Session Configurable Parameters	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays the configurable attributes and their selected values for each session by repository by folder. This report is the first node in the analytic workflow associated with the Session List primary report.
Session Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays labels associated with a session by repository by folder. This report is the first node in the analytic workflow associated with the Session List primary report.
Session List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays all sessions and their properties by repository by folder. This is a primary report in an analytic workflow.
Session Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays metadata extensions defined for each session and the properties of the metadata extension by repository by folder. This report is the first node in the analytic workflow associated with the Session List primary report.
Session Partitions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays transformation instances and the transformation type for a partition by repository by folder. This report is the first node in the analytic workflow associated with the Session List primary report.
Session Readers	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays how information is read from a source by repository by folder. This includes the name of the source qualifier instance. This is the first node in an analytic workflow associated with the Session List primary report.
Session Run Details	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays session run details for any start date by repository by folder. This is a primary report in an analytic workflow.
Session Run Details (Last Month)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by repository by folder, session run details for every time the session ran last month. This report is the second node in the analytic workflow associated with the Target Table Load Analysis (For Last Month) primary report.
Session Statistics (Last Month)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by repository by folder, the session statistics for all session instances that ran last month. This report is the first node in the analytic workflow associated with the Target Table Load Analysis (For Last Month) primary report.
Session Target Run Details	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays session run details by each target instance defined in a session by repository by folder. This report is the first node in the analytic workflow associated with the Session Run Details primary report.
Session Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays all versions of a session by the date session is saved. This report is part of the Session List analytic workflow.
Session Writers	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays how the PowerCenter Server writes information to a target by repository by folder. This includes the name of the target instance, the writer type (file or relational), and the name of the target connection created in Workflow Manager.
Sessions with Rejected Rows (Yesterday)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays all sessions that started yesterday and had rejected rows by repository and folder. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Source Field Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays column names for all sources by repository and folder. It also shows properties of these columns such as datatype, precision, and length. This report is the first node in an analytic workflow associated with the Source List primary report.
Source Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays labels associated with a source by repository and folder. This report is the first node in an analytic workflow associated with the Source List primary report.
Source List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays relational and non-relational sources by repository and folder. It also shows the source properties. This report is a primary report in an analytic workflow.
Source Mapping Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays mappings that use a particular source by repository and folder. This report is the first node in an analytic workflow associated with the Source List primary report.
Source Mapplet Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays mapplets that use a particular source by repository and folder. This report is the first node in an analytic workflow associated with the Source List primary report.
Source Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays metadata extensions associated with a source by repository and folder. It also displays the properties of the metadata extensions. This report is the first node in an analytic workflow associated with the Source List primary report.
Source Shortcuts	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays sources that are defined as shortcuts by repository and folder.
Source Statistics by Folder	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays the number of sources available in each folder. This cached, standalone report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Source to Target Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mappings	Displays the data flow from the source to the target by repository and folder. The report lists all the source and target ports, the mappings in which the ports are connected, the transformation expression that show how data for the target port is derived.
Source Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays all versions of a source object by the date the object is saved. This report is part of the Source List analytic workflow.
Target Field Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays column names for targets by repository and folder. It also displays properties of these columns such as datatype, length, and precision. This report is the first node in a workflow associated with the Target List primary report.
Target Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays, by repository and folder, labels associated with a target. This report is the first node in the analytic workflow associated with the Target List primary report.
Target List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays relational and non-relational targets available by repository and folder. It also displays the target properties. This is a primary report in an analytic workflow.
Target Mapping Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays mappings that use a particular target by repository and folder. This report is the first node in the analytic workflow associated with the Target List primary report.
Target Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays metadata extensions associated with a target by repository and folder. It also displays the properties of the metadata extensions. This report is the first node in the analytic workflow associated with the Target List primary report.
Target Shortcuts	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays targets that are defined as shortcuts by repository and folder.
Target Statistics by Folder	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays the number of targets available in each folder. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Target Table Load Analysis (Last Month)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the load statistics for each table for last month by repository by folder. This is a primary report in an analytic workflow.
Target Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays all versions of a target object by the date the object is saved. This report is part of the Target List analytic workflow.
Todays Failed Session Run Details	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by folder and repository, session details for all sessions that started today and failed. This report is the first node in the analytic workflow associated with the Todays Failed Session Statistics primary report.
Todays Failed Session Target Details	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays, by folder and repository, the target details for all target instances in sessions that started today and failed. This report is the second node in a workflow associated with the Todays Failed Session Statistics primary report.
Top 10 Session with Rejected Rows (Yesterday)	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays the top 10 sessions that had the most number of rows rejected. This cached report is attached to the Midnight Daily schedule, where it runs everyday at midnight.
Top 5 Session Error Messages	Public Folders\PowerCenter Repository Reports\Operations\Session Execution	Displays by folder the top 5 most common error messages encountered by sessions.
Transformation Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays, by repository and folder, labels associated with a transformation. This report is the first node in the analytic workflow associated with the Transformation List primary report.
Transformation List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays transformations defined by repository and folder. This is a primary report in an analytic workflow.
Transformation Mapping Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays mappings that use a particular transformation by repository and folder. This report is the first node in the analytic workflow associated with the Transformation List primary report.
Transformation Mapplet Dependency	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays mapplets that use a particular transformation by repository and folder. This report is the first node in the analytic workflow associated with the Transformation List primary report.
Transformation Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays all metadata extensions associated with a transformation by repository and folder and their properties. This report is the first node in the analytic workflow associated with the Transformation List primary report.
Transformation Port Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays ports available in each transformation by repository and folder. It also displays properties of each port. This report is the first node in the analytic workflow associated with the Transformation List primary report.
Transformation Properties	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays the default or user-defined properties for all transformations by repository and folder. This report is the first node in the analytic workflow associated with the Transformation List primary report.
Transformation Shortcuts	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays transformations that are defined as shortcuts by repository and folder.
Transformation Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays all versions of a transformation object by the date the object is saved. This report is part of the Transformation List analytic workflow.
Unused Mapplets in Mappings	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Mapplets	Displays mapplets defined in a folder but not used in any mapping in that folder.
Unused Sessions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sessions	Displays sessions that are not associated with any workflow by repository by folder.
Unused Sources	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Sources	Displays sources that are not used in any mapping or mapplet by repository and folder.
Unused Targets	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Targets	Displays targets that are not used in any mapping by repository and folder.
Unused Transformations	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Transformations	Displays transformations that are not used in any mapping or mapplet by repository and folder.
Workflow Composite Report	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Workflow Manager Workflow Report	This composite report consists of subreports that display workflow tasks, events, and variables. To generate this report, right click a workflow in the PowerCenter Workflow Designer and select View Workflow Report.
Workflow Events	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays workflow events and its properties by repository by folder. This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow Events	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Workflow Manager Workflow Report	This is a subreport in the Workflow Composite Report. This report displays workflow events and its properties by repository by folder.
Workflow Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays labels associated with a workflow by repository and folder. This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays workflows and workflow properties by repository by folder. This report is a primary report in an analytic workflow.
Workflow Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays metadata extensions defined for each workflow and the properties of the metadata extension by repository by folder. This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow Run Details	Public Folders\PowerCenter Repository Reports\Operations\Workflow Execution	Displays the run statistics of all workflows by repository by folder. This is a primary report in an analytic workflow.
Workflow Scheduler Details	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays, by repository by folder, scheduler settings for a workflow and properties of the scheduler, such as reusable flag and run on demand .This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow Task Instance Link Conditions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays how tasks are connected to each other in a workflow by repository by folder. This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow Task Instance Link Conditions	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Workflow Manager Workflow Report	This is a subreport in the Workflow Composite Report. This report displays how tasks are connected to each other in a workflow by repository by folder.
Workflow Task Instance List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays all tasks created in a workflow by repository by folder. This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow Task Instance List	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Workflow Manager Workflow Report	This is a subreport in the Workflow Composite Report. This report displays all tasks created in a workflow by repository by folder.
Workflow Task Run Details	Public Folders\PowerCenter Repository Reports\Operations\Workflow Execution	Displays the run statistics of all tasks in a workflow by repository by folder. This report is the first node in the analytic workflow associated with the Workflow Run Details primary report.
Workflow Variables	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays workflow variables and their properties by repository by folder. This report is the first node in the analytic workflow associated with the Workflow List primary report.
Workflow Variables	Public Folders\PowerCenter Repository Reports\Reports called from PC tools\PC Workflow Manager Workflow Report	This is a subreport in the Workflow Composite Report. This report displays workflow variables and their properties by repository by folder.
Workflow Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Workflows	Displays all versions of a workflow by the date the workflow is saved. This report is part of the Workflow List analytic workflow.
Worklet Events	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays worklet events and its properties by repository by folder. This report is the first node in the analytic workflow associated with the Worklet List primary report.
Worklet Labels	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays labels associated with a worklet by repository by folder. This report is the first node in the analytic workflow associated with the Worklet List primary report.
Worklet List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays worklets and worklet properties by repository by folder. This is a primary report in an analytic workflow.
Worklet Metadata Extensions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays, by repository by folder, metadata extensions defined for each workflow and the properties of the metadata extension. This report is the first node in the analytic workflow associated with the Worklet List primary report.
Worklet Run Details	Public Folders\PowerCenter Repository Reports\Operations\Workflow Execution	Displays the run statistics of all worklets by repository by folder. This is a primary report in an analytic workflow.
Worklet Task Instance Link Conditions	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays how tasks are connected to each other in a worklet by repository by folder. This report is the first node in the analytic workflow associated with the Worklet List primary report.
Worklet Task Instance List	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays all the tasks created in a worklet by repository by folder. This report is the first node in the analytic workflow associated with the Worklet List primary report.
Worklet Task Run Details	Public Folders\PowerCenter Repository Reports\Operations\Workflow Execution	Displays the run statistics of all tasks in a worklet by repository by folder. This report is the first node in the analytic workflow associated with the Worklet Run Details primary report.
Worklet Variables	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays variables defined for a worklet and its properties by repository by folder. This report is the first node in the analytic workflow associated with the Worklet List primary report.
Worklet Version History	Public Folders\PowerCenter Repository Reports\PowerCenter Objects\Worklets	Displays all versions of a worklet by the date the worklet is saved. This report is part of the Worklet List analytic workflow.

Rename Saved Search

Table of Contents

Repository Guide

Repository Guide

PowerCenter Reports

PowerCenter Reports