Cognos-11日期提示-如何添加“前8周”的筛选器？

Question

我对Cognos的编码方面非常陌生！

我正在尝试设置一个自动报告，它将在每周一运行，但计算前8周的数据。我已经添加了提示按钮来显示‘最近8周’，但现在我不确定如何添加它作为一个实际的过滤器。以下是我的当前日期过滤器：

case 
when ?p_DateCat? = 'EnteredDates'
then    case
        when ?p_StartDate? <> current_date
        then ?p_StartDate?
        else _add_days (current_date, -1) 
        end
when ?p_DateCat? = 'Yesterday'
then _add_days (current_date, -1) 
when ?p_DateCat? = 'ThisWeek'
then _add_days (current_date, 1-(_day_of_week (current_date, 1))) 
when ?p_DateCat? = 'ThisMonth'
then _add_days (current_date, 1-(_day (current_date))) 
when ?p_DateCat? = 'LastMonth'
then _add_months (_first_of_month (current_date), -1)
end

and

case 
when ?p_DateCat? = 'EnteredDates'
then    case
        when ?p_EndDate? <> current_date
        then ?p_EndDate?
        else _add_days (current_date, -1) 
        end
when ?p_DateCat? = 'Yesterday'
then _add_days (current_date, -1) 
when ?p_DateCat? = 'ThisWeek'
then _add_days (current_date, -1) 
when ?p_DateCat? = 'ThisMonth'
then _add_days (current_date, -1) 
when ?p_DateCat? = 'LastMonth'
then _last_of_month(_add_months (current_date, -1))
end```

Answer 1

找到答案: DateField >= _add_days (current_date，-56)

或

_add_days (current_date，-56)和_add_days (current_date，-1)之间的DateField

语法错误是由于其他行引起的。一旦删除，它将完美运行所需的56天！