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

Document ID : KB000019225
Last Modified Date : 14/02/2018
Show Technical Document Details

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.

Figure 1

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.

    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])

    Figure 4

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

    Figure 5

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

    Figure 6

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

    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.

    Figure 8

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