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

What connection strings did you try? Do you have the OLE DB for OLAP (ODBO) provider installed in the SAP deployment?

Try this connection string in my sample above:

Provider=MDrmSAP;Data Source=<my_bw_server>;User ID=<my_user_id>;Password=<my_password>;SFC_CLIENT=100;SFC_LANGUAGE=EN;Prompt=4

MDrmSAP is the registered name of the SAP ODBO module.

Take a look at those articles too.

http://www.simba.com/docs/Connecting-to-SAP-BW-from-ASP-Using-ADO-MD.pdf

http://help.sap.com/javadocs/NW04/current/bi/docs/connectors/odbo_howto.html

http://help.sap.com/saphelp_bw/helpdata/en//17/cb8685de1511d2acb70000e829fbfe/content.htm

Hi,

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,

Tamas

Hi,

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?

Thanks and best regards,

Tamas

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.

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.

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,

Tamas

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

Hi Atanas,

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 :)

Thanks and best regards,

Tamás