MS Analysis Services OLAP API for Python [英] MS Analysis Services OLAP API for Python

问题描述

我正在寻找一种方法来连接到MS Analysis Services OLAP多维数据集，运行MDX查询，并将结果转换为Python。换句话说，正是什么Excel。在Python中有一个解决方案，让我这样做？

I am looking for a way to connect to a MS Analysis Services OLAP cube, run MDX queries, and pull the results into Python. In other words, exactly what Excel does. Is there a solution in Python that would let me do that?

有一个类似的问题指向Django的ORM。就像我喜欢的框架，这不是我想要的。我也不是在寻找一种方法拉行和聚合他们 - 这是分析服务的第一位。

Someone with a similar question going pointed to Django's ORM. As much as I like the framework, this is not what I am looking for. I am also not looking for a way to pull rows and aggregate them -- that's what Analysis Services is for in the first place.

想法？谢谢。

推荐答案

我完全不了解Python，但如果它可以调用DLLs，那么它应该能够使用Microsoft的ADOMD目的。这是我可以想到的最好的选择。

I am completely ignorant about Python, but if it can call DLLs then it ought to be able to use Microsoft's ADOMD object. This is the best option I can think of.

您可以看看Office Web Components（OWC），因为它有一个OLAP控件，可以嵌入在网页上。我想你可以传递MDX到它，但也许你想让Python看到的结果，我不认为它允许。

You could look at Office Web Components (OWC) as that has a OLAP control than can be embedded on a web page. I think you can pass MDX to it, but perhaps you want Python to see the results too, which I don't think it allows.

否则你可以建立你的自己的代理在另一种语言。此程序/网页可以接受MDX，并返回显示结果的XML。 Python可以使用这个XML。

Otherwise perhaps you can build your own 'proxy' in another language. This program/webpage could accept MDX in, and return you XML showing the results. Python could then consume this XML.

这篇关于MS Analysis Services OLAP API for Python的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！