MicroStrategy has been growing rapidly in the last few years and it’s easy to get carried away with the new versions & all these new features & overlooking how our environments are setup & the impact it might cause if not setup correctly.
Reports can be schedule based on time or event using MicroStrategy scheduler.
Event based Scheduling: Lets assume we have a status table (name: load_status) in our warehouse which indicates an event of a fact table data load. We wanted to execute a few reports based on the event (when it turns '1').
SQL engine is a software component in the I-server which communicates with the metadata to generate the SQL. When a report is executed, the SQL engine interacts with the metadata to get the definitions of all the objects used in the report, to construct the SQL.
Any intermediate tables created in the SQL, generated by SQL engine will have tables name with around six alpha-numeric characters like "ZZMD00".
Most of you might be familiar with this. I am describing a simple and easy way to schedule an automated I-server re-start (and alerting before the re-start) using command manager and Narrowcast service.
Lets assume we wanted to restart the I-server every thursday at about 8pm EST. A simple way of doing this is as described below.
Step 1: Create a command manager script with a .scp extension. Save the file as "i_server_restart.scp" and the file contains the following code-