Set up the Report usage report

The Report usage report lists reports by frequency of use. Before it can be used, it must be set up.

Procedure

  1. If you are using the default application server (Tomcat) that is provided with IBM® Cognos® Business Intelligence, then in a text editor, open the web.xml file located at c10_location\webapps\p2pd\WEB-INF, and add the following XML fragment: 
    <servlet> 
	<servlet-name>DSServlet</servlet-name> 
   <servlet-class>com.cognos.demo.DSServlet</servlet-class> 
</servlet> 
<servlet-mapping> 
	<servlet-name>DSServlet</servlet-name> 
	<url-pattern>/cognos/DSServlet.jsp</url-pattern> 
</servlet-mapping>

    Note that the url-pattern value can be anything you choose.

  2. If you are using an application server other than Tomcat, or if Content Manager and Application Tier Components are installed in separate locations, add the XML fragment from step 1 to the following files:
    • c10_location\webapps\p2pd\WEB-INF\web.xml.noCM
    • c10_location\webapps\p2pd\WEB-INF\web.xml.withCM
  3. If you do not have the following directory on your system, create it: c10_location\webapps\p2pd\WEB-INF\classes\com\cognos\demo.
  4. Copy the file build.bat for Microsoft Windows operating system or build.sh for UNIX operating system located in c10_location\webapps\Audit to c10_location\webapps\p2pd\WEB-INF\classes\com\cognos\demo.

    Edit the build file to ensure the JAVA_HOME definition points to your JDK and ensure the CRN_HOME definition points to your IBM Cognos location.

  5. If it is not already there, copy the DSServlet.java file from the c10_location\webapps\Audit directory to c10_location\webapps\p2pd\WEB-INF\classes\com\cognos\demo.
  6. Do one of the following in the DSServlet.java file:
    • If you are allowing anonymous logon, comment out the following line: binding.logon(...)
    • If you are not allowing anonymous logon, make sure that the username, password, and namespace are correct and uncomment the following line: binding.logon(...)
  7. At a command prompt, run build.bat or build.sh from c10_location\webapps\p2pd\WEB-INF\classes\com\cognos\demo to compile the Java source file into the class file.
  8. Restart IBM Cognos software and open IBM Cognos Connection.
  9. If you are using an application server other than Tomcat, rebuild the application file and then redeploy IBM Cognos BI to the application server.

    For instructions, see the IBM Cognos Business Intelligence Installation and Configuration Guide.

  10. Create a data source connection to the XML data source by doing the following:
    1. In the upper-right corner of IBM Cognos Connection, click Launch, IBM Cognos Administration.
    2. On the Configuration tab, click New Data Source.
    3. Under Name, type url_xml.
    4. Click Next.
    5. Under Type, select XML.
    6. Click Next.
    7. In the Connection string field, enter the connection string. If you used the defaults, the connection string is http://localhost:9300/p2pd/cognos/DSServlet.jsp.
    8. Click OK.
Parent topic: Sample Audit Model and Audit Reports