Hi,
We have following requirement. We need to create 3 webi reports for following requirement and then send the reports as excel to the users
YTD-
Posting start date u2013 1st day of the year - End date u2013 last day of the month
QTD-
Posting start date u2013 1st day of the qtr - End date u2013 last day of the month
MTD-
Posting start date u2013 1st day of the month - End date u2013 last day of the month
Earlier we were using one BEx query to have these requirements filled where users can filter data monthwise or quarterwise but now since they want the reports to be emailed we need to have 3 different reports. What is the best way to achieve this requirement?
Thanks,
Nancy