小妹初次学习这个,在网上的例子照做的。这是一个邮件的例子MDX语句如下:select {[Measures].[数量],[Measures].[平均单价],[Measures].[总销售额]} ON columns,
{([产品类别].[所有产品],[客户性别].[所有性别])} ON rows
from [Sales]在kettle中的报错如下:
Problem while output excel file,OlapException: [Ljava.lang.StackTraceElement;@571cc4应该是mdx的语句写错了- - schema文件:<?xml version="1.0" encoding="UTF-8"?>
<Schema name="test">
<Cube name="Sales">
<Table name="sale" />
<Dimension name="客户性别" foreignKey="cusId">
<Hierarchy hasAll="true" allMemberName="所有性别" primaryKey="cusId">
<Table name="Customer"></Table>
<Level name="gender" column="gender"></Level>
</Hierarchy>
</Dimension>
<Dimension name="产品类别" foreignKey="proId">
<Hierarchy hasAll="true" allMemberName="所有产品" primaryKey="proId"
primaryKeyTable="product">
<join leftKey="proTypeId" rightKey="proTypeId">
<Table name="product" />
<Table name="producttype"></Table>
</join>
<Level name="proTypeId" column="proTypeId" nameColumn="proTypeName"
uniqueMembers="true" table="producttype" />
<Level name="proId" column="proId" nameColumn="proName"
uniqueMembers="true" table="product" />
</Hierarchy>
</Dimension>
<Measure name="数量" column="number" aggregator="sum" datatype="Numeric" />
<Measure name="总销售额" aggregator="sum" formatString="¥#,##0.00">
<MeasureExpression>
<SQL dialect="generic">
(unitPrice*number)
</SQL>
</MeasureExpression>
</Measure>
<CalculatedMember name="平均单价" dimension="Measures">
<Formula>
[Measures].[总销售额] / [Measures].[数量]
</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="¥#,##0.00" />
</CalculatedMember>
</Cube>
</Schema>
{([产品类别].[所有产品],[客户性别].[所有性别])} ON rows
from [Sales]在kettle中的报错如下:
Problem while output excel file,OlapException: [Ljava.lang.StackTraceElement;@571cc4应该是mdx的语句写错了- - schema文件:<?xml version="1.0" encoding="UTF-8"?>
<Schema name="test">
<Cube name="Sales">
<Table name="sale" />
<Dimension name="客户性别" foreignKey="cusId">
<Hierarchy hasAll="true" allMemberName="所有性别" primaryKey="cusId">
<Table name="Customer"></Table>
<Level name="gender" column="gender"></Level>
</Hierarchy>
</Dimension>
<Dimension name="产品类别" foreignKey="proId">
<Hierarchy hasAll="true" allMemberName="所有产品" primaryKey="proId"
primaryKeyTable="product">
<join leftKey="proTypeId" rightKey="proTypeId">
<Table name="product" />
<Table name="producttype"></Table>
</join>
<Level name="proTypeId" column="proTypeId" nameColumn="proTypeName"
uniqueMembers="true" table="producttype" />
<Level name="proId" column="proId" nameColumn="proName"
uniqueMembers="true" table="product" />
</Hierarchy>
</Dimension>
<Measure name="数量" column="number" aggregator="sum" datatype="Numeric" />
<Measure name="总销售额" aggregator="sum" formatString="¥#,##0.00">
<MeasureExpression>
<SQL dialect="generic">
(unitPrice*number)
</SQL>
</MeasureExpression>
</Measure>
<CalculatedMember name="平均单价" dimension="Measures">
<Formula>
[Measures].[总销售额] / [Measures].[数量]
</Formula>
<CalculatedMemberProperty name="FORMAT_STRING" value="¥#,##0.00" />
</CalculatedMember>
</Cube>
</Schema>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货