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.