. Grant or revoke user privileges, create security filters, and disable user accounts. Lists all attributes from a given location path within a project. 1. 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. The impact is limited to MicroStrategy Command Manager 9. Create a new user, "Workstation_user", and assign the security role created previously. LDAPLINK "LDAP_user_name" is the new LDAP user to be linked to the user group, of type string. Command Manager returns an "Object with ID 'XXX' and type 34 (User) is not found in metadata. Create a subscription via Command Manager as shown below. This allows the script to be encrypted so it can be. x. To Create an Event Using Command Manager. To invoke Command Manager from the database server, use one of the following. Controlling Access to a Project. However, if it uses Windows authentication, the user name passed to Command Manager is ignored and the Windows security credentials are used instead. Using MicroStrategy Enterprise Manager 9. This customization is provided as a convenience to MicroStrategy users and is only directly applicable to the version stated. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. You can create events with the following Command Manager script: CREATE EVENT event_name [DESCRIPTION description]; By default, this script is in the folder C:Program Files MicroStrategyCommand ManagerOutlines. Full control. MicroStrategy Command Manager is a script-based tool for automating Intelligence Server administration. For example, to create profile folder for user with ID `bkelt` in MicroStrategy Tutorial project, type the following command: CREATE USER PROFILE FOR USER `bkelt` FOR PROJECT `MicroStrategy Tutorial`; Modify the Folder ACLs. ini". x. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. KB440526: How-to-create-a-User-Procedure-based-on-a-Sample-Procedure-in-MicroStrategy-Command-Manager . size (); i++) { //Get a subscription address from the list of already created addresses WebSubscriptionAddress addr = _addresses. scp -o DisableUsers_output. 4. 4. ‒ 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. Number of Views 884. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. x do not list out all the users on reports containing metrics for user activity. If you create a batch file to execute a Command Manager script from the. Click User Manager . MicroStrategy Mobile privileges. A list of the user groups that reside on the Intelligence Server appears. 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. x can be used to generate lists of all user groups and all users within a particular group, there is currently no way for it to retrieve a list of all groups and all of the users in each group. The value of '1' means that the user is enabled. 5. For more information about using Command Manager and for script syntax, see. In some situations this may be more efficient than navigating the Developer GUI, since you can quickly change the names of reports, users, or projects with. MicroStrategy Office privileges. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. com" DELIVERYTYPE EMAIL DEVICE "generic EMAIL" TO USER "test01"; 2. If the package made any changes to. ” How to use it: man <command name> man cd. Create a batch file by saving the script and creating a . Select any project that is in the project source that contains the users and groups and click Next. In the Open drop-down list, type cmd and click OK. A blank visualization appears in the dossier. Execute below commands in Command Manager: ADD ADDRESS "01 EMAIL" PHYSICALADDRESS "01@01. The Security Role Editor opens. If the Service Account Name is defined as System Account, the Windows user credentials are used to access the data source. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. Double-click the security role you want to assign to the user or group. ANSWER: Currently, there are two ways that a user may manually trigger an email subscription for other users: Find the schedule associated with the subscription in question. Create the user using two Command Manager scripts instead of one. A blank visualization appears in the dossier. x. 4. For configuration purposes either will work. Proficiently handle MicroStrategy administration tasks, including project creation, user access management, command manager operations, and system manager duties. Delete the inconsistent table objects if no other objects are depending on it. CREATE USER (IMPORTWINUSER "nt_user_id" | "login_name") [FULLNAME "user_full_name"] [DESCRIPTION "user_description"] [LONGDESCRIPTION. Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. The following list describes each of them。Managing Configurations for Project Sources Using Command Manager Runtime Statements. Log in a project source in Command Manager. You must copy and paste it in. MicroStrategy Command Manager lets you perform various administrative and application development tasks by using text commands that can be saved as scripts. List all properties for a specific subscription. del c:cmdmgr rigger. The prompt answer of the subscription cannot be changed by changing the default answer in the prompt object itself. 4. A Command Manager Procedure must be referenced in a script file (*. These are discussed below. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. x. NET): Program FilesCommon FilesMicroStrategy directory. e. 1) In MicroStrategy Tutorial project, create a new subscription and define its name as Test. man pwd. Click on the Insert button to. INTRODUCTION This knowledge base article provides best practices for configuring, monitoring and troubleshooting Enterprise Manager 10. 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. 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. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. This is a known issue classified as a defect with MicroStrategy Command Manager 9. To Execute a Script from the Command Manager Graphical Interface. These statements place a lock on the metadata or configuration. This does not include the case of a user retrieving a report from the History List (which does not create a job). x? Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. Select the Members tab. x, select 'Project Documentation' from the Tools menu to start the wizard. 4. Mouse over the Hadoop data source options and choose Impala. Run the command script. 0. Users belonging to this user groups are in the list, as showed. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). subscription_GUID is the ID of the subscription. For details on this process, refer to the following Microstrategy Knowledge Base document: KB6392: How to execute a command manager script through a command. You are returned to the Summary page. Hive. 2. " Specify and change the Log output. where: USER "login_name" is the login name of the user for whom properties are listed, of type string. License Manager can be run on Windows or UNIX, in either GUI mode or command line mode. x? Number of Views 9. Where <Path> is the directory where the setup. With this interface, you can create and execute Command Manager scripts in an environment where the graphical user interface is unavailable, such as when accessing a UNIX system via telnet. This statement can only be executed in a Windows. You can retrieve subscriptions by filtering for Object Type = Subscriptions/Schedule. 2. 21: Control Center. Third Party Software Installation: WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. If the procedure file is not created using the Procedure window, the file may be missing this information and may not execute correctly. x and receives the following error:. 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. Workaround. Scripts from Enterprise manager are working well when they are executing with GUI 'Command Manager'. In this example the command is run for the user in the above example (called NTSID):Add a user using the Security Role Editor in MicroStrategy Developer: Note that the user, ‘auser’ added through MicroStrategy Developer, is displayed in the propeties of the Project Configuration, as shown in the image below: CAUSE: This is a known issue with MicroStrategy Command Manager 9. • Enterprise Manager. Type. 7. Command Manager Runtime is a slimmed-down version of the Command Manager command-line executable for use. The script now runs successfully without. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. The value of '1' means that the user is enabled. For example: This sample alters some properties for all of the users in a given group. However, it is also a requirement that. ACTION:Open MicroSoft Notepad and save the following commands as file: cmdmgr -n LON-GOTTFRIED -u Administrator -p Ad3pwx4 -f c:winntDisableUsers. 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 datasets, and manage Users/User Groups, Servers, Projects, and more. To Start the Command Manager Graphical Interface. 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. You. In Linux: Browse to the MicroStrategy Home folder, then to the. x, create a new report with the following definition:. USERS IN GROUP "user_group_name" is the name of the group for which. ). after running the Create User script with multiple qualifications in MicroStrategy Command Manager. FULLNAME "user_full_name" is the full name of the new user, of type string. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. The following table lists folders and files of interest that are included in the default directory structure after an installation of Enterprise Manager. Execute a Microstrategy Command Manager script through a command line interface. MicroStrategy Command Manager 10. MEMBERS "login_name1. The command prompt is displayed. 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. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. If you check the file, you may see the password for the administrator user. In the Configuration Package window, click "Search for Configuration Objects". That XML file can then be used to create the package from the command. 1 in command line mode. 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. Use Command Manager to import users with a Windows link. 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 instructions on how to view or edit a sample procedure, see Inserting sample statements. The steps below show you how to create a custom group in MicroStrategy Web. Right-click each service and select Stop. x: Use the "CREATE USER" outline to write a script to create a. x. To list all enabled users is the everyone group, here is sample code: import java. You can then call this procedure from another Command. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Such profile folders for which users do not exist anymore can be identified and deleted using a sample Command Manager procedure/outline. The Schedule Wizard opens with that schedule's information. For example, the following will illustrate how to create a metric with a constant element inside the Applysimple statement:It allows administrators to manage MicroStrategy product licenses to maintain license compliance. Statements consist of one or more tokens. 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. Number of Views 1. 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. When this privilege is granted, the Create And Edit Users And Groups privilege is automatically granted as well. 2. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. 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. For more information about Command Manager, see the Automating. it is evident that the user does not have Write permissions to this object. 1. In Windows: From the Windows Start menu, go to All Programs > MicroStrategy Tools > Command Manager. MicroStrategy Command Manager can trigger. COM" IN PORT 9999; NOTE: This command to connect is optional, as it just pings the server to check if it is up and running. 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. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. the workflow manager or enterprise scheduling tool, as a json request message; Requests messages can be sent from the workflow manager or. address. exe --ResponseFile="C: esponse. A. x. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. Grant and revoke privileges to users. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. While making changes to a data load with ALTER DATA LOAD is supported, it is recommended that users make changes to the original CREATE DATA LOAD command. Command Manager manipulates MicroStrategy objects by means of user-created scripts rather than a graphical user interface. To manage your subscriptions, select from the tasks below: To create a subscription, right-click in the Subscription Manager and select Subscription Creation Wizard. project_name is the name of the project, of type string, between double quotes ("). Environment. create DSNs and database instances as necessary. Creating users within the MicroStrategy metadata and assigning proper application privileges and access control. Click Modify to open the Properties dialog box: Security tab. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. With CM you can manage users (create. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. ACTION. The user must first have a valid workflow. For example, you can. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. 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 setup Platform Analytics through Command Manager, two commands need to be run to update the settings. Open the MicroStrategy Configuration Wizard. This script is at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_OutlinesInvalidate_Report_Cache_Outline. user_or_group_name is the name of the recipient user or group. 1. These reports are located in the project under: Public Objects > Reports > Project Analysis > Object Usage Analysis > Command Manager Reporting. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. Something similar to command manager in Microstrategy Tool) Is there a way to give bulk users access to a group of users?( Something similar to command. The MicroStrategy Web JAR files can be found under: MicroStrategy Web Universal (JSP): {web_root}/WEB-INF/lib directory. By default, these scripts are at C:\Program Files (x86)\MicroStrategy\Command Manager\Outlines\Cache_Outlines. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. Depending on the status of the Intelligence Server Producer this may or may not. You can also create, edit, or delete multiple custom groups 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. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . For details on this process, refer to the following Microstrategy Knowledge Base document: KB6392: How to execute a command manager script through a command. If installing over previous versions of the product, the folder remains the. For example, the user may want to create a new package every week that contains all the new metrics from the development project. A list of security roles in the project source opens in the main Developer pane. 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. Command name: “man” - stands for “Manual. 4. First, the user needs to use MicroStrategy Object Manager to create an XML file specifying what objects are to be included in the update package. “occurs during unloading a project via Command Manager or Developer when there is user session or job execution. The outline is called as Delete_Unlinked_User_Profiles available under Procedure_Outlines -> Sample_Procedures section. KB13380: How to create a list of Project Configuration Settings using MicroStrategy Command Manager 10. x and 10. Expand Administration, then User Manager, and then browse to the group containing the user. Command Manager contains a large number of sample procedures that you can view and modify. The syntax is for MicroStrategy Command Manager version 8. x script or via the Project Configuration Editor in MicroStrategy Desktop 8. Thus, the user cannot create a new folder inside of the Public Objects folder. The default file extension for update packages is . Every MicroStrategy environment may have atleast one of the above two things running in their environment. Create, modify, and delete database instances, connections, and logins. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. The documentation for every method includes the 8. A token is a word, a list of words enclosed in quotation marks, or a symbol. Log in to Command Manager with an Administrator user, and create a new folder to be. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). 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. User management: Add, remove,. While outlines are available for the majority of options outlines for some options are not available. bat. Each statement ends with a semicolon (; ). Follow these steps to achieve this customization:. Additionally, Command Manager allows you to manage various configuration settings within the. 3. Creating a Custom Group. 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. Select On from the drop-down. Additionally, Command Manager allows you to manage various configuration settings within the. bat with the following commands: if not exist c:cmdmgr rigger. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. Creating, Importing, and Deleting Users and Groups. Restart MicroStrategy Administrator - Command Manager for this setting to take effect. To Create an Event Using Command Manager. cmdshell. 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. 0. First script creates the basic user. Click Yes to open the command prompt with administrator privileges. A token is a word, a list of words enclosed in quotation marks, or a symbol. You can create events with the following Command Manager script: CREATE EVENT event_name [DESCRIPTION description]; By default, this script is in the folder C:\Program Files\ MicroStrategy\Command Manager\Outlines\. NAME "new_login_name" is the new login name of the user, of type string. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a User. For the sample to work, the MicroStrategy Web JAR files must be accessible by the Java Runtime. How can we create a Command Manager procedure? In Command Manager, from the File menu, select New Procedure. Grant or revoke user privileges, create security filters, and disable user. Country, Region, Call Centers, etc. REPRODUCTION: Login to MSTR web and access a. For configuration purposes either will work. In the Configuration Package window, click "Search for Configuration Objects". x . 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-10. From the Select a Project drop-down list, select the project for which to assign the security role. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. To Execute a Script from the Command Manager Graphical Interface. ACTION: You can use pre-made outlines from Command Manager for the following steps. Disable the " Synchronize user/group information with LDAP during Windows authentication and import Windows link option during Batch Import " option in LDAP-Import-Options in the Intelligence Server Configuration. " 2. The syntax is for MicroStrategy Command Manager version 8. WORKAROUND: Users can run the update schema command a second time in MicroStrategy Command Manager. It is using mstrio Python library and Command Manager scripts. KB43715: How to create automated scripts for MicroStrategy Object Manager 9. " Cache management. 0, run the script below: Php. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager. Therefore, MicroStrategy recommends to add. Uses MicroStrategy REST APIs; Optional Containerization (Kubernetes) Secure MicroStrategy connections; Cube refresh instructions and parameters are provided by the calling process, i. 4. If user A belongs to group A and B at the same time but user B and C belong to only one of groups, a report filter as 'User Group = Group A, B' in a report in MicroStrategy Enterpriser Manager 9. Scripts for Enterprise Manager do not work when they are run from Command manager console (cmd). Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. LU_Users. x when running the ALTER PROJECT CONFIGURATION command and the EMPTYREPORTMESSAGE parameter contains HTML tags. Materials on this site are not original. If the value is '0', then the user is disabled. This procedure needs to be supplied with the project name for which the profile. x and 10. The following examples show a URL for accessing a MicroStrategy folder when the user does not have an existing session. This issue occurs in Command Manager procedures in MicroStrategy 10. 3. Begin creating a configuration package by navigating to ToolsCreate Configuration Package. 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. A. x and newer. By default, Command Manager scripts are saved in plain text format. 4. You can also configure these settings using Command Manager scripts located at C:\Program Files (x86)\MicroStrategy\Command Manager\Outlines\Cache_Outlines. 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. Follow the instructions in Creating Subscriptions. This article describes how to generate a list of which user/group has access to a project using Command Manager. {~+, 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). Uses MicroStrategy REST APIs; Optional Containerization (Kubernetes) Secure MicroStrategy connections; Cube refresh instructions and parameters are provided by the calling process, i. 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. Prior to 2021 Update 7, you must have the Use Command Manager privilege instead. See full list on This tutorial shows how to create a new user in Workstation and assign basic privileges to the user using the Application Access & Roles tab. The sample procedures are stored in the Command Manager directory, in \Outlines\Procedure_Outlines\User_Procedures\. ACTION: Use a user ID that has administrator privileges to run the. ; Select one: To create a new security filter, click New. 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. License Manager opens in GUI mode. Where <Path> is the directory where the setup. Users wish to execute scripts in MicroStrategy Command Manager 9. ACTION. Contact your MicroStrategy sales representative to determine the location and login credentials for the MicroStrategy download site. Additionally, Command Manager allows you to manage various configuration settings within the. . In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. x and 10. Create a Custom MicroStrategy Installation Package. Execute below command to alter the address: ALTER ADDRESS "011 PRINT" FOR USER "test01"; It. ADD GROUP "Customers" TO SUBSCRIPTION "Test" FOR PROJECT "MicroStrategy Tutorial". The folder and its contents remain on the system and ownership is assigned to Administrator. Open User Preferences > Project Defaults. Triggering Events. This statement can only be executed in a Windows. In this example, a report with an element prompt will be executed and create a history list message for the current user. 4. To create and apply a security filter for a user or group; In Developer, from the Administration menu, go to Projects > Security Filter Manager. For example, if you submit an instruction to create a MicroStrategy user group with two members,. Follow the steps below to create such user account: In MicroStrategy Developer, use the Administrator account to browse through Administration > User Manager > System.