var awO="http://localhost/xmla/msxisapi.dll";var vU="http://localhost";var Hu="False";var Kw="1";var YW="";var uQ="";var FN="";var GK="45";var aCB="True";var abg="500";var abj="2500";var aaO="";var sc="";var MQ=false;var GK=30;var ry=500;var agC=2500;if(GK!=""){GK=parseInt(GK)};if(abg!=""){ry=parseInt(abg)};if(abj!=""){agC=parseInt(abj)};function Xmla(){this.cT=new ActiveXObject("Microsoft.XMLHTTP");this.hz=ael;this.nd=nd;this.gw=null;this.aas=null;this.aaL=false;this.PO="Data";};function ael(ib,dR,cB){if(gq==""){ad.Show(false);O.ShowMessageBox("XmlaServer is not set.",bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");return;}if(!dR||dR==""){dR="Multidimensional"};if(!cB){cB=""};document.body.style.cursor="wait";var cT=this.cT;var MY=oB("Command",oB("Statement",Az(ib)));var Ch=oB("Properties","<PropertyList><DataSourceInfo>"+kf+"</DataSourceInfo><Catalog>"+hh+"</Catalog><Content>"+this.PO+"</Content><Format>"+dR+"</Format><SspropInitAppName>DM Companion</SspropInitAppName>"+cB+"</PropertyList>");var xG=" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi = \"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"";var cC="<?xml version='1.0'?>\n"+'<SOAP-ENV:Envelope '+xG+">\n"+Aw()+"<SOAP-ENV:Body>\n"+" <Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\" >"+MY+Ch+" </Execute>"+"</SOAP-ENV:Body>\n"+"</SOAP-ENV:Envelope>\n";var by=GL(gq);if(!pP(gq))return;if(this.gw){cT.open("POST",by,true);var iCall=bS.length-1;cT.onreadystatechange=function(){Qi(iCall)};}else{cT.open("POST",by,false);}cT.setRequestHeader("SOAPAction",'"'+"urn:schemas-microsoft-com:xml-analysis:Execute"+'"');cT.setRequestHeader("Content-Type","text/xml");if(uQ!=""&&Hu=="True")cT.setRequestHeader("Authorization","Basic "+GU(uQ+":"+FN));for(var iTry=0;iTry<10;iTry++){try{cT.send(cC);break;}catch(e){if(e.message.indexOf("download of the specified resource has failed")== -1&&e.message.indexOf("No data is available for the requested resource")== -1&&e.message.indexOf("Unspecified error")== -1){EW("Client","Internal error",e.message);break;}else{if(iTry==9){EW("Client","Final Internal error",e.message);}else{cT=new ActiveXObject("Microsoft.XMLHTTP");if(this.gw){this.cT=cT;cT.open("POST",by,true);var iCall=bS.length-1;cT.onreadystatechange=function(){Qi(iCall)};}else{cT.open("POST",by,false);}cT.setRequestHeader("SOAPAction",'"'+"urn:schemas-microsoft-com:xml-analysis:Execute"+'"');cT.setRequestHeader("Content-Type","text/xml");if(uQ!=""&&Hu=="True")cT.setRequestHeader("Authorization","Basic "+GU(uQ+":"+FN));}}}}if(!this.gw){document.body.style.cursor="default";FH(cT.responseXML);if(cT.responseXML.parsed==true){return cT.responseXML;}else{return aaA(cT.responseText);}}};function Aw(){if(YW!="True")return "";if(sc==""){return "<SOAP-ENV:Header><XA:BeginSession xmlns:XA=\"urn:schemas-microsoft-com:xml-analysis\" xsi:type=\"xsd:int\" mustUnderstand=\"1\"/></SOAP-ENV:Header>";}else{return "<SOAP-ENV:Header><XA:Session xmlns:XA=\"urn:schemas-microsoft-com:xml-analysis\" mustUnderstand=\"1\" SessionId=\""+sc+"\"/></SOAP-ENV:Header>";}};function FH(aH){if(sc!=""||YW!="True")return;var aw=aH.selectSingleNode("SOAP-ENV:Envelope/SOAP-ENV:Header/Session");if(aw==null)return;var Ws=aw.attributes.getNamedItem("SessionId");if(Ws==null)return;sc=Ws.text;};function aaH(ib){document.body.style.cursor="wait";var acL="<SOAP-ENV:Header><XA:BeginSession xmlns:XA=\"urn:schemas-microsoft-com:xml-analysis\" xsi:type=\"xsd:int\" mustUnderstand=\"1\"/></SOAP-ENV:Header>";var cT=EL("BEGIN TRANSACTION",acL);var sc=cT.responseXML.selectSingleNode("SOAP-ENV:Envelope/SOAP-ENV:Header/Session").attributes.getNamedItem("SessionId").text;if(!pP(gq))return;var ra="<SOAP-ENV:Header><XA:Session xmlns:XA=\"urn:schemas-microsoft-com:xml-analysis\" mustUnderstand=\"1\" SessionId=\""+sc+"\"/></SOAP-ENV:Header>";EL(ib,ra);var wE="<SOAP-ENV:Header><XA:EndSession xmlns:XA=\"urn:schemas-microsoft-com:xml-analysis\" xsi:type=\"xsd:int\" mustUnderstand=\"1\" SessionId=\""+sc+"\"/></SOAP-ENV:Header>";EL("COMMIT TRANSACTION",wE);document.body.style.cursor="default";};function EL(ib,sHeader){document.body.style.cursor="wait";var cT=new ActiveXObject("Microsoft.XMLHTTP");var Ch=oB("Properties","<PropertyList><DataSourceInfo>"+kf+"</DataSourceInfo><Catalog>"+hh+"</Catalog><Content>Data</Content><Format>Multidimensional</Format><SspropInitAppName>DM Companion</SspropInitAppName></PropertyList>");var xG=" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi = \"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"";var MY=oB("Command",oB("Statement",Az(ib)));var cC="<?xml version='1.0'?>\n"+'<SOAP-ENV:Envelope '+xG+">\n"+sHeader+"<SOAP-ENV:Body>\n"+" <Execute xmlns=\"urn:schemas-microsoft-com:xml-analysis\" >"+MY+Ch+" </Execute>"+"</SOAP-ENV:Body>\n"+"</SOAP-ENV:Envelope>\n";var by=GL(gq);if(!pP(gq))return;cT.open("POST",by,false);cT.setRequestHeader("SOAPAction",'"'+"urn:schemas-microsoft-com:xml-analysis:Execute"+'"');cT.setRequestHeader("Content-Type","text/xml");if(uQ!=""&&Hu=="True")cT.setRequestHeader("Authorization","Basic "+GU(uQ+":"+FN));try{cT.send(cC);}catch(e){ad.Show(false);EW("Client","Internal error",e.message);}var kP=GetFault(cT.responseXML);if(kP!=""){ad.Show(false);O.ShowMessageBox("Error: "+kP,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");}return cT;};function nd(cv,gk,bX){if(gq==""){ad.Show(false);O.ShowMessageBox("XmlaServer not set.",bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");return};var cT=this.cT;var strType=oB("RequestType",cv);var strRestrictions=oB("Restrictions",oB("RestrictionList",gk));var Ch=oB("Properties",oB("PropertyList",bX));var xG=" xmlns:SOAP-ENV=\"http://schemas.xmlsoap.org/soap/envelope/\" xmlns:xsi = \"http://www.w3.org/2001/XMLSchema-instance\" xmlns:xsd=\"http://www.w3.org/2001/XMLSchema\"";var cC="<SOAP-ENV:Envelope "+xG+" >"+" <SOAP-ENV:Body>"+" <Discover xmlns=\"urn:schemas-microsoft-com:xml-analysis\" >"+strType+strRestrictions+Ch+" </Discover>"+" </SOAP-ENV:Body>"+" </SOAP-ENV:Envelope>";var by=gq;if(!pP(gq))return;if(this.gw){cT.open("POST",by,true);var iCall=bS.length-1;cT.onreadystatechange=function(){Qi(iCall)};}else{cT.open("POST",by,false);}cT.setRequestHeader("SOAPAction",'"'+"urn:schemas-microsoft-com:xml-analysis:Discover"+'"');cT.setRequestHeader("Content-Type","text/xml");if(uQ!=""&&Hu=="True")cT.setRequestHeader("Authorization","Basic "+GU(uQ+":"+FN));try{cT.send(cC);}catch(e){EW("Client","Internal error",e.message);}if(!this.gw){if(cT.responseXML.parsed==true){return cT.responseXML;}else{return aaA(cT.responseText);}}};function Qi(hX){var cT=bS[hX].cT;if(cT==null||cT.readyState!=4)return;document.body.style.cursor="default";if(bS[hX].aaL)return;bS[hX].aaL=true;var Ga="";if(cT.responseXML.parseError.errorCode!=0){Ga=cT.responseText.substring(1,500);EW("Server","Unknown server error",Ga);bS[hX].cT=null;}else if(cT.responseXML.documentElement==null){bS[hX].cT=null;ad.Show(false);O.ShowMessageBox("Error: responseXML.documentElement is NULL<br/>Text: "+cT.responseText,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");}else{var aH=cT.responseXML;var kP=GetFault(aH);if(kP!=""){if(window.Abort)(Qc());ad.Show(false);O.ShowMessageBox("Error: "+kP,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");if(bS[hX].aas){bS[hX].aas(kP);}}else{FH(cT.responseXML);bS[hX].gw(aH);}bS[hX].cT=null;}};function EW(errCode,errString,errRaw){if(MQ==true){ad.Show(false);O.ShowMessageBox("Query is canceled.",bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");MQ=false;}else{ad.Show(false);O.ShowMessageBox("Errors Code: "+errCode+"<br/>Error: "+errString+"<br/>Row Error: "+errRaw,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");}};function GetFault(aH){var strDescr="";if(nU()){var oNodeList=aH.selectNodes("soap:Envelope/soap:Body/ExecuteResponse/return/root/Messages/Error");}else{var oNodeList=aH.selectNodes("SOAP-ENV:Envelope/SOAP-ENV:Body/SOAP-ENV:Fault/detail/faultstring/Error");}try{var i=oNodeList.length;}catch(e){return "";}for(var i=0;i<oNodeList.length;i++){strDescr+=oNodeList[i].attributes.getNamedItem("Description").nodeValue+"\n";}if(strDescr==""){if(nU()){var aw=aH.selectSingleNode("soap:Envelope/soap:Body/soap:Fault/faultstring");}else{var aw=aH.selectSingleNode("SOAP-ENV:Envelope/SOAP-ENV:Body/SOAP-ENV:Fault/faultstring");}if(aw){strDescr=aw.text;}}return strDescr;};function aaA(hs){var jq=new ActiveXObject("MSXML.DOMDocument");jq.async=false;if(jq.loadXML(hs)==false){ad.Show(false);O.ShowMessageBox("XML Parsing Error:"+hs,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");}return jq;};function ayp(http){var jq=new ActiveXObject("MSXML.DOMDocument");jq.async=false;if(jq.load(http)==false){ad.Show(false);O.ShowMessageBox("Error parsing xml from http: "+http,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");}return jq;};function GL(by){if(Kw=="0"||Kw=="")return by;if(Kw=="1"){if(by.substring(0,4)!="http")return by;if(by.substring(0,vU.length).toLowerCase()==vU.toLowerCase()){return by;}}return by;};function akG(by){if(by.substring(0,4)=="http")return by;if(by.substring(0,1)=="/"){return vU+by;}else{return vU+"/"+by;}};function aaE(){if(gq.substring(0,vU.length).toLowerCase()==vU.toLowerCase()){var by=gq.substring(vU.length);if(by.indexOf(":")== -1){return by;}else{var iProxyPos=by.indexOf("?url");if(iProxyPos!= -1&&iProxyPos<by.indexOf(":")){return by;}else{return gq;}}}else{return gq;}};function Az(s){s=PP(s,"&","&amp;");s=PP(s,"<","&lt;");s=PP(s,">","&gt;");return s;};function PP(s,sSearch,replaceStr){var regexp=eval("/"+sSearch+"/gi");return s.replace(regexp,replaceStr);};function oB(sTag,bQ){return "<"+sTag+">"+bQ+"</"+sTag+">"};function Qc(){var i=bS.length-1;if(bS[i].cT){MQ=true;bS[i].cT.abort();bS[i].cT=null;}document.body.style.cursor="default";if(window.idAbort&&window.idAbort.style){idAbort.style.display="none";}};function GU(pY){var JM="";var chr1,chr2,chr3="";var enc1,enc2,enc3,enc4="";var i=0;var keyStr="ABCDEFGHIJKLMNOP"+"QRSTUVWXYZabcdef"+"ghijklmnopqrstuv"+"wxyz0123456789+/"+"=";do{chr1=pY.charCodeAt(i++);chr2=pY.charCodeAt(i++);chr3=pY.charCodeAt(i++);enc1=chr1>>2;enc2=((chr1&3)<<4)|(chr2>>4);enc3=((chr2&15)<<2)|(chr3>>6);enc4=chr3&63;if(isNaN(chr2)){enc3=enc4=64;}else if(isNaN(chr3)){enc4=64;}JM=JM+keyStr.charAt(enc1)+keyStr.charAt(enc2)+keyStr.charAt(enc3)+keyStr.charAt(enc4);chr1=chr2=chr3="";enc1=enc2=enc3=enc4="";}while(i<pY.length);return JM;};function nU(){return(gq.toLowerCase().indexOf("msmdpump.dll")!= -1)};function adY(){var cv="MDSCHEMA_CUBES";var gk="<CATALOG_NAME>"+hh+"</CATALOG_NAME><CUBE_NAME>"+et+"</CUBE_NAME>";var bX="<DataSourceInfo>"+kf+"</DataSourceInfo><Catalog>"+hh+"</Catalog><Format>Tabular</Format><SspropInitAppName>DM Companion</SspropInitAppName><Content>SchemaData</Content>";var av=new Xmla;var aH=av.nd(cv,gk,bX);var kP=GetFault(aH);if(kP!=""||aH.documentElement==null){ad.Show(false);O.ShowMessageBox("Error: "+kP,bz.Stop,bA.OK,null,"title:XMLA Info; width:400; height:200; zIndex:11100;");return "";}var bD="";var ac=aH.selectNodes("//root/row");if(ac.length>0){bD=ac[0].selectSingleNode("LAST_DATA_UPDATE").text;if(nU()==false){aaO=""}bD=PM(bD);}return bD;};function PM(sMyDate){try{var BQ=sMyDate.split("T");var sJ=BQ[0];var Ci=BQ[1];var jj=sJ.split("-");var oD="";var nk="";var sP="";switch(aaO){case "YYYY-MM-DD":oD=jj[0];nk=jj[1];sP=jj[2];break;case "DD-MM-YYYY":sP=jj[0];nk=jj[1];oD=jj[2];break;case "MM-DD-YYYY":nk=jj[0];sP=jj[1];oD=jj[2];break;}if(oD==""){return sJ+" "+Ci;}var JN=Ci.split(":");var Ux=parseInt(parseFloat(JN[0]));var Tn=parseInt(parseFloat(JN[1]));var Tz=parseInt(parseFloat(JN[2]));nk=parseInt(parseFloat(nk))-1;var dt=new Date();dt.setFullYear(oD,nk,sP);if(true){dt.setUTCHours(Ux,Tn,Tz);}else{dt.setHours(Ux,Tn,Tz);}}catch(e){return sJ};if(dt==null||dt+""=="NaN"){return sJ};return dt.toLocaleString();}