Skip to Content
0

How to make a date value as default in the webi prompt and ...

Dec 06, 2016 at 10:40 PM

61

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

seshu P Dec 08, 2016 at 01:35 PM
0
Share
10 |10000 characters needed characters left characters exceeded