Cognos itself is very powerful, just a lot of people's thinking is confined to the data-model-display level, let's introduce a bit of a somewhat unpopular in Cognos a component event Studio (IBM Cognos Event Studios), the concept of every place, Because of the time, we're going to go straight to the subject here to do a simple development of event Studio
Implement function: send email function based on conditional event
1: Open the event studio design interface
Before opening, as with Rs we need to first select a packet, the specific interface as shown in the setup step of the 1-2-3-4
2: Click Specify an event condition to add an event condition
An event condition expression is 1=1, which means that the condition is always true
3: Click Add Task to add a task to send email
Enter the sending address as shown in
4: Manage task Execution rules
As shown, defined as a new event
5: Add event code
Date_minute is a newly created data item expression: SUBSTRING (cast (Current_timestamp,varchar (35)), 1,16), taking a string of every minute for example 2016-1-14 11:17
As the event code
6: Set up Schedule Agent
Set to be sent from 10:50 to 10:51 every minute, total 2 times
7: Save current event Studio interface to Folder
8: Test Results
9: Extended Analysis
A: A lot of people will ask, if the regular email to use the schedule, but here is the event trigger Oh, we can extend step 2, so that eventstudio to give our data to do some monitoring reminders
B: Of course, we can not be limited to the task of sending mail, you can try a variety of task types, such as the task type to perform the report, we can change the report default properties to send the report
Cognos Event Studios Event Studio Development Steps