Read a date filter as input in WEBI report in SAP BO

Your requirement is one of its kinds but can be achieved. What you can try out is first create a brand new object in the context.

Let's say you provided the date as first input and 5 as a weekly slice in the second input.

Example

Here's how you can create a date filter formula using DATEADD function with prompts ?

[Date+5]=DATEADD(@prompt('Slice','X'{'Day','Month','Year'},mono,constrained,persistent),5,@prompt('Date','date',mono,free,persistent))

In this formula:

• X refers to your slice type (Day, Month, or Year)
• Date refers to the date input from the user
• 5 is the number of units to add to the base date
• mono specifies single selection
• constrained/free determines if values are restricted to list of values
• persistent saves the prompt value for the session

Implementation Steps

To implement this date filter in your WEBI report, follow these steps ?

1. Create a new object in the universe context using the formula above
2. Save and export the universe
3. In your WEBI report, add a filter using this new object
4. When you refresh the report, you'll be prompted for both the date and slice values

Then you can just add another filter to the report using this new object. The system will automatically prompt users for the required date and slice parameters when the report is refreshed.

Conclusion

This approach allows you to create dynamic date filters in SAP BusinessObjects WEBI reports by combining date prompts with the DATEADD function to calculate date ranges based on user input.