数据仓库研究之二--mondrian入门
来源:互联网 发布:德国联邦网络管理局 编辑:程序博客网 时间:2024/05/16 16:19
create table tb_employee
(
employee_id int ,
employee_name varchar(10)
);
create table tb_time
(
time_id int,
the_year char(4),
the_month char(2)
);
create table tb_salary
(
employee_id int,
time_id int,
salary int
);
insert into tb_employee values(1,"Mr A");
insert into tb_employee values(2,"Ms A");
insert into tb_employee values(3,"Ms B");
insert into tb_employee values(4,"Ms C");
insert into tb_time values(1,"2007","1");
insert into tb_time values(2,"2007","2");
insert into tb_time values(3,"2007","3");
insert into tb_time values(4,"2007","4");
insert into tb_time values(5,"2007","5");
insert into tb_time values(6,"2007","6");
insert into tb_salary values(1,1,11);
insert into tb_salary values(1,2,13);
insert into tb_salary values(1,3,12);
insert into tb_salary values(1,4,20);
insert into tb_salary values(1,5,21);
insert into tb_salary values(1,6,21);
insert into tb_salary values(2,1,13);
insert into tb_salary values(2,3,12);
insert into tb_salary values(2,4,12);
insert into tb_salary values(3,1,12);
insert into tb_salary values(3,2,13);
insert into tb_salary values(3,4,11);
insert into tb_salary values(4,1,11);
insert into tb_salary values(4,3,10);
insert into tb_salary values(4,5,10);
在MySQL数据库里面建立数据库mt<?xml version="1.0"?>
<Schema name="Mondrian">
<Cube name="CubeTest">
<Table name="tb_salary"/>
<Dimension name="Employee" foreignKey="employee_id">
<Hierarchy hasAll="true" primaryKey="employee_id">
<Table name="tb_employee"/>
<Level name="employeeID" column="employee_id" uniqueMembers="true">
<Property name="employeeName" column="employee_name"/>
</Level>
</Hierarchy>
</Dimension>
<Dimension name="Time" foreignKey="time_id">
<Hierarchy hasAll="false" primaryKey="time_id">
<Table name="tb_time"/>
<Level name="year" column="the_year" uniqueMembers="false"/>
<Level name="month" column="the_month" uniqueMembers="false"/>
</Hierarchy>
</Dimension>
<Measure name="Salary" column="salary" aggregator="sum"/>
</Cube>
</Schema>
文件路径为webapps/mondrian/WEB-INF/queries/s.xml。<%@ page import="mondrian.olap.*"%>
<%
Connection connection = DriverManager.getConnection("Provider=mondrian; Jdbc=jdbc:mysql://localhost/mt; JdbcUser=root; JdbcPassword=root; Catalog=file:///C:/Program Files/Tomcat 5.0/webapps/mondrian/WEB-INF/queries/s.xml; JdbcDriver=com.mysql.jdbc.Driver", null, false);
String querystr = " select {[Measures].[Salary]} ON COLUMNS, {[Employee].[employeeId].Members} ON ROWS from CubeTest ";
Query query=connection.parseQuery(querystr);
Result result = connection.execute(query);
out.println("get result");
out.println(result);
%>
附加:
http://dev.mysql.com/get/Downloads/Connector-J/mysql-connector-java-5.0.5.tar.gz/from/pick
解压后,把里面的mysql-connector-java-5.0.5-bin.jar文件复制到你的tomcat/common/lib下,重启Tomcat,jsp连接mysql的环境就完成。<%@ page contentType="text/html;charset=gb2312"%>
<%@ page import="java.sql.*"%>
<html>
<body>
<%
Class.forName("org.gjt.mm.mysql.Driver").newInstance();
String url ="jdbc:mysql://localhost/jsptest?user=***&password=***&useUnicode=true&characterEncoding=GB2312" ;
Connection conn= DriverManager.getConnection(url);
Statement stmt=conn.createStatement();
String query="select * from t";
ResultSet rs=stmt.executeQuery(query);
while(rs.next())
{
String s=rs.getString("field_name");//字段不是字符型的话就不能用getString,根据字段类使用getBoolean等等
int i=rs.getInt("v");
out.println(s+" "+i+"<br>");
}
%>
</body>
</html>
<%@ page import="mondrian.olap.*"%>
<%
Connection connection = DriverManager.getConnection("Provider=mondrian; Jdbc=jdbc:mysql://localhost/mt; JdbcUser=root; JdbcPassword=root; Catalog=file:///C:/Program Files/Tomcat 5.0/webapps/mondrian/WEB-INF/queries/s.xml; JdbcDriver=com.mysql.jdbc.Driver", null, false);
String querystr = " select {[Measures].[Salary]} ON COLUMNS, {[Employee].[employeeId].Members} ON ROWS from CubeTest ";
Query query=connection.parseQuery(querystr);
Result result = connection.execute(query);
out.println("get result");
out.println(result);
%>
- 数据仓库研究之二--mondrian入门
- 数据仓库研究之二--mondrian入门
- 数据仓库之mondrian的学习
- 数据仓库研究之三--JPivot入门
- mondrian入门
- Mondrian入门
- Mondrian入门介绍之schema manager
- 数据仓库基本知识之二
- Hive数据仓库之快速入门
- Mondrian入门 提取数据
- Ruby on Rails研究之二:简单入门
- Mondrian之初体验
- Mondrian之XMLA服务
- Hadoop学习日志二之数据仓库
- 数据仓库入门
- 研究心得之二
- PhoneGap研究之二
- Mondrian系列(二)-Mondrian的数据存储和聚合策略
- install flash player on Ubuntu
- SQL Server 索引基础知识(9)----Indexing for OR
- WSS(SharePoint) 在IIS中与其他网站并存
- 复制文件进度条
- demo里用到的模式
- 数据仓库研究之二--mondrian入门
- 转贴一下 老婆日记
- 一步步教你优化Delphi字串查找
- 负载均衡技术全攻略
- 转spring声明式事务管理祥述
- [转帖]让程序在Windows CE系统启动时自动运行[转帖]让程序在Windows CE系统启动时自动运行
- 如何在Windows平台下实现进程隐藏
- 超搞笑的设计模式诠释(绝对经典)
- 2007年我国有效专利状况分析