MicroStrategy ONE
MicroStrategy Command Manager
MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. These commands can be compiled into script files and run from a graphical interface or from the command line. The script files can be scheduled through operating system utilities or integrated into third-party Systems Management Software, automating repetitive maintenance tasks.
Command Manager minimizes administrative costs by automating critical, time-consuming administrative tasks, such as managing users and security, purging caches, and expiring jobs. Command Manager contains over 200 commands that automate administrative tasks. Command Manager makes it easy to incorporate MicroStrategy administration into any software management system.
Other examples of tasks you can perform using Command Manager include:
- User management: Add, remove, or modify users or user groups; list user profiles
- Security: Grant or revoke user privileges; create security filters and apply them to users or groups; change security roles and user profiles; assign or revoke ACL permissions; disconnect users or disable their accounts.
- Server management: Start, stop, or restart Intelligence Server; configure Intelligence Server settings; cluster Intelligence Server machines; change database connections and logins; disconnect active sessions on server or project.
- Database management: Create, modify, and delete connections, connection mappings, logins, and database instances.
- Project management: List or stop jobs; change a project's mode (idle, resume); expire and delete caches; change filter or metric definitions; manage facts and attributes; manage folders; update the project's schema; manage shortcuts; manage hidden properties; create tables and update warehouse catalog tables.
- Scheduling: Trigger an event to run scheduled reports.
- Narrowcast Server administration: Start and stop a Narrowcast Server; start, stop, and schedule Narrowcast Server services; add, modify, and remove subscription book users; define and remove user authentication.
For more information about Command Manager, see:
- System Administration Help: Instructions on how to create and execute these scripts to automate various administrative and application development tasks.
- System Administration Guide: A list of the commands available for Command Manager Runtime, which is a lightweight version of Command Manager for bundling with OEM applications.
- Command Manager Help: To access the online help, press F1 while using Command Manager.
System Requirements
For all certified systems, see Platform Certifications.
Compatibility and Interoperability
- Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines.
- Administrators no longer need to install Narrowcast Server on the machine where Command Manager is installed to manage a Narrowcast Server system.
For the complete MicroStrategy platform compatibility and interoperability specification, see Compatibility and Interoperability.
Hardware Requirements
| Operating System | Processor | RAM | Disk Space |
|---|---|---|---|
| Windows | 64-bit | 4 GB (minimum) | 0.5 GB |
| Linux | 64-bit | 4 GB (minimum) | 3 GB |
Installing MicroStrategy Command Manager
For steps to install MicroStrategy Command Manager, see the Installation and Configuration Help.
Directory Structure
The following table lists folders and files of interest that are included in the default directory structure after installing Command Manager.
The default folder is:
C:\Program Files (x86)\MicroStrategy\Product Namewhen installed on a 64-bit Windows environment./opt/MicroStrategy/Product Name, or$HOME/MicroStrategy/install/Product Nameif you do not have write access to /opt/MicroStrategy, when installed on UNIX or Linux environments.
If installing over previous versions of the product, the folder remains the same.
| Directory | Contents |
|---|---|
| \MicroStrategy\Command Manager | MicroStrategy Command Manager root directory |
Upgrading MicroStrategy Command Manager
To benefit from the latest functionality available in this version of MicroStrategy Command Manager, an administrator must upgrade the MicroStrategy system, including Command Manager and Intelligence Server:
- MicroStrategy products 10.4.x and 2019 and above can be upgraded directly to MicroStrategy ONE or MicroStrategy 2021.
Before upgrading, see the Upgrade Help for important information about preparing for the upgrade, the order in which to upgrade products, and tasks to perform after upgrading.
Uninstalling MicroStrategy Command Manager
For details about uninstalling MicroStrategy Command Manager, see the Adding or Removing MicroStrategy Components chapter of the Installation and Configuration Help.
Resolved Issues
For a list of all the resolved issues in this MicroStrategy release, see Resolved Defects and Enhancements.
Important Notes
- Ambiguity in filters, metrics, security filters, facts, and attribute expressions can be avoided by referring to the location of the object in the expression. Ambiguity was being caused by two or more objects having the same name but in different folders confusing the parser on which to reference. This can be solved like the following sample:
Create Filter "test" in folder "\" expression "[\schema objects\attributes\day]@ID=1"This avoids ambiguity if there is another "day" attribute located elsewhere in the project. Also, this provides a more efficient workaround than renaming duplicate objects.
- Report caches no longer expire automatically, you can instead invalidate report caches.
- The Alter Cache commands uses megabytes instead of kilobytes as the default unit.