Java cannot be included directly in a Command Manager script, but can be used directly for procedure. x. Each row in the ResultSet object contains information about one item. Type. x provided to ability to run some outlines without the need for an Intelligence Server or Narrowcast Server connection. x from a command line interface. x, the user has an option to use a Procedure to initiate a connection to a server and execute a script without storing the Administrative password in batch files. ' This issue does not occur if changes in thread priorities are made via the MicroStrategy Desktop interface. It contains the Command Manager script, which is just a series of Command Manager statements or procedure invocations. In this example, the script was created as follow: CREATE FILTER "Nested Filter" IN FOLDER "Public ObjectsFilters" EXPRESSION "" ON PROJECT "microstrategy tutorial"; 3) Execute the script. To see a list of instructions for the command line. Editing a script. Delete User Group Statement. All other text appears in black. MicroStrategy Administrator - Command Manager 9. 4) In MicroStrategy Developer, connect to the MicroStrategy. Command Manager. MicroStrategy Administrator - Object Manager is the component in the MicroStrategy Product Suite that allows system administrators to conduct project life-cycle management. A Command Manager 9. Create a regular Filter using a non prompted expression as in the example script belowWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformFor information about obtaining Command Manager Runtime, contact your MicroStrategy sales representative. CONTENT: The content of the subscription, returned as a string. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. 6. As the place holders are correctly replaced, the script can be validated and then executed for the privileges to be automatically granted. new_event_name is the new name of the event to be linked to an event-triggered. When creating a script, we can sequence different functions that will perform the tasks we request. exe, with the parameters listed in Command line syntax. USER "login_name" is the name of the user whose security roles you want to list, of type string. For example, run the following script to create the user:Run Command statement. Start the Command Manager graphical interface: In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. configure a project to collect statistics. Consider an example of Regional Sales Reports Regional Manager East • Region = East. Requests messages can be sent from the workflow manager or enterprise schedule by: Remote login via scheduler agent and running MSCT script with request as argument. This statement can only be used with three-tier or four. Returns. x and newer has a built in command line interface. This article describes how to automatically trigger Narrowcast services using Command Manager scripts. 2. To execute a script with Command Manager Runtime, call the Command Manager Runtime executable, cmdmgrlt. For a list of statements available to Command Manager Runtime, see List of statements supported in Command Manager Runtime. scp i PURGE OBJECT CACHING IN PROJECT "Project_Name"; Create a batch file named PurgeObjectCache. Example. Command Manager makes it easy to incorporate MicroStrategy administration into any software management system. Example. bat. ALLOW_CHANGE_PASSWORD: Whether or not the user's password can be changed, returned as a boolean value. 4. PROJECT: The project associated with the user connection, returned as a string. Execution errors occur when an instruction is formed correctly but returns an unexpected result when it is executed. x and newer has a built in command line interface. x database and leads to. scp" -o "RefreshService. A Command Manager script consists of one or more script statements. exe" -n "MicroStrategy Tutorial Direct" -u Administrator -p 007007 -f C:startserver. You can deny user or group access to a specific MicroStrategy project by using a security role. These script files can be created using Command Manager, as described in Creating and Executing Scripts. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformTime Discrepancy Between Command Manager Scripts and Time Required for Job Completion. Developers can use. Examples. x and 10…MicroStrategy Command manager. Just checked and it seems you have to omit the base path to the table. where: fact_name is the name of the fact, of type string, between double quotes (" "). 2. LONGDESCRIPTION "new_long_description" is the new long. This script is at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_OutlinesInvalidate_Report_Cache_Outline. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). x - 10. This is a known limitation in MicroStrategy Command Manager 9. that already exists in the MicroStrategy metadata database, Command Manager is not able to create the. MicroStrategy Command Manager can trigger events from the Windows command line. The script executes. By default, this is C:Program FilesMicroStrategyCommand ManagerCommand Manager. List User Group Privileges Statement. For reference on a comprehensive list of. The Kernel XML trace (communication between IS and command manager) Kernel XML trace:KB438788: Command Manager Script to List Intelligent Cube Properties Returns Null in MicroStrategy 10. Log in using and Administrator account. In some situations this may be more efficient than navigating the Developer GUI, since you can quickly change the names of reports, users, or projects with Command Manager. This command line interface is used to run command manager scripts without having to load the graphical interface and to be able to schedule scripts to run automatically. location_path is the folder path where the metric is located, of type string, between. For more information about. You can compose Command Manager scripts to manage user subscriptions. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. 1? ANSWER: When executing Command Manager scripts via Command Manager GUI, users have the option to save the outputs to CSV or Excel file format. IS_GROUP: Whether or not the member is a user group, returned as a boolean value. Below you will find a list of commands to open MicroStrategy Tools in MicroStrategy Universal installed in Linux and UNIX OS: To execute these commands, navigate to “<MSTR_INSTALL_HOME_PATH>/bin” to find these files: MicroStrategy Command Manager – mstrcmdmgrw. You can also import users. How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. This command line interface is used to run command manager scripts without having to load the graphical interface and to. These procedures are briefly described below. To execute. it displays the portion of the instruction set where. All other text appears in black. NUMERIC: When the answer is a number such as when trying to qualify on 2011 in the Year attribute in MicrosStrategy Tutorial project, use the following syntax: Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. RUN COMMAND executable_program [WAIT];. Command Manager contient plus de 200 commandes qui automatisent les tâches administratives. executeCapture runs any Command Manager command and returns the results (if the. To use the options file on a silent installation, specify -silent -options <FileName> as a command line argument to the wizard, where <FileName> is the name of this options file, for example, options. Another advantage of this feature is that if any of the Intelligent Cubes fails during the publication, this won't affect. /setup. x or 10. • Command line interface (using CmdMgr. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. (3) Your Command Manager license has expired. In order to achieve so, Command Manager procedure has been provided as a sample. Type cmdmgr . PUBLISH INCREMENTAL REFRESH REPORT ("name" IN FOLDER "folder_name" | GUID "guid"). Command Manager recognizes two classes of execution errors:. A full list of parameters can also be accessed from a command prompt by entering cmdmgr. When running the Command Manager scripts concurrently in two clients, two folders with the same name are created under the same parent folder. x provided to ability to run some outlines without the need for an Intelligence Server or Narrowcast Server connection. doesFieldExist (DisplayPropertyEnum iProperty) TRUE if a column for the specified PropertyID exists in the ResultSetTo modify the Web Idle Timeout, use the following script can (an abbreviated version of the above outline): ALTER SERVER CONFIGURATION WEBIDLETIME <number_of_seconds>; where <number_of_seconds> should be replaced with the new number of seconds, without any additional quotation marks or delimiters. A Command Manager script consists of one or more script statements. MicroStrategy Command Manager provides the ability to create text-based scripts and automate common administrative functionality. In MicroStrategy Command Manager there is a way to obtain list of filter specific properties (such as expressions). x and newer has a built in command line interface. e. Thanks, Nitin2) Create the second filter using MicroStrategy Command Manager 9. But for this Property Value is 3 which needs to be passed in command manager script. CREATE ATTRIBUTE "Month" DESCRIPTION "Duplicate of Month Attribute from folder \Time" IN FOLDER "\Schema Objects\Attributes" ATTRIBUTEFORM "ID" FORMDESC "Basic ID form" FORMTYPE TEXT SORT ASC EXPRESSION " [MONTH_ID]" LOOKUPTABLE "LU_MONTH" FOR PROJECT "MicroStrategy Tutorial"; where: schedule_name is the name of the schedule; contact_name is the name of the contact address_name is the name of the address; contact_group_name is the name of. exe -help. Statements consist of one or more tokens. Right mouse click the grid and choose 'Export Results -> to Excel'. Objects can be selected from this list and then inserted into Command Manager scripts. IS_GROUP: Whether the member is a user or a group, returned as a Boolean. To invoke Command Manager from the database server, use one of the following. x. To include Java in a Command Manager script, you write a procedure containing the Java code, and execute the procedure from a Command Manager script. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. /mstrcmdmgr -n 693177 -u administrator -f 691031. The documentation for every method includes the 8. For more information about. To execute a script from the command line. x script times out even after 20 minutes even though a timeout value of greater length is specified. In MicroStrategy Command Manager 9. Using MicroStrategy Command Manager, create a script file for starting the MicroStrategy Narrowcast Server as "startserver. x and 10. EXPRESSION IN SUBSCRIPTION: An example of how to pass in expression prompt answer in a CREATE EMAILSUBSCRIPTION command using MicroStrategy Tutorial. LIST [ALL] PROPERTIES FOR REPORTreport_nameIN FOLDERlocation_pathFOR PROJECTproject_name; report_name is the name of the report, of type string, between double quotes (" "). Its primary functions are accessed through the menu bar and toolbar. You can also create, edit, or delete multiple metrics at the same time by using a Command Manager script. If you're using 32-bit, please adjust accordingly. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . This can go both ways, but this script concentrates on Library -> Web path. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. The following list describes each of them。1. Automating Administrative Tasks with Command Manager. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. Execute the command "export DISPLAY=:0. Now from the same client machine, connect to the same Intelligence Server via MicroStrategy Command Manager. To check the syntax of the entire script before execution, see Checking the syntax of a script. x. sh script with the json request message as an argument,. MicroStrategy provides a rich array of SDKs to help you customize, extend, integrate and embed the power and functionality of MicroStrategy analytics into your Web and mobile applications. Navigate to the directory that contains Command Manager. cmdshell. Below is the syntax to be used when answering expression prompts while using the PROMPT and ANSWER script in MicroStrategy Command Manager. The command line options for executing Command Manager scripts using the command line are included in the following table. MicroStrategy Administrator - Command Manager 9. USER "login_name" is the name of the user whose security roles you want to list, of type string. exe and press ENTER. Some of its features include: find and replace functionality (including regular expressions) object search for the name of the object you want to reference in a command. For an explanation of each symbol in Command Manager syntax, see Symbols. These properties are not specified in the example script provided in Command Manager. MicroStrategy Administrator - Command Manager 9. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThe aim of this article is to catalog and expedite the troubleshooting process for Command Manager by ensuring that complete data makes it into our support organization before troubleshooting begins. subscription_GUID is the ID of the subscription. CACHE_FILE_NAME: The name of the Intelligent Cube cache file, returned as a string. The sample code could be as below where the ResultsFile that follows. The syntax is for MicroStrategy Command Manager version 8. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. For details on this process, refer to the. Locate Sending Log to Telemetry Server in the Features for Customer Feedback section. It is using mstrio Python library and Command Manager scripts. form_name is the name of. The script executes. In MicroStrategy Command Manager go to the Tools menu and select Options. STEPS TO REPRODUCE: 1. 2. All up to date privilege tokens are accessible in Command Manager, see Inserting Sample Statements: Outlines for more information. 3. It can be modified through the command manager script:This Knowledge Base article describes a known issue that a "Syntax Error" message appears when listing all properties for a metric in MicroStrategy Command Manager 9. USER. x scripts: CREATE SECURITY FILTER "Customer City" IN PROJECT "Duplicated MicroStrategy Tutorial" EXPRESSION "Customer City@ID=1";Save the changes to the options. The following can be reproduced with MicroStrategy Tutorial on a Linux machine in command line. MicroStrategy Configuration Wizard – mstrcfgwiz. is the name of the schedule. 0. ResultSet Columns. Procedures are reusable scripts that can be executed from other scripts. Example. 71K. NTSID "new_user_ntsid" is the new NTSID to be linked. Java cannot be included directly in a Command Manager script. Open User Preferences > Project Defaults. To create a new procedure. In MicroStrategy Command Manager 9. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. FILTER "filter_name" is the name of the filter to provide the. - UNIX and Linux: Type mstrsysmgr and press ENTER. Name: The name of the object returned by the search, returned as a string. Create a user as shown below: CREATE USER "jaime" PASSWORD "user" FULLNAME "jaime User" IN GROUP "Web Users"; Create a DbLogin for the user created in Step 2, as shown below: CREATE DBLOGIN "dblogin_ jaime". Creating a Command Manager script requires some knowledge of the Command Manager commands. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. Some statements are not available for UNIX users. Using a Command Manager script: You can also execute a Command Manager script to import an update package without using Object. Example. Steps to enable or disable Auto-complete. Trigger Event statement. This can go both ways, but this script concentrates on Library -> Web path. MicroStrategy provides a library of functions with examples that we can use to create our own scripts by clicking on the button:MicroStrategy Command Manager introduces the ability to save scripts with encryption. 4. For an introduction to Command. Assuming that the statistics tables have already been created in the. LIST [(ALL | INHERITED | GRANTED)] PRIVILEGES FOR USER "login _name ";where: ALL indicates all privileges. Now from the same client machine, connect to the same Intelligence Server via MicroStrategy Command Manager. 67K. 1. PASSWORD "new_user_password" is the new password for the users, of type string. ) From the Connection menu, select Execute. The Command Manager script outlines help you insert script statements with the correct syntax into your scripts. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. Please note that the Xmx parameter is case sensitive. Information if the script that is falling come from the outline list or this is new created script. location_path is the folder where the report resides, of type string,. This article provides instructions on how to configure Enterprise Manager Data Loads using Command Manager scripts in MicroStrategy 10. Execution: Choose whether the Command Manager statements to run are in a script file or the ones that you enter here: Script File (. By default, Command Manager scripts are saved in plain text format. Click the links below for syntax details for each type of metric expression: Simple. Schema objects, the building blocks of business intelligence and application objects that generate useful analytical information, can be transferred within or between. Click the desired topic below to view more details, or scroll down to view each of the following topics: The menu bar. From the Visualizations panel, select Grid . Dedicated Gallery with mstrio library code content modules, sample scripts, code snippets, and built-in search for easy navigation. 3 Hotfix 1. MicroStrategy comes with hundreds of default text. Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. Solution. If the MCST application is to be used with an enterprise scheduler or workflow agent, configure the agent to run the mstr_cube_trigger. Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. These script files can be created using Command Manager, as described in Creating and Executing. A full list of parameters can also be accessed from a command prompt by entering cmdmgr. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. 0. For more information about Command Manager, including steps to use Command Manager scripts, see the Command Manager chapter of the System. For LIST statements, the last section contains information about the ResultSet returned when the statement is used in a Java procedure. With this Graphical User Interface, you can look at various examples that was provided by MicroStrategy, copy the code into your own script, and edit your own script to your heart content. Example ADD ATTRIBUTEFORM "Last Name" FORMDESC "Last Name Form" FORMCATEGORY "DESC" F ORMTYPE TEXT SORT DESC EXPRESSION "[CUST_LAST_NAME]" LOOKUPTABLE "LU_CUSTOMER" TO ATTRIBUTE "Customer" IN FOLDER "Schema ObjectsAttributes" FOR PROJECT "MicroStrategy Tutorial";Script errors: Execution errors. Creates an attribute within a project. At the end of the database load routine, you include a statement to add a line to a database table, DB_LOAD_COMPLETE, that indicates that the database load is complete. Execute the command ". SYMPTOM:. Command Manager contains a large number of sample procedures that you can view and modify. For example, in the statement LIST MEMBERS FOR USER GROUP "Managers"; the word Managers is an identifier. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. Other examples of tasks you can perform using Command Manager include: User management: Add, remove, or modify users or user groups; list. MicroStrategy Command Manager 9. These commands can be compiled into script files and run from a graphical interface or from the command line. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics; Innovations; Futures. In MicroStrategy Command Manager 9. This document introduced How to establish a "connectionless" session in MicroStrategy Command Manager 9. For example, you can create multiple empty documents that use the same document template. CM is being used since REST API work only in Library and can't modify Web. Execute an Incremental Refresh report and publish the results to the Intelligent Cube associated with it. Java errors are showing when trying to run them. This statement can only be used with three-tier or four-tier project. WORKAROUND: Follow the next steps to workaround this limitation and create prompted security filters. When running a script via MicroStrategy Command Manager to stop MicroStrategy Intelligence Server, the users find that when re-starting MicroStrategy Intelligence Server, the schema is locked by MicroStrategy Command Manager. Lists all properties of a report in a project. Enable MicroStrategy Messaging Services. Script errors: Execution errors. Allow more space for the interface using the following steps: Note : This path is based on a 64-bit Windows OS. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. where: Name: The data load name. The following procedure describes how to write a script for MicroStrategy Command Manager 9. Execute a Microstrategy Command Manager script through a command line interface. LIST PROPERTIES FOR SECURITY ROLE "Architect Users"; ResultSet Columns. contact_name is the name of the recipient contact. To Execute a Script from the Command Manager Command Line Interface Using Command Manager. Command Manager script files that are used to create and administer the undo package files. x-10. x to create, import and undo packages?. For a more general introduction to MicroStrategy Command Manager, see Automating Administrative Tasks with Command Manager. PRIVILEGES: A ResultSet listing the privileges contained within the security role category. SESSION_ID: The session ID of the user connection, returned as a string. After altering the Database connection using the script from Command Manager in MicroStrategy 9. Purges the object server caching and element server caching. For further information on automating tasks using MicroStrategy Command Manager, refer to the MicroStrategy System Administration Guide product manual. KB300103: Exit code 10 is returned when executing a Command Manager workflow in MicroStrategy System Manager. Each statement ends with a semicolon (; ). Examples. Type the command of <script> EXEC to execute the. (10) A file-related operation failed. Type mstrcmdmgrw and press Enter. Command Manager was unable to. • Command line interface (using CmdMgr. The steps below show you how to create a custom group in MicroStrategy Web. Below are the syntax and examples (from Microstrategy Tutorial Project) necissary to answer Date value, Attribute qualification, Attribute element list, Text value, and Object prompts when using the 'CREATE HISTORYLISTSUBSCRIPTION' command in MicroStrategy Command Manager 9. To invoke Command Manager from the database server, use one of the following commands: SQL Server: exec xp. The following example uses the MicroStrategy Tutorial project for illustration purposes. This particular workflow is a template that is delivered out-of-the-box with System Manager. A Command Manager script consists of one or more script statements. x Number of Views 2. For example, you can edit all custom groups to use a different attribute element. It is the most basic, simple, and therefore, the most massive way to use command Manager. 1? ANSWER: When executing Command Manager scripts via Command Manager GUI, users have the option to save the outputs to CSV or Excel file format. Project source statement syntax. Create a user as shown below: CREATE USER "jaime" PASSWORD "user" FULLNAME "jaime User" IN GROUP "Web Users"; Create a DbLogin for the user created in Step 2, as shown below: CREATE DBLOGIN "dblogin_ jaime". This can go both ways, but this script concentrates on Library -> Web path. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. (From the File menu, select Open . For the Command Manager syntax for starting and stopping Intelligence Server, see the Command Manager Help (press F1 from within Command Manager). When executing Command Manager scripts via Command Manager GUI, users have option to save the outputs to CSV or Excel file format. For example, type the command: . A list of security roles in the project source opens in the main Developer pane. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. If you have purchased a license for Command Manager, you can use Command Manager scripts to create and manage your schedules and subscriptions. new_attr_name is the new name of the attribute, of type string, between double quotes ("). The command line options for executing Command Manager scripts using Command Manager Runtime are included in the following table. The script contains a statement that is not supported in Command Manager Runtime. KB43715: How to create automated scripts for MicroStrategy Object Manager 9. Every Command Manager command is represented in this module. The following topics contain syntax details and example script statements for each object. x. You can turn on the Sending Log to Telemetry Server feature using either MicroStrategy Web or Command Manager. High ROI DW and BI Solutions #2 Use of Pre – Post SQL VLDB Settings of MicroStrategy Use command manager script to get list of reports where VLDB setting – Pre-. Go to the Start Menu > All Programs > Microstrategy > Command Manager. Using X11 program create a Command Manager script such as "LIST ALL USER GROUPS". In System Manager, use the Find and Replace File Content task to change the string in the Command Manager script file to the parameter value. For more information about Command Manager, including instructions, see. Click the Outline button. MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. Number of Views 3. To load a script and execute it, type EXECFILE filename, where filename is the name of the script. blogspot. You can manage configuration settings within the MicroStrategy platform, for either project sources or Narrowcast Server metadatas. For information on deploying a workflow from the command line or as a silent process, see Deploying a Workflow. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. Create User Group Statement. Some of these tasks are performed in the Developer interface, such as managing user and group privileges for Web users, or registering a project in server (3-tier) mode so it can be available in Web. x. Command Manager allows administrators to: Add, remove, or modify users or user groups. Each statement ends with a semicolon (; ). MEMBER_RESULTSET: A ResultSet containing a list of group members and related details. To include Java in a Command Manager script, you write a procedure containing the. Command Manager facilite l'intégration de l'administration MicroStrategy dans n'importe quel système de gestion. x using Command Manager By default, MicroStrategy Command Manager handles cube publication synchronously (i. Related Topics. Type the command of <script> EXEC to execute the script. To invoke Command Manager from the database server, use one of the following. Metric expressions in Command Manager use a specific syntax. Triggers an event in a MicroStrategy Intelligence Server. exe /?. 768: Grid Report. If you try to execute a script with statements that are not available in Command Manager Runtime, the script fails with. Open the script. This command line interface is used to run command manager scripts without having to load the graphical interface and to. From MicroStrategy Web. In Microstrategy Administrator - Command Manager an administrator can move reports from one folder to another and can even re-name these reports when moving them. 0 and later Command Manager can be used to retrieve a list of all users assigned with given Security Role in a given project. Afterwards you will see Kafka log files created in the Kafka installation folder: C:Program Files (x86)MicroStrategyMessaging Services mpkafka-logs. Excel was not a supported file format for the Command Manager execution output in command line mode in MicroStrategy 9. sh -silent -options <path of the options. You can also create, edit, or delete multiple documents at the same time by using a Command Manager script. You can avoid this security risk by saving these scripts in an encrypted format. By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. 12. - In the Source File, specify the location of the original Command Manager script file. OBJECT purges object caches. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. Sending request as a file by sftp to MSCT server. cmdmgr -n "Project Source Name" -u Username -f "Input File" . LONGDESCRIPTION "new_long_description" is the new long. 1. Your Command Manager license has expired. You can use MicroStrategy Command Manager to manage any number of subscriptions. A blank visualization appears in the dossier. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. x, from the Command Outline window, follow the steps below to insert a sample into the active script window: Click to select the Samples window to bring it into focus (the current window has a white background) Highlight the desired sample to be inserted. This can be done by choosing the 'Save as Encrypted Script' option from the File menu, as shown: This password will be used for decrypting the script and will need to be entered when attempting to open the script within MicroStrategy Command Manager. where: executable_program is the name of the executable program to be launched/run, which indicates the full path and additional parameters (if necessary), of type string, between double quotes (" "). For example, you can change the system to allow more low priority jobs to complete at night than during regular hours. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. Examples include Execute SQL, Send Email, Wait, and Download Using FTP, among. You can then call this procedure from another Command Manager script, supplying.