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:

     

<?xml version="1.0"?>
<DataSources>
  <DataSource>
    <DataSourceName>MondrianFoodMart</DataSourceName>
    <DataSourceDescription>FoodMart 2000 Data Warehouse From MS Analysis Services</DataSourceDescription>
    <URL>http://localhost:8080/mondrian/xmla</URL>
    <DataSourceInfo>Provider=mondrian; Jdbc=jdbc:odbc:MondrianFoodMart; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver</DataSourceInfo>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    <Catalogs>
        <Catalog name="FoodMart">
            <Definition>/WEB-INF/schema/FoodMart.xml</Definition>
        </Catalog>
        <Catalog name="Marketing">
            <DataSourceInfo>Provider=mondrian; Jdbc=jdbc:odbc:MarketingDB; JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver</DataSourceInfo>
            <Definition>/WEB-INF/schema/Marketing.xml</Definition>
        </Catalog>
    </Catalogs>
  </DataSource>

  <DataSource>
    <DataSourceName>PostgreSQLTest</DataSourceName>
    <DataSourceDescription>Test Data Warehouse On PostgreSQL</DataSourceDescription>
    <URL>http://localhost:8080/mondrian/xmla</URL>
    <DataSourceInfo>Provider=mondrian; Jdbc=jdbc:postgresql://localhost/olap; JdbcDrivers=org.postgresql.Driver; JdbcUser=pgsql; JdbcPassword=pgsql</DataSourceInfo>
    <ProviderName>Mondrian</ProviderName>
    <ProviderType>MDP</ProviderType>
    <AuthenticationMode>Unauthenticated</AuthenticationMode>
    <Catalogs>
        <Catalog name="Test">
            <Definition>/WEB-INF/schema/TestPgsql.xml</Definition>
        </Catalog>
    </Catalogs>
  </DataSource>
</DataSources>

 

备注说明：

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

Provider：提供者必须是mondrian

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

JdbcUser：用户名

JdbcPassword：密码

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

Catalog：cube文件存放的路径

<ProviderType> and <AuthenticationMode> 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 <DataSource> 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 <Schema name="FoodMart">).

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文件对应内容如下：

  <servlet>

    <servlet-name>MondrianXmlaServlet</servlet-name>

    <servlet-class>mondrian.xmla.impl. MondrianXmlaServlet </servlet-class>

    <!--

    <init-param>

      <param-name>DataSourcesConfig</param-name>

      <param-value>/datasources.xml</param-value>

    </init-param>

    -->

  </servlet>