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

book

Article ID: 19225

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:

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>

Figure 1

<Please see attached file for image>

Figure 2

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>

    Figure 3

  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>

    Figure 4

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

    <Please see attached file for image>

    Figure 5

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

    <Please see attached file for image>

    Figure 6

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

    <Please see attached file for image>

    Figure 7

  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>

    Figure 8

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

Environment

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

Attachments

1558704385528000019225_sktwi1f5rjvs16qi5.gif get_app
1558704383418000019225_sktwi1f5rjvs16qi4.gif get_app
1558704381701000019225_sktwi1f5rjvs16qi3.gif get_app
1558704379987000019225_sktwi1f5rjvs16qi2.gif get_app
1558704378028000019225_sktwi1f5rjvs16qi1.gif get_app
1558704376053000019225_sktwi1f5rjvs16qi0.gif get_app
1558704374029000019225_sktwi1f5rjvs16qhz.gif get_app
1558704371944000019225_sktwi1f5rjvs16qhy.gif get_app