how to create report in microstrategy developer. Place the "Top 10 Customers vs All" (as is done with an attribute), the "Percent to Total Customers Revenue", and "Revenue" on the report and the result will as shown in the screen shot below: Users can create a report. how to create report in microstrategy developer

 
 Place the "Top 10 Customers vs All" (as is done with an attribute), the "Percent to Total Customers Revenue", and "Revenue" on the report and the result will as shown in the screen shot below: Users can create a reporthow to create report in microstrategy developer  Step 3: Create a new filter that is a shortcut to report pointing to the report created in Step 2

To do this: a. Click in the right pane. Under the Grid tab, make sure you are on the Y Axis tab. 1 and 10. The display format for dates does not change even after changing the SQL Date format and Date Pattern settings under VLDB properties of the project in MicroStrategy Developer. The function 'DayOfWeek' will return an integer value which '1' means 'Sunday', '2' means 'Monday' and so forth. 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. the Grid Lines are on the Display Status tab. In MicroStrategy Developer, locate the Freeform SQL report, right-click the report, and choose Edit. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Step 1: Create a filter that sets a user attribute equal to the System Prompt "User Login". Leverage your professional network, and get hired. For information about creating reports in MicroStrategy Developer, see the Basic Reporting Help; for creating reports in MicroStrategy Web, see the MicroStrategy. `. For steps to create a transformation, see the Project Design Guide. Open a 3-tier connection using MicroStrategy Developer and edit the desired report. Select the group in which to create a user. Create a Freeform SQL report in MicroStrategy Developer that returns only the server name (and port number if necessary) as new metric. Add “Component Object Category” attribute to the filter panel and filter on the “Cubes” element and the “Reports” element. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. Once the Export Schema dialog box opens, users can select the aspects of the schema they want to export to Microsoft Excel. For more information, see Permissions and Report/Document Execution. You can also display dashboards on an iPad with MicroStrategy Mobile. In Developer, from the File menu select New, and then Intelligent Cube. When applied to a language object, allows users to edit and save translations, and to select the language for display in their Developer or MicroStrategy Web language preferences. Open the Workstation window. Navigate to a prompted report and click Insert. Start building with MicroStrategy to deliver exceptional product experiences Request a demo Administration Support 2/6 videos | 20M 16S total runtime This tutorial. Within the Titles category, select the check box for the title or label to display. Report developers can leverage MicroStrategy reusable metadata objects to create any kind of report to meet any business requirement. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document. x - 10. If the New Filter dialog box is displayed, click the Empty Filter icon. under the "Insert" menu. Custom: Prompt created in step 1. 2. Select the metric on which to set the limit, by dragging the metric from the left frame to the top-right. Select 'Qualify on a Metric' in the Prompt Editor as shown below: Select the metric 'Revenue',. To Display a Filter's Definition. x. This technical note provides an explanation on why some metrics values are incorrect in page-by reports in MicroStrategy Developer. Just make sure the ssl_verify parameter is set to True when creating the Connection object in mstrio-py (it is True by default): conn = Connection(base_url, mstr_username, mstr_password, project_id=project_id, ssl_verify=True) The second way is to pass the certificate_path parameter to your connection object in mstrio. x? Perform the steps in this article to change the metric join type from the product default (Inner) to. Use the MicroStrategy Configuration Wizard to create a new metadata, or an existing one may be used. To ensure consistency between the metadata and the object cache, remember to update the schema after schema object modifications (i. Create a third object prompt that retrieves all object prompts in the project. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Open the MicroStrategy Configuration Wizard. Metrics are quantitative measures used to analyze the data in the particular context. In the MicroStrategy Tutorial project, create a report with attribute Category and metrics Revenue and Profit, using MicroStrategy Developer 9. Click the MicroStrategy icon and select Create Report. On the toolbar, click Add Element. In MicroStrategy Developer, you can view dashboards, with a limited range of interactivity. Follow the steps below to create such user account: In MicroStrategy Developer, use the Administrator account to browse through Administration > User Manager > System Monitors, as shown in the image below: Right. On the MicroStrategy Developer, point to New from the File menu, and then select Report. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. To create or edit a database login, perform the following steps: In the Database Login field, enter the name of the database login. Click Create on any folder page, point to New Report, and select Intelligent Cube Report. To create an attribute form that allows the attribute to display a name in the format of 'Last_Name, First_Name' in MicroStrategy 10. As the password characters are entered. How to create a report which shows the top 3 Suppliers offering the best price per Item in the Tutorial Project in MicroStrategy Developer 9. For example, if you want to create a new user in the Web Reporter group, click the Web Reporter group link. Create a database instance that references the intended datamart location by performing the following steps. You are returned to the New Filter page. To save the prompt. This defaults to creating a SUM (fact). To learn more about how to deploy your project using MicroStrategy Web, see the Installation and Configuration Help. From the left, select Dynamic Address Lists. Select the appropriate options to define the dynamic recipient list, as described above. This technical note describes the steps to create a list of reports with VLDB settings different from the default values in MicroStrategy Developer 9. The User Editor opens. 1,. Step 4: Attach the newly created filter (Step 3) to either a report or prompt. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. Select Display Attribute Forms. This may make related application objects (reports,. Metric Editor -> Tools -> Metric Joint Type. How to include items of Consolidation in report result when no fact data is available in MicroStrategy Developer 9. Create a Report Limit that is a metric qualification on sales between X and Y. 3. 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. x or earlier to version 9. 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. Drag the report into the filter definition window. All articles. Freeform SQL reports can be created only on MicroStrategy Developer. A report filter in a report is not being applied in MicroStrategy Developer 9. Login to MicroStrategy Developer as an administrator and create a new user with the User Manager, as shown below: Create a new security filter, as shown below: Open the user created in step 1 using the User Manager and go to the Security Filter tab. 'This online training video demonstrates how to create transformation objects in MicroStrategy. Create a compound metric called B with expression "RunningSum(A)" as shown below. 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. Further information can be found in KB30310: How to create a Freeform SQL Report in MicroStrategy Desktop 9. It is important to design the correct filter to retrieve the desired data. The New Grid dialog box opens. On the Freeform Sources tab, select Create Query Builder report. 33K KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. Create Dossier: Create a new dossier. If Apply only to displayed objects is selected, the Report Data Options are applied to only the objects displayed in the Summary pane, rather than all the objects selected in the find process. Select the function to use to calculate data in the metric. Open a report in Graph View. You can create a report to serve as a template for other reports; for details on templates, see Designing a report's structure: Templates. On the Freeform Sources tab, in the Source area, select a database instance for the data source to. For example, facts are used to. If the New Filter dialog box is displayed, click the Empty Filter icon. under the "Insert" menu. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. 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 . It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. From the list of available objects, select the objects to be used as default values for the prompt and click on '>' to add them to the list of selected objects. To Create a Metric. x. TTF format) and install the file. 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. Open MicroStrategy Developer and create a new Database Instance under the Database Instance Manager. Run both reports after enabling the metric levels log. Clear the Totals check box to remove the standard subtotals. A report with this metric follows: Notice that the report is now sorted ascending by the day attribute. x and 10. Let’s look at another example. 3-5 + years experience developing enterprise reporting / BI solutions. On the Freeform Sources tab, select Create Freeform SQL report. x. KB4377. Get an overview of the process! 2152 views · September 02, 2020. Format the report as desired. properties file for editing. x? The following report shows the top 3 Suppliers which offer the best price per Item: MicroStrategy Developer is ground zero for developers when it comes to creating the powerful analytics and crucial decision support workflow. Create Document. Displays or hides the. Change the formatting of the percent to total with the appropriate settings (decimal places, negative value formatting, etc). Navigate to a prompted report and click Insert. x and newer on Windows and Unix/Linux; Knowledge Base: How to perform a License Audit in MicroStrategy Intelligence Server 10. In MicroStrategy Developer, you can view dashboards, with a limited range of interactivity. and add other MicroStrategy users to a report or document subscription: SUBSCRIBEOTHERS: Web use advanced threshold editor: use the Advanced Threshold Editor:This tutorial shows how to create a new user in Workstation and assign basic privileges to the user using the Application Access & Roles tab. x. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. 4. Go to the 'Database Instance Manager'. From the Data menu, select Configure Bulk Export. The Bulk Export Setup dialog box is displayed. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. You can create customized, interactive dashboards to explore your business data. 5. Categories. When 'Save Options' appear, choose the first option, as shown. The Select a Function. Create compound metric "Rank Day" with the metric generated in step1. The object's editor or wizard opens. 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. Click Save. The Filter Editor opens. 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. Open a report in Graph View. A prompt is a question the system presents to a user when a report is executed. x: Create a metric called A with expression "Min(1){~}" as shown below. In the view filter choose. '. Note that. 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. NOTE: Users must be granted 'Create Application Objects' and 'Use Template Editor' privileges. Right click the project and select Project Configuration. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Learn how to switch to a compound grid, add column sets in this new visualization. Log in to Workstation with a MicroStrategy user, for which has not been granted the privilege ‘Use Freeform SQL Editor’. 4. After that, when users select some elements, the 1st text box will display selected elements and covered the 2nd one. ) User can now select the Gotham Medium font in Developer. 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. 5. While this procedure creates only Filter derived elements, you can create any combination of Group, Filter, and Calculation derived elements on a report or Grid/Graph. and the new filter created in Step 1. To Subscribe to a Report or Document. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. ; On the Freeform Sources tab, select Create Transaction report. The Green area on the scroll bar corresponds to. In the Multiple objects text box, search for and add filters to use when displaying objects in the prompt. x does not allow prompt answers to be entered when subscribing prompted reports or documents. However, in order to estimate when a report was originally scheduled within MicroStrategy Developer and Web, Enterprise Manager can be utilized to display the first instance of job execution initiated by the schedule. From the MicroStrategy home page, click New Metric . The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. Click the name of a report to execute it. x SYMPTOM: Dynamic dates can be employed to create a year-to-date report, or even a year-to month report. Type a name for the metric in the Metric Name field. All Objects. The Results Preview dialog box opens. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. x. From the File menu, select New, and then Fact. When you are done, click Close to return to MicroStrategy Developer. Click Save. Choose Add Data > Existing Dataset to add data. In the Navigation pane, click Projects. You can also create an Intelligent Cube that contains data from an MDX cube integrated into MicroStrategy from an MDX source such as SAP BW, Hyperion Essbase. x. x. Click OK. In this example the sorting of region will always be done by a rank of the most recent revenue that the region has. For a document, edit the document in Design Mode or Editable Mode. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. refer to the MicroStrategy Developer Help (formerly MicroStrategy Desktop Help). 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. In MicroStrategy Developer, choose File > New > Filter. MicroStrategy Developer — Reserved for administrator use, MicroStrategy Developer is a standalone application you access on the computer where MicroStrategy software is deployed. Make sure the Category attribute has the Image form as a Display form. The following code demonstrates how to programmatically create a new report with data and set its graph type using MicroStrategy Web SDK 9. Right-click on the report and choose 'Edit'. 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. Go to 'Data' on the top menu bar. Related articles from the Community: Knowledge Base: How to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 1. The transformation to apply to the metric has already been created. From the Home menu, select Design mode. The result is as follows for prompt answer = '1/12/2003':About custom groups. For this example, the filters Year = 2004 and Region = Northeast, Mid-Atlantic, Southeast,. Create a second report with the year and quarter attributes and the revenue metric. The following steps instruct how to get the latest 2 days data in the report. The following is an example of a 'Customer Geography' consolidation: Save the consolidation. To Create an Intelligent Cube Using Freeform SQL or Query Builder. Create a report with Region and Quarter in the rows and the metrics Revenue and Inter Metric in the columns. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. To Create a Report from Scratch Log in to the project in which you want to create a report. 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. In MicroStrategy Agent, go to Schema Objects. Bulk Export options are only available in MicroStrategy Developer. In addition, they can be included in Report Services documents in the same way. How do users create a simple metric? Double-click on any fact from the Object Browser to define a new metric. Create a Filter with the Date attribute. To build an Intelligent Cube. Open the cube report in Design View. The following procedure describes how to create a dynamic date filter based off of a prompt answer. 1. 3. , Attributes, Facts, Hierarchies, partition mappings, Tables or Transformation). A report template is created by report designers using MicroStrategy Developer. While database instances commonly point to a relational database, you. How to Programmatically Create a New Report with Data and Set its Graph Type Using the MicroStrategy Web SDK 9. Creating a new FreeForm SQL report or Query Builder report in Developer In Microstrategy versions previous to Microstrategy version 9. Select Add Subscription for the type of subscription you want. x?Creating a Custom Group. It is important to design the correct filter to retrieve the desired data. Open the Filter Editor and select the 'Add an Attribute qualification' radio button. rpkeller. Add objects such as attributes, metrics, and so on for the Intelligent Cube, the same way you would add report objects. Select MS Excel Worksheet from the Application drop-down menu. Revenue + Profit. Click on Browsing Options and `Display hidden objects. "Sales" as metric. This opens the Project Documentation dialog, as shown below:In MicroStrategy Desktop/Developer 9. Watch on. Save the report as R1. ? In some business scenarios, administrative users have a calendar master table. Right mouse-click this folder and select 'Search for objects. To add a transformation to a metric. If you creating a prompt for a filter, click OK to save the prompt in the filter. Put this Prompt inside a metric, as shown below: Create a report and put this metric in the Report objects window. Provide a number greater than the highest value in the y-axis to create the smooth curve. Double-click the attribute to edit. You can create a report to serve as a template for other reports; for details on templates, see Designing a report's structure: Templates. Click Save. In the Project Source Name field, type a name for the project source. Custom: (Prompt created in step 1)-6. 1/10. Click the General tab. Login to MicroStrategy developer as administrator. Drag and drop the reports into the Dataset Objects panel of the Document Editor. To enable totals and subtotals for a specific report, follow the steps below: Right-click on the report and select 'Edit'. This tutorial shows how to create derived attributes and metrics in a dossier. Use the subtotal created on the 'End on Hand' metric in the report, as shown below: Create an auxiliary metric that uses the 'End on hand' fact but aggregates values one level higher than the one in the report, as shown below: Create a subtotal based on the auxiliary metric, as shown below:Under Elements for this consolidation, right-click and select Add Element. Open an MDX cube report for editing, or create a new MDX cube report, as described below: To edit an MDX cube report, from MicroStrategy Developer, right-click an MDX cube report and select Edit. To view page-by section of the report, choose View > Page-by. Download the PDF manual and get started with MicroStrategy Office today. You create and interact with dashboards in MicroStrategy Web. If you want to create the metric by defining the metric's formula directly, see Metric Formula Editor. You need the Define Derived Elements (Developer) and/or the Web Define Derived Elements (Web) privileges. EXAMPLE. . Application objects such as reports are used to analyze and provide insight into the relevant data. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. x. Dynamic dates are created in MicroStrategy Developer by using the Filter Editor. The final report you create with Filter derived elements is shown below. x, first open the Freeform SQL report Editor to create a new report. 4. Metrics are quantitative measures used to analyze the data in the particular context. 4. 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. From the File menu, go to 'New 'and choose 'Report'. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. In The Logical Data Model, you learned how to use hierarchies to group related attributes in practical business areas. 2. From the Source table drop-down list, select the source table for the fact. Complete the dialog with the source folder, package name, class name. Select one of the following: Create Freeform SQL report: To create a report using custom SQL statements. Create a report in MicroStrategy Developer with the attribute 'Region' in the row section and the metric 'Cost' in the column section, as shown below:If a virtual attribute A is defined based on column A1 from Table 1 for a Freeform SQL report, the same virtual attribute A can be used in another Freeform SQL report even though the attribute in the second report is based on another column, Column A2 from table 2 in MicroStrategy Developer 9. x. 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/. Right-click the filter, and select one of the following (the options are described in more detail above): Replace Report Filter with a. Sr BI Java Developer - Jasper - Washington DC Area. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Revenue + Profit. How do users create a template? In the Template Editor, from the Object Browser double-click the on attributes to be added in the Template definition. Using MicroStrategy Developer, log in to a project connected to an MDX cube source. Configure Bulk Export. Click the Find Now button. To Create an Event Using Command Manager. Subscription Creation Wizard in MicroStrategy Developer 9. x - 10. The Report Editor opens. . Number of Views 1. How do users create a template? In the Template Editor, from the Object Browser double-click the on attributes to be added in the Template definition. The New Grid dialog box opens. yaml. For the example scenario, create a report with Item, Revenue, Profit, and Profit Margin on the report, as shown in Creating a view filter on a rank range of metric values. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. Choose Reports/Documents to be scheduled (Answer the prompts, if any) and click Next. Hover over a function in the Functions panel and click Edit. Save this report and add it with formatting to a new Report Services Document using the Blank Dashboard template. Navigate to Pages. For information on connecting to databases, see Connect to Databases. When user selects nothing, both text box will be hidden so nothing displayed. . Choose False for ASC. 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. 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. Other types of objects such as Report Services documents or shortcuts might be displayed, but this will be because of the dependency in the underlying dataset report(s) or target report respectively: The dependency should be manually removed from all the reports listed in the above search by editing them from MicroStrategy Developer. MicroStrategy Developer MicroStrategy Developer is a client interface that was conceived while thinking of an interface that the majority of the developers and users are familiar with: Windows Explorer. Navigate to a prompted report and click Insert. With MicroStrategy Developer Library, learn how to download the MicroStrategy Mobile SDK through the MicroStrategy Community Product Download. MicroStrategy users can format how the values of metrics and attributes are displayed on their reports. In MicroStrategy Developer, from the File menu, select New, and then choose Report. How to avoid: By default, MicroStrategy uses database connection caching. This setting for Developer is in the Project Configuration Editor (Project definition category. 3. Right click on the ' report (Report Execution) ' page and select “ Create New Add-on ”. Open the gcxi. From the Tools menu, select View Filter. The steps below illustrate how to create a report where users can prompt for threshold values in MicroStrategy Deveoper 10. . Click Blank Report. The reason for the case statement is that the value for. Do one of the following: For a report, click the name of the report to run it. Create a Prompt using Prompt Generation Wizard in MicroStrategy Desktop/Developer. To Create a Report Using a Template. To save the prompt. Click OK. x - 10. information. The document is split into two parts, the preliminary steps that need to be completed through MicroStrategy Developer and the steps that are needed in MicroStrategy Narrowcast Server to create a dynamic. Select Level Dimensionality. You can also display dashboards on an iPad with MicroStrategy Mobile. Select Project Sources and click Next. For a complete discussion of metrics, filters, reports, and other report objects, see the Basic Reporting Helpand the Advanced Reporting Help. ; On the Freeform Sources tab, select Create Query Builder report. In this tutorial, you learn how to create a dashboard dynamically using a template and existing. You can narrow the list of functions displayed in the pane by doing one of the following: To search for the function by name, type the. To Create an Event Using Command Manager. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. Security filters are similar to regular MicroStrategy filters, but they have a limited number of qualification types they can be defined with, and they apply to a user or group for all reports across a project. It should bring back all the reports in the folder. x SUMMARY: This Technical Note shows how a user can. Now create the Pareto Percentage by creating a new metric that divides RunningSum with this grand total metric, as shown below: For clarity, put all the metrics on the report as shown below, and the correct sorting is done by selecting the percentage metric and clicking on the 'Ascending' Icon:To Create a Query Builder Report from an Excel File. You can also begin creating reports in MicroStrategy Developer and MicroStrategy Web. As you can see from the Outline window below (this shows all. How to create a Report Service document with "image" attribute form displayed in grid but not in the selector for the same attribute in MicroStrategy Developer 9. x-10. 2) Go to the Data menu > Edit Drill Map. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both. Click the General tab. The follow implementation uses the system date to qualify on the current and previous months for data models using the month dimension format of 'YYYYMM'. Click Add a New Dynamic Address List. You are returned to the New Filter page. Microsoft Windows Explorer is a tool that helps the user to visualize, manage, organize, create, and delete files in a PC. After selecting the dates, the report will show data between the date chosen, and the date set in your custom expression at the end of step 3. You can also begin creating reports in MicroStrategy Developer and MicroStrategy Web. Expand the Object Templates category, select General, and from the Show templates for the. Select the object you want to base your filter on: To base your filter on an object that is part of the report's definition, use the Report Objects pane on the left and. MetricA will serve as the starting data point. In the Password field, enter the password that is paired with the user ID entered in Step 2. If the New Metric dialog box is displayed, click the Empty Metric icon. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. Option 1: Create a prompt using the Prompt Editor. In MicroStrategy Developer 10. 4. 4. In MicroStrategy Developer, from the File menu, point to New,. Create a new, empty report. The Freeform SQL Editor opens. In. Notes. Use Developer to create and manage projects, objects and users, and to perform other administrative actions. Right-click an object in the Grid/Graph and select Edit Links, as shown below: The following link editor opens: Click New to create a new link.