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