Control empty rows in reports

As an administrator, you can enable or disable the Show empty rows property at the Pentaho Server level. You can use this property to prevent a cross-join that is resource-intensive on the server. The values for the Show empty rows property are:

• enable

  All users have access (default).

• Disable

  No users have access.

• adminOnly

  Only admin users have access.

To control the report option, perform the following steps:

1. Navigate to the pentaho-server/pentaho-solutions/system/analyzer/ directory and open the analyzer.properties file with any text editor.

2. Set the report options showEmpty property to enable.

   The Show rows or columns with drop-down menu displays in the Report Optionsdialog box, as shown in the following example:

   

   Analyzer Report Options dialog box
3. Choose one of the following options:

   • Measure Data.

   • Measure and Calculated Measure data

   • Show all even blank measures

4. Restart the Pentaho Server.