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, 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 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

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

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