Web Services for DB2 Cube Views

Since this operation requires strong knowledge of programming language and Web service architecture, the package also includes an "out-of-the-box" solution in the form of an HTML front end. We encourage you to use this front end to become familiar with the Web service. Please refer to the documentation for information on how to install and use this front end.

• Only a subset of the XPath language is supported for the methods members and execute. Refer to the samples queries and the documentation to find the precise syntax.
• The XML attribute schema is not supported; in consequence, all elements of the metadata must use the same schema, and two elements at the same level (for example, two cubeDimensions of the same cube) cannot have the same name.
• Only balanced hierarchies with a standard deployment are supported.
• Only symmetric measures are supported; that is to say, only measures with one aggregation and one template are supported.

• Are you using the good version of TOMCAT (at least 4.1 is required)?
• Do you have the following environment variables defined correctly:
• CATALINA_HOME (TOMCAT main directory)
• JAVA_HOME (JDK 1.4.1 main directory)
• PATH contains %JAVA_HOME%\bin;%JAVA_HOME%\jre\bin
• Do you have all the needed libraries? During the installation, the Web service is deployed on a SOAP router. To run it correctly, you must have the following libraries (Assuming TOMCAT is installed on C:\Tomcat):
C:\Tomcat\shared\lib\xercesImpl.jar
C:\Tomcat\shared\lib\xml-apis.jar
C:\Tomcat\common\lib\activation.jar;
C:\Tomcat\common\lib\mail.jar;
C:\Tomcat\shared\lib\soap.jar

• Is TOMCAT running? This is necessary in order to deploy the Web service on the Web router.
• Do you get the following error?
[SOAPException: faultCode=SOAP-ENV:Client; msg=Error opening socket: Connection refused ...]
Then either TOMCAT is not running or else the URL of the SOAP router is incorrect. The script uses "http://localhost:8080/soap/servlet/rpcrouter".