In CA Business Intelligence (CABI) Web Intelligence (WEBI) reports, if a date prompt object with option 'Prompt with List of values' unchecked is used within a report, the list of values are still displayed even though they should not.

Products

• 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:

In CABI WEBI reports, if a date prompt object with option 'Prompt with List of values' unchecked is used within a report, the list of values are still displayed even though they should not.

Solution:

Steps to reproduce

1. Launch WEBI Infoview and create a new WEBI document based on the OOTB CA Service Desk Universe
   
   
2. Create a simple Request report and add a date filter. For example, add SYSTEM TIME (Request->Request Activity) to the Query Filters pane.
   
   
3. For SYSTEM TIME filter, change operator to Between, select Prompt for both ranges, and in Prompt properties uncheck 'Prompt with List of values'.
   
   
4. Run the query and notice that the list of values, instead of the calendar picker is displayed.

This has been identified as SAP as a product defect (ADAPT01686478) introduced with SP6.

Work Around:

1. Via the CABI Universe Designer application, import the OOTB CA Service Desk Universe
   
   
2. Click on the EDIT menu and select FIND
   
   
3. In the FIND WHAT dialog box, enter 'System Time' and ensure that NAMES is check under LOOK ALSO IN
   
   

   <Please see attached file for image>

   
   
   
4. Click FIND NEXT. The left hand pane will refresh with the location of the System Time object.
   
   
5. Double click on System Time and click on the PROPERTIES tab.
   
   
6. Unselect the 'Associate a List of Values' option
   
   

   <Please see attached file for image>

   
   
   
7. Click OK
   
   
8. Click FIND NEXT again - it will take you to the next instance of the System Time object within the Universe.
   
   
9. Repeat steps #5-#7 for all other occurrences of the System Time object
   
   
10. Save and Export the Universe
    
    
11. If you are already in Infoview, logout and clear your web browser cache
    
    
12. Login to Infoview and attempt to run the report(s) that were exhibiting the behavior.

Solution:

The above ADAPT is also fixed in CABI 3.3 SP2 (SAP BOXI 3.1 SP7). Applying this Service Pack would also resolve the issue as well.

Environment

Release:
Component: SDBOXI