来自PHP的MDX查询 [英] MDX query from PHP

问题描述

假设我的基础关系数据库是MySQL，是否有可能使用PHP作为宿主语言为JasperServer创建MDX查询?

Is it possible to create an MDX query for JasperServer using PHP as a host language, given that my underlying relational database is MySQL?

我想做的是将查询发送到JasperServer，以便创建OLAP视图并接收结果(最好是一些基于文本的格式，如与图像或PDF相对的视图).

What I would like to do is send the query to JasperServer in order to create an OLAP View and receive the view as a result (preferably in some text-based format, as oposed to an image or PDF).

我正在使用JasperServer CE 4.2.1.

I'm using JasperServer CE 4.2.1.

作为一个旁注，考虑像从应用程序中进行SQL查询一样，考虑从应用程序中进行MDX查询是否正确?如果是，是否可以使用PHP对任何OLAP服务器进行MDX查询?

As a side note, is it even correct to think about making MDX queries from you application, just like you would make SQL queries? If yes, is there any way to make MDX queries to any OLAP server using PHP?

:添加了缺少的信息:我正在使用MySQL作为关系数据库服务器.

Added missing information: I'm using MySQL as a relational database server.

推荐答案

您的OLAP服务器很可能支持XMLA. XMLA不仅仅是具有特定格式的SOAP.我不知道一个支持XMLA的php库，因此您必须走困难的路:

It's very likely your OLAP server supports XMLA. And XMLA is not more than SOAP with a specific format. I don't know a php library supporting XMLA, so you'll have to go the hard way :

最重要的工作是编组/解组XML->该标准由Microsoft定义，几乎所有其他供应商都遵循->

The big job is marshalling/unmarshalling the XML -> The standard is defined by Microsoft and followed by almost all other vendors -> http://msdn.microsoft.com/en-us/library/ms187178%28v=sql.90%29.aspx

也许您可以简化您的需求.

Maybe you can oversimplify for your needs.

这篇关于来自PHP的MDX查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！