Dear Experts,
I have defined the filter in Cockpit for Table widget but when executing with filters it is not showing any data. I had performed the following.
1. Defined the Query like "DOC_SALES_UNIT_COST_BY_MONTH" data set that is Example with Knowage.
select t.the_month,
DATE_FORMAT(t.the_date,'%d-%m-%Y') as the_day,
t.month_of_year, round(sum(unit_sales),2) as UNIT_SALES,
round(sum(store_sales),2) as SALES,
round(sum(store_cost),2) as COSTS
FROM sales_fact f inner join time_by_day t
on (f.time_id=t.time_id)
where t.the_year=$P{Year}
and t.the_month = 'April'
group by t.the_month, t.the_day,t.day_of_month
2. After that defined the "PARAMETERS" in dataset as following
Name : "Year"
Type : String
Default Value : 2015
Multivalue : Null
3. Defined the Analytical Driver that is already available with Knowage example i.e. "Year"
4. Create the new Cockpit with Table widget and saved and defined the "DOCUMENT ANALYTICAL DRIVER DETAILS"
Title : "Year"
Analytical driver : "Year"
Url Name : Year
with all other parameters remained default.
5. Now when trying to filter the table widget it is not filtering the data in the widget.
