Social Icons

Cognos Event Studio

In Event Studio, you set up agents to monitor your data and perform tasks when business events or exceptional conditions occur in your data that must be dealt with. When an event occurs, people are alerted to take action. Agents can publish details to the portal, deliver alerts by email, run and distribute reports based on events, and monitor the status of events. For example, a support call from a key customer or the cancellation of a large order may trigger an event, sending an e-mail to the appropriate people.

Example- Manage an Event

Use IBM Cognos Event Studio to define business events or exceptional conditions in your data that require attention. Create agents to monitor your data and notify decision-makers in your organization of events as they happen, so that they can make timely and effective decisions. You create agents to perform tasks or deliver alerts when the data meets predefined thresholds.

This exercise shows how to

  •  Define business events
  •  Define agent tasks
  • Review the status of events


You are a business analyst for the Sample Outdoors Company. You want to ensure that your customers are satisfied with the products and services that you provide. In particular, if products are returned, you want to investigate why, and ensure that you offer a replacement before your customers decide to shop elsewhere.
Event Studio can notify you when a customer returns a product because it was defective, unsatisfactory, incomplete, or because the wrong product was shipped to them. You want to immediately send an email to your customer service department with details about the order and the customer, so that they can contact
the customer. You will create an agent that looks like the Event Studio sample Returns Agent in
the GO Sales (query) sample package.

To perform this exercise, you must have the appropriate licensing and security permissions.

The tasks that you need to perform to create an agent in Event Studio appear in the I want to area. By default, when you open Event Studio, you start with the first task, defining an event.

Procedure
1. Open IBM Cognos Connection:
a. Start your Web browser.
b. In the address bar, type the URL supplied by your administrator, and then press Enter. The URL looks something like this: http://servername/cognos

2. In the IBM Cognos Welcome page, click Manage my events to open Event Studio.

3. Click Samples, Models, GO Sales (query).

4. Create the expression that defines the event:
a. In the Insertable Objects pane, expand Returned items (query) andReturned items.
b. Under Returned items (query), expand Return reason.
c. Use both Return quantity and Reason description to create the followingexpression: [Return quantity]>0 AND [Reason description] IN (’Wrong product shipped’,’Unsatisfactory product’,’Incomplete product’,’Defective product’) Tip: Insert items from the Insertable Objects pane. To select from a list of possible values for the return reason, click the select values button. Move the values you want from the Select Value box to the Selected Items box and click OK.
d. Click the validate button to validate your expression. 

Tip: You can also click Preview from the Actions menu to see the data retrieved from the data source. You defined the expression that will notify you whenever a customer returns a product because it was defective, unsatisfactory, incomplete, or because the
wrong product was shipped to them.


5. Create an email task to immediately send an email to your customer service department with details about the returned order and the customer so that they can contact the customer:
a. In the I want to list, click Add a task and click Send an email.
b. In the To box, type the email address for the customer service department.
Tip: Since this example is for learning purposes, the agent will not actually run. Therefore, you can type any email address.
c. In the Subject, type Products Returned.
d. Above the Body box, click the insert table button, specify four columns and two rows, and click OK.
e. Add information about returned products to the table as follows: Manually type the text for the heading row of the table. Overwrite the insert text... text in each cell. Drag objects from the Insertable Objects pane to the bottom row of the table.
Tip: In the Insertable Objects pane, expand Returned items (query). Expand Order to find Order number; Products to find Product; Returned items to find Return quantity, and Retailers to find Company name.

When the agent runs, the data item for each event is replaced by the current value in the package.
f. Select the heading row and then click bold to make the column headings more prominent.

6. Set the execution rules so that a notification is sent for new events only:
a. In the I want to list, click Manage the task execution rules.
b. Click the Event Key tab.
c. In the Insertable Objects pane, click the Source tab.
d. Expand Sales (query), Order, and drag Order number to the Event key box.
e. Click the Event Selection tab.
f. Under Select when to perform this task, ensure that only the New events check box is selected.
g. Click OK.

7. Set the schedule for when you want to the event to run:
a. In the I want to list, click Schedule the agent.
b. In the Set the schedule pane, under Frequency, click the By Day tab, and select Every 1 hour(s).
c. Click OK.

8. Save the agent as Returns Agent. Each hour, the agent runs and the next time a customer returns a product, an email is sent to the customer service department with information about the order.