Active reports multi-select issue

[Kiewaier]

I am using a cloud version of cognos analytics to generate active reports.
The multi-select function is not working consistently. It only works when the first checkbox is ticked.
My scenario: I have 3 check boxes Dubai, Hongkong, Singapore

If I select select Dubai, hk, sg
Data for all 3 countries is shown - all good

If select Dubai, sg
Data for Dubai and sg is shown - all good. Ditto for Dubai + HK

If I select sg, then hk
Only data for SG is shown. Hk data missing. The variable used for filtering shows SG, HK

If I select hk, then sg
Only data for hk is shown. Sg data is missing.  The variable used for filtering shows SG, HK

I'm using IE11. Could this be a bug in active reports

[MFGF]

I am using a cloud version of cognos analytics to generate active reports.
The multi-select function is not working consistently. It only works when the first checkbox is ticked.
My scenario: I have 3 check boxes Dubai, Hongkong, Singapore

If I select select Dubai, hk, sg
Data for all 3 countries is shown - all good

If select Dubai, sg
Data for Dubai and sg is shown - all good. Ditto for Dubai + HK

If I select sg, then hk
Only data for SG is shown. Hk data missing. The variable used for filtering shows SG, HK

If I select hk, then sg
Only data for hk is shown. Sg data is missing.  The variable used for filtering shows SG, HK

I'm using IE11. Could this be a bug in active reports

Hi,

Can you detail what your structures in the report are, and how the variable interacts with them? For example, are you driving a data deck using SELECT behaviour? Are you filtering a list or a visualization using FILTER behaviour? Something else?

Cheers!

MF.

[Kiewaier]

Hi
These are the items that I'm using in my active report

A query with the fields location, and expense amount

Data Check box with mutli select turn on.
This is linked to the location field in the query.

A data tab with a list in it.
The list is linked to the same query.

I have set a connection between the check box and the list, using a variable v_location to pass the value.
The interaction is set to 'filter', not 'select'. I used the 'in' condition when filtering.

These were the settings that I read off an IBM support page.

The strange thing is that multi select works when the first checkbox is ticked. But stops working when it is unticked. I checked v_location when I ran the report. It does indeed change to reflect all the values that are ticked.

[MFGF]

Hi
These are the items that I'm using in my active report

A query with the fields location, and expense amount

Data Check box with mutli select turn on.
This is linked to the location field in the query.

A data tab with a list in it.
The list is linked to the same query.

I have set a connection between the check box and the list, using a variable v_location to pass the value.
The interaction is set to 'filter', not 'select'. I used the 'in' condition when filtering.

These were the settings that I read off an IBM support page.

The strange thing is that multi select works when the first checkbox is ticked. But stops working when it is unticked. I checked v_location when I ran the report. It does indeed change to reflect all the values that are ticked.

Hi,

Is the data tab interfering with things here? I'm not seeing any need for it if you're just filtering a list? First try to simplify things by moving the list outside the data tab and removing the data tab from your report. Basically all you need is a control (your Data Check Box) based on one query, a List based on a second query, and a connection between the two where the data check box filters the list.

Cheers!

MF.

[Kiewaier]

Thanks, MFGF for your advice on stripping away the unnecessary elements. It took a lot of tries, but I finally got it to work. For some reason, it had to be done in this specific sequence that I will describe below. Hope this helps others who are facing the same issue.

1. Create query1
2. Add data checkbox (CB1) linked to query1.
3. Add field to be used in the checkbox. 'Location' for example
4. Add EMPTY list (list1). Link it to query1 but do not add any fields at this point in time
5. Create connection between checkbox.
Control Source: CB1
Control target: list1
Use FILTER instead of selection
Use a new or existing variable to store the field location
Select 'Copy from source'
6. You will find a new greyed out field 'location1' added to list1. Do not remove it. Leave it hidden if you don't want to display it.
7. Add the rest of the fields that you want to display into list1

That will work.

For cross tabs, it's different.
Populate the cross tab with fields before setting up the connection.

In both cases, connect the check box directly to the list or cross tab. Do not pass the variable value via data deck. Setting up the master relationship breaks it as well.

Cheers
Ai'er

[MFGF]

Thanks, MFGF for your advice on stripping away the unnecessary elements. It took a lot of tries, but I finally got it to work. For some reason, it had to be done in this specific sequence that I will describe below. Hope this helps others who are facing the same issue.

1. Create query1
2. Add data checkbox (CB1) linked to query1.
3. Add field to be used in the checkbox. 'Location' for example
4. Add EMPTY list (list1). Link it to query1 but do not add any fields at this point in time
5. Create connection between checkbox.
Control Source: CB1
Control target: list1
Use FILTER instead of selection
Use a new or existing variable to store the field location
Select 'Copy from source'
6. You will find a new greyed out field 'location1' added to list1. Do not remove it. Leave it hidden if you don't want to display it.
7. Add the rest of the fields that you want to display into list1

That will work.

For cross tabs, it's different.
Populate the cross tab with fields before setting up the connection.

In both cases, connect the check box directly to the list or cross tab. Do not pass the variable value via data deck. Setting up the master relationship breaks it as well.

Cheers
Ai'er

Hi,

That's one way to do this, but there are alternatives too. I would probably take the following approach:

1. Add a table to your page with one column and two rows - one for the checkbox control and one for the list.
2. Drag a data checkbox group into the top cell of the table. Allow it to default to using Query1 (maybe rename the query at this point to indicate it is for the data checkbox group).
3. Drag the field to be used into the data checkbox group.
4. Add a List to the bottom cell of the table. Allow it to default to using Query2 (again, maybe rename the query to indicate it is used for the List).
5. Drag the required items into the list, including the item you intend to filter on (the item you added to the data checkbox group).
6. Create a connection between the data checkbox group and the list. It will recognize the common item and populate the dialog for you. Choose the Filter behaviour.
7. In the List, click on the column body of the item you are filtering on, and from the Ancestor dropdown choose List Column. Set the Column Visibility property to Hidden.

Cheers!

MF.

[Kiewaier]

Thanks! I'll give it a try