Skip to Content
avatar image
Former Member

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

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
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Dec 08, 2016 at 01:35 PM
    Add comment
    10|10000 characters needed characters exceeded