Running CA Business Intelligence Web Intelligence (WEBI) reports provide only a limited/partial result set.

Products

• SUPPORT AUTOMATION- SERVER
• CA Service Desk Manager - Unified Self Service
• CA Service Desk Manager
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

Description:

Running CA Business Intelligence Web Intelligence (WEBI) reports provide only a limited/partial result set.

The WEBI result set window shows a 'Partial Results' message.

<Please see attached file for image>

Solution:

The cause of the 'Partial Results' message is a restriction on how many records are returned when executing a WEBI report.

There are a couple of places where the restriction could be enabled:

A. Within the report definition

From within the WEBI report, in the Properties tab of the Query Panel, there are the following options:

Maximum Rows Retrieved
Maximum Retrieval Time

<Please see attached file for image>

Ensure that there are no restrictions defined that could effect the report result set returned.

B. Within the CA Service Desk Universe parameters

1. From the Business Objects (BOXI) Designer application on the BOXI server (START -> PROGRAMS -> BUSINESSOBJECTS XI 3.1 -> BUSINESS OBJECTS ENTERPRISE -> ENTERPRISE), import the CA Service Desk Universe
   
   
2. Click on FILE -> PARAMETERS and select the CONTROLS tab
   
   

   <Please see attached file for image>

   
   
   
3. Ensure that there any restrictions defined are not interfering with the report result set.
   
   
4. Save changes and export CA Service Desk Universe (FILE -> EXPORT)

Environment

Release:
Component: SDBOXI