Report Studio

Validating a Report Studio Report

 

Validate your report to ensure that it contains no errors.

To validate A Report in Report Studio:

  1. Open the report that you want.
  2. If you want to clear parameters values stored on the PPM Cognos server, from the File menu, click Clear Parameter Values.
     
  3. From the Tools menu, click Validate Report .

    A message box appears indicating whether any errors were found in the report.
  4. If you require more detail from the validation process, from the Tools menu, click Validate Options, and do the following:
     
  5. Click one of the following validation levels.

 

Validation Level

Description

Error

Retrieves all errors returned from the query.

Warning

Retrieves all errors and warnings returned from the query.

Key Transformation

In addition to errors and warnings, retrieves informational messages describing important transformation steps from the report specification to the native query sent to the data source.

 

These messages can be helpful to understand the cause of errors and warnings returned from the query.

 

This feature is only partially implemented at present.

Information

Retrieves errors, warnings, key transformations, and other information related to query planning and execution.

 

 

 

  1. If you want to view only the tabular data, from the Run menu, click View Tabular Data .

    If the report contains multiple queries, you must first click an object, such as a list or crosstab, that uses the query for which you want to view the tabular data.

    Use this command to ensure that the right results appear. For example, you create a calculation and you want to ensure it is giving you the results you want.

    Note:
    You can also view tabular data in Query Studio, which is useful when you are building queries.
  2. If you encounter validation errors and want Report Studio to identify incorrect objects in your report, from the Tools menu, click Auto Correct.

    Report Studio provides a list of such objects that you can remove individually to successfully run your report.

    In some cases, the information or error message is linked to the location of the issue in your report. To go to the location of the issue, click the message, then click Select. If only warnings are information appear in the dialog box, these will disappear when you click OK.

 

Related Topics: