COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: csss2cognos on 22 Feb 2012 03:44:19 AM

Title: Follow up actions for 'Conditional Styles'
Post by: csss2cognos on 22 Feb 2012 03:44:19 AM
Hi dude,

I am facing a task that if VariableA in a crosstab meets eg. 100, then not only the bg colour changes(Hitting the conditional styles), but also need to send an email / trigger another reports.

I wonder if it could be done within Report Studio (not in metric studio).

Thank you! Any helps / suggestions are appreciated.

Edward
Title: Re: Follow up actions for 'Conditional Styles'
Post by: MFGF on 24 Feb 2012 03:59:21 AM
You can certainly do this in Event Studio. An alternative, you could get alerts generated from Cognos 10 when your report output is regenerated and saved (for example via a schedule). To do this, go into the properties of the report in Cognos Connection, go to the report tab, click on "Advanced properties" and switch on the "Enable enhanced user features in saved output versions" option.

If you now run the report and save output, you can view the saved output and select the relevant cell. Click on the "Watch new versions" link at the top of the report viewer, and select "Alert using new watch rule". This will then present a dialog where you can enter your threshold value condition to generate an alert.

Regards,

MF.
Title: Re: Follow up actions for 'Conditional Styles'
Post by: csss2cognos on 28 Feb 2012 03:51:08 AM
Got it. Thanks so much, MF!

regards,
Edward
Title: Re: Follow up actions for 'Conditional Styles'
Post by: charon on 28 Feb 2012 06:48:57 AM
You might want to add, that
1) the report version has to be a HTML version...pdf wont work
2) cognos checks for the condition every time the html version get new/ overwriten, means if you schedule
your report just once a week, cognos will only check once a week for the defined condition, how often the data changes in real does not matter.

cheerz :P
Title: Re: Follow up actions for 'Conditional Styles'
Post by: csss2cognos on 05 Mar 2012 06:21:16 AM
Thank you! Now I am wondering how to do it in Dashboard. Is it the same story?

Let me have a try!