Custom BI publisher/nformation publisher report

Hi,

i am trying to create a report from OEM which will have the weekly average cpu/memory utilization of multiple servers of target type host in a single page. I am trying to utilize the information publisher and BI publisher with the below query but I am not getting any success.

SELECT mmd.target_name,

mmd.metric_label,

mmd.column_label,

MIN(mmd.collection_timestamp)"From Date",

MAX(mmd.collection_timestamp)"To Date",

AVG(mmd.value)

FROM mgmt$metric_details mmd

WHERE mmd.target_name IN(

'<Target Name01>',

'<Target Name02>',

'<Target Name03>'

)AND mmd.target_type = 'host' AND mmd.column_label IN(