Begin creating a configuration package by navigating to ToolsCreate Configuration Package. In order to kick off this Command Manager file, we then create a windows . /mstrcmdmgr -interactive and press ENTER to open Command Manager. In MicroStrategy Command Manager 9. x. Type the following command in the Windows command line: <Path> setup. 6: MicroStrategy Web. In MicroStrategy 10. These reports are. Command Manager returns an "Object with ID 'XXX' and type 34 (User) is not found in metadata. After running the command in Command Manager, edit the subscription and the delivery format for that subscription is now set to. In the Actions column, select the Edit icon for the user to modify. FILTER "filter_name" is the name of the filter to provide the. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a User. List all properties for a specific subscription. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. To invoke Command Manager from the database server, use one of the following. Click User Manager . This script is at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_OutlinesInvalidate_Report_Cache_Outline. The Python script below was written for that purpose. While still logged into MicroStrategy Web 8. Right-click each service and select Stop. x search for unused objects, but this doesn't happen, as shown below:Platform Analytics is a completely new product introduced in MicroStrategy 11. Refresh. Liaison but would like to reference available resources, he/she may create a MicroStrategy Community account to access the site. The syntax is for. A MicroStrategy Intelligence Server was not found at this location. The following is a list of all the user privileges, their corresponding privilege to be used in Command Manager and their descriptions: Web Reporter privileges Web Analyst. In Command Manager, create a cache update subscription by running the script below: CREATE CACHEUPDATESUBSCRIPTION "cube cache update" SCHEDULE "all the time" USER "administrator" CONTENT "Intelligent Cube - Dynamic Sourcing" IN FOLDER "Public ObjectsReportsMicroStrategy Platform CapabilitiesMicroStrategy. Log in a project source in Command Manager. Platform Analytics. The licensing scheme operates as follows: Auditing named users for every component of the MicroStrategy 9. Web Professional privileges. 4. x returns only the English group name. When creating many users, it is necessary to use MicroStrategy Command Manager to increase the speed of creating users. KB45980: How to get the list of users belonging to user groups in MicroStrategy Command Manager 9. The WHLINK option sets the login name for both database authentication and. Trigger events. In MicroStrategy Command Manager 9. After executing a ’PURGE [ALL REPORT] CACHING' script in MicroStrategy Administrator Command Manager 9. The Command Manager application provides a convenient feature that allows the user to create a project (data) source directly in the application rather than switching to MicroStrategy Developer. Every Command Manager command is represented in this module. In order to obtain a list of all of the reports that access a specific table with the use of MicroStrategy, users can use MicroStrategy Enterprise Manager to obtain this with the follow the next steps:. bat file. The following privileges are the minimum privileges required in order to use the User Manager to its fullest: Enable Intelligence Server administrator from Web,Create and edit users and groups,Enable user,Reset Password,Configure Group Membership,Link users and. WORKAROUND: Users can run the update schema command a second time in MicroStrategy Command Manager. Privilege in Command Manager * Create derived metrics: create calculations using metrics on a report: CREATEDERIVEDMETRICS * Define derived elements: create derived elements in a report or document: DEFINEDERIVEDELEMENTS * Use report objects window: view and use the Report Objects window: USEREPORTOBJECTSWINDOW * Use view. A Command Manager script consists of one or more script statements. Place the Command Manager procedure file in the specified procedure directory. xAs Bruno said, the Outlines option gives you all the templates that there are in Command Manager, which you can build together and define to do what you want. Today I bring you another tool from the MicroStrategy suite of products: the Command Manager, a MicroStrategy scheduling tool that can make the difference between a task lasting seconds and lasting. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. reg file under the. e. 4. Once the above outline is executed in Command Manager, all addresses associated with all users under Everyone will be deleted. For using Enterprise Manager through Command Manager, users don’t have to run this. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. Command Manager returns an "Object with ID 'XXX' and type 34 (User) is not found in metadata. 1) Create a dashboard in MicroStrategy. The folder and its contents remain on the system and ownership is assigned to Administrator. TRIGGER SUBSCRIPTIONsubscription_name [MANAGE ALL] [ (USERuser_name| CONTACT contact_name| OWNERowner_name| CONTENT (report_or_document_name IN FOLDER location_name) | GUID report_or_document_guid)] FOR PROJECTproject_name; where: subscription_GUID is the ID of the subscription. Triggering Events. it is evident that the user does not have Write permissions to this object. Note that historically the fencing feature was only available in Command. ACTION: Use a user ID that has administrator privileges to run the. A user can be forced to update their password by marking the appropriate checkbox on their user page in Developer: This checkbox can be marked for all users easily, via MicroStrategy Command Manager: ALTER USERS IN USER GROUP "Everyone" CHANGEPWD TRUE;To manage your schedules, select from the tasks below: To create a new schedule, see Creating Schedules. The Save dialog box opens. The reason this is useful is because the command line. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from cubes and reports, create new datasets, add new data to existing. Place the Command Manager procedure file in the specified procedure directory. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. LU_Groups. 4. Creating a Custom Group. Click on the "Log" tab. USER "login_name" is the name of the user whose security roles you want to list, of type string. STEPS TO REPRODUCE. x and 10. Exercise – Creating user Hierarchies In this exercise you will learn to create Hierarchies. STEPS TO REPRODUCE: 1. Level 1 (0-15 days) Level 2 (15-30 days) Level 3 (30+ days) Hyper-threading technology is ignored when counting CPUs of MicroStrategy Intelligence Server. 4. • Enterprise Manager. Open your new project MicroStrategy Essentials and go to the SchemaIn MicroStrategy Object Manager 9. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER. For more information about Command Manager, see Automating Administrative Tasks with Command Manager, or the Command Manager Help (from within Command Manager, press F1). MicroStrategy Command Manager. 5. Create, modify, and delete database instances, connections, and logins. To create an event using Command Manager. For general information about Command Manager, see Automating Administrative Tasks with Command Manager. 63K. MicroStrategy Office privileges. This script is at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_OutlinesInvalidate_Report_Cache_Outline. Click Create Role . For general information about Command Manager, see Automating Administrative Tasks with Command Manager. The Security Role Editor opens. Use this module to create or execute MicroStrategy Command Manager scripts. The following procedure describes how to use MicroStrategy Command Manager 9. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER "mstr_test" PASSWORD "123. Lists all attributes from a given location path within a project. Command Manager は、スクリプトによって直接またはプロジェクト ソースによって Intelligence Server (メタデータ リポジトリ) に接続できます。. MicroStrategy Command Manager. exe --ResponseFile="C: esponse. x and 10. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. ACTION. The following privileges are the minimum privileges required in order to use the User Manager to its fullest: Enable Intelligence Server administrator from Web,Create and edit users and groups,Enable user,Reset Password,Configure Group Membership,Link users and. Where <Path> is the directory where the setup. MicroStrategy Command Manager MicroStrategy Command Manager gives the administrators the ability to create scripts to automate the most common administrative tasks. For steps to complete various configurations tasks with the Configuration Wizard, see the sections listed below: Once you reach the Summary page for a configuration, click Save. Create a file subscription with the delivery format set to Excel; When the subscription runs, the file delivers as an Excel file. C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. subscription_GUID is the ID of the subscription. The documentation for every method includes the 8. All up to date privilege tokens are accessible in Command Manager, see Inserting Sample Statements: Outlines for more information. Command name: “man” - stands for “Manual. bat. 7. PRE-REQUISITES:-DSN for the Enterprise Manager warehouse repository must be created in this Linux environment. e. For the sample to work, the MicroStrategy Web JAR files must be accessible by the Java Runtime. This capability allows you to personalize messages using user information and create. Where <Path> is the directory where the setup. 2. Open Command Manger and create a connected or connection-less session. txt goto 20. One means of doing this is to use the "List all metrics for project" outline under OutlinesMetrics in Command Manager and export the content for further analysis. x metadata using a Command Manager outline. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). x. Click OK. To Start the Command Manager Graphical Interface. Create an attribute called TestCategory with an ID form using following expression: Create an attribute qualification prompt called Category ; Create report r1 and add the Category prompt to. For more information, reference the following doc: MicroStrategy Command Manager Help; Web API Reference ; Via Web Java SDKAlthough MicroStrategy Command Manager 9. Related articles from the Community: Knowledge Base: How. 5. The user has the option to send all logs to one single file. Create a Security Role. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. MicroStrategy Command Manager lets you perform various administrative and application development tasks by using text commands that can be saved as scripts. 4. Create a batch file with content similar to below that can kick off the above Command Manager script by executing Command Manager through Command Line C:Program Files (x86)MicroStrategyCommand Manager>cmdmgr -connlessmstr -f CJ_PURGE. Create an attribute called TestCategory with an ID form using following expression: Create an attribute qualification prompt called Category ; Create report r1 and add the Category prompt to. ; Select the Security Filters tab. " Cache management. Create a new attribute form for any existing attribute. x, select 'Project Documentation' from the Tools menu to start the wizard. To update structure for a warehouse table, you will need to provide a name. x script or via the Project Configuration Editor in MicroStrategy Desktop 8. KB43715: How to create automated scripts for MicroStrategy Object Manager 9. 0. A. A blank visualization appears in the dossier. MicroStrategy Command Manager. x . A token is a word, a list of words enclosed in quotation marks, or a symbol. MicroStrategy Command Manager introduces the ability to save scripts with encryption. Change the MDI preference of the user to. x returns only the English group name. ). Tokens can be: reserved words. Fire events. Proficiently handle MicroStrategy administration tasks, including project creation, user access management, command manager operations, and system manager duties. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. ; Go to Connection Type > Direct (2-tier), and click Next. Follow the instructions in Creating Subscriptions. x, it is possible to setup a system to automate creating, importing and undoing Packages for Object Manager entirely from command line. x: Use the "CREATE USER" outline to write a script to create a new user. In MicroStrategy Developer, create two users: User A: Danielle Address: New Address 1 User B: Dani Address: New Address 1 Create a contact group called TEST and add. ACTION: Use a user ID that has administrator privileges to run the. login_name is the login name of the subscription owner schedule_name is the name of the schedule. The script now runs successfully without. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. When possible, references to original articles are listed on each page. MicroStrategy Command Manager is an application designed to simplify and automate administration tasks, such as add, delete, or update enterprise-level data associated with large numbers of users and user groups. To achieve this, perform the following steps: Open. Country, Region, Call Centers, etc. If you create a batch file to execute a Command Manager script from the command line and you are using standard MicroStrategy authentication, the password for the Project Source or Narrowcast. Using MicroStrategy Enterprise Manager 9. Create Data Load and check EM_Configuration table. From the Select a Project drop-down list, select the project for which to assign the security role. Email and File Subscriptions cannot be created or edited using MicroStrategy Developer. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. Every Command Manager command is represented in this module. NET): Program FilesCommon FilesMicroStrategy directory. Follow these steps to achieve this customization:. For example, this might be provided by a customer ID attribute form of the. Select any project that is in the project source that contains the users and groups and click Next. A MicroStrategy user ID to be linked to the address. USERS IN GROUP "user_group_name" is the name of the group for which. Another method for providing a script to non administrative users for them to use, without giving them access to the adminstrative credentials, is to use encrypted scripts. 1. Prior to 2021 Update 7, you must have the Use Command Manager privilege instead. For specific information about how to manage Mobile subscriptions using Developer, see Managing Multiple Subscriptions at Once with Developer. Uses MicroStrategy REST APIs; Optional Containerization (Kubernetes) Secure MicroStrategy connections; Cube refresh instructions and parameters are provided by the calling process, i. In order to configure a project source and list projects to be monitored by MicroStrategy Enterprise Manager, the user must satisfy one of the following. Open the Workstation window with the Navigation pane in smart mode. Select only Configuration Objects for documentation. A Procedure window opens. x-10. The user will now be. 4. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. Create a folder Command name: “mkdir” - stands for “Make Directory. Right click on the System Administrator's. in MicroStrategy 2019, “The project can’t be loaded because it is not fully offline, please check whether there is any job running against it or any user session connecting to it. /mstrcmdmgr -interactive and press ENTER to open Command Manager. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. ACTION:Click Insert Visualization . ” How to use it: man <command name> man cd. ” How to use it: mkdir <new folder name> This will create a folder inside the current folder you are in (use pwd to check where you are) Delete a folder or a fileCreate a command script in Command Manager and save it as encrypted. Example. Once the above outline is executed in Command Manager, all addresses associated with all users under Everyone will be deleted. The following MicroStrategy Command Manager script will create a user that must change their password on their next logon: CREATE USER "login_name" PASSWORD "password" FULLNAME "User Full Name" DESCRIPTION "Developer" ALLOWCHANGEPWD TRUE PASSWORDEXPFREQ 30 DAYS CHANGEPWD TRUE;For instructions on creating these scripts with Command Manager, see Automating Administrative Tasks with Command Manager, or see the Command Manager Help. A metadata lock prevents other MicroStrategy users from modifying any objects in the project in Developer or MicroStrategy Web. The User Editor opens. x. 5. Settings for an individual recipient overwrite settings at the subscription level. Select the group in which to create a user. How does a Developer user access. To create to a direct project source. ). ; From the Choose a project drop-down list, select the project that you want to create a security filter for. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. List Attributes statement. x Number of Views 2. 0. 4. Alternatively, the user can split the logs between Results, Failed Instructions, and. To schedule a script to run at a certain time, use the Windows AT command with the cmdmgr executable. Knowledge Base: How to generate an audit report through the command line with the MicroStrategy License Manager 9. This document shows one user procedure which could do the same task as below: The sample outline of executing this procedure is as below: EXECUTE PROCEDURE List_AllAddresses_AllUsers_UserGroup("Everyone"); How to create MicroStrategy user accounts from an existing customer repository in MicroStrategy Administrator - Command Manager This document is a sample methodology on how to synchronize existing MS SQL Server logins to create new MicroStrategy user accounts in the MicroStrategy Metadata, via MicroStrategy Administrator - Command Manager. To create and apply a security filter for a user or group; In Developer, from the Administration menu, go to Projects > Security Filter Manager. LU_Users. x to create, import and undo packages? Number of Views 7. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager. Command Manager contains a large number of sample procedures that you can view and modify. PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string. Materials on this site are not original. 4. Example In addition to the graphical user interface and the command line execution, Command Manager has a text-based command line interface. However, Command Manager solely changes settings, and without Developer open, there is no trigger to have the "User must change password at next login" option grayed out automatically as it is when changed in the User Editor. The following table lists folders and files of interest that are included in the default directory structure after an installation of Object Manager. Open MicroStrategy Web and click Add external data. On the General tab, type the following information: Here are more examples of tasks you can perform using Command Manager: User management: Add, remove, or modify users or user groups; list user profiles. This procedure needs to be supplied with the project name for which the profile. From the Select a Project drop-down list, select the project for which to assign the security role. x can be used to create a list of users within a single project source for export to Microsoft Excel. csv - information about every user in the metadata. ; Select one: To create a new security filter, click New. For steps to complete various configurations tasks with the Configuration Wizard, see the sections listed below: Once you reach the Summary page for a configuration, click Save. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. ‒ Uses an English like scripting language to convert a manual process into an automated one ‒ Executes a script automatically at a scheduled time without any. The newly created doesn't have any metric dependent on it so it should be returned by a MicroStrategy Command Manager 9. x. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. A token is a word, a list of words enclosed in quotation marks, or a symbol. Check "Use File Logging. Select the user and press Delete. You are returned to the Summary page. Changing this to “Date” or any other user defined Category will make the form to be successfully deleted. You can also lock or unlock a project or a configuration manually using Developer. To invoke Command Manager from the database server, use one of the following commands: SQL Server: exec xp. A list of security roles in the project source opens in the main Developer pane. Select the group that contains the user to modify. This article explains how to use Command Manager Script to add recipient(s) from "Personal List" to existing Subscriptions. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. Open Command Manger and create a connected or connection-less session. Run the command 'LIST MEMBERS FOR USER GROUP "<user_group_name>"'. You can then call this procedure from another Command Manager script, supplying. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . Intelligence Server connects to the metadata by reading the server metadata connection registry when it starts. Triggering Events. To setup Platform Analytics through Command Manager, two commands need to be run to update the settings. 1 Support Liaisons MicroStrategy Technical Support can work more effectively with your organization by collaborating with a regular set of contacts, identified as “Support Liaisons. x, as shown below: All report caches, even caches associated with History List messages are deleted. Creating a Custom Group. 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. SYMPTOM: Users may create a Command Manager procedure which uses one of the following two scripts to get information about Intelligent Cube caches: LIST [ALL] INTELLIGENT CUBE CACHES. 2. 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. To use the Application level, go to 'Tools' > 'Options' > 'Results' tab as shown below. The Kernel XML trace (communication between IS and command manager) Kernel XML trace:When opening command manager outlines, look for the 'Alter_user' or 'Alter_users' outlines located under the 'User oulines' folder. From the Visualizations panel, select Grid . The Security. Creating, Importing, and Deleting Users and Groups. 0. 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. The following procedure describes how to create a prompted subscription based on text ID form in Tutorial project in MicroStrategy Command Manager 10. Information if the script that is falling come from the outline list or this is new created script. Open Object Manager, and connect to the desired project source in which a configuration package will be created to delete users. KB440526: How-to-create-a-User-Procedure-based-on-a-Sample-Procedure-in-MicroStrategy-Command-Manager . scp -o DisableUsers_output. NOTE: Users have to hardcode the password for the MicroStrategy user in the batch file. 3. 2) Create a subscription to update the caches of the dashboard via Command Manager using a syntax similar to:Once the user creates a workflow using System Manager, the user can use a command line version of the System Manager interface to deploy a workflow in MicroStrategy 9. 1 Hotfix 3. x with the same web session, purge all of the report caches using a MicroStrategy Administrator - Command Manager 8. x: In the Results tab, Right Mouse Click > Export Results > to Excel as shown in the image below:. In the Open drop-down list, type cmd and click OK. As MicroStrategy transitions to newer solutions and moves towards sunsetting Command Manager, this list is not maintained. NOTE: This script does not appear in the outlines list. The privileges are grouped by privilege type: Web Reporter privileges. bat with the following commands: if not exist c:cmdmgr rigger. Select On from the drop-down. ACTION:Open MicroSoft Notepad and save the following commands as file: cmdmgr -n LON-GOTTFRIED -u Administrator -p Ad3pwx4 -f c:winntDisableUsers. Start Monitoring. ". exe --ResponseFile="C: esponse. Command Manager allows administrators to: Add, remove, or modify users or user groups. x. Exact outline that is failing. x. 4. Exact outline that is failing. Click Enter. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command: CREATE USER (IMPORTWINUSER "nt_user_id" | "login_name") [FULLNAME "user_full_name"] [DESCRIPTION "user_description"] [LONGDESCRIPTION "long_description"] [NTLINK "nt_user_id" | NTSID "windows_user_ntsid"] [PASSWORD "user_password"] [LDAPLINK "LDAP_user_name"] [TRUSTEDLOGIN "trusted_authenticated_id"] [WHLINK "warehouse_login"] [WHPASSWORD. If you create a batch file to execute a Command Manager script from the. In Web, access the Intelligence Server Administration page. MicroStrategy Command Manager provides a set of Sample Procedures, which take advantage of java code flexibility, out of the box. Edit the schedule to be an event-based. CAUSE: When a user connects in Command Manager, they choose a 3-tier project source which they would like to. The Enterprise Manager project can be in the same metadata as your other projects. These statements place a lock on the metadata or configuration. These procedures are briefly described below. License Manager can be run on Windows or UNIX, in either GUI mode or command line mode. MEMBERS "login_name1. 2. 94K KB405775: When an image is referenced using relative paths in a dashboard, when the. Windows from the command line, then perform the following steps: From the Windows Start menu, select Run. Enter a name and description for the new security role. Click Yes to open the command prompt with administrator privileges. 1. • Creating Security filters for group of users in the dashboard view2) Create the second filter using MicroStrategy Command Manager 9. From MicroStrategy Web. it is evident that the user does not have Write permissions to this object. The following MicroStrategy Command Manager script will create a user that must change their password on their next logon: CREATE USER "login_name" PASSWORD "password" FULLNAME "User Full Name" DESCRIPTION "Developer" ALLOWCHANGEPWD TRUE PASSWORDEXPFREQ 30 DAYS CHANGEPWD TRUE; In MicroStrategy Web, create a grid report containing at least three columns. MicroStrategy Command Manager MicroStrategy Command Manager is a scripting tool that allows administrators to automate nearly all administrative and maintenance tasks. The default file extension for update packages is . x . CREATE USER GROUP " user_group_name" [DESCRIPTION " user_group_description"] [LONGDESCRIPTION ". Update Structure statement. MicroStrategy Enterprise Manager project 9. Retrieve the MicroStrategy installation files from the installation disk or the MicroStrategy download site. Command Manager will search for the table and update its column structure. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Open Object Manager, and connect to the desired project source in which a configuration package will be created to delete users. Enable or disable users. N" is the login name of a user to be added to the new group, of type string. Upgrade to that version to take advantage of this fix. The Security. Create, modify, and delete database instances, connections, and logins. 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. Enable user. To test, run the script. 4) In MicroStrategy Developer, connect to the MicroStrategy. However, if it uses Windows authentication, the user name passed to Command Manager is ignored and the Windows security credentials are used instead. x do not list out all the users on reports containing metrics for user activity. Open Workstation and connect to the environment with "Workstation_user". If you check the file, you may see the password for the administrator user. In the Command Manager editor, the user can use the key word "AND", "OR" to separate the conditions within the security filter expression command outline. The command prompt is displayed. . Create a new user, "Workstation_user", and assign the security role created previously. 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.