Within CALUMO there are events that fire on certain actions such as when a user writes a number back to a cube or when a user drills through to transactions, when these “Cube Events” occur, you can configure CALUMO to run a SQL Stored Procedure.
The Cube Events administration page lets you configure which events you want to hook into, what stored procedure you want to run as well as configure what is passed into your stored procedure by CALUMO.
The page is made up of two sections, the left side lists out the cubes that you have already wired up events and the right side shows the events for the selected item on the left side.
When you add or edit a event mapping, you will see the edit screen show. This is broken up into two sections, the top section is gathering details about what cube you want to watch, the event you want to watch for, the SQL data source and database where the stored procedure is that your want to run, the name of the stored procedure and a place for you to give this mapping a name so it is easy to remember.
The bottom section is all about mapping the parameters of your stored procedure to the correct piece of information that CALUMO will pass through.
Note: Depending on the event type selected, you will either be shown the parameters for the selected stored proc, or for “Block” style events, you will be asked to create the parameters that will be passed in in the XML.