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

[srinivasp74]

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

[former_member199945]

HI ,

Have you checked this

https://blogs.sap.com/2015/07/17/how-to-use-new-feature-dynamic-default-value-for-universe-unx-promp...