Transcription

Cognos Event StudioDeliver By : Amit SharmaPresented By : Amit Sharmawww.hyperionguru.comwww.bisptrainings.com

An IntroductionCognos Event Studio to notify decision-makers of events as they happen, sothat they can make timely and effective decisions.Agents: That monitor your organization's data to detect occurrences of businessevents.Event : An event is identified when specific items in your data achievesignificant values.Tasks: When an agent detects an event, it can perform tasks, such as sendingan e-mail, adding information to the portal, and running reports.Source Items : IBM Cognos Event Studio works with source items that were defined inan IBM Cognos Framework Manager model and published as a package to IBM ings.com

The IBM Cognos Event Studio Windowwww.hyperionguru.comwww.bisptrainings.com

Example - Create an Agent with a Single TaskYou create an agent to perform a task when it detects a business event.You are a sales manager who wants to ensure that your most valued customersare pleased with the quality of service they receive.You decide that, whenever a valued customer calls your support group, you willcall the customer the next day to make sure they're satisfied. You use IBMCognos Event Studio to create an agent that monitors support call records. Youspecify an event condition as follows:[Call Status] Open AND [Customer Profile] GoldNext you add a task and specify that, when the event occurs, the agent sendsyou an e-mail entitled Urgent: Call Customer Today.The e-mail message you receive contains details both about the customer andabout the call. You do not need to continually check the call system or runreports.The relevant data is sent to you only when you need to act upon it.www.hyperionguru.comwww.bisptrainings.com

Event Criteria[Return quantity] 100 and [Order method type] 'E-mail'www.hyperionguru.comwww.bisptrainings.com

Event InstancesAn event instance is a single row of data that matches the event queryexpression. When an agent monitors data, it detects each event instance. Theagent then follows the task execution rules to determine if it should perform atask.Event ListAn event list shows the events processed by the agent. Each event iscategorized by one of the following statuses: new, ongoing but changed, ongoingand unchanged, or ceased.Task Execution RulesThe task execution rules specify the event status for which each task isperformed.Example - Event Status of NewYou want to receive an e-mail message advising you whenever a Gold categorycustomer phones technical support about a new problem. You specify that ane-mail task be performed only when the event status is new. You receive an email when the call record from a Gold customer is first placed in the .com

What Is an Event? Events are the driving force behind the agent, they look for conditions in the data that meet thespecifications required for an action to occur. When a condition is met, the event tells the agent to trigger the list of actions defined within theagent. Events are made up of event instances, an event list, an event key, and task execution rules.An event instance : is a row of data that meets the criteria of the event condition.An event list : shows the events that have been processed by the agent and are categorized by thefollowing statuses: New This is the first time the event has occurred. Ongoing But Changed The event occurred before but the results are differentthis time. Ongoing And Unchanged The event occurred before and the results are thesame this time. Ceased The event has stopped occurring.An event key is a unique combination of fields from your data source that identifies anevent and is used to determine the status of an event.Task execution rules define the event status for which each task is executed.Task execution rules define the event status for which each task is executed.www.hyperionguru.comwww.bisptrainings.com

Example - Event Status of NewYou want to receive an e-mail message advising you whenever a Gold categorycustomer phones technical support about a new problem. You specify that ane-mail task be performed only when the event status is new. You receive an email when the call record from a Gold customer is first placed in the calldatabase.Example - Event Status of Ongoing But ChangedYou want a report to run if the account balance of an overdrawn customerchanges.Example - Event Status of No EventsYou want to receive a daily e-mail that reassures you that none of yourcompany's accounts has a balance less than zero.You define the following event condition:[Account Balance] 0You specify that an e-mail task be performed if the event status is no events.www.hyperionguru.comwww.bisptrainings.com

Accessing Event StudioYou access Event Studio from Cognos Connection. Event Studio opens in aseparate web browser.Example1For instance, if quantity of a product on stock is less than a given value, eventmanager can send an email to a responsible person which will contain awarning with the problem description and a link to appropriate report. ThenEvent studio will take necessary actions.www.hyperionguru.comwww.bisptrainings.com

