SAP Knowledge Base Article - Public

1314354 - Message: "Your range has been reduced to maximum rows allowed" appears when opening a dashboard document.

Symptom

  • Information message is displayed when a dashboard model is exported to SAP BusinessObjects platform.
  • Message: "Your range has been reduced to maximum rows allowed".

Environment

  • SAP BusinssObjects Business Intelligence Platform 4.x
  • SAP Dashboards 4.x

Reproducing the Issue

  1. Logon to Dashboard Designer
  2. From the query browser, create a query having a result set exceeding 100 row 
  3. Go to Query properties, change the maximum rows to 100
  4. Map the query data to Excel sheet
  5. Create a component on top of it
  6. Save this model to Enterprise.
  7. From BI launchpad, open the dashboard file and the warning appears

Cause

It's a warning message indicating that the result set is exceeding the maximum limit defined.

Resolution

  1. Logon to Designer and import the dashboard
  2. From the query browser, edit the query
  3. Go to Query properties, increase the maximum rows to the wanted value
  4. Save this model back to Enterprise.

Keywords

xcelsius, max, error, missing, limited , KBA , BI-RA-XL-DES , Dashboards, design-time, designing, exporting, usability , BI-RA-XL , BusinessObjects Dashboards and Presentation Design , Problem

Product

SAP BusinessObjects Dashboards 4.0 ; SAP BusinessObjects Dashboards 4.1 ; SAP BusinessObjects Dashboards 4.2 ; SAP BusinessObjects Xcelsius Enterprise 2008