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
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.
Hi, Tamas,
Thanks for the tutorials, they came in handy.
There is no need for you to expose your server publicly. I managed to set up one here. I can explore some of the cubes and dimensions with the REX tool you sent me. That should be enough for our dev team to figure it out. They are working on it as I write and hopefully will be able to complete it soon.
I'll keep you posted.
All the best,
Atanas
Tamas,
I run into a little problem with the SAP BW. In the demo I have set up I have a number of dimensions and measures, but I cant figure out how to enter data in the cube. I have the structure but the results of all my MDX queries are empty. I've been trying to populate the cube my whole day today fruitlessly.
Can you point me in the right direction?
This is exactly what I did for half a day yesterday... it is pretty complicated. Luckily I found two step by step guides:
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 :)
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
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.
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.
May I kindly ask if there are news on the topic? Can I help somehow?
Many thanks and best regards,