MicroStrategy ONE

The main Command Manager window

The main Command Manager window contains the Script windows you use to edit and execute Command Manager scripts. Its primary functions are accessed through the menu bar and toolbar.

Click the desired topic below to view more details, or scroll down to view each of the following topics:

The menu bar

In addition to standard Windows options, the Command Manager menu bar includes the following items unique to the application:

File menu

  • Connect: Opens a connection to a project source or Narrowcast Server. For detailed instructions, see Connecting to a server.
  • Disconnect: Closes the active connection and any associated scripts. For detailed instructions, see Disconnecting from a server.
  • Disconnect All: Closes all currently open metadata connections and associated scripts. For detailed instructions, see Disconnecting from a server.
  • Close All Scripts: Closes all scripts in the active Script window, and opens a new tab in that window. For detailed instructions, see Closing one or more scripts.
  • Export Results: Exports the result sets to a CSV or XML file. For detailed instructions, see Exporting the results of a script.
  • Print Results: Prints the results from the currently active script. For detailed instructions, see Exporting the results of a script.
  • Most recently used connections list: Displays the most recently used metadata connections. For detailed instructions, see Connecting to a server.

Edit menu

  • Select All Results: Selects everything in the Results tab of the active Script window.
  • Clear Window: Clears the script area for the currently selected script. For detailed instructions, see Editing a script.
  • Clear Results: Clears the Results tab of the active Script window.
  • Clear History: If the Script History feature is enabled, clears the contents of the Script History drop-down list. For more information about the Script History feature, including detailed instructions, see Inserting previously executed scripts: Script History.
  • Decrease Indent: Deletes a tab character at the beginning of the selected lines. For detailed instructions, see Indenting or unindenting a selection.
  • Increase indent: Inserts a tab character at the beginning of the selected lines. For detailed instructions, see Indenting or unindenting a selection.
  • Comment Block: Inserts two slashes // at the beginning of the selected lines. These lines are not executed or checked for syntax when the script is executed. For detailed instructions, see Commenting or uncommenting a selection.
  • Uncomment Block: Deletes two slashes at the beginning of the selected lines.For detailed instructions, see Commenting or uncommenting a selection.
  • Go to Line: Jumps to the line you specify in the currently selected script. For detailed instructions, see Jumping to a specific line.
  • Insert/Search Objects: Opens a submenu. From this menu you can open the Choose Outline dialog box or the Search for Objects dialog box. This allows you to select a script outline to insert into the currently selected script, or to search for specific objects to insert into the script. For more information about outlines, including detailed instructions, see Inserting sample statements: Outlines. For more information about searching for objects, including detailed instructions, see Inserting a list of objects into a script.

Connection menu

  • Execute: Executes either the active script or the selected portion of the script. For detailed instructions, see Executing a script.
  • Results: Allows you to select the option to display results in the following formats: To Text, To Grid, To File, and To List. For more information about these options, see Script output. For detailed instructions, see Viewing the results of a script.
  • Reconnect: Refreshes the active project source or Narrowcast Server connection. For detailed instructions, see Managing your connections.
  • Connection Information: Provides metadata source name, login ID, location, software version, and activation status information for the current connection. For detailed instructions, see Managing your connections.

Tools menu

  • Options: Displays the Options dialog box. From this dialog box, you can select such things as:

    • directories and extensions for outlines, procedures, scripts, and script results
    • the depth of the Script History
    • a default format for script results
    • a default directory where log files are saved
  • For detailed information about the options, see the Options dialog box.

The toolbar

In addition to standard options, the toolbar includes:

Related Topics

Connecting to a server

Starting a new script

Opening a previously saved script

Editing a script

Inserting sample statements: Outlines

Inserting previously executed scripts: Script History

Executing a script

Exporting the results of a script