Skip to Content
avatar image
santhosh c

Prompt with default current date and show the data for past one month

Feb 22, 2018 at 07:05 PM | 45 Views | Last edit Feb 22, 2018 at 07:07 PM 2 rev.

Hi ,

I have a Creation date field in Webi report. Whenever user executes the reports the field creation date should take current date and gives output for past one month. Could anyone suggest how to achieve this in Webi report or in Universe.

Thanks and Regards

Santhosh

SAP BusinessObjects - Web Intelligence (WebI)
SAP BusinessObjects BW Universe Builder | SAP BusinessObjects BI support tool | SAP BusinessObjects Explorer | SAP BusinessObjects - OLAP | sap webi
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Anish Mahadik
    Feb 23, 2018 at 03:56 PM

    Hi Santosh,

    Pass the current date as a default parameter or create constant value as Current date filter in universe so it will show Creation date as current date.

    And to show for last month data , Create predefined filter at universe level and use the same filter at Report Level so report will bring last month data.

    Thanks,

    Anish

    Add comment
    10|10000 characters needed characters exceeded