BusinessObjects Board

Scheduling report with prior month's results

general discussion
#1

Hi,
I have a prompt in my Universe and the end users can enter any date they like.

Now, I would like to schedule this report so that the report shows the prior month’s results. It will be sent out every 15th of the month. So, for this month (January 2014), I would like the report to show Dec 2013 results.

How can I accomplish this? Thank you in advance.

samistl (BOB member since 2012-12-26)

#2

Create universe objects for “first day of last month” and “last day of last month” - this topic shows how: DB-specific Relative Dates SQL Server, Oracle, Netezza, DB2

In your report - instead of your prompt, just put

where date between first_day_of_last_month_object and last_day_of_last_month_object

Debbie

Debbie :uk: (BOB member since 2005-03-01)