Web Intelligence Report which has more than 5000 rows does not display.

book

Article ID: 49799

calendar_today

Updated On:

Products

CA IT Asset Manager CA Software Asset Manager (CA SAM) ASSET PORTFOLIO MGMT- SERVER SUPPORT AUTOMATION- SERVER CA Service Desk Manager - Unified Self Service KNOWLEDGE TOOLS CA Service Management - Asset Portfolio Management CA Service Management - Service Desk Manager

Issue/Introduction

Description:

This issue occurs because of the option "Limit size of result set to" is set to 5000 by default.

Solution:

To resolve this issue, increase the value of "Limit size of result set to" to 10000 by following the below steps:

  1. Login to the designer with administrator credentials.

  2. Click on File and Import the Universe. Once imported, click on File and then Parameters.

  3. In the Universe parameters window, click on controls tab and check the option "Limit size of result set to" and change the value to 10000 as shown in the below screenshot:

    <Please see attached file for image>

    Figure 1

  4. Click on OK and then click on File and then click on Export.

  5. Once export in the designer is completed, login to Infoview and run the report.

You should now able fetch more than 5000 rows.

Environment

Release:
Component: ARGIS

Attachments

1558709861923000049799_sktwi1f5rjvs16rmz.gif get_app