is there documentation on how formulate request xmla?
the iccube xmla endpoint me is: http://localhost:8282/iccube/xmla
i want make demo call endpoint using postman or similar, not sure parameters pass in soap request.
i have tried:
<x:envelope xmlns:x="http://schemas.xmlsoap.org/soap/envelope/" xmlns:urn="urn:schemas-microsoft-com:xml-analysis"> <x:header> <urn:session sessionid="?" mustunderstand="?"/> <urn:beginsession mustunderstand="?"/> <urn:endsession sessionid="?" mustunderstand="?"/> </x:header> <x:body> <urn:execute> <command> <statement> select {[customers].[geography].[all regions].[north america].[canada].[ottawa]} on columns, {[measures].[count]} on rows [sales] </statement> </command> <properties/> </urn:execute> </x:body> </x:envelope>
and empty response:
<soap:envelope xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/"> <soap:header> <session sessionid="1hb96vaa7acol14bj97tyokd4f" xmlns="urn:schemas-microsoft-com:xml-analysis"/> </soap:header> <soap:body> <executeresponse xmlns="urn:schemas-microsoft-com:xml-analysis"> <return> <root xmlns="urn:schemas-microsoft-com:xml-analysis:empty"/> </return> </executeresponse> </soap:body> </soap:envelope>
does know can find more information on how make request? iccube documentation @ http://www.iccube.com/support/documentation/user_guide/running_iccube/xmla.php non-existent.
thank in advance help.
i had add correct properties information soap call:
<?xml version="1.0" encoding="utf-8"?> <soap-env:envelope xmlns:soap-env="http://schemas.xmlsoap.org/soap/envelope/" soap-env:encodingstyle="http://schemas.xmlsoap.org/soap/encoding/"> <soap-env:body> <execute xmlns="urn:schemas-microsoft-com:xml-analysis" soap-env:encodingstyle="http://schemas.xmlsoap.org/soap/encoding/"> <command> <statement> select {[customers].[geography].[all regions].[north america].[canada].[ottawa]} on columns, {[measures].[count]} on rows [sales] </statement> </command> <properties> <propertylist> <catalog>sales</catalog> </propertylist> </properties> </execute> </soap-env:body> </soap-env:envelope>
the best documentation have been able find xmla xml analysis specification.
Comments
Post a Comment