Cognos Analytics

 View Only
Expand all | Collapse all

Filtering issue in Dashboard

  • 1.  Filtering issue in Dashboard

    Posted Wed November 09, 2022 08:12 AM
    Hi,

    I am using cognos 11.2.1 . I created a simple data module with Customer and time as dimensions and Revenue as Fact table. All inner joins. Time dimension has the column dependencies set ( year, quarter, Month, date levels). In Dashboard, I dragged columns from Customer and Revenue in Table visualization and added quarter from time dimension limiting to current quarter as local filter. The local filter is not getting applied. I get data summed up for all quarters. But when I add it as a part of the required columns in the table , the filter is working fine and I get data just for current quarter . Is there way to filter on a dimension without adding as a layout element of the visualization in Cognos dashboard just like in Reporting?

    ------------------------------
    Raghavan
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Filtering issue in Dashboard

    IBM Champion
    Posted Fri November 11, 2022 10:09 AM
    Hi, Is the filter defined in the dashboard (widget) or in the data module? Does this happen if you remove the column dependencies (they should be unneccessary if you are only joining on date level)? But anyway this sounds a bit like a support case for IBM.

    ------------------------------
    Philipp Hornung
    ------------------------------