These procedures are briefly described below. List all properties for a specific subscription. In this example, the script was created as follow: CREATE FILTER "Nested Filter" IN FOLDER "Public ObjectsFilters" EXPRESSION "" ON PROJECT "microstrategy tutorial"; 3) Execute the script. 5. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. x and 10. 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. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. 2. 1. " Cache management. List of statements supported in Command Manager Runtime. A solution/code fix for this. Open Command Manger and create a connected or connection-less session. Enter a name such as appdev for the role. Run the “Trigger all subscriptions for delivery type” command in Command Manager. This issue has been classified as a defect by MicroStrategy. 31K KB45030: How to list project sources when using Command Manager's Interactive Mode in MicroStrategy Command Manager 9. You can use the User Manager GUI tool to create users, or you can create users programmatically with Command Manager or. x: Use the "CREATE USER" outline to write a script to create a new user. NAME "new_login_name" is the new login name of the user, of type string. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager. 4. The outline is called as Delete_Unlinked_User_Profiles available under Procedure_Outlines -> Sample_Procedures section. This procedure needs to be supplied with the project name for which the profile. Using MicroStrategy Command Manager, run the following scripts for each user:Using the Intelligence Server SDK provided in MicroStrategy 10. A MicroStrategy user ID to be linked to the address. If you have a large number of objects to create or edit, you can also use MicroStrategy Command Manager to work with these objects. The -object type- editor. This article explains how to use Command Manager Script to add recipient(s) from "Personal List" to existing Subscriptions. A metadata lock prevents other MicroStrategy users from modifying any objects in the project in Developer or MicroStrategy Web. x-10. reg file under the setting. Customers wishing to use Platform Analytics in 11. PROD -f c:cmdmgrjob. A list of security roles in the project source opens in the main Developer pane. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. LIST [ALL] PROPERTIES FOR SUBSCRIPTIONuser_or_group_namereport_or_document_name. ACTION:In MicroStrategy Command Manager, when tried to disable the "administrator" user using the " ALTER USER "Administrator" DISABLED;" command fails to execute with this message " You are not allowed to change this protected property on the Administrator user" as shown in the screenshot. Type. Using MicroStrategy Enterprise Manager 9. these scripts are at C:Program Files (x86)MicroStrategyCommand. x-10. Grant the "Use Workstation" privilege under "18. MicroStrategy Command Manager lets you perform various administrative and application development tasks by using text commands that can be saved as scripts. You can then call this procedure from another Command. 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). You can also lock or unlock a project or a configuration manually using Developer. A token is recognized by Command Manager as an individual unit with a specific meaning. From the Tools menu, select Import Package: Browse to the saved update package and select it. Command Manager will search for the table and update its column structure. ). FULLNAME "user_full_name" is the full name of the new user, of type string. In MicroStrategy Command Manager 10. Create a new user and add the user to multiple user groups in MicroStrategy Command Manager May 11, 2020 The following steps show how to. 0. Select the users or groups that you want to add to the object's ACL. Command Manager allows administrators to: Add, remove, or modify users or user groups. Settings for an individual recipient overwrite settings at the subscription level. Go to the Languages tab. Each statement ends with a semicolon (; ). Use this module to create or execute MicroStrategy Command Manager scripts. The Save dialog box opens. To Deny User. 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. contact_name is the name of the recipient contact. 2. This can be done with MicroStrategy SDK 9. Open System Manager, and then add Command Manager->Intelligence Server into workflow window. Type the command of CONNECTMSTR -n Project_source_name -u username -p password to connect to an existing project source. Procedures can use Command Manager syntax, or they can be written in the Java programming language and incorporate Command Manager statements in Java commands. Double-click the security role you want to assign to the user or group. The licensing scheme operates as follows: Auditing named users for every component of the MicroStrategy 9. 4. 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. 0. To add new users or groups to the object's access control list (ACL): Click Choose Users/Groups. In order to achieve so, Command Manager procedure has been provided as a sample. All objects in the update package are copied to the destination project or project source, following the rules specified in the update package. Example. "login _name" is the login name of the new user, of type string. Select Roles in the Security menu. 3. The following administrative tasks can be automated using Command Manager in MicroStrategy 9. 2 that allows the user to execute in a sequential order different Intelligent Cube Reports. 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 columns correspond with each of the three required subscription properties: Physical address. A Command Manager Procedure must be referenced in a script file (*. 1 Hotfix 3. link in the top right of the Data Sources pane. mmp: Click OK. Refresh. Use the "CREATE USER" outline to write a script to create a new user. ; Go to Connection Type > Direct (2-tier), and click Next. In MicroStrategy Command Manager 9. NET): Program FilesCommon FilesMicroStrategy directory. List of machines involved (OS types of machine) and which one is running command manager. x-10. NOTE: Users have to hardcode the password for the MicroStrategy user in the batch file. A list of the user groups that reside on the Intelligence Server appears. To invoke Command Manager from the database server, use one of the following. These procedures are briefly described below. NOTE: This script does not appear in the outlines list. 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. 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. The following table lists folders and files of interest that are included in the default directory structure after an installation of Object Manager. Select the Members tab. 3. 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. Third Party Software Installation: WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. Click Yes to open the command prompt with administrator privileges. In the Platform Analytics directory, located in C:Program Files (x86)MicroStrategyPlatform Analytics, open the bin folder. where: subscription_name is the name of the subscription. Click the New User icon on the toolbar. ). Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. Command Manager allows administrators to: Add, remove, or modify users or user groups. Creating, Importing, and Deleting Users and Groups. USER_GROUP_RESULTSET: A ResultSet containing a list of user groups to which the user belongs. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. If the value is '0', then the user is disabled. Click on the "Log" tab. ACTION:Open MicroSoft Notepad and save the following commands as file: cmdmgr -n LON-GOTTFRIED -u Administrator -p Ad3pwx4 -f c:winntDisableUsers. Common privileges. With introduction of Library there is a need to synchronize user language preferences between Web and Library interfaces. Users wish to execute scripts in MicroStrategy Command Manager 9. Select the Members tab. ACTION. Therefore, MicroStrategy recommends to add. KB45980: How to get the list of users belonging to user groups in MicroStrategy Command Manager 9. PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string. Data Management "I want to create 500+ attributes in bulk using. " after running the Create User script with multiple qualifications in MicroStrategy Command Manager. 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. To allow other users to add data to the metric (to emulate MicroStrategy 6. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. Tokens can be: reserved words. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. x-10. Developers of OEM applications that use embedded MicroStrategy projects may need flexibility in configuring their environment. MicroStrategy Office privileges. Checking Who Is Logged-in To A Remote Computer or Server. exe file is stored. You can compose Command Manager scripts to manage user subscriptions. Open Command Manager; Connect; Copy and paste the following script: LIST PROJECT ACCESS FOR PROJECT CONFIGURATION. Configure Through Command Manager. x-10. ACTION. x metadata using a Command Manager outline. 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. Microstrategy Command Manager – Bulk Create Attributes Posted by previous_toolbox_user 2013-06-27T17:51:00Z. 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. 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. Create a Custom MicroStrategy Installation Package. That XML file can then be used to create the package from the. Run the following command to connect the Enterprise Manager Data Load Service to a MicroStrategy environment by choosing an Intelligence Server from that environment. NTSID "new_user_ntsid" is the new NTSID to be linked. 1 - 10. The "OBJECTS" section. This allows the new source to be created with the UseSSL setting enabled. To locate these settings, right-click the project and select Project Configuration. x: In the Results tab, Right Mouse Click > Export Results > to Excel as shown in the image below:. 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. Create Data Load and check EM_Configuration table. Click Modify to open the Properties dialog box: Security tab. It provides information on sessions, which user has the highest number of errors, and the number of inactive users. MicroStrategy Command Manager is a script-based tool for automating Intelligence Server administration. Run the command 'LIST MEMBERS FOR USER GROUP "<user_group_name>"'. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. The following procedure describes how to create a prompted subscription based on text ID form in Tutorial project in MicroStrategy Command Manager 10. Number of Views 1. The prompt answer of the subscription cannot be changed by changing the default answer in the prompt object itself. x-10. For more information about Command Manager, see Automating Administrative Tasks with Command Manager, or the Command Manager Help (from within Command Manager, press F1). ACTION Contact Microstrategy Technical. MicroStrategy Web (. Command Manager allows administrators to: Add, remove, or modify users or user groups. Click on the "+" button next to "Reports" to create a new report. For instructions on how to view or edit a sample procedure, see Inserting sample. Thus, it is possible to get a list of users that which are enabled by adding a filter to the report with 'Enabled Status. These statements place a lock on the metadata or configuration. Lists all attributes from a given location path within a project. x Number of Views 2. Follow the steps below to create such user account: In MicroStrategy Developer, use the Administrator account to browse through Administration > User Manager > System. Start Monitoring. In MicroStrategy Object Manager 9. In a UNIX console window, browse to the "bin" folder under <HOME_PATH> where the MicroStrategy is installed. They only list users with some activity while omitting users with zero activity. Select On from the drop-down. For more information about Command Manager, see Automating Administrative Tasks with Command Manager. USERS IN GROUP "user_group_name" is the name of the group for which. man pwd. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. 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. To modify a schedule, right-click the schedule and select Edit. The syntax is for MicroStrategy Command Manager version 8. TRUSTED_LOGIN: Whether the user is a trusted login, returned as a string. Type. This statement can only be executed in a Windows. Specify a name and location to save the response file, and click Save. For the syntax for using the executable, see Executing a Command. x . “occurs during unloading a project via Command Manager or Developer when there is user session or job execution. 13: MicroStrategy Command Manager. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. This can be achieved as follows: Connect to a project. 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. KB312890: "LIST ALL USER GROUPS;" in MicroStrategy Command Manager returns different result after upgrading from 9. User management: Add, remove,. Number of Views 884. The folder and its contents remain on the system and ownership is assigned to Administrator. Command Manager is a MicroStrategy tool designed to automate certain tasks and processes. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. Triggering Events. x and receives the following error:. You can also import users. 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:. contact_name is the name of the recipient contact. x, the user can choose to create an update package from the command line by specifying values in an XML file. Creating a Custom Group. 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. MicroStrategy Developer と MicroStrategy Command Manager は、同じコンピューター上、または異なるコンピューター上にインストール. 1. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. This scp file can be executed from a command line, System Manager workflow, or a third-party workflow management tool. 4. 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. 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. 6: MicroStrategy Web. 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. Then, in the Project Configuration Editor, expand Caching, and then select Result Caches. A token is a word, a list of words enclosed in quotation marks, or a symbol. You can manage configuration settings in the MicroStrategy platform for either project sources or Narrowcast Server metadatas. ” 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. 7: Scheduler. A Procedure window opens. PRE-REQUISITES:-DSN for the Enterprise Manager warehouse repository must be created in this Linux environment. 4. get (i); addr. Further, it is not possible to access the email subscriptions of other users through the MicroStrategy Web interface. The Subscription Manager allows you to manage all the subscriptions for a project from one interface. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. Click Create Role . Open your new project MicroStrategy Essentials and go to the SchemaIn MicroStrategy Object Manager 9. 4. 4) In MicroStrategy Developer, connect to the MicroStrategy. Begin creating a configuration package by navigating to ToolsCreate Configuration Package. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. For more information, reference the following doc: MicroStrategy Command Manager Help; Web API Reference ; Via Web Java SDKAlthough MicroStrategy Command Manager 9. The command prompt is displayed. PROJECT "project_name" is the project for which you want to list the security roles for the user or group, of type string. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. USER GROUP "user_group_name" is the name of the group whose security roles you want to list, of type string. Uses MicroStrategy REST APIs; Optional Containerization (Kubernetes) Secure MicroStrategy connections; Cube refresh instructions and parameters are provided by the calling process, i. Click Yes to open the command prompt with administrator privileges. 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. For example, the user may want to create a new package every week that contains all the new metrics from the development project. 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. FOLDER "location_path" is the folder path where the security filter is to be placed in the project, of type string. ACTION: Use a user ID that has administrator privileges to run the. Run the script LIST ALL CHANGE JOURNALINGS. Alternately, the warehouse login ID can be set 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. The User Editor opens. x-10. Open the MicroStrategy Configuration Wizard. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. Open MicroStrategy Web and click Add external data. 4. x and 10. Run the ALTER CONTACT script to change the LINKMSTRUSER to the new user. The value of '1' means that the user is enabled. USER "login_name" is the name of the user whose security roles you want to list, of type string. x with the same web session, purge all of the report caches using a MicroStrategy Administrator - Command Manager 8. x. 'In MicroStrategy 9. populate (); //Get the device corresponding to the desired address WebSubscriptionDevice device = addr. In MicroStrategy 10. For more information about using Command Manager and for script syntax, see. 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. 0. To invoke Command Manager from the database server, use one of the following commands: SQL Server: exec xp. For general information about Command Manager, see Automating Administrative Tasks with Command Manager. x and 10. x do not list out all the users on reports containing metrics for user activity. LU_Users. Mouse over the Hadoop data source options and choose Impala. ‒ 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. ini". Log in a project source in Command Manager. In Linux: Browse to the MicroStrategy Home folder, then to the. 23: OfficeTo Create an Event Using Command Manager. Platform Analytics. /mstrcmdmgr -interactive and press ENTER to open 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. To manage your subscriptions, select from the tasks below: To create a subscription, right-click in the Subscription Manager and select Subscription Creation Wizard. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. This can happen when a user runs a report or when the report is run on a schedule for the user. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. KB34483: ‘List All Groups’ script in MicroStrategy Command Manager 9. This capability allows you to personalize messages using user information and create. MicroStrategy Command Manager. Workaround. x. You can deny user or group access to a specific MicroStrategy project by using a security role. 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. Click OK. 1 HF3 Command Manager syntax for the command. This technical note explains how this can be accomplished using MicroStrategy Administrator - Command Manager . Update Structure statement. When creating security fiters via Command Manager, users may wish to include multiple filtering conditions (i. x, it is possible to programmatically execute a report, answer any prompts, and create/update a report history list message. If installing over previous versions of the product, the folder remains the. Once the above outline is executed in Command Manager, all addresses associated with all users under Everyone will be deleted. 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. The value of '1' means that the user is enabled. From the Choose a Permission Level drop-down list, select the predefined set of permissions, or select Custom to define a custom set of permissions. Hover over the Properties column and click Open Intelligence Server Administration Portal . User creates a new application object using MicroStrategy Command Manager 9. . The Enterprise Manager project can be in the same metadata as your other projects. Select any project that is in the project source that contains the users and groups and click Next. Server - Intelligence" to the user. CREATE USER IMPORTWINUSER "DomainNameTest" PASSWORD "xxxx" NTLINK "DomainNameTest" FULLNAME "Test User" ALLOWSTDAUTH TRUE IN. Run the following command to connect the Enterprise Manager Data Loader service to a MicroStrategy environment by choosing an Intelligence Server from that environment. Statements consist of one or more tokens. exe --ResponseFile="C: esponse. x. You can create events with the following Command Manager script: CREATE EVENT event_name [DESCRIPTION description];. In a text editor (such as Notepad), enter the command line statement that the task scheduler should execute. 1. CREATE ATTRIBUTE "Month" DESCRIPTION "Duplicate of Month Attribute from folder Time" IN FOLDER "Schema ObjectsAttributes" ATTRIBUTEFORM "ID" FORMDESC "Basic ID form" FORMTYPE TEXT SORT ASC EXPRESSION " [MONTH_ID]" LOOKUPTABLE "LU_MONTH" FOR PROJECT "MicroStrategy Tutorial";• granting Access to users • Creating Security Roles using Microstrategy Desktop • Migrating project changes from Development to UAT and from UAT to Production using Microstrategy Object Manager • Setting preferences for different projects that govern the way projects are run for web users using Microstrategy Web • Creating Command. Place the Command Manager procedure file in the specified procedure directory. 4. This article describes how to generate a list of which user/group has access to a project using Command Manager. For example, this might be provided by a customer ID attribute form of the. In Command Manager, procedures are reusable scripts that can be executed from other scripts. Place the Command Manager procedure file in the specified procedure directory. CAUSE This. Edit the schedule to be an event-based. MicroStrategy users need connectivity to the metadata so that they can access projects, create objects, and execute reports. From the Windows Start menu, point to All Programs, then MicroStrategy Tools, then select Service Manager. Variable "INTELLIGENCE_CUBES_RESULT_SET" cannot be recognized in procedure code in MicroStrategy Command Manager 9. 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. Go to Administration > User Group > Everyone. The privileges are grouped by privilege type: Web Reporter privileges. Managing Configurations for Project Sources Using Command Manager Runtime Statements. x. The 'Enabled Status' form is a flag that has been added to the EM_USER table in the MicroStrategy Enterprise Manager warehouse. 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. Create a new attribute form for any existing attribute. Retrieve the MicroStrategy installation files from the installation disk or the MicroStrategy download site. 1. However, if it uses Windows authentication, the user name passed to Command Manager is ignored and the Windows security credentials are used instead. ACTION: Click Insert Visualization . scp -o DisableUsers_output. ini". MicroStrategy Command Manager provides a set of Sample Procedures, which take advantage of java code flexibility, out of the box. A Command Manager script consists of one or more script statements. Enterprise Manager reports in 9. Enterprise Manager consists of a MicroStrategy project, the Enterprise Manager server (service), and an interface in MicroStrategy Command Manager where administrators can control how the server. For example, you can. Windows GUI: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then select License Manager. The MicroStrategy projects on each Intelligence Server can be configured to log usage statistics to the staging tables. Example: A Command Manager script consists of one or more script statements. Workstation provides a central place to create and manage multiple cards. Related articles from the Community: Knowledge Base: How. LIST ALL SUBSCRIPTIONS FOR CONTENT GUID <report_or_document_guid> FOR PROJECT "<project_name>"; CAUSE: This is a known limitation MicroStrategy Command. user_or_group_name is the name of the recipient user or group. For instructions on how to view or edit a sample procedure, see Inserting sample statements. ACTION Contact Microstrategy Technical. 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. For example, you can create a procedure called NewUser that creates a user and adds the user to groups. x . To Execute a Script from the Command Manager Graphical Interface. 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. ; Select the Security Filters tab. 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. Alternatively, when the Schedule Manager folder is selected, users may go to the File menu in MicroStrategy Desktop and Select New and then Schedule. To invoke Command Manager from the database server, use one of the following. exe -w SQLServer -u user -p pass -d master -s dbo. 3. x through the MicroStrategy License Manager; Knowledge Base: License Compliance. KB13380: How to create a list of Project Configuration Settings using MicroStrategy Command Manager 10. To schedule a script to run at a certain time, use the Windows AT command with the cmdmgr executable. ACTION:Click Insert Visualization . Adding support for TLS is done by selecting the Use SSL checkbox. This is a new feature introduced in MicroStrategy version 9. {~+, 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). x and 10. Create, modify, and delete database instances, connections, and logins. 4. 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. 2.