You can also create scripts to be run at times when it. Such profile folders for which users do not exist anymore can be identified and deleted using a sample Command Manager procedure/outline. Hive. In order to kick off this Command Manager file, we then create a windows . In Web, access the Intelligence Server Administration page. By default, Command Manager scripts are saved in plain text format. x? Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. The default file extension for update packages is . A token is a word, a list of words enclosed in quotation marks, or a symbol. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. Type. Each statement ends with a semicolon (; ). To invoke Command Manager from the database server, use one of the following. MicroStrategy Command Manager 10. For the sample to work, the MicroStrategy Web JAR files must be accessible by the Java Runtime. Every Command Manager command is represented in this module. This script is at C:\Program Files (x86)\MicroStrategy\Command Manager\Outlines\Cache_Outlines\Invalidate_Report_Cache_Outline. In the Open drop-down list, type cmd and click OK. NTLINK "new_nt_user_id" is the new Windows user name ID to be linked to the user, of type string, with format DOMAINusername. Workaround. SOURCE_APP: The source application associated with the user connection, returned as an integer: 1: MicroStrategy Developer. 0 can do so by running the MicroStrategy. MicroStrategy Command Manager can trigger events from the Windows. If installing over previous versions of the product, the folder remains the. You can use MicroStrategy Command Manager to manage any number of subscriptions. For example, the user may want to create a new package every week that contains all the new metrics from the development project. Fire events. The Security Role Editor opens. 4. You must copy and paste it in. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. These procedures are briefly described below. 23: OfficeTo Create an Event Using Command Manager. 4. /mstrcmdmgr -interactive and press ENTER to open Command Manager. MicroStrategy Command Manager (CM) is a great tool providing many out-of-the-box scripts (outlines) that make many tasks extremely fast and easy to accomplish. 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. ). The Schedule Wizard opens with that schedule's information. Note: For more information on executing a workflow in. Right-click each service and select Stop. This particular workflow is a template that is delivered out-of-the-box with System Manager. link in the top right of the Data Sources pane. 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. Both of these outlines contain the commands for modifying either a groups password policy or a single user's password policy. Notice that the Change Journal entry created in Step 3 is not present. 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. This can be done by choosing the 'Save as Encrypted Script' option from the File menu, as shown: This password will be used for decrypting the script and will need to be entered when attempting to open the script within MicroStrategy Command Manager. In MicroStrategy Object Manager 9. Open Object Manager, and connect to the desired project source in which a configuration package will be created to delete users. Open Command Manger and create a connected or connection-less session. 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. x and 10. You can turn on the Sending Log to Telemetry Server feature using either MicroStrategy Web or Command Manager. At this point, the user may have a newer version of Test Report that they want to send out. To create and apply a security filter for a user or group; In Developer, from the Administration menu, go to Projects > Security Filter Manager. x-10. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. The reason this is useful is because the command line. 3. USER_GROUP: The name of the user group, returned as a string. 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. The full procedure file is attached in this tech note for references. Would you like to use this machine name anyway? CAUSE: The user ID that was used to launch Command Manager through the command line does not have administrator privileges on the machine. Input the parameters of Intelligence Server and add the command script created before. This script is at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_OutlinesInvalidate_Report_Cache_Outline. " Cache management. 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. User management: Add, remove, or modify users or user groups; list user profiles Security : Grant or revoke user privileges; create security filters and apply them to. This can go both ways, but this script concentrates on Library -> Web path. x, Command Manager returns a row of 1 for script “LIST ALL. Command Manager Runtime is a slimmed-down version of the Command Manager command-line executable for use. KB442598: User occasionally fails to copy objects from one project and paste to another project across different project s… Number of Views 267 KB438574: MicroStrategy Command Manager 10. e. Users wish to execute scripts in MicroStrategy Command Manager 9. where: subscription_name is the name of the subscription. If the procedure file is not created using the Procedure window, the file may be missing this information and may not execute correctly. This allows the new source to be created with the UseSSL setting enabled. Triggering Events. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. x-10. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . NOTE: Users have to hardcode the password for the MicroStrategy user in the batch file. Place the Command Manager procedure file in the specified procedure directory. x script or via the Project Configuration Editor in MicroStrategy Desktop 8. Description of the illustration b1. A list of security roles in the project source opens in the main Developer pane. Cloudera CDH Hadoop Gateway System. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. 94K KB405775: When an image is referenced using relative paths in a dashboard, when the. FOLDER "location_path" is the folder path where the security filter is to be placed in the project, of type string. In MicroStrategy Developer 9. The following statements are supported in Command Manager Runtime. Environment. 5. To Create an Event Using Command Manager. size (); i++) { //Get a subscription address from the list of already created addresses WebSubscriptionAddress addr = _addresses. First, make the following changes in MicroStrategy Developer: Log in to the project source. MicroStrategy Administrator - Object Manager is the component in the MicroStrategy Product Suite that allows system administrators to conduct project life-cycle management. The folder and its contents remain on the system and ownership is assigned to Administrator. Follow the steps below to create such user account: In MicroStrategy Developer, use the Administrator account to browse through Administration > User Manager > System. This allows the new source to be created with the UseSSL setting enabled. NET): Program FilesCommon FilesMicroStrategy directory. Once the above outline is executed in Command Manager, all addresses associated with all users under Everyone will be deleted. A MicroStrategy Intelligence Server was not found at this location. Additionally, Command Manager allows you to manage various configuration settings within the. 4. Creating a Custom Group. x can be used to create a list of users within a single project source for export to Microsoft Excel. To add new users or groups to the object's access control list (ACL): Click Choose Users/Groups. This tutorial shows how to create a new user in Workstation and assign basic privileges to the user using the Application Access & Roles tab. x. As MicroStrategy transitions to newer solutions and moves towards sunsetting Command Manager, this list is not maintained. after running the Create User script with multiple qualifications in MicroStrategy Command Manager. Command Manager allows administrators to: Add, remove, or modify users or user groups. If the value is '0', then the user is disabled. For example, when users run this script in Command manager, CREATE SECURITY FILTER "SecFilter3" DESCRIPTION "region@id=1" IN PROJECT "MicroStrategy Tutorial" EXPRESSION "Region@ID=?Contributors"; will receive the following error: CAUSE: This is a known limitation in MicroStrategy Command Manager 9. x do not list out all the users on reports containing metrics for user activity. Edit the schedule to be an event-based. Open Object Manager, and connect to the desired project source in which a configuration package will be created to delete users. Make sure that the Form Category is set to “None”. In MicroStrategy 2019, the primary form of consumption of Cards will be through a Google Chrome extension. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. To Execute a Script from the Command Manager Graphical Interface. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Start Monitoring. Enable user. Published: Oct 12, 2021. Create a batch file by saving the script and creating a . The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Enterprise Manager and to address issues encountered during the statistics. 3. Trigger events. All up to date privilege tokens are accessible in Command Manager, see Inserting Sample Statements: Outlines for more information. The syntax is for. Begin creating a configuration package by navigating to ToolsCreate Configuration Package. x and 10. 3. 2. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). 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. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Even if that report is cached, it does not increase its hit count. After running the command in Command Manager, edit the subscription and the delivery format for that subscription is now set to. MicroStrategy Command Manager provides a set of Sample Procedures, which take advantage of java code flexibility, out of the box. 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. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. From MicroStrategy Web. 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. A. Select each folder, right-click and choose 'Properties', and in the Security tab delete all the permissions and add the user that owns that folder and assign Full Control in the Object and Children levels. {~+, Region+;-} To exclude filter attributes not on the report or in the metric level from calculation in the metric, put ;/ at the end of the level statement (inside the braces). The second script, using the Alter User. 'In MicroStrategy 9. For details on this process, refer to the following Microstrategy Knowledge Base document: KB6392: How to execute a command manager script through a command. In the Server drop-down list, select the name of the machine on which the service is installed. List Attributes statement. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. To create the Enterprise Manager project, run Configuration Wizard on the MicroStrategy Intelligence Server machine that uses the Metadata where the project should be created, and select the Create Enterprise Manager project option. List all properties for a specific subscription. You are returned to the Summary page. You can use the User Manager GUI tool to create users, or you can create users programmatically with Command Manager or. 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. New parameter "ASYNCHRONOUS" to publish Intelligence cube via command manager in. The User Activity dossier included with Platform Analytics helps administrators analyze and assess user activity across the MicroStrategy platform. Click No. x. Create a Security Role. Web Professional privileges. NTSID "new_user_ntsid" is the new NTSID to be linked. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. For using Enterprise Manager through Command Manager, users don’t have to run this. Restart MicroStrategy Administrator - Command Manager for this setting to take effect. For example, this might be provided by a customer email attribute form of the Customer attribute. User creates a new application object using MicroStrategy Command Manager 9. The user is trying to use variable INTELLIGENCE_CUBES_RESULT_SET in Command Manager procedure to get intelligent cubes directory of all projects but it is unable to pass the code check. TRUSTED_LOGIN: Whether the user is a trusted login, returned as a string. It also stores other types of objects that allow you to access that information. Users should click the "Next" button to continue. For instructions on how to view or edit a sample procedure, see Inserting sample. x behavior), put ;-at the end of the level statement (inside the braces). x and 10. • Enterprise Manager. From the Visualizations panel, select Grid . The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. For more information about using Command Manager and for script syntax, see. MicroStrategy Command Manager can trigger. The subscription is triggered. x with the same web session, purge all of the report caches using a MicroStrategy Administrator - Command Manager 8. Click Options. In Windows: From the Windows Start menu, go to All Programs > MicroStrategy Tools > Command Manager. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. To create to a direct project source. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. 4. This involves use of the command line projectmerge utility and xml configuration files. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. Enable or disable users. x: Use the "CREATE USER" outline to write a script to create a. contact_name is the name of the recipient contact. 94K KB405775: When an image is referenced using relative paths in a dashboard, when the. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. The following administrative tasks can be automated using Command Manager in MicroStrategy 9. 4. A blank visualization appears in the dossier. Click Yes to open the command prompt with administrator privileges. 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. Click Create a new Security Role next to Security Roles. Should an out-of-compliance notification with respect to named users be generated, run MicroStrategy License Manager to identify the users that resulted in exceeding licensed capacity and. For example, a report with the "User" attribute and "RP Number of Jobs" metric will only list users whose number of jobs is greater than 0. They only list users with some activity while omitting users with zero activity. csv - information about every user in the metadata. Where <Path> is the directory where the setup. The MicroStrategy Web JAR files can be found under: MicroStrategy Web Universal (JSP): {web_root}/WEB-INF/lib directory. The value of '1' means that the user is enabled. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. 1. MicroStrategy Command Manager. Developers of OEM applications that use embedded MicroStrategy projects may need flexibility in configuring their environment. Run the “Trigger all subscriptions for delivery type” command in Command Manager. x, History List messages return the message 'Cached report result not found in server report cache. This is a known issue classified as a defect with MicroStrategy Command Manager 9. x. Create a security role with cache monitoring privilege only; Create a user group with use Command Manager, Desktop Analyst and Desktop Designer privileges; Create a user as a member of the group created in step 2; Apply the security role to the group created in step 2 with MicroStrategy Tutorial project; Login to Desktop with the. Select Project Sources and click Next. List of statements supported in Command Manager Runtime. List all properties for a specific subscription. It is possible to create users individually using the User Manager interface in Developer, or using Command Manager (for a detailed explanation of how to use Command Manager, including examples, see Automating Administrative Tasks with Command Manager). Each statement ends with a semicolon (; ). Specifying "Shared Reports Folder" is one of the missing outlines in the Command Manager. The script now runs successfully without. • Creating Security filters for group of users in the dashboard view2) Create the second filter using MicroStrategy Command Manager 9. Right click and select New and then Schedule. Run the command 'LIST MEMBERS FOR USER GROUP "<user_group_name>"'. For configuration purposes either will work. The command "ALTER USER 'XXX' DISABLED IN GROUP 'YYY';" is actually executing the below two tasks: ALTER USER 'XXX' DISABLED; - This is to disable user account 'XXX'It is possible to get the list of all disabled users MicroStrategy 10. 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:. ini". For general information about Command Manager, see Automating Administrative Tasks with Command Manager. The Command Manager script engine uses a unique syntax that is similar to SQL and other such scripting languages. 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; The administration of Users, User Groups and Security Role objects may be made in an easy way through a Command Manager outline feature that allows the automatic management of privileges in MicroStrategy 9. Further, it is not possible to access the email subscriptions of other users through the MicroStrategy Web interface. Full control. MicroStrategy Command Manager is a script-based tool for automating Intelligence Server administration. WORKAROUND: Users can run the update schema command a second time in MicroStrategy Command Manager. Prior to 2021 Update 7, you must have the Use Command Manager privilege instead. For example: This sample alters some properties for all of the users in a given group. x, it is possible to setup a system to automate creating, importing and undoing Packages for Object Manager entirely from command line. 4. scp -o c:cmdmgroutput. That XML file can then be used to create the package from the. The impact is limited to MicroStrategy Command Manager 9. To Execute a Script from the Command Manager Graphical Interface. Information if the script that is falling come from the outline list or this is new created script. This allows the script to be encrypted so it can be. x to generate a list of a user group with corresponding users . When creating many users, it is necessary to use MicroStrategy Command Manager to increase the speed of creating users. 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. 4. 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. x, no or incomplete results are returned. The user will now be. For example, this might be provided by a customer ID attribute form of the. ; OR. 4. Open System Manager, and then add Command Manager->Intelligence Server into workflow window. When possible, references to original articles are listed on each page. x do not list out all the users on reports containing metrics for user activity. Mouse over the Hadoop data source options and choose Impala. Specify a name and location to save the response file, and click Save. bat file. To locate these settings, right-click the project and select Project Configuration. x: Use the "CREATE USER" outline to write a script to create a new user. The sample procedures are stored in the Command Manager directory, in \Outlines\Procedure_Outlines\User_Procedures\. x, the user can choose to create an update package from the command line by specifying values in an XML file. If the value is '0', then the user is disabled. 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. x, select 'Project Documentation' from the Tools menu to start the wizard. Users can leverage the existing ACL. 4. How to move Users and User Groups across. Statements consist of one or more tokens. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. These statements place a lock on the metadata or configuration. . subscription_GUID is the ID of the subscription. These reports are. 2. Command Manager manipulates MicroStrategy objects by means of user-created scripts rather than a graphical user interface. x, all subscriptions outlines are specified in Subscription_Outline folder, as shown below: There are two workarounds to create an email subscription to multiple users: A: Add users/contact group to an existing email subscription. How can we create a Command Manager procedure? In Command Manager, from the File menu, select New Procedure. ; From the Choose a project drop-down list, select the project that you want to create a security filter for. the workflow manager or enterprise scheduling tool, as a json request message; Requests messages can be sent from the workflow manager or. A token is recognized by Command Manager as an individual unit with a specific meaning. When a user executes the below mentioned outline in MicroStrategy Command Manager 9. Specify a name and location to save the response file, and click Save. contact_name is the name of the recipient contact. 0. 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. ; Select the Security Filters tab. Open the MicroStrategy Configuration Wizard. REPRODUCTION: Login to MSTR web and access a. To locate these settings, right-click the project and select Project Configuration. In the Service drop-down list, select the service. With the minimum privileges the edit user window looks like the following: However, without additional privileges the user will not be able to modify many user and user group properties. If installing over previous versions of the product, the folder remains the same. 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. If you are using UNIX, you must use Command Manager to manage your system's security roles. 1 - 10. The following procedure describes how to use MicroStrategy Command Manager 9. For example, a report with the "User" attribute and "RP Number of Jobs" metric will only list users whose number of jobs is greater than 0. The URL contains not only the. project_name is the name of the project, of type string, between double quotes ("). MicroStrategy Command Manager. Grant/Revoke privilege. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. For details on this process, refer to the following Microstrategy Knowledge Base document: KB6392: How to execute a command manager script through a command. 4. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. CREATE USER (IMPORTWINUSER "nt_user_id" | "login_name") [FULLNAME "user_full_name"] [DESCRIPTION "user_description"] [LONGDESCRIPTION. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. Go to Administration > User Group > Everyone. user_or_group_name is the name of the recipient user or group. NAME "new_login_name" is the new login name of the user, of type string. Locate Sending Log to Telemetry Server in the Features for Customer Feedback section. For example, administrators may configure fences for users who require more processing power or high availability. Run the script LIST ALL CHANGE JOURNALINGS. The user then creates a subscription to "Test Report" in MicroStrategy Command Manager that specifies the folder name and location of the report. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. project_name is the name of the. Triggering Events. Click on the "Log" tab. ; From the Choose a project drop-down list, select the project that you want to create a security filter for. A list of the user groups that reside on the Intelligence Server appears. It is used to apply database (row-level) security to a MicroStrategy user. Use this module to create or execute MicroStrategy Command Manager scripts. For more information on the commands available see the Syntax Examples section of the Command Manager Help documentation. MicroStrategy Command Manager MicroStrategy Command Manager is a scripting tool that allows administrators to automate nearly all administrative and maintenance tasks. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. Related articles from the Community: Knowledge Base: How to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. The user is listed on the Service Startup tab, in the Login field. 4. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting. A user object in MicroStrategy can store one database login name for authentication, and one login/password for linked warehouse execution. Right click on the System Administrator's. Windows GUI: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then select License Manager. x, if the user alters data load by, for example, adding new projects to be monitored, or modifying data load name, the data load is disabled. Command Manager returns an "Object with ID 'XXX' and type 34 (User) is not found in metadata. For configuration purposes either will work. The full procedure file is attached in this tech note for references. KB13380: How to create a list of Project Configuration Settings using MicroStrategy Command Manager 10. For example, you can. Just make sure the ssl_verify parameter is set to True when creating the Connection object in mstrio-py (it is True by default): conn = Connection(base_url, mstr_username, mstr_password, project_id=project_id, ssl_verify=True) The second way is to pass the certificate_path parameter to your connection object in mstrio. If the value is '0', then the user is disabled. Users belonging to this user groups are in the list, as showed. Changing this to “Date” or any other user defined Category will make the form to be successfully deleted. 1. 6.