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.

Article Id: 18436
Status: Published
Updated On: 14-02-2018 07:25
Legacy Id: TEC612157
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>

    Figure 1

  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>

    Figure 2

  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

insert_drive_file 1558696997484000018436_sktwi1f5rjvs16nna.gif
arrow_downward Download
insert_drive_file 1558696995600000018436_sktwi1f5rjvs16nn9.gif
arrow_downward Download