kpiquery.mdx

< SQL Server2005程序设计>

SELECT 
 {
 KPIValue("Average Total Sales KPI"),
 KPIGoal("Average Total Sales KPI"),
 KPIStatus("Average Total Sales KPI"),
 KPITrend("Average Total Sales KPI")
 }
 ON COLUMNS
FROM [Sales]
WHERE
 (
 [Order Date].[Year -  Quarter -  Month -  Date].[Year].&[1997-01-01T00:00:00], 
 {[Geography].[Country].&[Brazil], 
 [Geography].[Country].&[Canada]}
 )