Why are unexpected values displayed in the Input Control List box if one CABI Web Intelligence Document has multiple reports?

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:

If you create a Web Intelligence Document with multiple reports, for example, create 2 reports, one report shows all tickets for Group A, and the other shows all tickets for Group B, all values, regardless of the Group, show in the Input Control List box.

e.g.
The Group A report has the Request Statuses "OP" and "ACK" and the Group B report has only "WIP". The Request Status list box has 3 values, "ACK", "OP" and "WIP" including all the available statuses for both reports. Also note the Request Type Symbol list box on the Group B report displays "Request" despite there being no Request tickets available for Group B.

<Please see attached file for image>

<Please see attached file for image>

Solution:

This is working by design. If you would like the Input Control to display only the values related to each report, you need to create a new Dimension and specify it as the Input Control.

e.g. Create the Input Control for "Request Status".

1. Open a Web Intelligence Document in edit mode and click on <Edit Report>.
   
   
2. Click on <Variable Editor> icon from the toolbar.
   
   

   <Please see attached file for image>

   
   
   
3. Type the following and click <Save>.
   
   e.g. For Request Status,
   
   Name: Query 1 Request Status
   Qualification: Dimension
   Formula: =[Query 1].[Request Status] In ([Query 1].[Request Status])
   
   

   <Please see attached file for image>

   
   
   
4. Select [Data] tab and make sure if the created dimension "Query 1 Request Status" is displayed.
   
   

   <Please see attached file for image>

   
   
   
5. Open [Input Control] tab and click on <New>.
   
   

   <Please see attached file for image>

   
   
   
6. Select "Query 1 Request Status" from 'Select Report Object' list and click on <Next>.
   
   

   <Please see attached file for image>

   
   
   
7. Choose Control Type and click on <Next>, and then hit <Finish>.
   --->
   The values listed in the input Control are displayed as expected.
   
   

   <Please see attached file for image>

   
   
   

You need to create the Dimensions for all Input Controls similarly.

Environment

Release: UAPMAC990JPP-12.6-Asset Portfolio Management-Asset Configuration
Component: