Program Installation

Please follow the following steps to install the application:

1) Install XML for Analysis SDK

• Install MSXML 4.0
• Install XML for Analysis SDK 1.1
• Create the that points to the “C:\Program Files\Microsoft XML For Analysis SDK\isapi” folder
• Change the execute permissions for the “XMLA” virtual directory to “Script and Executables”
• Update the datasources.xml to point to your OLAP Server

2) Install the program files

• Create a virtual directory (XmlaClient for example)
• Unzip all of the files into the directory

3) Change the xmla.asp file to point to the your server.

• In xmla.asp change var sXmlaServer = "http://localhost/xmla/msxisapi.dll"; to var sXmlaServer = "http://your_serve/xmla/msxisapi.dll";

4) Setup Database

• Execute “tables.sql” script file against your database to create two tables (QueryFolder, QueryXml) that will hold the report information.
• Double click on the "xmla.udl" and point it to the location of the database.