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
Are you using Silverlight or WPF version of the control?
Thanks,George
Hi George,
I'm using the WPF version.
Did you tried with AdomdClient?
No I haven't tried. However I could not try it today, I'm not sure what I have to install to have this. I cannot use Microsoft.AnalysisServices.AdomdClient in my project and I don't know which reference I should add.
I'm not sure if I need the Microsoft Analysis Services to use this. Can't we simply use the URL that SAP provides for XMLA (soap based)?
For anyone who is following this thread - the feature is complete now. It is being rigorously tested at the moment and will be officially included in the upcoming 10.3 release.
Hi, Tamas,
There are good news. The feature is almost ready. We are in the process of testing it. We will release it before the end of the month (along with the service release) if we manage to confirm that it is working properly.
It would be very much helpful if you could provide us with some sample data to test it with (I did setup a trial SAP server, but I could not get real data into it, apart from cubes, dimensions and measures - I've never worked with the administrative tool before). The address to the sap xmla service and credentials for it should be enough. Do not expose any sensitive data through the service. Any dummy data would do. If the service returns non null result for MDX queries it would be perfect. You could send the credentials to my email: adyulgerov@infragistics.com if you do not want them published in the forum.
All the best,
Atanas
Hi Atanas,
May I kindly ask if there are news on the topic? Can I help somehow?
Many thanks and best regards,
Hi Atanas, May I ask if it is likely that this XMLA connection via SOAP will work with SAP by the end of August? I'll have to do some sort of a presentation and I must know if I will be able to include your product or not. Many thanks and best regards, Tamas
This is exactly what I did for half a day yesterday... it is pretty complicated. Luckily I found two step by step guides:
http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/5916
http://learnsapbw.blogspot.com/2008/04/infocube-creation-using-sap-bw-35-bi-70.html
I'm not a BW expert, so it was SAP (slow and painful) for me too :)