小妹初次学习这个,在网上的例子照做的。这是一个邮件的例子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>