我已经使用Python连接到我的SSAS多维数据集,但是在执行MDX查询时遇到了一些问题。以下是我使用的代码:
from sys import path
path.append('\\Program Files\\Microsoft.NET\\ADOMD.NET\\140')
from pyadomd import Pyadomd
conn_str = 'connection_str'
query = """mdx_query"""
with Pyadomd(conn_str) as conn:
with conn.cursor().execute(query) as cur:
print(cur.fetchall())
我已经用print(conn.state)
检查了连接,一切正常
我得到的错误是:
Traceback (most recent call last):
File "C:/Users/kkrukows/PycharmProjects/test/main.py", line 22, in <module>
with conn.cursor().execute(query) as cur:
File "C:\Users\kkrukows\Anaconda3\envs\test\lib\site-packages\pyadomd\pyadomd.py", line 71, in execute
adomd_type_map[self._reader.GetFieldType(i).ToString()].type_name
KeyError: 'System.Object'
有人能帮忙吗
请将程序包升级到版本0.0.6,然后重试
您可以使用pip执行此操作:
pip install pyadomd upgrade
相关问题 更多 >
编程相关推荐