I am working on BO 4.0 SP9. Our requirement is to schedule the webi reports with dynamic prompt values like the below scenario:
If the report is scheduled every monday, then the data should be for the last week. (i.e last sunday to monday)
If the report is scheduled every 1st day of the month, then data should be for entire last month.
Like wise there can be other scenarios as well. currently to schedule such reports we need to create customer exit variable at bex level and so we need to create seperate reports for each scenario.
So, I wanted to know if there is any way that we can achieve scheduling webi reports with dynamic prompts.