Mondrian案例
1.mdx定义
<?xml version="1.0" encoding="UTF-8"?>
<Schema name="tezz">
<!-- Shared dimensions -->
<Dimension name="Product">
<Hierarchy hasAll="true" primaryKey="product_id">
<Table name="product"/>
<Level name="proName" column="product_name" uniqueMembers="true"/>
</Hierarchy>
</Dimension>
<!-- end 分享的维度 -->
<!-- Sales -->
<Cube name="Sales" defaultMeasure="Unit Sales">
<Table name="sales_fact_1997"/>
<DimensionUsage name="Product" source="Product" foreignKey="product_id"/>
<Measure name="Unit Sales中文" column="unit_sales" aggregator="sum" formatString="Standard"/>
<Measure name="Store Cost" column="store_cost" aggregator="sum" formatString="#,###.00"/>
<Measure name="Store Sales" column="store_sales" aggregator="sum" formatString="#,###.00"/>
</Cube>
</Schema>
2.查询操作:
/**
* NO.2. 以product(商品[所有商品])为维度查询,1997年的销量信息
*/
public void two(){
String mdxStr = "S