Hi,
I've seen the feature of using any XMLA source with the pivotgrid. SAP is explicitly mentioned on the product page. Do you have any documents or detailed info how to integrate SAP with Infragistics components (pivotgrid, chart, map)? Do you maybe have any info how to read XMLA data from SAP?
Many thanks,
Tamás
Hi again,
Can't I somehow use directly this? Like I can make a web reference in visual studio to this service. However I don't know how I could connect that to the datasource of the pivotgrid.
Thanks and Best Regards,
Tamas
Hi Atanas,
I had no luck with this one. Anyway I'd like to achieve the connection without any IIS/SSAS or anything. There is a freeware XMLA browser called REX that is able to connect to my SAP BW without anything like these.
Can't we use MsXmlAnalysis with MsXmlAnalysisSoap to connect?
I think it would work, since that it what I've found in the WSDL:
<w:definitions targetNamespace="urn:schemas-microsoft-com:xml-analysis">
−<w:types>−<s:schema targetNamespace="urn:schemas-microsoft-com:xml-analysis" elementFormDefault="qualified" attributeFormDefault="qualified">−<s:element name="Discover">−<s:complexType>−<s:sequence><s:element name="RequestType" type="s:string" nillable="true"/>−<s:element name="Restrictions" nillable="true">−<s:complexType>−<s:sequence>−<s:element name="RestrictionList">−<s:complexType>−<s:sequence>−<s:element name="CATALOG_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="32"/></s:restriction></s:simpleType></s:element>−<s:element name="CUBE_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="70"/></s:restriction></s:simpleType></s:element>−<s:element name="CUBE_TYPE" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="70"/></s:restriction></s:simpleType></s:element>−<s:element name="DIMENSION_UNIQUE_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="32"/></s:restriction></s:simpleType></s:element>−<s:element name="HIERARCHY_UNIQUE_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="65"/></s:restriction></s:simpleType></s:element>−<s:element name="LEVEL_UNIQUE_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="108"/></s:restriction></s:simpleType></s:element><s:element name="LEVEL_NUMBER" type="s:unsignedInt" nillable="true"/>−<s:element name="MEMBER_UNIQUE_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="143"/></s:restriction></s:simpleType></s:element><s:element name="TREE_OP" type="s:unsignedInt" nillable="true"/>−<s:element name="MEASURE_UNIQUE_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="143"/></s:restriction></s:simpleType></s:element>−<s:element name="PROPERTY_NAME" nillable="true">−<s:simpleType>−<s:restriction base="s:string"><s:maxLength value="30"/></s:restriction></s:simpleType></s:element></s:sequence></s:complexType></s:element></s:sequence></s:complexType></s:element>−<s:element name="Properties" nillable="true">−<s:complexType>−<s:complexContent>−<s:extension base="s0:PropertiesType">−<s:sequence>−<s:element name="PropertyList">−<s:complexType>−<s:sequence><s:element name="AxisFormat" type="s:string" nillable="true"/>−<s:element name="BeginRange" nillable="true">−<s:simpleType>−<s:restriction base="s:int"><s:totalDigits value="10"/></s:restriction></s:simpleType></s:element>−<s:element name="EndRange" nillable="true">−<s:simpleType>−<s:restriction base="s:int"><s:totalDigits value="10"/></s:restriction></s:simpleType></s:element><s:element name="Catalog" type="s:string" nillable="true"/><s:element name="Cube" type="s:string" nillable="true"/><s:element name="Content" type="s:string" nillable="true"/><s:element name="DataSourceInfo" type="s:string" nillable="true"/><s:element name="Format" type="s:string" nillable="true"/><s:element name="LocalIdentifier" type="s:string" nillable="true"/><s:element name="MDXSupport" type="s:string" nillable="true"/><s:element name="ProviderName" type="s:string" nillable="true"/><s:element name="ProviderVersion" type="s:string" nillable="true"/><s:element name="StateSupport" type="s:string" nillable="true"/>−<s:element name="Timeout" nillable="true">−<s:simpleType>−<s:restriction base="s:int"><s:totalDigits value="10"/></s:restriction></s:simpleType></s:element></s:sequence></s:complexType></s:element></s:sequence></s:extension></s:complexContent></s:complexType></s:element></s:sequence></s:complexType></s:element>−<s:element name="DiscoverResponse">−<s:complexType>−<s:sequence>−<s:element name="return" minOccurs="0">−<s:complexType>−<s:sequence><s:any/></s:sequence></s:complexType></s:element></s:sequence></s:complexType></s:element>−<s:element name="Execute">−<s:complexType>−<s:sequence>−<s:element name="Command" nillable="true">−<s:complexType>−<s:sequence><s:element name="Statement" type="s:string" nillable="true"/></s:sequence></s:complexType></s:element><s:element name="Properties" type="s0:PropertiesType"/></s:sequence></s:complexType></s:element>−<s:element name="ExecuteResponse">−<s:complexType>−<s:sequence>−<s:element name="return" minOccurs="0">−<s:complexType>−<s:sequence><s:any/></s:sequence></s:complexType></s:element></s:sequence></s:complexType></s:element><s:complexType name="PropertiesType"/></s:schema></w:types>−<w:message name="DiscoverSoapIn"><w:part name="parameters" element="s0:Discover"/></w:message>−<w:message name="DiscoverSoapOut"><w:part name="parameters" element="s0:DiscoverResponse"/></w:message>−<w:message name="ExecuteSoapIn"><w:part name="parameters" element="s0:Execute"/></w:message>−<w:message name="ExecuteSoapOut"><w:part name="parameters" element="s0:ExecuteResponse"/></w:message>−<w:portType name="MsXmlAnalysisSoap">−<w:operation name="Discover"><w:input message="s0:DiscoverSoapIn"/><w:output message="s0:DiscoverSoapOut"/></w:operation>−<w:operation name="Execute"><w:input message="s0:ExecuteSoapIn"/><w:output message="s0:ExecuteSoapOut"/></w:operation></w:portType>−<w:binding name="MsXmlAnalysisSoap" type="s0:MsXmlAnalysisSoap"><soap:binding transport="http://schemas.xmlsoap.org/soap/http" style="document"/>−<w:operation name="Discover"><soap:operation soapAction="urn:schemas-microsoft-com:xml-analysis:Discover" style="document"/>−<w:input><soap:body use="literal"/></w:input>−<w:output><soap:body use="literal"/></w:output></w:operation>−<w:operation name="Execute"><soap:operation soapAction="urn:schemas-microsoft-com:xml-analysis:Execute" style="document"/>−<w:input><soap:body use="literal"/></w:input>−<w:output><soap:body use="literal"/></w:output></w:operation></w:binding>−<w:service name="MsXmlAnalysis">−<w:port name="MsXmlAnalysisSoap" binding="s0:MsXmlAnalysisSoap"><soap:address location="http://192.168.0.197:8000/sap/bw/xml/soap/xmla"/></w:port></w:service></w:definitions>
Many thanks and Best Regards,
Hi, Tamas,
Here is the code for a sample AdomdDataSource:
<olap:AdomdDataSource x:Key="adomdDataSource" Database="Adventure Works DW Standard Edition"> <olap:AdomdDataSource.ConnectionSettings> <olap:AdomdConnectionSettings ConnectionString="Provider=MSOLAP.4;Persist Security Info=True;Data Source=http://sampledata.infragistics.com/olap/msmdpump.dll;MDX Compatibility=1;Safety Options=2;MDX Missing Member Mode=Error" /> </olap:AdomdDataSource.ConnectionSettings> </olap:AdomdDataSource>
The olap namespace is this:
xmlns:olap="http://schemas.infragistics.com/olap"
You should change the connection string to reflect your desired settings to connect to the SAP server and then assign the data source to the XamPivotGrid's DataSource property.
All the best,
Atanas
Hi George,
Can you please give some hints about AdomdClient? Do you maybe have a sample program?
What I'd like to achieve is to connect directly to SAP BW without any SSAS or any Microsoft stuff in between.
Thanks and best regards,
it is 7.01.
Best regards,