使用IronPython在SQL Server Analysis Services上执行查询 [英] Execute query on SQL Server Analysis Services with IronPython
问题描述
我能够使用Microsoft.AnalysisServices.dll
使用Python连接到SQL Server Analysis Service,现在我无法在多维数据集上执行查询.
I was able to connect to SQL server Analysis service in Python using Microsoft.AnalysisServices.dll
, and now I can't execute query on cube.
我尝试了与以下相同的Execute
方法:
I've tried Execute
method same as following:
amoServer.Execute('select from finance')
发出Execute
方法后,出现此错误:
After issuing Execute
method I have this error:
<Microsoft.AnalysisServices.XmlaError object at 0x000000000000002B [Microsoft.AnalysisServices.XmlaError]>
注意:我正在Windows Server 64Bit上使用IronPython和Python 2.7.
Note: I'm using IronPython with Python 2.7 on Windows Server 64Bit.
出什么问题了?
推荐答案
最好使用 Microsoft.AnalysisServices.AdomdClient.dll 和 mdx 查询. 并在 Ststem.Data 程序集中的数据集中设置查询结果 像这样的东西:
its better use Microsoft.AnalysisServices.AdomdClient.dll and mdx query. and set query result in Datasets in Ststem.Data assembly something like this:
clr.AddReference ("Microsoft.AnalysisServices.AdomdClient.dll")
clr.AddReference ("System.Data")
from Microsoft.AnalysisServices.AdomdClient import AdomdConnection , AdomdDataAdapter
from System.Data import DataSet
conn = AdomdConnection("Data Source=0.0.0.0;Catalog=MyCatalog;")
conn.Open()
cmd = conn.CreateCommand()
cmd.CommandText = "your mdx query" # in your case 'select from finance'
adp = AdomdDataAdapter(cmd)
datasetParam = DataSet()
adp.Fill(datasetParam)
conn.Close();
# datasetParam hold your result as collection a\of tables
# each tables has rows
# and each row has columns
print datasetParam.Tables[0].Rows[0][0]
这篇关于使用IronPython在SQL Server Analysis Services上执行查询的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!