Summary Browser-based multidimensional data reporting - using IE5 & WebService Behaviour that implements Open XML for Analysis Specification 1.0

Current Features :

• Drag & drop support to build MDX Query
• Run MDX Query without refreshing the entire page
• Dynamic multidimensional report generation
• SOAP standard, based on XML Analysis Specification 1.0

Current Limitations :

• Some variables are still hardcoded
• ....

Project files :

• Client.htm
• webservice.htc (Microsoft's WebService Behaviour beta 2)
• xamd.xsl  (taken from XML for Analysis SDK)
• xmla.wsdl (taken from XML for Analysis SDK)
  

Requirements :

• Server Side :
  SQL Server 2000 + Analysis Service
  XML for Analysis SDK
  MSXML 3.0
• Client Side :
  IE5 or greater
  MSXML 3.0

Installation :

Copy all files into any virtual directory

Open these files & change the addresses below with your own :

• Client.htm :
  var BaseURL = http://localhost/olap/ ;
• xmla.wsdl :
  <soap:address location='http://localhost/xmla/msxisapi.dll' />

Additional information

<!-- Part of the code (Client.htm) --> <script language="JavaScript"> var BaseURL = "http://localhost/olap/"; //Change this with your URL var WSDLURL = BaseURL + "xmla.wsdl"; var XSLURL = BaseURL + "xamd.xsl"; var SoapMethod = "Execute"; var isFinish; function init() { service.use(WSDLURL, "FriendlyName"); } function Invoke() { var strQuery = (txtMDXQuery.value); strQuery = "<Statement>" + strQuery + "</Statement>"; var xmlQuery = new ActiveXObject("MSXML2.DOMDocument.3.0"); xmlQuery.async = false if(xmlQuery.loadXML(strQuery) == false) { alert("error parsing xmlQuery"); } //This property is still hardcoded var strProps = "<PropertyList><DataSourceInfo>Provider=MSOLAP;Data Source=local</DataSourceInfo><Catalog>FoodMart 2000</Catalog><Content>Data</Content><Format>Multidimensional</Format></PropertyList>"; var xmlProps = new ActiveXObject("MSXML2.DOMDocument.3.0"); xmlProps.async = false if(xmlProps.loadXML(strProps) == false) { alert("error parsing xmlProps"); } isFinish=false; iCallID = service.FriendlyName.call(CallBackFunction, SoapMethod, xmlQuery, xmlProps); idProgress.innerText = "LOADING.. | "; checkReadyState(); } function CallBackFunction(result) { isFinish=true; idProgress.innerText = " "; if(result.error) { var xfaultcode = result.errorDetail.code; var xfaultstring = result.errorDetail.string; var xfaultsoap = result.errorDetail.raw; alert("Errors xfaultcode->" + xfaultcode + " xfaultstring->" + xfaultstring + " xfaultsoap->" + xfaultsoap); } else { var xmlResult = result.raw.xml; if (xmlResult != "" && xmlResult != null) { var xmlDoc = new ActiveXObject("MSXML2.DOMDocument.3.0"); xmlDoc.async = false if(xmlDoc.loadXML(xmlResult) == false) { alert("error parsing XML"); } xmlDoc.loadXML(xmlDoc.documentElement.selectSingleNode("//root").xml); var docXsl = new ActiveXObject("MSXML2.DOMDocument.3.0"); docXsl.async = false if(docXsl.load(XSLURL) == false) { alert("error parsing XSL"); } var strTransformed = xmlDoc.transformNode(docXsl); idReport.innerHTML = strTransformed; } } } </script>