Google
 

Wednesday, September 5, 2007

Setting up SQL 2005 and XMLA

Command line to query KPI data from Analysis Services.  I wonder if there is a PerformancePoint equivalent? 

cscript //nologo xmla.wsf /url:"http://localhost/olap/msmdpump.dll" /c:"Adventure Works DW" /e:"SELECT { [Measures].[Total Product Cost], KPIValue('Product Gross Profit Margin'), KPIGoal('Product Gross Profit Margin'), KPIStatus('Product Gross Profit Margin'), KPITrend('Product Gross Profit Margin') } ON COLUMNS, { [Employee].[All Employees] } ON ROWS FROM [Adventure Works]" /out:"aw-kpi.html" /v

Setting up SQL 2005 and XMLA

No comments: