Trigger Events
Under your Administration Drop Down Menu in Microstrategy is “Events”. What is this odd item, and what’s it used for?
Keeping Command Manager extras out of this…and sticking with the straight “Out of the Box” functions…let me tell you why this matters.
One of the advantages of MicroStrategy in the ability to subscribe to reports. When a person subscribes to a report…the project caches that report for a predesignated period of time, in my case 24 hours. These report caches are cleared at predesignated times (see here for that how-to); however, as any administrator who works with ETL processes knows, sometimes you get the managerial, “I need the ETL run right now so I can see X transaction that was just posted.” All fine and dandy, until you realize that all of the reports that he ran this morning, still have a cache in place? Check the “Cache Monitor” under your Administration menu to see what’s out there.
The way to solve this is to create an event like above called “Database Load”, and then create an administration event that clears the cache linked to the event “Database Load”. Then, run your ETL. When the process is done, go to your Event option under the menu again, and trigger the appropriate event. Every Scheduled Item linked to that event will then take place.
Users can create schedules that update reports not only at set time (midnight, 4 A.M.), but also based on a series of events. Need that Balance Sheet repopulated when the Books Close, or maybe, you need to Idle a project when you’re in production? Event manager is a simple way to organize what would normally be a manual process.
Recent Comments