To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. ' In Application, change to 'Text File' and select Advanced. To automatically open the report in Excel after you export the report, select the Show application after exporting check box. . ; In the Source area, select the database instance for your Excel file. Perform one of the following actions to specify an object prompt: Select 'Use a pre-defined list of objects' and click on 'Add. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. 1) create the report. In order to exclude the values, create another filter expression which will always be TRUE and. The New Grid dialog box opens. x:To create relationships between attributes, see Defining attribute relationships. To Display a Filter's Definition. Log in to a project in MicroStrategy Developer. How to create a report that dynamically selects which metrics to display on the report based on the specified attribute elements in the Page-by in MicroStrategy Developer 9. To access the dialog in Developer, from the ' Schema' menu, choose ' Export Project Schema'. x? Perform the steps in this article to change the metric join type from the product default (Inner) to. Create compound metric "Rank Day" with the metric generated in step1. Go to Connection Type > Direct (2-tier), and click Next. 1 and 10. To edit a document in Design Mode, from a folder, right-click the document and select Edit. MicroStrategy Command Manager can trigger. under the "Insert" menu. In addition, they can be included in Report Services documents in the same way as standard reports. Example using the MicroStrategy Tutorial project: Create a new, empty report. A derived attribute works the same as any other attribute. Right-click on the project name and select My Preferences. At the Report-level, null handling can be set by editing the report and then clicking on the toolbar Data > Report Data Options > Display > Null Values. Subscription Creation Wizard in MicroStrategy Developer 9. This video presents how to create a report in the MicroStrategy 9 Developer (here referred to as “Desktop”). If the New Grid dialog box opens, select Blank Report as the report object template. 1 the following options are available: The option to define a Freeform SQL report has been moved into the "ODBC Sources" tab of this window, as shown below: By enabling the radio button to "Use Freeform SQL Editor" a new Freeform SQL report can be defined. Click on the "Validate" button to validate the formula. You can also select an existing template (see How to Create a Report Based on an. For a complete discussion of metrics, filters, reports, and other report objects, see the Basic Reporting Helpand the Advanced Reporting Help. For example, you can edit. This document explains how to join tables in MicroStrategy Architect where the attribute ID columns are named differently (also known as heterogeneous column support) by creating an attribute that can join on columns from different tables with different names (heterogeneous column joining). x, open the Attribute Editor for the desired attribute and create a new form with the following syntax in the Form Expression section: ApplySimple ("#0 ',' #1", ,)For the example scenario, log in to the MicroStrategy Tutorial project. at the top of the page. The following steps demonstrate how to design this kind of report in MicroStrategy Tutorial project as shown below: Create two compound metrics C_R=Cost/Revenue and C_R_PM=C_R/. Then, open a report editor and add Year, Category and Item into the report template. The following report shows metric ranking in descending order of Dollar Sales. About dashboards. Filters ensure that the report results contain only the data that answers the specific business query the report was designed to answer. Links are created using the Link Editor. From the File menu, go to 'New 'and choose 'Report'. Creating and Adjusting Titles in MicroStrategy Developer. In the Data Source dialog, select Reports. On the toolbar, click Add Element. EXAMPLE. Log in to Workstation with a MicroStrategy user, for which has not been granted the privilege ‘Use Freeform SQL Editor’. x, if there are any compound metrics included in the interface, users may click on the word Metrics, and that will break down all compound metrics into its constituent simple metrics. Freeform SQL reports can be created only on MicroStrategy Developer. The reason for the case statement is that the value for. Projects are discussed in Creating and Configuring a Project. How to create a report with a null column using metrics that are not based on facts in MicroStrategy? Symptom: The user would like to create a report with a metric that has an empty column. x-10. To Create a Report Using a Template. Select the attribute 'Date' and choose 'ID' from the Qualify on menu. Save and close the filter. Navigate to a prompted report and click Insert. Create three attributes named A, B, C, and after them added in a report in Developer, no data returns， as showed below. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. Create a report with Category and sub-category as its two columns. This technical note lists the steps to create a grid report showing Pareto (percentage) or cumulative percentages in MicroStrategy Developer 9. Select Add Subscription for the type of subscription you want. x. Right-click on the report and choose 'Edit'. Business. Add To Report Editor: Page-by Area. To send a report or document to a network folder on a schedule. Sets a maximum for the number of categories in a graph based on the value typed into the Categories field. Enter a Form name and Description. . On the upper right of any page, click your user name, and then select Preferences from the drop-down list. To change the layout of the walls, in the top menu bar, go to Graph > 3-D Settings: To change other properties, go to Graph > Graph Options: the Marker Shape and Size is on the General tab. Go to the Object Types tab and check the box for 'Report. Specify the delimiter desired for each data item, as shown below: Create a search object using MicroStrategy defined by the search criteria specified by the user, as shown below:In MicroStrategy 2021 Update 7 and later, MicroStrategy users cannot adjust the ACL for FFSQL reports, although they have the Full Control privilege over the same objects. The Manual Layout option is located under Graph Preferences for a report in MicroStrategy Developer. Create a database instance that references the intended datamart location by performing the following steps. ? In some business scenarios, administrative users have a calendar master table. To create a derived metric. When selecting a font to format a grid report or document in Developer, the. x SYMPTOM: In MicroStrategy Developer 9. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. If you creating a prompt for a filter, click OK to save the prompt in the filter. Enter a SQL statement and click on the 'Add prompt' button, as shown below: The prompt element will be added automatically, as shown below:The Keep parent while drilling setting can be set in either Report Data Options or the Drill Map Editor. In MicroStrategy Web, on the reports page, under the name of the report/document that you want to create a subscription for, click the Subscriptions icon . Create two different templates. x - 10. The expression will be as follows: Sum(Revenue) {~} <> Create a new standalone metric which calculates the total revenue values, with the Report level enabled, as well as the Month of Year as a level, with standard filtering and no grouping. SUMMARY: This Technical Note shows how a user can programmatically create a new report, add data to it then choose the type of graph he/she’d like to display with MicroStrategy Web SDK 9. Create an object prompt that prompts the user on the unmasked and the masked attributes, as shown below: Create a report that contains the desired information, including the object prompt in the template as if it were an attribute, as shown below: Execute the report, choosing the masked version of the attribute. x?Creating a Custom Group. STEPS TO REPRODUCE: Follow the steps below to reproduce this issue in the MicroStrategy Tutorial project:In MicroStrategy Developer 9. Create a report with Subcategory, Item, Rank Metric (created in Step 2) and Revenue. The Create New Attribute Form dialog box now appears. Put this Prompt inside a metric, as shown below: Create a report and put this metric in the Report objects window. SYMPTOM: Consider a scenario in which a user of the MicroStrategy Tutorial project wants to create a report displaying a running sum of revenue at the monthly level, breaking by quarter. Create a Filter with the Date attribute. In the view filter choose. Open the report or. However, when defining a new report in MicroStrategy Desktop 9. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. Follow the steps below to create an attribute qualification filter that will allow the user to enter more than one value to filter on:This document explains, through the use of an example, how to create a dynamic report execution in MicroStrategy Narrowcast Server 9. To view. Run both reports after enabling the metric levels log. Set Keep parent while drilling to Default to allow the drill path to determine. Create Dossier: Create a new dossier. Modify the SQL statement or the column mappings as needed. In the Login ID field, enter the user ID needed to access the warehouse. The following steps instruct how to get the latest 2 days data in the report. The Insert Function dialog box opens. How to create a report that shows the beginning and ending values of a date range on the template in MicroStrategy Developer 10. The following procedure describes how to add or create a prompt in a cube report in MicroStrategy Developer. Users may wish to consider specifying the connection to one of the data warehouses as the primary database instance for the project and then using Freeform SQL reports to extract data from the second warehouse. MetricA will serve as the starting data point. You can also begin creating reports in MicroStrategy Developer and MicroStrategy Web. Click the name of a report to execute it. Use expression: Rank([Metric Day]) Create report with Day attribute and add the following 2 filters:A user wants a MicroStrategy Developer report to only retrieve a specified number of rows. at the top of the page. Select the environment and project where you want to save your prompt. access the Create Report folder and design reports, and to run new reports from the folder where he or she has saved the report definition: WEBCREATENEWREPORT:. This filter, which will be used on the report, qualifies on the current date. In MicroStrategy Developer, choose File > New > Report. Perform the following steps in the MicroStrategy Tutorial project to create a total of summary metrics across different datasets in a Report Services document in MicroStrategy Developer. To achieve this, perform the following steps: Create a running sum metric which will return the row number for each record. "Sales" as metric. Create a blank dossier or open an existing one. You create and interact with dashboards in MicroStrategy Web. You can also display dashboards on an iPad with MicroStrategy Mobile. 1. 1 Unfortunately it's not possible to create a report using MicroStrategy Command Manager. The steps below give a detailed explanation on how to create a report that contains a metric based on another metric that will return a static string of data from the warehouse. When the Java Editor opens paste the addon code. 4. MetricB will serve as the length/duration from the starting point. To Create an Event Using Command Manager. If installed over previous versions of the product, the folder remains the same. Select the appropriate options to define the dynamic recipient list, as described above. Create Freeform XQuery report: To create a report using custom. Add Object and Component Object attributes to the grid to see all dossiers and their dependent datasets Example 2: How to create a dossier that shows all objects that use a certain metric 1. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. x, as shown below. 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. KB5078: How to create a value prompt in. If you are on a folder page, click Create on the icon bar on the left, then select New Metric. NOTE: Users must be granted 'Create Application Objects' and 'Use Template Editor' privileges. This attribute is referred to as a derived attribute. They are metrics that are saved and displayed only on the specific report on which they are created. x and newer on Windows and Unix/Linux; Knowledge Base: How to perform a License Audit in MicroStrategy Intelligence Server 10. To save the prompt. The template should include the maximum number of attributes and metrics of any. New: Create a new report. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. Use this section to familiarize yourself with the Report Editor interface. x, with the Intelligence Server running on Linux, the image in the. If the Report Filter panel is not displayed above the report, click the Filter icon . Choose Graph > Titles and Labels. Used PL/SQL procedures in different places. Create a report that uses an object prompt, such as Category or Subcategory. The Input Metric Formula dialog box opens. For example, if you want to create a new user in the Web Reporter group, click the Web Reporter group link. Creating logical views. Click 'OK'. To email a report or document on a schedule. You will see that R2 still displays the first 6 months data. MicroStrategy Developer 9. Allow the report designer to create a smaller number of reports overall, using more inclusive objects, rather than having to create numerous, more specific reports that are individualized to each analyst. All Others' report in MicroStrategy Developer 10. On the My Subscriptions page, under the Email section, click Add email subscription. Step 1: Create a filter that sets a user attribute equal to the System Prompt "User Login". The Report Limit Editor opens. '. Go to 'Data' on the top menu bar. Input the metric formula. 2. Select 'Configure Bulk Export': Specify any additional desired configuration options. Let’s look at another example. To choose the 'Rank Order by' properties, select 'Rank Parameters' in the Metric Editor. When you are done, click Close to return to MicroStrategy Developer. Add “Component Object Category” attribute to the filter panel and filter on the “Cubes” element and the “Reports” element. For a quick breakdown of the knowledge required to integrate your metadata with your warehouse, object creation required for reporting in MicroStrategy, and other items to adjust MicroStrategy to your. Open a 3-tier connection using MicroStrategy Developer and edit the desired report. Right mouse-click this folder and select 'Search for objects. Drag and drop the reports into the Dataset Objects panel of the Document Editor. To Create and Adjust Titles in MicroStrategy Developer. The object's editor or wizard opens. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . If the New Filter dialog box is displayed, click the Empty Filter icon. KB31287: How to add row numbers in a grid report in MicroStrategy Developer 9. Dynamic dates are created in MicroStrategy Developer by using the Filter Editor. Select the "OK" button to insert the new metric into the report. Knowledge Base: How to generate an audit report through the command line with the MicroStrategy License Manager 9. To Create a Subscription in MicroStrategy Web. Step 2: Create a new report that includes the User attribute, the other attribute that you wish to filter. A window, as displayed below, appears: Assign a Cost Range for reports by either using the horizontal scroll bars or the text boxes. To access the Template Editor, execute the following: From the File menu, go to New and choose Template. To edit a document in Design Mode, from a folder, right-click the document and select Edit. Create a report and add the Item_Demo attribute, the three metrics created in Step_6, the three metrics created in Step_7, and an attribute element prompt based off the Subcategory attribute. The custom reports that you create might. Create a new, empty report. properties file for editing. x. This article is to introduce a workaround to achieve the attribute left outer join on. Create another metric named DateDifference that compares the value from the two metrics and sets the value to 'NEW' or 'OLD' with the following formula: IF((MetricB >= MetricD), "NEW", "OLD") Create a report with the Day attribute on the column and the DateDifference metric on the row. To learn more about how to deploy your project using MicroStrategy Web, see the Installation and Configuration Help. The metadata may be created from any of the nodes and only needs to be done once. Use MicroStrategy. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. Edit the report or document in MicroStrategy Developer. For information on connecting to databases, see Connect to Databases. In MicroStrategy Developer, from the File menu, select New, and then choose Report. This allows enterprise BI developers and administrators to build and administer sophisticated enterprise and mobile analytics applications, at a fraction of the effort it traditionally takes. Custom totals can be used to selectively display subtotals for different metrics in MicroStrategy Developer, as shown in the report below: Custom subtotals can be configured from the Report Editor. 4. x-10. Add the attribute Subcategory and metric Revenue to the report template. In MicroStrategy Developer, prompts can also be created as an intrinsic part of a given report, filter, or custom group, at the same time. Add the 'Month to Date' transformation. information. To select totals by rows, columns or pages, click on 'Advanced' and. The following steps may be use as a reference when building reports with Report Builder: Create a new report in MicroStrategy Developer 10. Right-click a project and choose Properties. NOTE: The 'Refresh' option assists in frequent updates to the interface for end user objects such as metrics, filters, prompts, etc. 4. Specifying Warehouse Connection Information. Displays or hides the. Click OK. This can be done by editing the object template from the object template folder. General Settings. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. The following procedure describes how to achieve prompt-in-prompt in a Freeform SQL report in MicroStrategy Tutorial project: Create a new filter, select Add an Attribute qualification and choose the highest level attribute Country. 4. From the Tools menu, select View Filter. x. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. In MicroStrategy Developer, choose File > New > Report. It lets the users view various information about the schema design of a MicroStrategy project. Click Add a New Dynamic Address List. 4. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. If the parent report is configured, under Report Data Options > Attribute Join Type, to preserve all lookup table elements joined to the final result table, then the target report will also preserve lookup table elements. rpkeller. To create to a direct project source. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. To obtain the Project Documentation for only reports in a certain folder in MicroStrategy Developer, follow the steps below: Log into MicroStrategy Developer. Related articles from the Community: Knowledge Base: How to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. In MicroStrategy Developer, choose File > New > Report. Metrics are quantitative measures used to analyze the data in the particular context. Create a report with the following: "Customer" as attribute. 12K subscribers Subscribe 18K views 3 years ago Explore how to add templates, attributes, metrics, filters, and. 5. The function 'DayOfWeek' will return an integer value which '1' means 'Sunday', '2' means 'Monday' and so forth. Looker Studio (formerly Data Studio) is a powerful data visualization tool that enables you to build dashboards on top of big data sources, like the Chrome UX Report. " Select "Use a filter to reduce the number of elements" and select the "QUARTER FILTER" created in the previous step. The other two metrics simply need to be in the report objects window. Run the report and it will prompt the user to select a date. x. You can easily create a derived attribute that: Changes the data type of an existing attribute. Used Enterprise manager to create reports on the project usage and report usages. To access the Metric Editor, execute the following: From the File menu, go to New and choose Metric. A report with this metric follows: Notice that the report is now sorted ascending by the day attribute. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. . For example, facts are used to create metrics, which are in turn used to design reports. 4. To do this, right-click the report or document, and select Edit. Click Select. To access the Metric Editor, execute the following: From the File menu, go to New and choose Metric. Right-click the filter, and select one of the following (the options are described in more detail above): Replace Report Filter with a. To Create a Data Mart. Clear the Totals check box to remove the standard subtotals. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. To Create a Report Using a Template. In. x, as shown in the screenshot below: 2. How to create a dynamic filter that returns months less than or equal to current date in MicroStrategy Developer 9. Metrics are completely reusable - they can be added to different reports or even other metrics. Further information can be found in KB30310: How to create a Freeform SQL Report in MicroStrategy Desktop 9. For a document, edit the document in Design Mode or Editable Mode. When users create a Report Services document and set a report with multiple prompts as a data set, users cannot find the 'Prompt Ordering' option under the Data menu in MicroStrategy Developer 9. 3. Right-click on Rank > Rank Parameters. How to create a report that dynamically selects which metrics to display on the report based on the specified attribute elements in the Page-by in MicroStrategy Developer 9. This defaults to creating a SUM (fact). It is possible to create a multiple value prompt to enter more than one value to filter on an attribute in MicroStrategy Developer 10. Application objects such as reports are used to analyze and provide insight into the relevant data. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. In the Multiple objects text box, search for and add filters to use when displaying objects in the prompt. x, it is not possible to specify a date when defining a dynamic date filter. Logical views can be created in MicroStrategy Developer using the Table Editor, which is shown in the image below. Custom: Prompt created in step 1. How to include items of Consolidation in report result when no fact data is available in MicroStrategy Developer 9. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table when the data mart report is executed. Displays or hides the objects on your report. Create a third object prompt that retrieves all object prompts in the project. Choose False for ASC. x - 10. Click the General tab. Make sure that the users are included in the Access Control List of all the objects included in the report with at least 'View' permissions. The New Grid dialog box opens. Once the report has run, right click the Category attribute. Name the derived metric using the top most text field in the window. In the Data Source dialog, select Reports. 4. In addition, they can be included in Report Services documents in the same way. 4. With MicroStrategy Developer Library, learn how to download the MicroStrategy Mobile SDK through the MicroStrategy Community Product Download. Creation Guide. Create a Freeform SQL report in MicroStrategy Developer that returns only the server name (and port number if necessary) as new metric. In a report, right-click an object and select Edit Links. Go to the Reports tab and select 'Export Options. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. x, the following points must be kept in mind: A pair of metrics defines start and length pair which will be translated as a horizontal bar in the chart. Microsoft Windows Explorer is a tool that helps the user to visualize, manage, organize, create, and delete files in a PC. If the New Metric dialog box is displayed, click the Empty Metric icon. Use the Object Browser window to search for and locate the filter that you want to add to the report. TTF format) and install the file. Create a report (for example, customer state, customer city, revenue) and add P1 into report filter. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both. Click Create on any folder page, point to New Report, and select a template (such as Call Center Analysis) from the list of pre-designed reports. Click the MicroStrategy icon and select Create Report. For example if it is desired to add object prompts when using report builder the steps below can be used. Click Add a New Dynamic Address List. Create a compound metric called B with expression "RunningSum(A)" as shown below. Creating a new FreeForm SQL report or Query Builder report in Developer In Microstrategy versions previous to Microstrategy version 9. Start building with MicroStrategy to deliver exceptional product experiences Request a demo Administration Support 2/6 videos | 20M 16S total runtime This tutorial. On the Freeform Sources tab, select one of the following options: To create an Intelligent Cube by creating SQL statements using the Freeform SQL Editor. This tutorial shows how to create derived attributes and metrics in a dossier. The steps below show you how to display and format titles for a graph. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. 4. x, when trying to create a new FreeForm SQL report or Query Builder report one would have to click on New > Report and select FreeForm SQL report in order to open the editor. This metric is used for getting "1" value for all rows. Field: Date. Place the new metric in the desired location, as shown in the screen shot below:To Create an Intelligent Cube Using Freeform SQL or Query Builder. This video is unavailable. The result is as follows for prompt answer = '1/12/2003':About custom groups. 2. The only difference is that for each of the three different Null value handling categories shown below, at the Report. 2. x - 10. x, there is a graph called Pareto (Percentage). Choose Add Data > Existing Dataset to add data. Double click in the Report Filter box to open Filtering Options pane to start creating a report filter, select Add an Advanced qualification and click. Introduction MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and. This video will step through how to create a License Audit report on your MicroStrategy Intelligence Server through License Manager. x - 10. In MicroStrategy Developer, you can view dashboards, with a limited range of interactivity. On the Freeform Sources tab, select Create Query Builder report. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same way you would add report objects. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. Set the Sort parameter for the metric so that data make sense when displayed. Type the following for the name: "Total for the #P #0". Specify the project source of the project to be duplicated. Provide a number greater than the highest value in the y-axis to create the smooth curve. KB10969: How to set the default metric Join Type to Outer Join in MicroStrategy Developer 9. Add the metric "RP First Job. Do one of the following: For a report, click the name of the report to run it. As you can see from the Outline window below (this shows all. ; On the Freeform Sources tab, select Create Query Builder report. x. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Page-by pane: (top of Report View pane) Where you place subsets of your report results to be displayed as separate pages of the executed report. SCENARIO. For information about creating reports in MicroStrategy Developer, see the Basic Reporting Help; for creating reports in MicroStrategy Web, see the MicroStrategy. Security filters. The object's editor or wizard opens. In the Source area, select the database instance for your Excel file. In this video I will show you how to create a prompted Freeform SQL report in MicroStrategy. KB36744: How to restrict a user or user group to build and edit reports only on Intelligent Cubes in version 9. Select the 'ignore' option under the 'Filtering' column for 'Report Level', as shown below: Save the new metric as 'Ignore Filter'. Right click on the dynamic text and then click on "Format". Add the attribute Subcategory and metric Revenue to the report template. Any physical table in the project database instance can be used in the SELECT statement. Filters ensure that the report results contain only the data that answers the specific business query the report was designed to answer. From the left, click All Objects, then navigate to the objects you want to place on the report. x. A valid expression is one such as: SUM (FACT1 + FACT2). The definition for this metric is: (RunningSum<SortBy= (Salary) > (Case ( ( [M0]= Salary), 0, 1)) + 1) The metric will now show a dense rank. The Fact Editor opens, with the Create New Fact Expression dialog box displayed on top of it. Create a Prompt using Prompt Generation Wizard in MicroStrategy Desktop/Developer. Learn how to create, edit, and share reports, dashboards, and documents using Excel, PowerPoint, Word, and Outlook. has a MicroStrategy implementation with 4 environments: Development, QA, Mirror, and Production. Select a prompt answer and click Apply. Categories. x do not have an administration task to purge object caches, as illustrated below: However, administrator can use a script to purge object cache in MicroStrategy Command Manager and.