Define a Parameter Parameters can be defined to be used within an event condition. When the agent is manually run, the user will be prompted to enter a value for the parameter.1. From the Insert menu, select Parameter. Define the Parameter screen displays.2. In the Parameter Name text box, type a name for the parameter.3. Click OK. The parameter displays on the Parameters tab in the Insertable Objects pane, as shownnext:Define a CalculationA calculation uses multiple data items to derive a single value.1. From the Insert menu, select Calculation. Define the Data Item screen displays.2. In the Name text box, type a name for the calculation. For this example, we name the calculationGross Profit %.3. In the Expression text box, define the calculation by dragging items and/or functions from theInsertable Objects pane or by typing directly in the Expression text box. For this example, we definethe expression for the calculation as Gross Profit divided by Revenue,4. Click OK. The calculation displays in the Data Items tab. You can include the calculation whenspecifying an event condition or task. For this example, we add the Gross Profit % calculation to theevent m

TESTING PROCEDURE1. From the Actions menu, select Validate. If any syntax errors are found in the agent, they display inthe View The Validation Results dialog after the validation is complete.2. From the Actions menu, select Preview All. A new window displays each task in the agent. Examinethe steps to determine whether they are correct.Adding a Task Multiple tasks can be added to an agent, but only one condition can be defined per agent. Tasks can be used for things such as sending a notification to the business as data changes,providing automation to workflow, or running administrative tasks.The following tasks are available: Send an email Update a database Publish a news item Call a web service Run a report Run an export Run a job Run an import Run an agent Run a content maintenance task Advanced Run a metric task Run a migration taskwww.hyperionguru.comwww.bisptrainings.com

Event Statuswww.hyperionguru.comwww.bisptrainings.com

Run a JobA job is a group of executable entries, such as reports, that are executed as a batch and share thesame schedule settings.Run an AgentAdd an agent task when you would like the agent to run another agent. Running more than one agentin sequence allows the output from one agent to be used as the input for another agent. An agent taskcan also be used to allow agents pulling from different data sources to interact.Call a Web ServiceAdd a web service task to run applications on either internal or external web servers using standardInternet protocols.Run an ExportYou can use an agent to run a saved content export process. This is useful when different installationsof Cognos 8 are used for your development and production environments and you want an export tobe deployed dependent upon a specific event.Run an ImportThe import task goes hand-in-hand with the export task. You can use an agent to run a saved importtask; this will move migrated content from an export file into the target com

Run a Content Maintenance TaskYou can use an agent to run a previously defined Content Maintenance task. The ContentMaintenance tasks do one of two things: a consistency check or a report upgrade. A consistency checkcan confirm that each Cognos 8 user defined in the Cognos namespace is a valid user in theAuthentication namespace. Report upgrade attempts to upgrade any reports in the defined location tothe currently installed version of Cognos 8. Report upgrades should be done only for very simplereports, as the conversion process can be complex and usually requires some sort of manualintervention.Specify the Task Execution RulesTask execution rules define the event status for which each task is executed. By default, tasks areexecuted for all new and all ongoing instances of events. You can modify this behavior through theManage The Task Execution Rules option. This option allows you to define when a specific task will orwill not run based on the status of the event.Scheduling an AgentSetting a schedule for an agent allows you to set the agent to run at a later date and time or on arecurring basis. The agent monitors data and performs tasks according to its schedule and does notneed to be run manually.Only one schedule can be associated with an agent.www.hyperionguru.comwww.bisptrainings.com

www.hyperionguru.comwww.bisptrainings.com

Cognos Event Studio to notify decision-makers of events as they happen, so that they can make timely and effective decisions. Agents: That monitor your organization's data to detect occurrences of business events. Event : An event is identified when specific items in your data achieve . manager can send an email to a responsible person which .