Troubleshooting: Your report does not display data

Pentaho Business Analytics

Version
10.1.x
Audience
anonymous
Part Number
MK-95PDIA004-17

In some situations, your report might not display any data. The table below outlines the most likely scenarios and their solutions.

What you did What happened Likely Reason Example Solution
You added or modified a filter The report returned blank. The filter(s) you added are too restrictive. Your filter only includes the year '1997' but you have sales revenue only for '2005'. Change your filters or change the report options to show rows or columns where the number cell is blank.
You added a new number field. The report returned blank. There are no values for the number field(s) that in the report. You added the "Quota" field but you have not yet loaded any Quota data into Pentaho. Contact your administrator to: 1) get data loaded into this field OR 2) hide this field.
You added a new text field. You have no number fields on the report. The report returned blank. You have two or more text fields on the report but in some cases Pentaho Analyzer needs a number field to tie it all together. You have Account Name and Order Status on the report Add a number field.