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 Tamas,
We are enabling the pivot grid to bind to XMLA data sources. SQL Server & SAP are two examples of servers that support XMLA as a data access option. Other controls in the suite (Chart, Map, etc) do not currenlty support that data format. If that's something that you'd be interested in, let me know, it seems like it would make sense for the chart controls for sure.
The pivot grid takes a URI which points to the XMLA service, so if you have a correctly configured server the grid will consume the data. We have posted information on configuring a SQL Server Analysis Server to serve up XMLA, we do not have any information on configuring SAP to serve up XMLA.
Let me know if you need any more info on this,
Thanks
Jason
Hi Jason,
I've tried to modify the sample program to get all the data from SAP BW (replaced the URI), but it did not work out. However I see that the URI that is in the sample points to a dll, and my URI is this:
http://192.168.0.197:8000/sap/bw/xml/soap/xmla
Anyway, other applications can access my SAP BW installation through xmla (get the cubes, cube details etc.).
What could be the problem?
Thanks and best regards,
Tamas
I've tried the following connection string:
"Provider=MDrmSAP;Data Source=http://192.168.0.197:8000/sap/bw/xml/soap/xmla;User ID=xxx;Password=xxx;SFC_CLIENT=000;SFC_LANGUAGE=EN;Prompt=4"
However an exception is thrown: the server did not return the Catalog property. It is strange that the same error message is given if I modify the Provider or the DataSource to an invalid value.
I have installed the SAP GUI extension for BW which as far as I know contains the ODBO drivers.
Do I have to install IIS on the SAP server?
Thanks and Best Regards,
I've made some progress with plain XMLA connection. Now I can access the server from Visual Studio by simply creating a web service reference to the BW system. I have problems with connecting this to the pivotgrid.
Here is my code:
using (SAPXMLA.MsXmlAnalysisSoapClient ws = new SAPXMLA.MsXmlAnalysisSoapClient()) { SAPXMLA.Restrictions r = new SAPXMLA.Restrictions(); SAPXMLA.Properties p = new SAPXMLA.Properties(); SAPXMLA.Properties.PropertyListType pl = new SAPXMLA.Properties.PropertyListType(); SAPXMLA.Restrictions.RestrictionListType rl = new SAPXMLA.Restrictions.RestrictionListType(); p.PropertyList = pl; r.RestrictionList = rl; p.PropertyList.DataSourceInfo = "default"; p.PropertyList.Content = "SchemaData"; p.PropertyList.Format = "Tabular"; ws.ClientCredentials.UserName.UserName = "xxx"; ws.ClientCredentials.UserName.Password = "xxx"; System.Xml.Linq.XElement elem = ws.Discover("MDSCHEMA_CUBES", r, p);
}
I see that you have XmlaConnection, XmlaDataProvider and XmlaDataSource, but I don't know how to use them.
All the examples in the help use an URL wich point to "msmdpump.dll". However this is not the case for me, I use the webservice via SOAP. How can I use the infragistics xmla stuff via SOAP?
msmdpump.dll". However this is not the case for me, I use the webservice via SOAP. How can I use the infragistics xmla stuff via SOAP?
Hi, Tamas,
I have installed a Trial version of the SAP NW and have reproduced your exact setup. At this point you can't use that data as a source as a new DataProvider has to be implemented. We are working on the issue and will notify you as soon as we have a solution.
I am sorry for the inconvenience.
Atanas
Hi Atanas,
I've found two very good blogs about setting up BW for the Netweaver trial edition:
http://wiki.sdn.sap.com/wiki/display/BI/Setting+Up+BI+in+Netweaver+7.0+ABAP+Trial+version
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5916
I hope this helps.
Unfortunately the server is down :( I'll try to breathe new life into it as soon as possible. I'll update you when it can be accessed again.By the way the rex tool (warehouse explorer) is open source. I don't know if it helps you, but the source code is included in the download. It is in java, but it's possible to figure out how it communicates with the target system.Thanks and best regards,Tamas