For more information on the commands available see the Syntax Examples section of the Command Manager Help documentation. where: subscription_name is the name of the subscription. Command Manager manipulates MicroStrategy objects by means of user-created scripts rather than a graphical user interface. 4. 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. x . This section lists the basic commands you need to execute in Command Manager to begin capturing, analyzing, and reporting on data about your system with Enterprise Manager. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Execute a Microstrategy Command Manager script through a command line interface. subscription_GUID is the ID of the subscription. In MicroStrategy Developer 9. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Click Options. This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. Set Freeform SQL and MDX objects default security. This message will also be displayed if a user connects using MicroStrategy Administrator - Command Manager or MicroStrategy License Manager. • Using MicroStrategy command manager to carry out administrative task like maintaining user cleaning of unused objects. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). 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. x. To create to a direct project source. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. To schedule a script to run at a certain time, use the Windows AT command with the cmdmgr executable. smw format. From the Visualizations panel, select Grid . 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. They only list users with some activity while omitting users with zero activity. In order to kick off this Command Manager file, we then create a windows . Statements consist of one or more tokens. is the name of the schedule. Use the "CREATE USER" outline to write a script to create a new user. To Execute a Script from the Command Manager Graphical Interface. KB45980: How to get the list of users belonging to user groups in MicroStrategy Command Manager 9. LIST ALL SUBSCRIPTIONS FOR CONTENT GUID <report_or_document_guid> FOR PROJECT "<project_name>"; CAUSE: This is a known limitation MicroStrategy Command. The syntax is for MicroStrategy Command Manager version 8. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The following administrative tasks can be automated using Command Manager in MicroStrategy 9. " after running the Create User script with multiple qualifications in MicroStrategy Command Manager. x will not exclusively show the result with user A only but the result will show all users who belong to one of groups, as illustrated below. Developers of OEM applications that use embedded MicroStrategy projects may need flexibility in configuring their environment. CAUSE: When a user connects in Command Manager, they choose a 3-tier project source which they would like to. A token is recognized by Command Manager as an individual unit with a specific meaning. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. x, no or incomplete results are returned. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. x. x to generate a list of a user group with corresponding users . This location will vary depending on where MicroStrategy is installed and can be found in the MSIReg. The prompt answer of the subscription cannot be changed by changing the default answer in the prompt object itself. User creates a new application object using MicroStrategy Command Manager 9. Click Create a new Security Role next to Security Roles. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting. Enter a name and description for the new security role. In the left pane, click Privileges. x-10. Click Create Role . To Start the Command Manager Graphical Interface. GROUP "parent_user_group_name" is the name of a user group of which the new group is a member, of type string. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. com" DELIVERYTYPE EMAIL DEVICE "generic EMAIL" TO USER "test01"; 2. x. For configuration purposes either will work. 4. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a User. User should be careful with using this procedure. Command name: “man” - stands for “Manual. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. 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. 2. bat. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. License Manager can be run as a graphical user interface (GUI) or as a command line tool, in either Windows or UNIX/Linux environments. 4. All the logical tables using this warehouse table will also get their definitions updated. However, this connection is only one segment of the connectivity picture. 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. Edit the schedule to be an event-based. Create a new attribute form for any existing attribute. If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. To Start the Command Manager Graphical Interface. 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. From the Windows Start menu, point to All Programs, then MicroStrategy Tools, then select Service Manager. 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. Grant or revoke user privileges, create security filters, and disable user accounts. x-10. Click Yes to open the command prompt with administrator privileges. Use the "CREATE USER" outline to write a script to create a new user. 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. 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 gives the steps to create. A Procedure window opens. Pour les spécifications complètes de. x and 10. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. " Cache management. {~+, 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). Checking Who Is Logged-in To A Remote Computer or Server. 1. x, all subscriptions outlines are specified in Subscription_Outline folderExpand Administration, then expand Configuration Managers, and then select Subscriptions. Output XML file is not constant when running script to list all users/groups in MicroStrategy Command Manager 9. Fire events. This article explains how to use Command Manager Script to add recipient(s) from "Personal List" to existing Subscriptions. ". Administrators no longer need to install Narrowcast Server on the machine where Command Manager. USER_GROUP: The name of the user group, returned as a string. For configuration purposes either will work. First script creates the basic user. MicroStrategy Command Manager. How to create MicroStrategy user accounts from an existing customer repository in MicroStrategy Administrator - Command Manager. ACTION Contact Microstrategy Technical. x. In the Open drop-down list, type cmd and click OK. You can also configure these settings using Command Manager scripts located at C:Program Files (x86)MicroStrategyCommand ManagerOutlinesCache_Outlines. Environment. KB440526: How-to-create-a-User-Procedure-based-on-a-Sample-Procedure-in-MicroStrategy-Command-Manager . The default file extension for update packages is . MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. 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. Assign users to this group who need to view reports. Hover over the Properties column and click Open Intelligence Server Administration Portal . Liaison but would like to reference available resources, he/she may create a MicroStrategy Community account to access the site. Make sure that the Form Category is set to “None”. MicroStrategy Developer et MicroStrategy Command Manager peuvent être installés sur le même ordinateur ou des ordinateurs différents. 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. If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. Run the command 'LIST MEMBERS FOR USER GROUP "<user_group_name>"'. Command Manager returns an "Object with ID 'XXX' and type 34 (User) is not found in metadata. These procedures are briefly described below. This changes the way the results are displayed by default in MicroStrategy Administrator - Command Manager. Windows GUI: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then select License Manager. Notice that the Change Journal entry created in Step 3 is not present. 4. Command Manager Runtime is a slimmed-down version of the Command Manager command-line executable for use. In Command Manager, I then save this code into a . Where <Path> is the directory where the setup. To Deny User. MicroStrategy Command Manager provides a set of Sample Procedures, which take advantage of java code flexibility, out of the box. Select any project that is in the project source that contains the users and groups and click Next. Server - Intelligence" to the user. Security: Grant or revoke user privileges; create security filters and apply them to users or groups; change security roles and user profiles; assign or revoke ACL permissions; disconnect users. x. 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. Description of the illustration b1. Start, stop, or restart the Intelligence Server, configure clusters, and disconnect active sessions. Command Manager Runtime is a slimmed-down version of the Command Manager command-line executable for use. Start Monitoring. 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. This statement can only be executed in a Windows. Begin creating a configuration package by navigating to ToolsCreate Configuration Package. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. /mstrcmdmgr -interactive and press ENTER to open Command Manager. With CM you can manage users (create. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. A token is a word, a list of words enclosed in quotation marks, or a symbol. 0. The following steps explain how to change the result display type to Grid from default List type in MicroStrategy Command Manager 9. Double-click the security role you want to assign to the user or group. Configure Through Command Manager. Create a Security Role. Tokens can be: reserved words. Create the statistics and Enterprise Manager repository in a database that is. 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. Click Add. The user has the option to send all logs to one single file. Example. x and receives the following error:. Each statement ends with a semicolon (; ). KB36573: Privileges needed to use the User Manager in MicroStrategy Web 9. x: In the Results tab, Right Mouse Click > Export Results > to Excel as shown in the image below:. MicroStrategy Command Manager is a script-based tool for automating Intelligence Server administration. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. One of the things which one can try is to see any command manager script or system manager workflow. 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. 1. ACTION Contact Microstrategy Technical. If installing over previous versions of the product, the folder remains the same. x-10. exe --ResponseFile="C: esponse. ACTION. 2. CREATE HISTORYLISTSUBSCRIPTION "hl_sub_prompt_2" SCHEDULE "Monday Morning" USER "administrator" CONTENT "Store Sales" IN FOLDER "Public ObjectsReportsSubject AreasDaily Analysis" IN PROJECT "MicroStrategy Tutorial" PROMPT "Predefined. 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\. Click on the Insert button to. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . If installing over previous versions of the product, the folder remains the. x. To Create an Event Using Command Manager. Create a batch file by saving the script and creating a . The Subscription Manager allows you to manage all the subscriptions for a project from one interface. If the package made any changes to. Exact outline that is failing. The documentation for every method includes the 8. This optimizes performance and enables administrators to select specific user requests or subscriptions to process first based on priority level. REPRODUCTION: Login to MSTR web and access a. 1 HF3 Command Manager syntax for the command. Right-click each service and select Stop. The Python script below was written for that purpose. Further, it is not possible to access the email subscriptions of other users through the MicroStrategy Web interface. Using MicroStrategy Enterprise 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. 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. Expand Administration, then User Manager, and then browse to the group containing the user. Creating a Custom Group. user_or_group_name is the name of the recipient user or group. 1) Create a dashboard in MicroStrategy. 4. From the Select a Project drop-down list, select the project for which to assign the security role. x-10. To test, run the script. There are 8 new features added in MicroStrategy Command Manager 9. x-10. x. When creating security fiters via Command Manager, users may wish to include multiple filtering conditions (i. 4. Managing Configurations for Project Sources Using Command Manager Runtime Statements. In a text editor (such as Notepad), enter the command line statement that the task scheduler should execute. Create a user as shown below: CREATE USER "jaime" PASSWORD "user" FULLNAME "jaime User" IN GROUP "Web Users"; Create a DbLogin for the user created in Step 2, as shown below: CREATE DBLOGIN "dblogin_ jaime" LOGIN "sa" PASSWORD "sa"; Create the. 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. cmdmgr. The Schedule Wizard opens with that schedule's information. ; From the Choose a project drop-down list, select the project that you want to create a security filter for. This can create a security risk if your script contains a user name and password, such as for the CONNECT SERVER statement. The privileges are grouped by privilege type: Web Reporter privileges. Thus, the user cannot create a new folder inside of the Public Objects folder. The value of '1' means that the user is enabled. x, select 'Project Documentation' from the Tools menu to start the wizard. Additionally, Command Manager allows you to manage various configuration settings within the. 1 provides new reports that can provide MicroStrategy Command Manager scripts to delete unused objects in the project. It delivers a streamlined data model, simpler schema and real-time monitoring. Data Load is enabled: </ScheduleType><Enabled>1</Enabled></EMSchedule>. Command Manager allows administrators to: Add, remove, or modify users or user groups. These statements place a lock on the metadata or configuration. KB440526: How-to-create-a-User-Procedure-based-on-a-Sample-Procedure-in-MicroStrategy-Command-Manager . Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. If the value is '0', then the user is disabled. 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. Grant or revoke user privileges, create security filters, and disable user accounts. 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). Exact outline that is failing. Command Manager allows administrators to: Add, remove, or modify users or user groups. It provides information on sessions, which user has the highest number of errors, and the number of inactive users. Click Enter. In Windows: From the Windows Start menu, go to All Programs > MicroStrategy Tools > Command Manager. 1. Execute a Microstrategy Command Manager script through a command line interface. csv - information about every user group in the metadata. 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. Security: Grant or revoke user privileges; create security filters and apply them to users or groups; change security roles and user profiles; assign or revoke ACL permissions; disconnect users. project_name is the name of the project, of type string, between double quotes ("). Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. 2. Email and File Subscriptions cannot be created or edited using MicroStrategy Developer. ”How to Update the Database User Password. Workaround. This can go both ways, but this script concentrates on Library -> Web path. Specify a name and location to save the response file, and click Save. 4. 4. ADD GROUP "Customers" TO SUBSCRIPTION "Test" FOR PROJECT "MicroStrategy Tutorial". For the sample to work, the MicroStrategy Web JAR files must be accessible by the Java Runtime. That XML file can then be used to create the package from the. It is used to apply database (row-level) security to a MicroStrategy user. INTRODUCTION This knowledge base article provides best practices for configuring, monitoring and troubleshooting Enterprise Manager 10. Users belonging to this user groups are in the list, as showed. x: Use the "CREATE USER" outline to write a script to create a. To add new users or groups to the object's access control list (ACL): Click Choose Users/Groups. 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. These are discussed below. exe file is stored. Adding support for TLS is done by selecting the Use SSL checkbox. 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. Double-click the Administrator user. Grant and revoke privileges to users. 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. You can use MicroStrategy Command Manager to manage any number of subscriptions. List of statements supported in Command Manager Runtime. 23: OfficeTo Create an Event Using Command Manager. To create an event using Command Manager. 3. Run the command 'LIST MEMBERS FOR USER GROUP "<user_group_name>"'. MicroStrategy Command Manager provides a set of Sample Procedures, which take advantage of java code flexibility, out of the box. Further, it is not possible to access the email subscriptions of other users through the MicroStrategy Web interface. Open Workstation and connect to the environment with "Workstation_user". The User Editor opens. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Locate Sending Log to Telemetry Server in the Features for Customer Feedback section. Knowledge Base: How to generate an audit report through the command line with the MicroStrategy License Manager 9. In Command Manager, the list of enabled users in the metadata is returned by the following command: LIST LOGIN, ENABLED FOR USERS IN GROUP "Everyone"; This can also be done using MicroStrategy Web SDK 10. To list all enabled users is the everyone group, here is sample code: import java. Users might also observe that a particular user who is in the export of the command " LIST MEMBERS FOR USER GROUP "Everyone";" might not be in the " LIST MEMBERS FOR USER GROUP "LDAP Users"; CAUSE This is a known defect in MicroStrategy Command Manager 10. The value of '1' means that the user is enabled. For specific information about how to manage Mobile subscriptions using Developer, see Managing Multiple Subscriptions at Once with Developer. Update a table with its new structure obtained from the warehouse. 2. Click Modify to open the Properties dialog box: Security tab. ; Go to Connection Type > Direct (2-tier), and click Next. Command Manager allows administrators to: Add, remove, or modify users or user groups. Statements consist of one or more tokens. ACTION: This issue has been fixed in MicroStrategy 10. 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. How to generate a list of users whose account status is 'Enabled' or 'Disabled' using MicroStrategy Command Manager? Using MicroStrategy Administrator -. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results. The following table lists folders and files of interest that are included in the default directory structure after an installation of Enterprise Manager. For more information about Command Manager, see the Automating Administrative Tasks chapter. The second script, using the Alter User. 4. Update Structure statement. Run the “Trigger all subscriptions for delivery type” command in 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. 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. 4. contact_name is the name of the recipient contact. NOTE: This script does not appear in the outlines list. The WHLINK option sets the login name for both database authentication and. Type the following command in the Windows command line: <Path> setup. To Execute a Script from the Command Manager Graphical Interface. 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 following procedure describes how to use MicroStrategy Command Manager 9. A Command Manager script consists of one or more script statements. In Command Manager, procedures are reusable scripts that can be executed from other scripts. To locate these settings, right-click the project and select Project Configuration. 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. In MicroStrategy 10. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. To invoke Command Manager from the database server, use one of the following. TEST. This article describes how to generate a list of which user/group has access to a project using Command Manager. Statements consist of one or more tokens. 0. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded. 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. x and 10. 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. This issue occurs in Command Manager procedures in MicroStrategy 10. Python within Workstation. From the Visualizations panel, select Grid . " 2. However, this is not the case. The device IDs can be obtained by executing the code shown below. Proficiently handle MicroStrategy administration tasks, including project creation, user access management, command manager operations, and system manager duties. This document is a sample. You can then call this procedure from another Command. Go to Administration > User Group > Everyone. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. By default, Command Manager scripts are saved in plain text format. The Save dialog box opens. 1. Type. MicroStrategy Command Manager MicroStrategy Command Manager is a scripting tool that allows administrators to automate nearly all administrative and maintenance tasks. Platform Analytics. x, the user can choose to create an update package from the command line by specifying values in an XML file. A. 4. This does not include the case of a user retrieving a report from the History List (which does not create a job).