简介
Mondrian是一个开放源代码的Rolap服务器,使用java开发的。它实现了xmla和jolap规范,而且自定义了一种使用mdx语言的客户端接口。
环境准备
1、JDK5及以上版本。
2、Tomcat6,其它版本没测过
3、Mondrian,当前最新版本为3.5.0,下载地址:http://mondrian.pentaho.com/
安装
1、安装JDK,配置JAVA_HOME环境变量
2、安装Tomcat
3、解压mondrian-3.5.0.zip,复制lib\mondrian.war到Tomcat的webapps目录下,启动Tomcat
4、进入/webapps/mondrian/WEB-INF目录,修改web.xml,注释掉DataSourcesConfig
<servlet> <servlet-name>MondrianXmlaServlet</servlet-name> <servlet-class>mondrian.xmla.impl.DynamicDatasourceXmlaServlet</servlet-class> <!-- This is an example of how to add a callback to the XML/A servlet. It must implement mondrian.xmla.XmlaRequestCallback. <init-param> <param-name>Callbacks</param-name> <param-value>com.example.MyCallbackClass;com.example.SomeOtherCallback</param-value> </init-param> <init-param> <param-name>DataSourcesConfig</param-name> <param-value>/WEB-INF/datasources.xml</param-value> </init-param> --> </servlet>
5、修改datasources.xml
<?xml version="1.0"?> <!-- == This software is subject to the terms of the Eclipse Public License v1.0 == Agreement, available at the following URL: == http://www.eclipse.org/legal/epl-v10.html. == You must accept the terms of that agreement to use this software. == == Copyright (C) 2005-2006 Pentaho and others == All Rights Reserved. --> <DataSources> <!-- A data source is a collection of logically related Mondrian catalogs. The XMLA specification allows an XMLA provider to have multiple data sources, but some clients, particularly ones based on ADOMD.NET such as Simba's O2X client and Pentaho Spreadsheet Services, can only connect to the first declared data source. Therefore, we recommend that you use a single data source, containing multiple catalogs if necessary. --> <DataSource> <!-- Name of the data source. --> <DataSourceName>Provider=Mondrian;DataSource=MyDW;</DataSourceName> <!-- Description of the data source. --> <DataSourceDescription>Mondrian My Data Warehouse</DataSourceDescription> <!-- The URL of the servlet. --> <URL>http://localhost:8080/mondrian/xmla</URL> <!-- Mondrian connect string for the data source. If this data source contains multiple catalogs, omit the 'Catalog' property, and specify the URI of the schema.xml file in the catalog's <Definition> element. Catalogs can override the connect string with their own <DataSourceInfo> element. --> <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:mysql://localhost:5029/mydw;JdbcUser=usr;JdbcPassword=pwd;JdbcDrivers=org.gjt.mm.mysql.Driver</DataSourceInfo> <!-- Provider name must be 'Mondrian'. --> <ProviderName>Mondrian</ProviderName> <!-- Provider type must be 'MDP'. --> <ProviderType>MDP</ProviderType> <!-- Authentication mode. Allowable values are 'Unauthenticated', 'Authenticated', 'Integrated'. --> <AuthenticationMode>Unauthenticated</AuthenticationMode> <!-- A data source contains one or more catalogs. --> <Catalogs> <!-- Catalog names must match the name inside the schema.xml file, and must be unique across all data sources defined in this datasources.xml file. --> <Catalog name="mycube"> <!-- Mondrian connect string for the data source. This element is optional; if specified, it overrides the data source's <DataSourceInfo> element. Typically, you would use this element if the catalogs have different JDBC data sources. --> <!-- <DataSourceInfo>Provider=mondrian;Jdbc=jdbc:odbc:MondrianFoodMart;JdbcDrivers=sun.jdbc.odbc.JdbcOdbcDriver</DataSourceInfo> --> <!-- URI of the schema definition file. --> <Definition>/WEB-INF/queries/testcube.xml</Definition> </Catalog> </Catalogs> </DataSource> </DataSources>
相关推荐
Mondrian 介绍 配置
本资源包括mondrian源码运行的方法,以及说明文档 还有配置过程中需要的jar包,这个配置方法是可行的,本人已经用这个配置方法成功的运行了mondrian源码!
foodmart.mondrian.xml。这个可以包含属性、信息。 同时支持了mondrian3.x版本和mondrian4.x版本,配合其他资源的sql,通过建模workbench链接数据库之后,直接加载当前的这个xml就可以了。 亲测不报错,建模正常解析...
mondrian配置例子,附件是openi源码例子,集成了mondrian+Jpivot。
自已刚开始学mondrian,里面有两个文件,一个是mondrian自带的一个演示示例,是基于oracle实现的过程。还有一个是eclipse中配置mondrian源代码的过程。都是我自己总结的,原创。QQ:6855957
mondrian操作手册和优化配置.手册
mondrian源码配置,mondrian的源代码在Eclipse中配置
本文档详细讲解了,如何自己创建一个mondrian项目,并且把该项目集成在自己的web项目中。是一个学习mondrian的很好帮助文档。
jpivot + mondrian + xmla配置需要的jar, 包括 commons-discovery-0.2.jar jaxrpc.jar axis.jar wsdl4j-1.5.1.jar
mondrian部署、配置总结1
Mondrian是一个开放源代码的Rolap服务器,使用java开发的。它实现了xmla和jolap规范,... Mondrian中使用物理的xml文件存储元数据,它的设计者规定了xml文件的格式。下面简单介绍一下它是如何存储元数据的。
[Manning Publications] Mondrian 实战 英文版 [Manning Publications] Mondrian in Action E Book ☆ 出版信息:☆ [作者信息] William Back D Nicholas Goodman Julian Hyde [出版机构] Manning ...
Mondrian is an OLAP (online analytical processing) engine written in ... It reads from JDBC data sources, aggregates data in a memory cache, and implements the MDX language and the olap4j and XML/A APIs.
mondrian4 schema设计说明文档,压缩包解压后打开index.html。4版本,官网链接 https://mondrian.pentaho.com/head/documentation/schema.php,无法访问,直接用该资源即可。附3版本地址: ...
mondrian报表技术概要,实例讲述开发过程中遇到的问题以及配置
mondrian foodmart SQL SERVER 数据库
Mondrian lets users drive analysis 8 ■ Mondrian is a low-cost, low-risk solution 11 ■ Mondrian is fast 13 ■ Mondrian is secure 14 ■ Mondrian is based on open standards 14 1.4 Summary 15 2 Mondrian...
It reads from JDBC data sources, aggregates data in a memory cache, and implements the MDX language and the olap4j and XML/A APIs. Mondrian 3.0.4 is a bug fix release version of the leading open ...
包含开发所需的mondrian-3.0.4.11371,编写xml的schema-workbench工具,sql文件,以及开发文档。
Catalog=mondrian:///datasources/foodmart4.xml;JdbcDrivers=com.mysql.jdbc.Driver;DynamicSchemaProcessor=bi.meteorite.App;StartDate=19970101 ;EndDate=19981231;Cubes=Sales=the_date,Warehouse=time_id ...