Reg: Current Weekly Filter
I am having one requirement to add current weekly filter in webi report, where starting day is Sunday and end day is Saturday.
The report should be automated with the current weekly filter, so i have added current weekly filter in IDT and i have published .
I am using this query for current weekly filter DimDate.Date between CONVERT(date, dateadd(WEEK,0,getdate())) and convert(date,GETDATE(),6)
But when i do published it shows successfully but when i open in webi level to add this filter in filter panel, the current weekly filter is not showing so can any one can help me to fix this issues.