Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Reg: Current Weekly Filter

Hi friends,

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.

Advance Thanks

Not what you were looking for? View more on this topic or Ask a question