By executing Command Manager scripts, external systems can trigger events and cause the associated tasks to be run. Solution. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). Why is this happening? The default transaction isolation level is ' MDb::TRANSACTION_ISOLATION_UNKNOWN ' which can't prevent two transactions from updating a table at the same time. The syntax details for each project source statement are grouped by the type of objects they affect. MicroStrategy System Administration Guide. LIST ALL PROPERTIES FOR INTELLIGENT CUBE CACHE GUID 1234567890ABCDEF IN PROJECT "Development Project 5"; ResultSet Columns. For example, the script may have tried to write to a read-only file, or read from a file that does not exist. Information if the script that is falling come from the outline list or this is new created script. Execute the command ". x from a command line interface. ) Run the following command in Command Manager against any project source (the below example is for the sample. For more information on the different types of metrics that can be used in MicroStrategy reports, see the Metrics section of the MicroStrategy Developer Help (formerly the MicroStrategy Desktop Help ). GUID cache_guid1. In Command Manager, procedures are reusable scripts that can be executed from other scripts. reg file under the. 2. For example, password a'b"c&d must be entered as. This can go both ways, but this script concentrates on Library -> Web path. Number of Views 455. MicroStrategy Command Manager is a script-based tool for automating Intelligence Server administration. In windows command prompt, append“ | findstr. -connlessmstr MicroStrategy Metadata MicroStrategy Metadata Connection-less -connlessncs NarrowCast Server MicroStrategy Metadata Connection-less -f Script input filefMicroStrategy. scp i PURGE OBJECT CACHING IN PROJECT "Project_Name"; Create a batch file named PurgeObjectCache. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. LIST [(ALL | INHERITED | GRANTED)] PRIVILEGES FOR USER "login _name ";where: ALL indicates all privileges. MicroStrategy will continue to investigate and post updates as soon as they are available. - UNIX and Linux: Type mstrsysmgr and press ENTER. Call the Command Manager executable, cmdmgr. Examples. IS_GROUP: Whether or not the member is a user group, returned as a boolean value. LOGIN: The login of the member, returned as a string. x. Click tab 'Display' and select 'Results to grid' in the dropdown list. 4. USER "login_name" is the name of the user whose security roles you want to list, of type string. Currently this issue is being reviewed for feasibility by our Technology team for a potentical. numbers in any notation dates object GUIDs other special characters such as carriage returns, tabs, or spacesThe Command Manager command line interface opens, in console mode, with an active connection-less project source connection. Procedures cannot be used with Narrowcast Server statements. Hi @Peter Ott(Inactive) (Microstrategy, Inc. - In the Source File, specify the location of the original Command Manager script file. With the workflow shown above, if Intelligence Server starts successfully the first time, the Command Manager script is executed next and the loop is not needed. Java is only supported in procedures, and procedures are only supported with project. x-10. x outline to alter the metric dimensionality. From the MicroStrategy Object Manager on a client machine connect to the Intelligence Server and create a project package. /mstrcmdmgr -n 693177 -u administrator -f 691031. Outlines are preconstructed statements with optional features and user-defined parameters clearly marked. Procedures are reusable scripts that can be executed from other scripts. LIST ALL DEPENDENTS FOR <PROJECT OBJECT> DSS_OBJECT_TYPE: The type of the dependent, returned as an integer: 256: Filter; 257: Custom Group. Allow more space for the interface using the following steps: Note : This path is based on a 64-bit Windows OS. Open the script. 2. In MicroStrategy Command Manager 9. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. Go to the Display tab and check or uncheck the "Enable Auto-complete" option as shown in the following image: Click Ok. 0 and later Command Manager can be used to retrieve a list of all users assigned with given Security Role in a given project. x database and leads to. Purges the object server caching and element server caching. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. With introduction of Library there is a need to synchronize user language preferences between Web and Library interfaces. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. A full list of parameters can also be accessed from a command prompt by entering cmdmgr. For example, you want to execute several reports immediately after a database load occurs so that these reports. exe -help. To Execute a Script from the Command Manager Graphical Interface. 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. Delete Metric statement. CHECKCACHEEXISTENCE indicates to check for a given cache's existence before purging it. You can also create multiple metrics at the same time by using a Command Manager script. x, when using the Command Manger ADD ACE FOR FOLDER or REMOVE ACE FROM FOLDER outlines to affect ACLs in MicroStrategy Developer, the changes are not saved after an I-Server restart or purging object cache. Type the command of <script> EXEC to execute the script. These reports are. MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. For instructions on creating these scripts with Command Manager, see Automating Administrative Tasks with Command Manager, or see the Command Manager Help. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. Consider an example of Regional Sales Reports Regional Manager East • Region = East. Administrators no longer need to install Narrowcast Server on the machine where Command Manager. The command line options for executing Command Manager scripts using the command line are included in the following table. From edit mode you can continue typing your script. There are three ways to load an outline: Create Attribute statement. 2) Create the second. CREATE FILEDEVICE "device_name" TRANSMITTER "transmitter. Settings for an individual recipient overwrite settings at the subscription level. Type help. Type. Example: Open Command Manager. 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. Sure, currently just exploring the mstrio. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. Creating a procedure is very similar to creating a script. The below command manager script can be used to check whether Messaging Services is enabled in Intelligence Server, and the Kafka Producer configuration can also be checked by this command. How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. Navigate to the directory that contains Command Manager. Command Line. When this command is executed, Command Manager waits for the report to finish executing before continuing to the next statement in the script. Now from the same client machine, connect to the same Intelligence Server via MicroStrategy Command Manager. In the example above, the script executes and completes successfully because it checks that the event was. Consider the following command from the command line:For purging the object cache use the IDSSSource interface. Create a new metric "Test DIM 2" in the Public ObjectsMetricsCount Metrics folder with the following definition: Count. A token is a word, a list of words enclosed in quotation marks, or a symbol. If the MCST application is to be used with an enterprise scheduler or workflow agent, configure the agent to run the mstr_cube_trigger. To execute. The impact is from the MicroStrategy 9. administrators to automate nearly all administrative and maintenance tasks. (10) A file-related operation failed. Right mouse click the grid and choose 'Export Results -> to Excel'. OBJECT purges object caches. address. For more information about Command Manager logging, see Using log files. If the MCST application is to be run in a loop at startup, add the command mstr_cube_trigger_loop. CONTENT: The content of the subscription, returned as a string. 3. Execution errors occur when an instruction is formed correctly but returns an unexpected result when it is executed. smw format. PROJECT "project_name1. List Attribute Properties statement. You can also create, edit, or delete multiple metrics at the same time by using a Command Manager script. new_description is the new description of the metric, of type string, between double quotes (" "). 0". Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. RUN SEARCH "Search for all objects of type Metric" IN FOLDER "Public ObjectsSearches" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. Lists all attributes from a given location path within a project. Command Manager also includes a number of sample procedures and procedure outlines. In the MicroStrategy Developer File menu, point to New > Fact. A full list of parameters can also be accessed from a command prompt by entering cmdmgr. Type mstrcmdmgrw and press Enter. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. 04K. 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. MicroStrategy Command Manager includes a. 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 introduces the ability to save scripts with encryption. txt file. If the project source name, the input file name, or any of the output file names contain a space in the. As a MicroStrategy system administrator, you may be responsible for managing MicroStrategy Web and Mobile environments. x and 10. x - 10. If help information for using the command line version of System Manager is displayed, this means that System Manager is installed correctly. For instructions on creating these scripts with Command Manager, see Automating Administrative Tasks with Command Manager, or see the Command Manager Help. 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. ) ,. MicroStrategy provides a library of functions with examples that we can use to create our own scripts by clicking on the button: In some scenarios, it is required to list all users with email addresses under specific user group with Command Manager script. scp in cmdmgr -n Project_Source_Name -u Username -f InputfileOpen Command Manager. The script executes. x. Statements consist of one or more tokens. exe and press ENTER. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. To reproduce the issue with MicroStrategy Tutorial, an Administrative user can run the following MicroStrategy Command Manager 8. Command line exit. cmdmgr -n "Project Source Name" -u Username -f "Input File" . Now from the same client machine, connect to the same Intelligence Server via MicroStrategy Command Manager. exe) — Enables you to execute existing Command Manager scripts using parameters in the command line mode. DBINSTANCE "dbinstance_name" is the name of an existing database instance (role) that will be used. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. These outlines facilitate the script development by providing the command syntax for the instructions submitted to the script executor for object manipulation. MicroStrategy Developer と MicroStrategy Command Manager は、同じコンピューター上、または異なるコンピューター上にインストール. KB233716: How to pass a System Manager parameter value into a Command Manager script or procedure. A Command Manager script consists of one or more script statements. NAME "new_login_name" is the new login name of the user, of type string. Example. You can deny user or group access to a specific MicroStrategy project by using a security role. You can then call this procedure from another Command Manager script, supplying. You can view license information in License Manager. 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. Insert a package outline to create an Undo package using following syntax as example: Click Insert Visualization . All other text appears in black. MicroStrategy Command Manager is a scripting tool that allows. This can create a security risk if your script contains a user name and password, such as for the CONNECT SERVER statement. scp. MicroStrategy Command Manager does not check anything outside of the script to ensure that it successfully completes. Sample Workflows: Templates. These properties are not specified in the example script provided in Command Manager. Execute the command through Command Manager. CACHE_FILE_SIZE: The file size of the Intelligent Cube, returned as an integer. ACTION:This command terminates the entire Command Manager process. 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. Add User Group Statement. x. To do this, you could create a script to increase the number of low priority database. The second script, using the Alter User script, is used to configure the user. Example. A command line window opens. Script Gallery tooltip with insights on how to uses classes and functions, with usage. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. Description: A basic demo for Admins and Advanced. A list of outline categories displays on the left side of the dialog box. By default, this executable is located in C:Program FilesMicroStrategyCommand Manager. LIST ALL USER CONNECTIONS FROM PROJECT "Testing Project 1"; ResultSet Columns. In MicroStrategy Command Manager 9. List User Group Properties Statement. For example, you can create multiple empty documents that use the same document template. 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. MicroStrategy recommends that you follow these best practices for configuring your upgrade test environment:. Each row in the ResultSet object contains information about one item. These procedures are briefly described below. ###Description Goal of this repo is to share/collect customer created/customized procedures of MicroStrategy Command Manager. 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. There are 8 new features added in MicroStrategy Command Manager 9. LIST PRIVILEGES FOR SECURITY ROLE "Architect Users"; ResultSet Columns. • Command line interface (using CmdMgr. (12) The script contains a statement that is not supported in Command Manager Runtime. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. For more information, see the Command Manager chapter of the System Administration Guide. Scripts from Enterprise manager are working well when they are executing with GUI 'Command Manager'. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. A Distribution Services file device is used to automatically send a MicroStrategy report or document to a folder on a computer on your network in a file format that the user chooses when subscribing to the report. bat, as shown below, to run PurgeObjectCache. 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. You can turn on the Sending Log to Telemetry Server feature using either MicroStrategy Web or Command Manager. Number of Views 16. Lists all attributes from a given location path within a project. Lists all properties from a given attribute within a project. Executing a script. For example, the syntax for granting the privilege 'Web use design mode' is: GRANT WEBUSEDESIGNMODE TO USER "TESTER". The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. scp Encrypted Script Files Which administrative tasks can be automated with Command Manager using out-of-the-box scripts in MicroStrategy 9. /mstrcmdmgr -connless -f /home/mstr/MicroStrategy/test. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). 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. 2. The user must first have a valid workflow. For example, you can. x provided to ability to run some outlines without the need for an Intelligence Server or Narrowcast Server connection. A registry key or file required for Command Manager was not found. So this will work: CREATE FACT "TestFact" IN FOLDER "Schema ObjectsFactsBulkFactTest" EXPRESSION "StuffCount" EXPSOURCETABLES "TableName" FOR PROJECT. (From within Command Manager, select Help. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. List User Group Privileges Statement. 4. PASSWORD "new_user_password" is the new password for the users, of type string. SYMPTOM:. MicroStrategy Administrator - Command Manager 9. 3. This file is created using MicroStrategy Object Manager. LIST ALL REPORTS FOR PROJECT "MicroStrategy Tutorial"; LIST ALL REPORTS IN FOLDER "Public ObjectsReports" FOR PROJECT "MicroStrategy Tutorial"; ResultSet Columns. OR. You can also import users. Number of Views 5. Enable MicroStrategy Messaging Services. Some statements are not available for UNIX users. With. log Note: the “KeyWord” should be set in the. Creating a Command Manager script requires some knowledge of the Command Manager commands. To start the Command Manager command-line interface. GUID cache_guid1. DESCRIPTION "new_user_description" is the new description of the users, of type string. For example, the script may have tried to write to a read-only file, or read from a file that does not exist. The following example uses the MicroStrategy Tutorial project for illustration purposes. To invoke Command Manager from the database server, use one of the following. (DB Query Tool is located at Start > Programs > MicroStrategy >. A single batch file can contain more than one script to be executed. Returned as an integer: 257: Custom Group. 0. The following list describes each of them。1. 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. For more information about. Command Line. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. For examples of the correct syntax for all Command Manager statements, see the Help. Comments display as green. Each statement ends with a semicolon (; ). Delete User Group Statement. N are the GUIDs of the report caches to be deleted, of type GUID. Script Gallery tooltip with insights on how to uses classes and functions, with usage. • System Tools—These processes enable you to perform tasks external to MicroStrategy. All the scripts (ISQL and MicroStrategy Administrator - Command Manager) can be embedded into a single. ) For example, the user could type UNR and press CTRL+SPACE to fill in the rest of UNREGISTER without having to type the complete word. x and newer has a built in command line interface. Using X11 program create a Command Manager script such as "LIST ALL USER GROUPS". They can be manipulated as follows: To see the actual outline statements, expand a category by clicking the + sign next to it. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. You can manage configuration settings in the MicroStrategy platform for either project sources or Narrowcast Server metadatas. Editing a script. The process to grant privileges using MicroStrategy Command Manager is: Open MicroStrategy Command Manager and connect to the appropriate metadata. However, a given Script window can execute only one script at a time. Automating Administrative Tasks. 0, Command. It is using mstrio Python library and Command Manager scripts. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. MicroStrategy Administrator - Command Manager 9. 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. Source: MicroRooster. However, other. The Security Role Editor opens. LOGIN: The login of the member, returned as a string. 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. In Windows: From the Windows Start menu, go to All Programs > MicroStrategy Tools > Command Manager. MEMBER_RESULTSET: A ResultSet listing the members of the security role. Save the workflow in . DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB486117: MicroStrategy Command Manager でスクリプトの日本語が文字化けする. To Start the Command Manager Graphical Interface. These script files can be created using Command Manager, as described in Creating and Executing Scripts. 3. Uses an English like scripting language to convert a. MicroStrategy Command Manager can trigger events from the Windows command line. scp":. MicroStrategy Administrator - Command Manager 9. Name: The name of the object returned by the search, returned as a string. (From within Command. Command Manager contains a large number of sample procedures that you can view and modify. For more information about. List Report Properties statement. Double-click the security role you want to assign to the user or group. Delete the inconsistent table objects if no other objects are depending on it. LONGDESCRIPTION "new_long_description" is the new long. STEPS TO. The Command Manager script outlines help you insert script statements with the correct syntax into your scripts. Check "Use File Logging. 4. The following is a list of the different properties of a MicroStrategy metadata object that can be listed using Command Manager 8. To check the syntax of the entire script before execution, see Checking the syntax of a script. Type cmd and press ENTER. For example, the string “REPLACEME” was used in the image below. It is using mstrio Python library and Command Manager scripts. 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. For example, you can create multiple empty documents that use the same document template. 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. For a complete guide to the commands and statements used in Command Manager, see the Command Manager Help. 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. Steps to automatically complete a script command. IS_GROUP: Whether or not the member is a user group, returned as a boolean value. It contains the Command Manager script, which is just a series of Command Manager statements or procedure invocations. OWNER: The owner of the subscription, returned as a string. for a script with several commands, one of which being a cube publication command, the. executeCapture runs any Command Manager command and returns the results (if the. 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. Trending Articles. This article provides instructions on how to configure Enterprise Manager Data Loads using Command Manager scripts in MicroStrategy 10. When creating a script, we can sequence different functions that will perform the tasks we request. form_name is the name of. Answer. PROJECT "project_name1. Connect to a project source or Narrowcast Server. From the Select a Project drop-down list, select the project for which to assign the security role. DESCRIPTION "new_user_description" is the new description of the users, of type string. Go to the Display tab and check or uncheck the "Enable Auto-complete" option as shown in the following image: Click Ok. A list of security roles in the project source opens in the main Developer pane. Dedicated Gallery with mstrio library code content modules, sample scripts, code snippets, and built-in search for easy navigation. This statement can only be used with three-tier or four-tier project. The syntax is for MicroStrategy Command Manager version 8. log -showoutput | findstr /I "KeyWord" >> CustomizeLog. 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. 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. desc is the description of the attribute, of type string, between double quotes ("). Lists the current properties of a user. You can start and stop Intelligence Server. The command prompt in console mode displays the metadata source and user to which Command Manager is connected. 5. Command Manager は、スクリプトによって直接またはプロジェクト ソースによって Intelligence Server (メタデータ リポジトリ) に接続できます。. You can start and stop Intelligence Server. x. Command Manager allows administrators to: Add, remove, or modify users or user groups. Excel was not a supported file format for the Command Manager execution output in command line mode in MicroStrategy 9. 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. These commands can be compiled into script files and run from a graphical interface or from the command line. For example, you want to execute several reports immediately after a database load occurs so that these reports. The main Command Manager window contains the Script windows you use to edit and execute Command Manager scripts. 769:. The Subscription Manager allows you to manage all the subscriptions for a project from one interface. x Number of Views 2. README. Command Manager contains over 200 commands that automate administrative tasks. After altering the Database connection using the script from Command Manager in MicroStrategy 9. With Command Manager you can change multiple configuration settings all at once as part of an automated script. Every Command Manager command is represented in this module. ACTION Contact Microstrategy Technical. 4. Create, modify, and delete database instances, connections, and logins. PROJECT: The project associated with the user connection, returned as a string. The script only contains the first part of the sequence and hence only tracks that piece of information. FOLDER "location_path" is the folder path where the security filter is to be placed in the project, of type string. In a text editor (such as Notepad), enter the command line statement that the task scheduler should execute. Knowing this, a user can create their own User Procedures starting from scratch or based in any Sample Procedure provided and making their own modifications. Java code, and execute the procedure from a Command Manager script. This document introduced How to establish a "connectionless" session in MicroStrategy Command Manager 9. Number of Views 884. REPORT purges report caches. LIST PROPERTIES FOR SECURITY ROLE "Architect Users"; ResultSet Columns. project_name is the name of the project, of type string, between double quotes ("). How to automatically trigger reports to execute after Intelligent Cubes are published or refreshed in MicroStrategy 9. Execute script statements: Type in the Command Manager statement or statements to be completed. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. KB42309: When using MicroStrategy Command Manager script ALTER SERVER. For example, you can edit all custom groups to use a different attribute element. Exact outline that is failing.