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

Scheduling Reports on Cognos Analytics 11.0.13.1

Started by SHA, 04 Mar 2019 02:56:07 PM

Previous topic - Next topic

SHA

Hello - I am not a developer, I am a user and am hoping to get some guidance.   I use Cognos Analytics 11.0.13.1 - I run certain existing reports and would like to schedule them to run automatically for me every day.  The report however requires the user to select the date to be run each time.... therefore when I try to schedule the report, it will only give me the report run for a specific date each time.   How can I schedule this report to run for me every day automatically updating the date?

Somewhat related question, what is the difference between scheduling a report and subscribing to a report.

Cognos_Jan2017

Scheduling includes frequency the Report is to run where Daily is an option, and you can select the Time of Day when the Report will run.

SHA

Thank you.    I have actually selected a time of day, however the report that it runs will be for a specific date's data and that date needs to be a selection in the report criteria - otherwise it runs the same date's report every day no matter what time I select.  So what I am struggling with is... is it possible for the scheduling process to automatically update the "date" selection prompt for each run. 

dougp

Because you are scheduling the report to display data from a date or date range relative to the current date, you can't use a prompt.  Modify the report to remove the prompt and include the filter you need for this use case.

Lynn

Quote from: SHA on 04 Mar 2019 02:56:07 PM
Hello - I am not a developer, I am a user and am hoping to get some guidance.   I use Cognos Analytics 11.0.13.1 - I run certain existing reports and would like to schedule them to run automatically for me every day.  The report however requires the user to select the date to be run each time.... therefore when I try to schedule the report, it will only give me the report run for a specific date each time.   How can I schedule this report to run for me every day automatically updating the date?

Somewhat related question, what is the difference between scheduling a report and subscribing to a report.

As dougp suggests, the report author will need to revise the report to support logic that filters data relative to the current date.

Scheduling a report will run it to produce output that is saved to the content store and optionally distributed in other ways such as via email or saved to a file share.

A subscription is a way to be notified that a new saved output is available. In this situation someone else may schedule the report and you are interested in the latest versions as they become available so you subscribe. I believe that is a correct explanation so hopefully someone will correct me if I'm not completely accurate.

MFGF

Quote from: Lynn on 07 Mar 2019 09:24:33 AM
As dougp suggests, the report author will need to revise the report to support logic that filters data relative to the current date.

Scheduling a report will run it to produce output that is saved to the content store and optionally distributed in other ways such as via email or saved to a file share.

A subscription is a way to be notified that a new saved output is available. In this situation someone else may schedule the report and you are interested in the latest versions as they become available so you subscribe. I believe that is a correct explanation so hopefully someone will correct me if I'm not completely accurate.

Just to add some details on the Subscribe option:
Think of it as a simplified personal schedule. You can ask for a report to run on a daily basis (choosing which days of the week and at what time), you can specify how the output is delivered (email or saved back to the content store with a notification to tell you) and you can specify the rendering type (HTML, PDF, Excel etc).
Cheers!
MF.
Meep!