Browse DevX
Sign up for e-mail newsletters from DevX


Web-enable Your Business Intelligence Using XML/A and ASP.NET : Page 2

Exploit the power of XML for Analysis (XML/A) and make your data cubes available via the Web using a simple Web service, an ASP.NET Web Form, and some XSLT to format the data.




Building the Right Environment to Support AI, Machine Learning and Deep Learning

Obtaining and Installing the XML/A SDK
Microsoft has released the first version of the XML/A SDK for Analysis Server. This entire SDK consists of one DLL, msxisapi.dll, and several configuration files. The msxisapi.dll sends Discover and Execute requests encapsulated in SOAP packets, wraps the response XML in a SOAP packet and sends it back to the client. To use the DLL, you need to create a Web site, map it to the msxisapi.dll and start sending and receiving SOAP packets (see Figure 2).
Figure 2: The msxisapi.dll handles sending and receiving SOAP packets to and from clients.
Now that you have some idea of what XML/A is and how it works, it's time to set it up on your computer. Here are the steps to install XML/A:

  1. Download the XML/A SDK.
  2. Install it in the desired directory. I recommend that you accept the default installation path.
  3. Open IIS and create a virtual directory named "xmla" and map it to the directory that contains the msxisapi.dll file. Typically, you'll find that file in the ISAPI subdirectory of your XML for Analysis SDK installation.
After installing you can use the local URL http://localhost/xmla/msxisapi.dll (substitute your server's domain name for localhost if you didn't install XML/A on your local machine) to accept SOAP packets and run queries

Comment and Contribute






(Maximum characters: 1200). You have 1200 characters left.



Thanks for your registration, follow us on our social networks to keep up-to-date