How to make a date value as default in the webi prompt and provide option for user to select desired date
Hi All,
User requirement is to populate the webi prompt with a default date (trunc(sysdate,'MM')-1) and also should be able to enter different date in the webi report . We are on 4.1 SP6 and my universe is in .UNV.
To achieve this ,
1) I have created a dimension in universe with definition :
start date = @Prompt('Enter Begin Date:','D',, mono,free)
2) Created a filter object in the universe and in the where condition , I have inserted the code : M_GLDW1.REV_EXP_JRNL_LN_VW.ACCOUNTING_PERIOD = CASE WHEN @Prompt('Enter Begin Date:','D',, mono,free) = ' ' then(trunc(sysdate,'MM')-1) else @Select(Report Objects\start date) end
But I am getting error "Inconsistent Data Types: Expecting DATE ,got CHAR STATE N/A" when I click Parse Objects . After saving the universe , when I include the filter object in the webi filter and execute the report , default date value is not populating in the prompt.
Any suggestions on this ?
Thanks,
Srinivas
Add comment