KB8087: How to trigger a data load from the command line in MicroStrategy Enterprise Manager 9.4.x

INTRODUCTION
The ability to run the Data Load process through a command line interface allows the administrator to remotely trigger the data load process without having to be at the Enterprise Manager Console and to schedule the Data Load using Windows Scheduler.
 

Several Data Loading options can be executed from the command prompt.
 
Once users open a Command Prompt window and navigate to C:\Program Files\Strategy\Enterprise Manager, they only need to type the following command to see the options available with the executable:
 

MAEMETL/?
 
MAEMETL [-DM][-COS][-EF][-OL][-REP][-UWTS][-USTS][-CWM][-WHD][/?]

• - Data migration process: This switch executes the task of migrating data from Strategy Intelligence Server statistics tables to Strategy Administrator - Enterprise Manager warehouse tables.
• - Clean orphan sessions process: This switch updates the information in users' statistics table to close any sessions left open by the Strategy Intelligence Server for any reason.
• - Exists flag update process. This switch determines which objects monitored by Strategy Administrator - Enterprise Manager no longer exist in users' projects. If users have deleted objects, this switch allows them to distinguish between existing and deleted objects.
• - Object location update process: This switch updates the 'location' property of all objects. If users have moved objects or changed their folder structure, this switch allows Strategy Administrator - Enterprise Manager to be synchronized with the users' project structure.
• - Repopulate Enterprise Manager relate tables: This switch refreshes the relationship tables in the Strategy Enterprise Manager warehouse. It synchronizes the Enterprise Manager relationship tables with current object relationships so that these relationship tables reflect the current state of the metadata.
• - Update Enterprise Manager warehouse table statistics process: This switch helps improve the query performance on the database. The database's optimizer uses these statistics when running SQL. This switch is available for SQL Server, Oracle and Teradata.
• - Update Intelligence Server statistics table statistics process: This switch helps improve the query performance on the database. The database's optimizer uses these statistics when running SQL. This switch is available for SQL Server, Oracle and Teradata.
• - Custom Window Migration. Following this switch, specify the starting and ending dates with a hyphen before each. For example, the following would execute a custom time window data load for the month of January, 2008.
   
  
  

  maemetl -cwm -01/01/2008 -01/31/2008

  
   
  
  
• - Warehouse Deletion, which removes data from the Enterprise Manager warehouse tables for the specified date range. As with the -CWM option, the starting and ending dates should follow the -WHD switch.
• /? This switch opens the Strategy Administrator - Enterprise Manager Data Migration help dialog box, which provides the syntax and a description of the tasks performed by the switches.

 
 
Note: The -UWTS and -USTS refer to table statistics for the database optimizer. "Updating statistics" in this context does not refer to Intelligence Server or Enterprise Manager statistics. These options do not perform a data migration. If a data migration is required, use the -DM or -CWM options.
 
 
The /? option brings up the following window, summarizing the commandline switches.