on 11-01-2016 4:36 PM
I am trying to get the SAP Variable metadata using XMLA. I am using the discover call with the Request Type set to MDSCHEMA_SAP_VARIABLES according to http://help.sap.com/saphelp_nw70ehp1/helpdata/en/ba/12533d6dd60610e10000000a114084/content.htm
This does not work and I get the following error:
<SOAP-ENV:Fault xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/"> <faultcode>XMLAnalysisError.0x80000005</faultcode> <faultstring>The XML for Analysis provider encountered an error</faultstring> <faultactor>XML for Analysis Provider</faultactor> <detail> <Error Description=" Object Rowset MDSCHEMA_SAP_VARIABLES not found" ErrorCode="2147483653" HelpFile="" Source="XML for Analysis Provider"/> </detail> </SOAP-ENV:Fault>
Request-
<SOAP-ENV:Envelope xmlns:SOAP-ENV="http://schemas.xmlsoap.org/soap/envelope/" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <SOAP-ENV:Body> <Discover xmlns="urn:schemas-microsoft-com:xml-analysis" SOAP-ENV:encodingStyle="http://schemas.xmlsoap.org/soap/encoding/"> <RequestType>MDSCHEMA_SAP_VARIABLES</RequestType> <Restrictions> <RestrictionList> <CUBE_NAME>0SD_MC01/Z_0SD_MC01_Q0011</CUBE_NAME> </RestrictionList> </Restrictions> <Properties> <PropertyList> <DataSourceInfo>Provider=SAP_BW;Data Source=SAP_BW</DataSourceInfo> <Catalog>0SD_MC01</Catalog> <Content>Data</Content> </PropertyList> </Properties> </Discover> </SOAP-ENV:Body> </SOAP-ENV:Envelope>
try to use
SAP_VARIABLES instead of
MDSCHEMA_SAP_VARIABLES
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
85 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.