If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Report schedule

Started by cielo, 02 Jul 2019 11:56:48 AM

Previous topic - Next topic

cielo

I have a requirement for report outputs to be provided for each month. The date parameter will be the only change for each month. For instance, I need to share 5 inputs with different product ids for one report. Likewise, I have various Reports to publish the outputs by e-mail.what would be the best way to fulfill this requirement...Creating a job/schedule/event studio?
Your inputs would be greatly appreciated. Thank you

Wangd

I am not sure I understand your questions fully, but I will try to share what we do by addressing your questions part by part:

1. I have a requirement for report outputs to be provided for each month. The date parameter will be the only change for each month
We have filter expression to pull data from last month only.  Then in the report schedule, we set it to run on the first day of the month at 12:00am. Here is an example of the expression:

[Created Date] between _first_of_month(_add_months(Cast ({sysdate}, date),-1)) and _first_of_month(Cast ({sysdate}, date))

2. I need to share 5 inputs with distinct product ids for one report
This requirement sounds like you need to use the Bursting function in Report Studio.

3. I have various Reports to publish the outputs by e-mail
In the report schedule, under the Delivery option,  check Send the report by email  Then special the email addresses and the delivery message.

Hope this helps.
Deanna


cielo

Thank you for the response.I am planning to save report copies with date filter and then schedule for the different product ids.Make sense?

Francis aka khayman

create views for different prompt options (product ids and/or date)