Viewpoint Reporting Overview

Viewpoint has extended the BIRT Reporting Framework for report viewing and there are several standard reports that are available when Moab is configured to use the MySQL database.

Due to the memory intensive nature of reporting, Tomcat's permanent generation (PermGen) memory should be increased. Add the following configuration setting to your other JAVA_OPTS settings in your Tomcat init script: JAVA_OPTS="$JAVA_OPTS -XX:MaxPermSize=256m" Specifying more heap space is ineffective in handling the memory intensive nature of reporting; more PermGen improves performance.

Configuring Viewpoint for Reporting

Once Moab is configured to use MySQL for statistics, configure Viewpoint to view standard reports by following these steps:

1. To allow users to access the Viewpoint Reporting page, add the report.read permission to the core.xml file that is located in the Viewpoint home directory.

<permission name="report.read" />

2. Add the page to the navigation links by adding the following to the core.xml file in the navigation section:

<menu label="Reporting">
  <link href="page://Reporting" label="Reporting">
   <permission name="report.read" />
  </link>
</menu>

3. Configure the reporting.xml file. The reporting.xml file should be located in the Viewpoint home directory. The file contains information for all standard reports and configuration information for the MySQL database connection. The following is an example reporting.xml file:

<reporting xsi:schemaLocation="http://www.adaptivecomputing.com reporting.xsd">
  <reports>
    <report>
      <display-name>Test</display-name>
      <name>test.rptdesign</name>
      <display-category>Adaptive</display-category>
      <category>adaptive</category>
      <description>desc for test</description>
    </report>
    <report>
      <displayName>Jobs Submitted</displayName>
      <name>jobs_submitted.rptdesign</name>
      <display-category>Adaptive</display-category>
      <category>adaptive</category>
      <description>Report for viewing submitted jobs by user, group, qos and account</description>
    </report>
  </reports>
  <database-connection type="mysql-jdbc">
    <url>jdbc:mysql://localhost/Moab</url>
    <username>root</username>
    <password>root</password>
    <driver>com.mysql.jdbc.Driver</driver>
  </database-connection>
</reporting>

4. Configure the MySQL database connection in Moab. Use the following example as a guide:

<database-connection type="mysql-jdbc">
  <url>jdbc:mysql://localhost/Moab</url>
  <username>root</username>
  <password>root</password>
  <driver>com.mysql.jdbc.Driver</driver>
</database-connection>

• The type of connection is mysql-jdbc.
• The <url> element contains a JDBC database connection URL to either your own database or Moab's ODBC database.
• The <username> and <password> elements are for the Moab ODBC database.
• The <driver> element is the MySQL JDBC driver that you're using. Note that you must include the JDBC driver in the Viewpoint application WEB-INF/lib directory.