PowerCenter Reports

This page will show you all the Available reports for PowerCenter Reports, once you select a report name, it will open the report query page. copy and paste it to your PC and run it from, toad or any other DB tools you have.


Configuration Management reports

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


select “DEP_GROUP_NAME”,
“REPOSITORY_NAME”,
“CREATED_BY”,
case when (“IS_SHORTCUT” = 1) then (‘Yes’) else (‘No’) end as “Calc_IS_SHORTCUT”,
“OBJECT_TYPE_NAME”,
case when (“GROUP_TYPE” = 0) then (‘Normal’) else (case when (“GROUP_TYPE” = 1) then (‘Dynamic’) else (”) end) end as “Calc_GROUP_TYPE”,
“TARG_SUBJECT_AREA”,
“OBJECT_NAME”,
“SRC_VERSION_NUMBER”,
“TARGET_REP_NAME”,
“SRC_SUBJECT_AREA”,
“DEPLOY_TIME”,
“TARG_VERSION_NUMBER”
from (SELECT DISTINCT DEPLOYMENT_GROUP.DEP_GROUP_NAME, DEPLOYMENT_GROUP.GROUP_TYPE as GROUP_TYPE, DEPLOYMENT_GROUP.CREATED_BY, DEPLOYMENT_GROUP_DETAIL.DEPLOY_TIME, DEPLOYMENT_REPOSIT_INFO.REPOSITORY_NAME, DEPLOYMENT_GROUP_DETAIL.TARGET_REP_NAME, DEPLOYMENT_GROUP_DETAIL.OBJECT_NAME, DEPLOYMENT_GROUP_DETAIL.OBJECT_TYPE_NAME, DEPLOYMENT_GROUP_DETAIL.SRC_VERSION_NUMBER, DEPLOYMENT_GROUP_DETAIL.TARG_VERSION_NUMBER, DEPLOYMENT_GROUP_DETAIL.SRC_SUBJECT_AREA, DEPLOYMENT_GROUP_DETAIL.TARG_SUBJECT_AREA, DEPLOYMENT_GROUP_DETAIL.IS_SHORTCUT as IS_SHORTCUT, DEPLOYMENT_GROUP.DESCRIPTION as DESCRIPTION, DEPLOYMENT_GROUP_DETAIL.USER_NAME FROM REP_REPOSIT_INFO DEPLOYMENT_REPOSIT_INFO, REP_DEPLOY_GROUP DEPLOYMENT_GROUP LEFT OUTER JOIN REP_DEPLOY_GROUP_DETAIL DEPLOYMENT_GROUP_DETAIL ON DEPLOYMENT_GROUP.DEP_GROUP_ID = DEPLOYMENT_GROUP_DETAIL.DEP_GROUP_ID WHERE (DEPLOYMENT_GROUP.DEP_GROUP_ID <> DEPLOYMENT_REPOSIT_INFO.REPOSITORY_ID)) “query”
order by “DEP_GROUP_NAME”, “Calc_GROUP_TYPE”, “CREATED_BY”

Object Version

Operations Reports

Session Execution

Workflow Execution

Monitoring Reports

Powercenter Objects Reports

Mappings

Mapplet

Sessions

Sources

Targets

Transformations

Workflows

Worklets

 

 

I hope you will enjoy the content of my website.
Please leave me a comment below if you have any suggestion for improving

Leave a Comment

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>
*
*