使用Olap4j(比较慢,求推荐好用的olap连接工具)连接sap的BW系统查找数据,单使用mdx语句会报参数未设置错误。
用fidler捕捉request发现parameter并未设置:
<?xml version="1.0" encoding="UTF-8"?>
<soapenv:Envelope
xmlns:soapenv="http://schemas.xmlsoap.org/soap/envelope/"
xmlns:xsd="http://www.w3.org/2001/XMLSchema"
xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">
<soapenv:Body>
<Execute xmlns="urn:schemas-microsoft-com:xml-analysis">
<Command>
<Statement>
<![CDATA[
SELECT NON EMPTY { [0SALES_DIST__0CUST_GRP2].[LEVEL01].Members } ON COLUMNS, NON EMPTY { [0CALMONTH].[LEVEL01].Members } ON ROWS FROM [ZQD_C28/ZQD_C28_Q0001] WHERE [0CALMONTH].[201503]]]>
</Statement>
</Command>
<Properties>
<PropertyList>
<Catalog>ZBF_C51</Catalog>
<DataSourceInfo>SAP_BW</DataSourceInfo>
<Format>Multidimensional</Format>
<AxisFormat>TupleFormat</AxisFormat>
</PropertyList>
</Properties>
<Parameters>
<Parameter>
</Parameter>
</Parameters></Execute>
</soapenv:Body>
</soapenv:Envelope>
用OLAP4J怎样设置参数?