hi,
is there a way to query (value, goal etc) of multiple KPIs (in same
query). the result should be a data set rather than all values in
different columns.

this is how i expect this to be:

KPI Name | KPI Value | KPI Goal | KPI Trend | KPI Status
-------------------------------------------------------
KPI1 12,000 13,000 1 1
KPI2 13,000 13,000 1 1
KPI3 20,000 50,000 1 1


on even if i can get the same in xml format?

i've seen oliver's post, but was wondering if i can avoid the for loop
and can get the values of specific kpis in one query!

Ali