MicroStrategy ONE

Command Manager syntax

The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages.

A Command Manager script consists of one or more script statements. Each statement ends with a semicolon (;).

Statements consist of one or more tokens. A token is a word, a list of words enclosed in quotation marks, or a symbol. A token is recognized by Command Manager as an individual unit with a specific meaning. Tokens can be:

  • Reserved words, which are words with a specific meaning in a Command Manager script. For a list of reserved words, see Reserved words.

  • Identifiers, which are words that the user provides as parameters for the script. For example, in the statement LIST MEMBERS FOR USER GROUP "Managers"; the word Managers is an identifier.

  • Symbols, such as ;^ , ' ". For an explanation of each symbol in Command Manager syntax, see Symbols.

  • Numbers in any notation

  • Dates and times

  • Object GUIDs

  • Other special characters such as carriage returns, tabs, or spaces

Identifiers must be enclosed in quotation marks, for example, "Managers". In general, either double quotes or single quotes can be used to enclose identifiers. To make the syntax guide text consistent, double quotes are used in the syntax examples.

If you want to include either single quotes or double quotes as part of an identifier, you must either enclose that identifier in the other kind of quotes, or put a caret in front of the interior quote. For example, to refer to a metric named Count of "Outstanding" Customer Ratings, you would need to use one of the following methods:

  • Use single quotes to enclose the identifier:

    Copy
    'Count of "Outstanding" Customer Ratings'
  • Use double quotes to enclose the identifier, and put carets in front of the interior double quotes:

    Copy
    "Count of ^"Outstanding^" Customer 
             Ratings"

If your identifier contains double-byte characters, such as characters used in the Korean, Japanese, or Chinese character sets, you must enclose the identifier in square brackets [ ]. If the identifier is also enclosed in quotation marks, these square brackets must be placed inside the quotation marks.

Related Topics

Reserved words

Symbols

Statement syntax reference guide

Project source statement syntax

Procedures and Java syntax

Narrowcast Server statement syntax

Editing a script