From the File menu, go to 'New 'and choose 'Report'. 1 and 10. Sr BI Java Developer - Jasper - Washington DC Area. Log in to Workstation with a MicroStrategy user, for which has not been granted the privilege ‘Use Freeform SQL Editor’. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. In a document, right-click a grid/graph displayed as a grid, and select Edit Grid. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. In MicroStrategy Developer, choose File > New > Report. Custom: Prompt created in step 1. x, a separate 'Rank' metric needs to be created. x - 10. x and the SQL Engine is not generating the where clause as expected. Create a report named Year Revenue Report with Year attribute on the row and Revenue, Last Year's Revenue & Percentage Change in Revenue metrics on the column and run it as shown below: Notice that the percentage sign (%) is displayed with the values under the Percentage Change in Revenue metric. In MicroStrategy Developer, the report SQL View shows this time as "Total Other Processing time" in summary and as "Other Processing Time" in the first SQL Pass. Field: Date. and the new filter created in Step 1. The object's editor or wizard opens. To save the prompt. As the password characters are entered. Select one of the following: Create Freeform SQL report: To create a report using custom SQL statements. Create a metric called "Metric Day" with Day attribute. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. MicroStrategy Developer is an advanced, Windows-based environment providing a complete range of analytical functionality designed to facilitate the deployment of reports. Place the newly created consolidation in the template. 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. Create a compound metric called B with expression "RunningSum(A)" as shown below. A list of the users that belong to the selected group is displayed. NOTE: Users must be granted 'Create Application Objects' and 'Use Template Editor' privileges. Provide a number greater than the highest value in the y-axis to create the smooth curve. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy Developer help. , Attributes, Facts, Hierarchies, partition mappings, Tables or Transformation). A report filter in a report is not being applied in MicroStrategy Developer 9. Click Blank 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. . The New Grid dialog box opens. 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 . If the New Filter dialog box is displayed, click the Empty Filter icon. For more information, see Permissions and Report/Document Execution. Navigate to a prompted report and click Insert. This icon is available if the document was created based off of a graph report with the Manual Layout option enabled. All Objects. x: Create a value prompt and set the limits and the default answer. From the left, select Dynamic Address Lists. About dashboards. MicroStrategy Workstation Become a More Intelligent Enterprise Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Create a metric 'MTD Revenue' with fact 'Revenue'. Triggering Events. xFor example, the Use permission on a metric allows a user to create a report containing that metric. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. 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. 4. Create a Prompt using Prompt Generation Wizard in MicroStrategy Desktop/Developer. . Filters ensure that the report results contain only the data that answers the specific business query the report was designed to answer. Select the appropriate options to define the dynamic recipient list, as described above. Create a filter “Category do not end with c” with definition below: This filter will filter out Category elements with character “c” in names. x: Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. Go to the Object Types tab and check the box for 'Report. 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. ARCHITECT VIDEOS & TUTORIALS. To use time zone based reporting you must enable the feature and set a default time zone for a project. For steps, see Interaction of Report Details Preferences and Report Details for Reports. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. The Subtotals dialog box opens. The attribute is given a default name and is displayed in the table. Type the following for the name: "Total for the #P #0". Navigate to Pages. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. For a complete discussion of metrics, filters, reports, and other report objects, see the Basic Reporting Helpand the Advanced Reporting Help. If you creating a prompt for a filter, click OK to save the prompt in the filter. Note: If you use gcxi-secrets. You can create customized, interactive dashboards to explore your business data. 4. Open the Workstation window. x or earlier to version 9. Click on the "Validate" button to validate the formula. Create a report with Region and Quarter in the rows and the metrics Revenue and Inter Metric in the columns. 7) Within the report editor -> Data -> subtotals, select the Total subtotalAs shown below: Put 1st text box above 2nd text box, and apply background color to 1st text box so that is covers the 2nd one. MicroStrategy does not provide out of the box functionality to filter a report on metric subtotals because the subtotals are processed in the Analytical Engine after the result set has been retrieved. Select a prompt answer and click Apply. Log in to the project in which you want to create a report. The DIReportID is the metadata id of the data import cube. x-10. You cannot create fact level extensions using Architect. ; In the Source area, select the database instance for your Excel file. 4. 4. If a dialog appears, click OK. All articles. 4. 4. The location in which you begin browsing for objects is defined in the Report Options dialog box in MicroStrategy Developer. 2. From the Insert menu, select New Metric. Create a new report in the Report Editor as follows: Add the Category attribute to the rows. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the. Make sure the Category attribute has the Image form as a Display form. When user selects nothing, both text box will be hidden so nothing displayed. When a project is upgraded from MicroStrategy version 7. In MicroStrategy Developer, choose File > New > Report. Follow the steps below to create a prompt-in-prompt. Choose Add Data > Existing Dataset to add data. Specify the project source of the project to be duplicated. You will see that R2 still displays the first 6 months data. 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. 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. A developer can build simple or compound metrics, apply to them many additional features like conditionality, level, transformation and also specify the formatting. Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. To learn more about how to deploy your project using MicroStrategy Web, see the Installation and Configuration Help. To create a custom expression filter, the Advanced Qualification Editor must be enabled in the user's project preferences in MicroStrategy Developer 9. Add the report created in step 2 as dataset report of the document which is required to display yesterday's date. The Fact Editor opens, with the Create New Fact Expression dialog box displayed on top of it. ; Enter the XQuery statement required to connect to the third-party. The search object must search within subfolders. Select Add Subscription for the type of subscription you want. For information on connecting to databases, see Connect to Databases. A report with this metric follows: Notice that the report is now sorted ascending by the day attribute. Select 'Configure Bulk Export': Specify any additional desired configuration options. KB5078: How to create a value prompt in. Select 'Qualify on a Metric' in the Prompt Editor as shown below: Select the metric 'Revenue',. 4. 4. To create an attribute form that allows the attribute to display a name in the format of 'Last_Name, First_Name' in MicroStrategy 10. x. To access the Link Editor, do one of the following: In a report, right-click an object and select Edit Links. Each prompt must be part of a filter before it can be included in a MicroStrategy Developer 10. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Introduction MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and. The New Intelligent Cube dialog box opens. Input the metric formula. In MicroStrategy Developer, use the Folder List on the left to navigate to the folder where you want to store your new filter. In the MicroStrategy Tutorial project, create a report with attribute Category and metrics Revenue and Profit, using MicroStrategy Developer 9. In The Logical Data Model, you learned how to use hierarchies to group related attributes in practical business areas. Use the following table when considering how and where to add a prompt to a report: Prompt type. Create a threshold using this metric to. To choose the 'Rank Order by' properties, select 'Rank Parameters' in the Metric Editor. Format the report as desired. x does not provide ability to add row numbers in grid reports. " Select "Use a filter to reduce the number of elements" and select the "QUARTER FILTER" created in the previous step. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. Run a report in Grid View. The Object Browser on the left-hand side lists all tables and columns that have been imported into the project. 4. This may be a physical table or view in the warehouse, or it may be a logical view defined in MicroStrategy. How do users create. Administrators no longer need to install Narrowcast Server on the machine where. In. To view. This video presents how to create a report in the MicroStrategy 9 Developer (here referred to as “Desktop”). To Create a Transaction Services Report. For steps to use an existing template to create a new report, see How to Create a Report Based on an Existing Template. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. From the Folder List, browse to the folder which contains all the reports to be documented. Expand the Object Templates category, select General, and from the Show templates for the following objects list, select Report. The options for exporting the report to a Microsoft Excel worksheet are displayed. You are returned to the New Filter page. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. Hover over a function in the Functions panel and click Edit. The derived attribute can be a string, number, or date. However, the user can simulate the same feature by adding a metric with "RunningCount" function. 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. Create a second report with the following: "Region" as attribute "Sales" as metricTo create a link. It is important to design the correct filter to retrieve the desired data. 4. Under 'Source tables', select a table and click 'Set as Lookup'. To access the Metric Editor, execute the following: From the File menu, go to New and choose Metric. Give the link a name. Go to 'Data' on the top menu bar. The Green area on the scroll bar corresponds to. 3. In MicroStrategy 9. Click Blank. To save the prompt. Create a standalone metric that calculates the Top 10 Revenue values. Click 'Next' after the introduction. When creating Freeform SQL reports, you can use the SQL statements that you previously defined or create new ones from scratch. GIS lets business users visualize data in forms such as maps, globes, reports, and charts so that they can identify and analyze relationships, patterns, and. A report template is created by report designers using MicroStrategy Developer. 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. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. If the New Metric dialog box is displayed, click the Empty Metric icon. Change the metric join type to 'Outer'. Drag and drop the objects into the report grid from the. Click OK. Create an Intelligent Cube with Date and Revenue with tutorial data. Option 1: Create a prompt using the Prompt Editor. A report template is created by report designers using MicroStrategy Developer. Add the attribute Subcategory and metric Revenue to the report template. 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/. x. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. x - 10. yaml to store secrets, edit it instead of gcxi. Follow these steps to enable drilling on metrics: In MicroStrategy Developer. The New Grid dialog box opens. 2. ; Enter the XQuery statement required to connect to the third-party. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). Select 'Configure Bulk Export': Specify any additional desired configuration options. Create a cube report. In the Navigation pane, click Projects. Number of Views 1. 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'. Drag and drop the reports into the Dataset Objects panel of the Document Editor. Step 3: Create a new filter that is a shortcut to report pointing to the report created in Step 2. 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. x - 10. x, there is a graph called Pareto (Percentage). The window will not appear when creating a new report if the checkbox to not show the dialog box in the future is checked. Select the appropriate options to define the dynamic recipient list, as described above. The Year - Define a new member attribute. Click Advanced, then New to create a custom subtotal. 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. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. In MicroStrategy Developer, prompts can also be created as an intrinsic part of a given report, filter, or custom group, at the same time. This filter, which will be used on the report, qualifies on the current date. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. 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. Role: Microstrategy Developer / Tester Confidential,is an IT Service firm offering IT solutions to different organizations in banking, retail, Credit services and Telecommunications &. Place only the lowest level filter in the filter section of the report. The new template should be viewable when prompted to choose a. 4. The Create New Attribute Form dialog box now appears. 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. How to avoid: By default, MicroStrategy uses database connection caching. In MicroStrategy Developer, from the File menu, select New, and then choose Report. John is the MicroStrategy administrator in Acme. Tutorial project is used here. MetricA will serve as the starting data point. Follow steps below to find out all the Freeform SQL Reports in a project in MicroStrategy Developer: Log in to the project from Developer and click the search button. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. Modify the SQL statement or the column mappings as needed. Type a name for the subscription in the Name field. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. A window, as displayed below, appears: Assign a Cost Range for reports by either using the horizontal scroll bars or the text boxes. How to create a report that shows the beginning and ending values of a date range on the template in MicroStrategy Developer 10. Add the Report attribute to the rows. Click 'OK'. Add To Report Editor: Template Definition Pane. 12K subscribers Subscribe 18K views 3 years ago Explore how to add templates, attributes, metrics, filters, and. The Manual Layout option is located under Graph Preferences for a report in MicroStrategy Developer. x that will display the top 'n' Item sales (variable) for each Subcategory within a Category , the final report will appear as follows, where the column Custom_Group is the variable that changes as the data in the warehouse is updated. has a MicroStrategy implementation with 4 environments: Development, QA, Mirror, and Production. Double-click the attribute to edit. Once the report has run, right click the Category attribute. 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. '. Do one of the following: For a report, click the name of the report to run it. Click the name of a report to execute it. The 'Select Objects' dialog box, where objects can be chosen to be available to the user at runtime. In this example, the Year attribute is used. Filters are most commonly used on reports, to filter all the data the report would otherwise retrieve from the data source and display. 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. To access the Metric Editor, execute the following: From the File menu, go to New and choose Metric. 1, users now have the ability to enable this behavior at the attribute level, so that when an attribute form is set as a Report Sort form in the Attribute Editor, the attribute will sort by that form in all reports by-default, even if that form is not present on the report at all - not even in. Create Document. Choose Add Data > Existing Dataset to add data. Create a report with Subcategory, Item, Rank Metric (created in Step 2) and Revenue. 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. This target report inherits VLDB properties, including attribute outer join settings, from the parent report. Qualifications are the actual conditions that must be met for data to be included in the custom group element. x-10. x. 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. Ship Date stands in for the invoice and due dates on the document. Community & Support Search Discussions Open A Case View My CasesTo Create an Attribute Qualification Using a Dynamic Date Create the Today Filter. The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, DELETE, and GET. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. 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. It is designed to help developers build data-driven client applications quickly and easily. x? In some business scenarios, it is required to create a Report Service document with "image" attribute form displayed in grid but not in the selector for the same attribute. x. MicroStrategy Web can also be integrated with mapping services to create sophisticated Geospatial Information System (GIS) applications through the use of MicroStrategy GIS Connectors. You can create events with the following Command Manager script: CREATE EVENT event_name [DESCRIPTION description]; By default, this script is in the folder C:Program Files MicroStrategyCommand ManagerOutlines. They are metrics that are saved and displayed only on the specific report on which they are created. x?Creating a Custom Group. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. 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. If the View Filter area is not displayed, from the View menu, select View. Step 4: Attach the newly created filter (Step 3) to either a report or prompt. 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. . For information on training metrics and creating predictive. Right-click on the report and choose 'Edit'. Click OK to exit the Freeform SQL Editor and. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. On the Freeform Sources tab, select Create Freeform SQL report. Create a selector on metrics, targeting the graph in step 3. The only difference is that for each of the three different Null value handling categories shown below, at the Report. To obtain the Project Documentation for only reports in a certain folder in MicroStrategy Developer, follow the steps below: Log into MicroStrategy Developer. Any physical table in the project database instance can be used in the SELECT statement. The following two options can be used in defining each prompt as part of a filter. In the Source area, select a database instance for the database to access using Freeform SQL. The following procedure describes how to create a dynamic date filter based off of a prompt answer. This defaults to creating a SUM (fact). 1. A report template is created by report designers using MicroStrategy Developer. Building reports from scratch A simple report generally has at least one attribute, one metric, and one filter. Click 'Save and Close' to exit the Report Limit Editor. It is important to design the correct filter to retrieve the desired data. 2. This steps below describe method to create a value prompt for each row of a report that has n rows and these rows correspond to elements in the Top n Rank of a metric in MicroStrategy Developer Consider a report that has Item attribute, Revenue metric and Forecast Revenue metric. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. This video is private. To do this: a. From the 'Edit' menu, choose 'Group'. If installed over previous versions of the product, the folder remains the same. Today’s top 12,000+ Business Intelligence Developer jobs in United States. Click in MicroStrategy Web Configuration in Application Settings view to expand the hierarchical tree. When an OLAP report is created from an Intelligent Cube, some users may have difficulty adding prompt objects to that report. Create a new document. From the Elements menu, choose Add Element. 4. 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. To Create a Report from Scratch Log in to the project in which you want to create a report. 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. This forces the calculation of the MovingSum to no longer be based on the preceding revenue values but. To Create an Event Using Command Manager. Next, right click anywhere under the data source tab and near any of the measure fields. The object's editor or wizard opens. Notes. Choose the project for which the security filter is used and associate the user with the. In the Data Source dialog, select Reports. The custom reports that you create might. Logical views can be created in MicroStrategy Developer using the Table Editor, which is shown in the image below. Logical views can be created in MicroStrategy Developer using the Table Editor, which is shown in the image below. Create a filter on attribute "Month" and click "Prompt. x and newer on Windows and Unix/Linux; Knowledge Base: How to perform a License Audit in MicroStrategy Intelligence Server 10. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'. Perform one of the following actions to specify an object prompt: Select 'Use a pre-defined list of objects' and click on 'Add. x and higher To create a list of reports with VLDB settings different from the default values, follow the steps below: Creating and Adjusting Titles in MicroStrategy Developer. Watch on. 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. To create a report filter qualification. SCENARIO. When 'Save Options' appear, choose the first option, as shown. Metrics are quantitative measures used to analyze the data in the particular context. This occurs when the data type of the attribute is timestamp. For example, the Use permission on a metric allows a user to create a report containing that metric. The Object Browser on the left-hand side lists all tables and columns that have been imported into the project. For information about creating reports in MicroStrategy Developer, see the Basic Reporting Help; for creating reports in MicroStrategy Web, see the MicroStrategy. 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. 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. You can also create, edit, or delete multiple custom groups at the same time by using a Command Manager script. 4. x can help users create a report filtered on the report subtotals. Involve in creating users, groups, assigning rights to users or groups, scheduling reports, managing servers using CMC. Edit the predefined text for the Prompt title and instructions. New Business Intelligence. One of the other functions of MicroStrategy Developer is to create projects. x. Save this report and add it with formatting to a new Report Services Document using the Blank Dashboard template. If you do not want this dialog box to be shown in the future,. Run both reports after enabling the metric levels log. Follow the steps below to create the base metric: Open the metric editor and create a new metric. 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. Use Developer to create and manage projects, objects and users, and to perform other administrative actions. In the View filter, click Add Condition. 1. To create or edit a database login, perform the following steps: In the Database Login field, enter the name of the database login. This technical note lists the steps to create a grid report showing Pareto (percentage) or cumulative percentages in MicroStrategy Developer 9. Environment: Microstrategy Desktop 8. Create a table to relate filtering dates to the dates in the month up to and including the filtering date. Double-click Time to open the folder, then double-click Year. This technical note describes the steps to create a report that displays a row for each of the months in a year up to a month specified in a report filter qualifications in MicroStrategy Developer 9. Subscription Creation Wizard in MicroStrategy Developer 9. 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. 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-10. x - 10. Right click on the ' report (Report Execution) ' page and select “ Create New Add-on ”. 06K. Creating a Report MicroStrategy Community 4. As you can see from the Outline window below (this shows all. x-10. Create a blank dossier or open an existing one. Click on the "Validate" button to validate the formula. Click OK to accept your changes, and then repeat the previous step to open the New Grid dialog box. 4. MicroStrategy Command Manager can trigger. For example if it is desired to add object prompts when using report builder the steps below can be used. For example, the value of this metric will be one. 4. Firstly, launch MicroStrategy Developer, open a project and go to a folder where you want to create a report. On the Freeform Sources tab, in the Source area, select a database instance for the data source to. Log in to a project in MicroStrategy Developer. While database instances commonly point to a relational database, you. Click Select. In MicroStrategy Developer, choose File > New > Filter. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. This tutorial shows how to create derived attributes and metrics in a dossier. In the filter editor, select 'Add an attribute qualification' as shown below. x. Add the metric "RP First Job.