How to use @prompt in semantic layer to get yesterdays date by default in webi ?

[Former Member]

Hi All,

Is it possible to get the report by yesterdays date by default and also user must be possible to select previous dates as such ( Optional Prompt )

Please provide me the @prompt definitions. I have been trying and gone through many links, but still I am stuck at the same place.
Please help em out in this issue.

I am using SAP BO SP4 and DB is SQL Server 2008.

Thanks,

Santhosh

[Former Member]

Have a read through the blog post below; it should help.

http://www.dagira.com/2008/07/21/using-a-magic-date-value-in-prompts/

Regards,

Mark