사용자 정의 메트릭의 쿼리 제목 예제
오브젝트 유형과 연관된 모든 메트릭의 단일 쿼리 제목을 정의할 수 있습니다. 다음은 프로젝트와 연관된 메트릭의 쿼리 제목 예제입니다.
Select
UAP_PROJECTS.PROJECT_ID,
a.METRIC_VALUE1 as TotalRevenue,
b.METRIC_VALUE1 as ResponseRateActual,
b.METRIC_VALUE2 as ResponseRateTarget,
c.METRIC_VALUE1 as TotalLeadsGeneratedActual,
c.METRIC_VALUE2 as TotalLeadsGeneratedTarget,
d.METRIC_VALUE1 as TotalCostPassed
From
UAP_PROJECTS
LEFT JOIN
(select PROJECT_ID, METRIC_VALUE1 from UAP_PROJ_METRICS
where UAP_PROJ_METRICS.METRIC_ID = 'TotalRevenue') as a
ON a.PROJECT_ID = UAP_PROJECTS.PROJECT_ID
LEFT JOIN
(select PROJECT_ID, METRIC_VALUE1, METRIC_VALUE2 from UAP_PROJ_METRICS
where UAP_PROJ_METRICS.METRIC_ID = 'ProjectResponseRate') as b
ON b.PROJECT_ID = UAP_PROJECTS.PROJECT_ID
LEFT JOIN
(select PROJECT_ID, METRIC_VALUE1, METRIC_VALUE2 from UAP_PROJ_METRICS
where UAP_PROJ_METRICS.METRIC_ID = 'NumberOfLeadsGeneratedPassed') as c
ON c.PROJECT_ID = UAP_PROJECTS.PROJECT_ID
LEFT JOIN
(select PROJECT_ID, METRIC_VALUE1 from UAP_PROJ_METRICS
where UAP_PROJ_METRICS.METRIC_ID = 'TotalCostPassed') as d
ON d.PROJECT_ID = UAP_PROJECTS.PROJECT_ID
Copyright IBM Corporation 2013. All Rights Reserved.