From the Visualizations panel, select Grid . This can be done by choosing the 'Save as Encrypted Script' option from the File menu, as shown: The user is then prompted to enter a password after selecting the location of the script file and the save button, as shownSeptember 18, 2018 Command Manager Scripts in Microstrategy to create a user and add to a group CREATE USER "LDAPID" FULLNAME "FirstName LastName" NTLINK "DOMAINLDAPID" PASSWORD "123456" ALLOWCHANGEPWD TRUE ALLOWSTDAUTH TRUE CHANGEPWD FALSE PASSWORDEXP NEVER; ADD USER. long_description is the long description of the attribute, of type string, between double quotes ("). (From within Command. exe and press ENTER. The following steps show how to implement this functionality in MicroStrategy Command Manager: Create User Profile Folder In MicroStrategy Command Manager, using the User Profile outlines to write a script to create the user profile folder. Statements consist of one or more tokens. You can also create, edit, or delete multiple metrics at the same time by using a Command Manager script. - In the Destination File, specify. Java errors are showing when trying to run them. Create, modify, and delete database instances, connections, and logins. Exact outline that is failing. More architectural examples can be found here. The following procedure describes how to write a script for MicroStrategy Command Manager 9. MicroStrategy Command Manager 9. contact_name is the name of the recipient contact. For example, password a'b"c&d must be entered as. PRIVILEGE_NAME: The name of the privilege, returned as a string. MicroStrategy Command Manager can trigger events from the Windows command line. Project source statement syntax. In this example the file name "691031. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. Statements consist of one or more tokens. For more information about. You can execute Command Manager scripts in the following ways: • From the Command Manager graphical interface (see Creating and executing scripts, page 640 ) • From the Command Manager command line interface (see Using Command Manager from the command line, page 650 )LISTS OF MICROSTRATEGY OBJECTS USED IN COMMAND MANAGER SCRIPTS List of Configuration Object Types DBINSTANCE, DBCONNECTION, DBLOGIN, SCHEDULE, USER, GROUP, EVENT List of Project Object TypesKB30342: MicroStrategy Command Manager feature: Auto-complete commands in a script The auto-complete feature can significantly speed up the time it takes users to create a Command Manager script and also will reduce the dependency to the usage of the outlines window and documentation referenceWhen the answer is a text such as "Atlanta", ^" must be placed around the answer because Command Manager requires an escape character for the quotes. 3. where: user_name is the name of the user contact_name is the name of the contact contact_group_name is the name of the contact group address_name is the name of the. PROJECT: The project associated with the user connection, returned as a string. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. You can perform various administrative and application development tasks by using text commands that can be saved as scripts or entered as commands to be completed as part of a System Manager workflow. MicroStrategy Administrator - Object Manager is the component in the MicroStrategy Product Suite that allows system administrators to conduct project life-cycle management. For a more general introduction to MicroStrategy Command Manager, see Automating Administrative Tasks with Command Manager. 4) In MicroStrategy Developer, connect to the MicroStrategy. This can create a security risk if your script contains a user name and password, such as for the CONNECT SERVER statement. These commands can be compiled into script files and run from a graphical interface or from the command line. Click the Outline button. MicroStrategy Command Manager lets you perform various administrative and application development tasks by using text commands that can be saved as scripts. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . 4. Now from the same client machine, connect to the same Intelligence Server via MicroStrategy Command Manager. FULL_NAME: The full name of the member, returned as a string. new_description is the new description of the metric, of type string, between double quotes (" "). Parameters Explained: mstrio for R - Get Cube. " This syntax reference guide lists the statements available for Command Manager Runtime and gives the syntax and examples for each statement. After altering the Database connection using the script from Command Manager in MicroStrategy 9. Once MicroStrategy Service Manager is open, click on Service Options, as shown below: Windows Service Manager - click Start-> Settings-> Control Panel-> Administrative Tools-> Services. long_description is the new long description of the metric, of type string, between double quotes ("). For a full list of product privileges, see Privileges by License Type. The Command Manager script outlines help you insert script statements with the correct syntax into your scripts. These procedures are briefly described below. The command prompt in console mode displays the metadata source and user to which Command Manager is connected. In the Log file path field, type the path of a log file, or use the folder (browse) icon to browse to a log file. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. Command line syntax for Command Manager Runtime. It is using mstrio Python library and Command Manager scripts. By default, Command Manager scripts are saved in plain text format. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. Name: The name of the object returned by the search, returned as a string. By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. The following topics contain syntax details and example script statements for each object. <. (12) The script contains a statement that is not supported in Command Manager Runtime. List of machines involved (OS types of machine) and which one is running command manager. scp. Is it possible to export Command Manager results to CSV or Excel when executing scripts in Windows command line for MicroStrategy Analytics Command Manager 9. The syntax details for each project source statement are grouped by the type of objects they affect. In MicroStrategy Command Manager 9. LONGDESCRIPTION "new_long_description" is the new long. Type the command of . Scripts from Enterprise manager are working well when they are executing with GUI 'Command Manager'. 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. When you execute a script, Command Manager checks the syntax of each statement immediately before executing it, to ensure that the statement is a well-formed Command Manager instruction. - UNIX and Linux: Type mstrsysmgr and press ENTER. Some statements are not available for UNIX users. Execution errors occur when an instruction is formed correctly but returns an unexpected result when it is executed. For example, you can create a subscription to send multiple recipients a report via email but specify that one member of the subscription receive the information as a link to. 1. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. MicroStrategy Administrator - Command Manager 9. Starting in MicroStrategy Command Manager, the user can take advantage of Procedures, a new concept that introduces the flexibility of using java code with regular command manager commands. for a script with several commands, one of which being a cube publication command, the subsequent commands. Project name: Specifies the project which data will be used. A Command Manager script consists of one or more script statements. Example. These properties are not specified in the example script provided in Command Manager. x. STEPS TO. The Subscription Manager allows you to manage all the subscriptions for a project from one interface. This document introduced How to establish a "connectionless" session in MicroStrategy Command Manager 9. new_desc is the new description of the attribute, of type string,. Examples. Automating Administrative Tasks. PASSWORD "new_user_password" is the new password for the users, of type string. x and 10. x provided to ability to run some outlines without the need for an Intelligence Server or Narrowcast Server connection. Execute script statements: Type in the Command Manager statement or statements to be completed. It is the most basic, simple, and therefore, the most massive way to use command Manager. Each row in the ResultSet object contains information about one item. GRANTED indicates only privileges that are directly granted to the user. The description of each parameter is as follows: -n Project_Source_Name: Specifies the project source name to which the application must connect to execute the script. (DB Query Tool is located at Start > Programs > MicroStrategy >. x script times out even after 20 minutes even though a timeout value of greater length is specified. However, if starting Intelligence Server is not successful, the first thing that occurs is that the Update Loop Counter configuration updates a parameter for the workflow. for a script with several commands, one of which being a cube publication command, the. Allow more space for the interface using the following steps: Note : This path is based on a 64-bit Windows OS. The script executes. new_desc is the new description of the attribute, of type string,. PROJECT "project_name" is the name of the project for which caching is to be purged, of type string. Call the Command Manager executable, cmdmgr. The following topics contain syntax details and example script statements for each object. 1. Java code, and execute the procedure from a Command Manager script. 31K. Open MicroStrategy Command Manager and connect to the appropriate metadata. The steps below show you how to create a custom group in MicroStrategy Web. Double-click the security role you want to assign to the user or group. LOGIN: The login of the member, returned as a string. 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. List Attributes statement. As MicroStrategy transitions to newer solutions and moves towards sunsetting Command Manager, this list is not maintained. e. Execute the command ". In Command Manager, procedures are reusable scripts that can be executed from other scripts. Java code, and execute the procedure from a Command Manager script. To start the Command Manager command-line interface. 2. You can deny user or group access to a specific MicroStrategy project by using a security role. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. For more information about Command Manager, including steps to use scripts, see the Command Manager chapter of the System Administration Help. This server should previously be added to Enterprise Manager using the Start Monitoring command. Syntax errors occur when Command Manager encounters an instruction that it does not understand. txt file. For an explanation of each symbol in Command Manager syntax, see Symbols. Information if the script that is falling come from the outline list or this is new created script. 2. Command line syntax. 0 and later Command Manager can be used to retrieve a list of all users assigned with given Security Role in a given project. Using X11 program create a Command Manager script such as "LIST ALL USER GROUPS". 3. In the MicroStrategy Tutorial project, go to Public ObjectsReports. NAME: The name of the subscription, returned as a string. 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. cmdshell. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Rework the Command Manager script so that it will change the "User must change password at next login" option to FALSE, such as in the following example: ALTER USER "TestUser" PASSWORD "19eighty2" ALLOWCHANGEPWD FALSE. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. • Telemetry Manager (Zookeper) • MicroStrategy Intelligence Server Log Consumer (Kafka Consumer). 4. The Search for Objects is a new feature added in the Command Manager 9. The same schedule should be made to break the link between the report and itself after the execution. LONGDESCRIPTION "new_long_description" is the new long. x. They can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager. Type cmd and press ENTER. scp): Browse to and select the Command Manager script file that defines all the tasks to be completed. MicroStrategy. This can go both ways, but this script concentrates on Library -> Web path. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. You can avoid this security risk by saving these scripts in an encrypted format. PUBLISH INCREMENTAL REFRESH REPORT ("name" IN FOLDER "folder_name" | GUID "guid"). GUID cache_guid1. For more information about Command Manager logging, see Using log files. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. To do this, you could create a script to increase the number of low priority database. In Command Manager, procedures are reusable scripts that can be executed from other scripts. For detailed information. This article provides instructions on how to configure Enterprise Manager Data Loads using Command Manager scripts in MicroStrategy 10. As of MicroStrategy 9. The Security Role Editor opens. Alternatively, the user can split the logs between Results, Failed Instructions, and. NOTE: Parameters enclosed in brackets '' are optional. Insert a package outline to create an Undo package using following syntax as example: Click Insert Visualization . Lists all attributes from a given location path within a project. address. You can manage configuration settings within the MicroStrategy platform, for either project sources or Narrowcast Server metadatas. ) ,. This statement can only be used with three-tier or four. While specifying the filtering and grouping condition, please refer to the metric dimensionality symbols guide in KB7952. 4. Outline syntax; Privileges and time zones; Steps to insert an outline into a script; Steps to insert part of an outline into a script; Steps to. This script is at C:\Program Files (x86)\MicroStrategy\Command Manager\Outlines\Cache_Outlines\Invalidate_Report_Cache_Outline. For version 2020, this step also applies the command manager script which finalizes the configuration of the Platform Analytics project. REPORT purges report caches. Outline syntax; Privileges and time zones; Steps to insert an outline into a script; Steps to insert part of an outline into a script; Steps to. MicroStrategy Command Manager can trigger events from the Windows command line. By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. Enable MicroStrategy Messaging Services. Type. x. It is using mstrio Python library and Command Manager scripts. Number of Views 16. 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. project_name is the name of the project, of type string, between double quotes ("). Connect to a project source or Narrowcast Server. /mstrcmdmgr -connless -f /home/mstr/MicroStrategy/test. new_start_date is the new start date that determines the first day the schedule will be active, of type date (mm/dd/yyyy). LIST ALL DEPENDENTS FOR <PROJECT OBJECT> DSS_OBJECT_TYPE: The type of the dependent, returned as an integer: 256: Filter; 257: Custom Group. A token is a word, a list of words enclosed in quotation marks, or a symbol. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. In order to change an attribute form expression of an attribute form, use the "add attributeformexp" script with the overwrite option. The schedule will never be triggered again after this date. There are 2 types of Procedures: User and Sample procedures. The sample code could be as below where the ResultsFile that follows. MicroStrategy Command Manager 9. Description: A basic demo for Admins and Advanced. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. For a complete guide to the commands and statements used in Command Manager, see the Command Manager Help. exe /?. 4. For the Command Manager syntax for starting and stopping Intelligence Server, see the Command Manager Help (press F1 from within Command Manager). scp. 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. Go to the Start Menu > All Programs > Microstrategy > Command Manager. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. x After Enterprise Manager has been installed and Enterprise Manager Data Loader Service configured in your environment, Command Manager scripts should be used to connect to Intelligence Server and configure. MicroStrategy Command Manager introduces the ability to save scripts with encryption. MicroStrategy Command Manager does not check anything outside of the script to ensure that it successfully completes. The command line options for executing Command Manager scripts using the command line are included in the following table. x-10. x-10. Please note that the Xmx parameter is case sensitive. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. The command line options for executing Command Manager scripts using Command Manager Runtime are included in the following table. Steps to automatically complete a script command. To Access Fact Expressions For a New Fact with an Expression. ResultSet Columns. 0". MicroStrategy Command Manager provides the ability to create text-based scripts and automate common administrative functionality. 4. scp". You can manage configuration settings in the MicroStrategy platform for either project sources or Narrowcast Server metadatas. Command Manager は、スクリプトによって直接またはプロジェクト ソースによって Intelligence Server (メタデータ リポジトリ) に接続できます。. To create a new procedure. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. 0, Command. MEMBER_RESULTSET: A ResultSet listing the members of the security role. 4. location_path is the folder where the fact is to be placed, of type string, between double quotes (" "). a Script History that saves previously executed scripts and inserts them into the. GUID cache_guid1. For more information about Command Manager, see the Automating Administrative Tasks chapter in the System Administration Help. Steps to enable or disable Auto-complete. If help information for using the command line version of System Manager is displayed, this means that System Manager is installed correctly. To do this, you could create a script to increase the number of low priority database. In MicroStrategy Command Manager go to the Tools menu and select Options. This file is created using MicroStrategy Object Manager. Statements consist of one or more tokens. Administrators no longer need to install Narrowcast Server on the machine where Command Manager. CREATE ATTRIBUTE "Month" DESCRIPTION "Duplicate of Month Attribute from folder Time" IN FOLDER "Schema ObjectsAttributes" 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. DELETE METRICmetric_nameIN [FOLDER]location_pathFROM PROJECTproject_name; metric_name is the name of the metric to be deleted, of type string, between double quotes (" "). To invoke Command Manager from the database server, use one of the following. The Command Manager script outlines help you insert script statements with the correct syntax into your scripts. Within Command Manager, after connecting to the project source, click on "Tools--> Options. project_name is the name of the project, of type string, between double quotes ("). For general information about Command Manager, see Automating Administrative Tasks with Command Manager. 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. exe -help. Right mouse click the grid and choose 'Export Results -> to Excel'. ; Actions: The actions this data load will trigger. The steps below show you how to deploy a workflow from within System Manager. Assuming that the statistics tables have already been created in the. When using MicroStrategy Command Manager in Command Line mode on Linux or MicroStrategy Cloud Remote Command Manager, the command fails with exit code 10. N" are the projects from which the invalid report caches are to be deleted, of type string. However, a given Script window can execute only one script at a time. List User Group Members Statement. Example. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Java cannot be included directly in a Command Manager script. Number of Views 3. Example. Save the file as Filename. IS_GROUP: Whether the member is a user or a group, returned as a Boolean. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). The method IDSSSource::ExecuteCommand - with the command DssSrcCmdPurge purges all objects from an object cache. A Command Manager script consists of one or more script statements. Schema objects, the building blocks of business intelligence and application objects that generate useful analytical information, can be transferred within or between. 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. The impact is from the MicroStrategy 9. e. Go to the Display tab and check or uncheck the "Enable Auto-complete" option as shown in the following image: Click Ok. MEMBER_RESULTSET: A ResultSet listing the members of the security role. For example, you want to execute several reports immediately after a database load occurs so that these reports always have a. For the syntax of metric expressions in Command Manager, see Metric expressions syntax. sourcetableN is the name of the source table to be used in the form, of type string, between double quotes ("). Click tab 'Display' and select 'Results to grid' in the dropdown list. These scripts and commands are created using Command Manager. ALLOW_CHANGE_PASSWORD: Whether or not the user's password can be changed, returned as a boolean value. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. DESCRIPTION "new_user_description" is the new description of the users, of type string. Attribute threshold applied to wrong rows when exporting sample documents with formatting. Creating a Custom Group. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. This document introduced How to establish a "connectionless" session in MicroStrategy Command Manager 9. As a MicroStrategy system administrator, you may be responsible for managing MicroStrategy Web and Mobile environments. This script is at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_OutlinesInvalidate_Report_Cache_Outline. With Command Manager you can change multiple configuration settings all at once as part of an automated script. x using Command Manager By default, MicroStrategy Command Manager handles cube publication synchronously (i. Command Line. 04K. The script contains a statement that is not supported in Command Manager Runtime. Different properties of a MicroStrategy metadata object that can be listed using Command Manager 9. For example, you can create a subscription to send multiple recipients a report via email but specify that one member of the subscription receive the information as a link. Consider the following command from the command line:For purging the object cache use the IDSSSource interface. The user has the option to send all logs to one single file. You can compose Command Manager scripts to manage user subscriptions. KB43715: How to create automated scripts for MicroStrategy Object Manager 9. 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. 4. The script file is empty. Other examples of tasks you can perform using Command Manager include: User management: Add, remove, or modify users or user groups; list. /mstrcmdmgr -connless -f /home/mstr/MicroStrategy/test. The following list describes each of them。1. For steps on how to create this update package, see Copy Objects in a Batch: Update Packages. Locate Sending Log to Telemetry Server in the Features for Customer Feedback section. x, execute the following script to create a security filter that qualifies on the ID form of the Region attribute: CREATE SECURITY FILTER "Sample Sec Filter" FOLDER "Project ObjectsMD Security Filters" IN PROJECT "MicroStrategy Tutorial" EXPRESSION "Region@ID=1";You can also create, edit, or delete multiple reports at the same time by using a Command Manager script. NOTE: Parameters enclosed in brackets '' are optional. Deletes a metric from the specified project. Command Manager contains over 200 commands that automate administrative tasks. The is a idenfitied defect in MicroStrategy Command Manager 9. Delete Metric statement. Command Manager was unable to load and prepare its operating environment. These reports are. Just checked and it seems you have to omit the base path to the table. ResultSet Columns. Script Outlines The Command Manager script outlines help you insert script statements with the correct syntax into your scripts. A Command Manager 9. If you try to execute a script with statements that are not available in Command Manager Runtime, the script fails with the message, "You are not licensed to run this command. Will let you know more about it once I started using it. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. Type the command of <script> CHECK to check if the syntax is correct. Now, simply execute the procedure, by typing: EXECUTE PROCEDURE Cube_Dep («MicroStrategy Tutorial»);, where «MicroStrategy Tutorial» is the name of. To include Java in a Command Manager script, you write a procedure containing the. These reports are located in the project under: Public Objects > Reports > Project Analysis > Object Usage Analysis > Command Manager Reporting. CM is being used since REST API work only in Library and can't modify Web. scp i PURGE OBJECT CACHING IN PROJECT "Project_Name"; Create a batch file named PurgeObjectCache. LIST ALL PROPERTIES FOR USER "palcazar"; LIST ALL PROPERTIES FOR USERS IN GROUP "MicroStrategy Tutorial Managers"; ResultSet Columns. xConsider the following example: A user would like to create a schedule that will execute daily at 7:00 P. IS_GROUP: Whether or not the member is a user group, returned as a boolean value. 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. It returns an exit code. Editing a script. scp Encrypted Script Files Which administrative tasks can be automated with Command Manager using out-of-the-box scripts in MicroStrategy 9. It was saved as Year = 2011:. This can go both ways, but this script concentrates on Library -> Web path. To invoke Command Manager from the database server, use one of the following commands: SQL Server: exec xp. To execute a script from the command line. x and above. Settings for an individual recipient overwrite settings at the subscription level. Both examples can be found in the MicroStrategy Tutorial project in the following folder: MicroStrategy Tutorial/Schema Objects/Facts. 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. SYMPTOM: In MicroStrategy Command Manager, users can export the current Project Configuration settings as a backup file to text or Excel (for Windows only) using the following script:USER "login_name" is the login name of the user to be altered, of type string. It returns an exit code. M. Creating a procedure is very similar to creating a script. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. It is using mstrio Python library and Command Manager scripts. Type cmdmgr . A Command Manager script consists of one or more script statements. ) From the Connection menu, select Execute. where: fact_name is the name of the fact, of type string, between double quotes (" "). LIST ALL REPORTS FOR PROJECT "MicroStrategy Tutorial"; LIST ALL REPORTS IN FOLDER "Public ObjectsReports" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. The syntax guide and the sample script statements are useful references to these commands. You can also create, edit, or delete multiple metrics at the same time by using a Command Manager script. DBINSTANCE "dbinstance_name" is the name of an existing database instance (role) that will be used. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Service Manager - click Start-> Programs-> MicroStrategy-> Tools-> Service Manager. 2. 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. 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. 769:. e. MicroStrategy Command Manager introduces the ability to save scripts with encryption. Command line exit. executeCapture runs any Command Manager command and returns the results (if the. For example, you can.