Configuring a report to generate a truncated output

A Data Insight report can contain any number rows based on the report type and its input parameters. A report having an large number of rows can have significant overheads for system resources. You can avoid this overhead, by truncating the report to include only a specified number of rows (records).

You can truncate only the following reports:

You can specify a value to truncate the report outputs for all the supported report types.

To set a global value to truncate all report types

  1. On the Data Insight Management Server, navigate to C:\Program Files\Veritas\DataInsight\bin\.
  2. Open the reportcli.vmoptions file in a text editor.
  3. Set the value for the argument, Dreport.details.limit, with the desired number of records.
  4. Save and close the file.

You can also specify a truncation value for a report type which overrides the global truncation value for that report types.

To truncate a particular report type

  1. In the Data Insight Management Console, click Reports.
  2. From the left-hand side pane, click the report you want to generate. The Reports listing page displays a list of already generated reports, if any.
  3. Click Create Report.
  4. Click Configuration.
  5. In Truncate output if record exceeds field, specify the maximum number of rows after which you want the report to be truncated..
  6. Click Save.

Once you configure a report to have a truncated output, the report instance on the Reports listing page displays a warning icon under the Last Run Status column. Hover your mouse pointer over the warning icon to view the total number of rows that the report would normally contain if no truncation value was specified.

You can modify the truncation value directly from the report listing page and regenerate the current instance of the report. Additionally, you can save setting to be applied for all the future instances of the report.

To modify the truncation value for regenerating a report instance

  1. In the Data Insight Management Console, click Reports.
  2. Click the report type to view the listing page for that report type. It displays the generated instances of the report. The report instance with truncated records displays a warning icon under its Last Run Status column.
  3. Click the report instance for which you want to modify the truncation value.
  4. Click Select Action.
  5. Click Regenerate Output.
  6. Enter the new value for the maximum row count for the report.
  7. Select Save settings for future reports to apply the settings for all the future instances of the report.
  8. Click Generate Output to generate the report with the revised row count.