定制度量的查询主题示例
您可以对与对象类型相关联的所有度量定义单独的查询主题。以下是与项目相关联的度量的查询主题示例：
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
从
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.