Cognos Analytics

 View Only
  • 1.  11.1 Active Report, Data Buttons not Filtering Crosstabs

    Posted Mon June 17, 2019 03:28 AM
    I have tested the simplest of Active Report features and am having some issues.

    When using a Data Radio Button Group to filter other elements of an Active Report, the Filter works on all items (Lists, Visualisations etc) but does not filter or even select a Crosstab.

    Here are the settings,

    and the output result,

    Any idea why this might be happening?

    ------------------------------
    Jonathan berry
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: 11.1 Active Report, Data Buttons not Filtering Crosstabs

    Posted Tue June 18, 2019 09:46 AM
    @Jonathan berry If you add a data item/member to the column of the crosstab do you get the desired behavior?​ Also, if you are looking to filter the crosstab, make sure to specify the filter details in the container filter of the crosstab.

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 3.  RE: 11.1 Active Report, Data Buttons not Filtering Crosstabs

    Posted Thu June 20, 2019 03:07 AM
    Hi Denny, No adding a data item does not solve it. I have also specified the filter details in the container filter of the crosstab. Still no luck. As I said the settings of the Crosstab and List are identical.

    ------------------------------
    Jonathan berry
    ------------------------------



  • 4.  RE: 11.1 Active Report, Data Buttons not Filtering Crosstabs

    Posted Thu June 20, 2019 07:41 AM
    @Jonathan berry - Are you able to provide a copy of the report spec or a sample report spec showing the issue? ​

    ------------------------------
    DENNY NAREZNY
    ------------------------------



  • 5.  RE: 11.1 Active Report, Data Buttons not Filtering Crosstabs

    Posted Tue June 18, 2019 01:49 PM
    Hi Jonathan,
    I had a similar issue a while back, where I wanted to connect a data checkbox group to a crosstab, but didn't want the connecting data item visible on my crosstab.

    So I placed the connecting data item on a list ( as a hidden column) and also in the underlying crosstab query. Then embedded the crosstab in the list, connected the list-crosstab with a master detail relationship.

    Then connected the data checkbox group to the list query. And the crosstab filtering worked just fine.

    To clean up a bit of the messy structure I set the list column title (the one holding the crosstab) Box Type property to None. So the only items visible were the data checkbox group and the crosstab.

    Hope this helps,
    Syd

    ------------------------------
    Syd
    Cognos Consultant / Trainer
    Newberg OR
    ------------------------------