SAP Knowledge Base Article - Public

1314354 - Message: "Your range has been reduced to maximum rows allowed"

Symptom

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

Environment

  • Xcelsius 2008 Enterprise Service Pack 3
  • SAP Dashboards 4.x
  • BusinessObjects Enterprise XI 3.1

Reproducing the Issue

  1. Create an Xcelsius dashboard which contains data mapped to more than 512 rows.
  2. Go to File > Export > SAP BusinessObjecs Platform and save this model to Enterprise.

Cause

The default row limit set for Excel in Xcelsius 2008 is 512 rows.

Resolution

In Xcelsius, go to File > Preferences > Excel Options and increased the "Maximum Number Of Rows" to match the number of rows of data present in Excel sheet.

Note: It is recommended to keep this number less than 1024 to avoid performance issue of dashboard during design and runtime.

Keywords

KBA , BI-RA-XL-DES , Dashboards, design-time, designing, exporting, usability , Problem

Product

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