hi,
select {KPIValue([SalesAmount KPI]),KPIGoal([SalesAmount
KPI]),KPIStatus([SalesAmount KPI]),KPITrend([SalesAmount KPI])} on columns
from [New Cube]

in this i have one kpi named SalesAmount KPI. When i execute this query in
query analyzer, i get the proper result but when i call the same query in
asp.net using msolap i get only the value of measure Sales Amount.

why? would this query can't be excuted in asp.net when the same gives
correct result in query analyzer.

Plz help.

Thanks