Specifying Maximum Rows and Columns

Administrators can specify maximum values for rows and columns to be retrieved in a Smart View grid. By default, Provider Services installations set a maximum of 5000 rows and a maximum of 255 columns. If all Smart View users are using Excel 2007 or later, the administrator can increase these maximum values for rows and columns. However, if some or all Smart View users are using Excel 2003, then the default values of 5000 rows and 255 columns (the limits set by Excel 2003) must be used.

Changes to the maximum row and column properties take effect only after the Smart View client connects to a new session of Provider Services.

  To specify maximum rows and columns:

  1. Open Administration Services.

  2. From Enterprise View or a custom view, under the Hyperion Provider Services node, select the Provider node.

  3. Right-click and select Edit, then Properties.

  4. In Hyperion Provider Services Properties, select Settings.

  5. In Maximum number of rows, specify the number of rows to retrieve (default is 5,000).

  6. In Maximum number of columns, specify the number of columns to retrieve (default is 255).

  7. Click Apply.

  8. Click Close.