Mondrian xml服务mysql_Mondrian xmla Provider的配置

To will setup XMLA service, follow these steps.

1. Describe the data sources in datasources.xml

In WEB-INF directory of your webapp, create a file called datasources.xml, with content like this:

MondrianFoodMart

FoodMart 2000 Data Warehouse From MS Analysis Services

http://localhost:8080/mondrian/xmla

Provider=mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver

MDP

Unauthenticated

/WEB-INF/schema/FoodMart.xml

Provider=mondrian; Jdbc=jdbc:odbc:MarketingDB; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver

/WEB-INF/schema/Marketing.xml

PostgreSQLTest

Test Data Warehouse On PostgreSQL

http://localhost:8080/mondrian/xmla

Provider=mondrian; Jdbc=jdbc:postgresql://localhost/olap; JdbcDrivers=org.postgresql.Driver; JdbcUser=pgsql; JdbcPassword=pgsql

Mondrian

MDP

Unauthenticated

/WEB-INF/schema/TestPgsql.xml

备注说明：

URL：xmla所在地址，tomcat端口号可能不同，请改为安装tomcat时设置的端口号；datacourceinfo部分

Provider：提供者必须是mondrian

Jdbc：数据库jdbc驱动的路径，此处为acceess数据库，不同数据库的jdbc路径请参阅相关文档

JdbcUser：用户名

JdbcPassword：密码

JdbcDrivers：jdbc完整的驱动名称，此处为access数据库，不同数据库的驱动名称请参阅相关文档

Catalog：cube文件存放的路径

 and  are ignored because the XML/A implementation currently only supports 'MDP' and 'Unauthenticated'.

Multiple data sources and multiple catalogs

if you intend to use Mondrian with Microsoft's ADOMD.NET client library or Simba's O2X bridge, the data sources file must have precisely one  element. These clients will ignore all but one data source. Other XML/A clients, such as Rex, work fine with multiple data sources.

Note that each catalog has a name attribute, and the URI (path) of an XML schema file. The name of the catalog must match the name attribute in the schema file (for example ).

Whether  you use one data source or several, the catalogs in the datasources.xml file must have unique names.

Configure XmlaServlet in your web.xml

(1)       修改…\Tomcat 6.0\webapps\mondrian\WEB-INF中web.xml文件对应内容如下：

MondrianXmlaServlet

mondrian.xmla.impl. MondrianXmlaServlet