cancel
Showing results for 
Search instead for 
Did you mean: 

How to get SAP Variable metadata using XMLA?

Former Member
0 Kudos

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>

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

try to use

SAP_VARIABLES instead of

MDSCHEMA_SAP_VARIABLES