To Create a Dynamic Date Based on a Prompt Answer Create the Date Prompt. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. You can qualify the condition based on the attribute element's ID form, one of its description forms, or the DATE form if the attribute is time-based using the radio buttons. Click the name of a report to execute it. This type of prompt allows users to determine how the report's data is filtered, based on attributes in a hierarchy, lists of attribute elements, or metrics. Highly formatted MicroStrategy reporting. If you are on a folder page, click Create on the icon bar on the left, then select New Metric. The prompt and its default or personal answer are ignored because the prompt is not required; the report is executed, but it is not filtered by the prompt. To not display a search box, select False. Select the Repeat attribute column checkbox to display the attribute. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. Observe the selection box next to the text box is automatically changed to "Simple Prompt". A screenshot of the VI Dashboard in Design Mode; A Screenshot of the Diagnostics and Configuration Tool on the Diagnostics Configuration tab. Slice and dice features are awesome. Or, you can create a prompt that displays the Day, Month, Quarter, and Year attributes to users, so the user can specify the granularity of the report. Includes scorecards. and. If you created a new dossier, you must save the dossier before adding an existing dataset. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. A prompt allows a user to provide an answer to restrict or filter data during report execution. The Grid Settings section allows you to select the Fit to page option, which fits the grid's width onto one PDF page width, or you can select the Allow horizontal pagination option, which breaks a wide grid onto numerous pages. Choose File > New Filter. I need to pass the Username to the SP. Next, select an operator from the Operator list. x and. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. This prompt is used in a filter. Open the document or dashboard in Design Mode. This prompt, which will be used on the filter, asks the user for one date. To apply default formatting and behavior to grid reports project-wide. 3. MicroStrategy does a quick search for the entered information and can't find a single object that lines up with it. MicroStrategy 9. Whenever you use a view report instead of the intelligent cube, the MicroStrategy Analytical Engine (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Attribute is lost from reports/dashboards that use a cube whose attribute was linked to another attribute in a VI dashboard in MicroStrategy 9. (You can add more than one prompt to a filter. Choose a project to contain your filter and click Select. x. Get inspiration at the MicroStrategy data dashboard gallery. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. Using system prompts, users can use. x, no data is returned on the grid when a geo-attribute is directly added to a Dashboard via Web using the 'browse all objects' option. Double-click the attribute to edit. Add this report as a dataset in a Report Services document. Click Next. There is a technote that explain how to build the URL to set a selector to the default value that you prefer: TN46649: How to use Mobile URL API to pass hard-coded (default) selector answers to a target document in. Drag the prompt onto the Definition pane at the bottom right, as shown in the image below:Create a date prompt to accept the date. This course is intended for business and. For example, you can stack two panels, each containing a different Grid/Graph. The prompt wizard will be launched. While privileges are assigned to users (either. Remember that you are telling a story with your data. Anyway this is good for the users, because they can change the prompt answers if they need. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. These custom prompts give you more control than the default edit links and can come in handy when advanced developers want to get creative. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. Each button can be configured differently and. Check available Attributes OR; Use View Filter grid > [+Add Condition] to open a list of. Unlock new opportunities within your existing customer base, and place bets to bring in new accounts. What is dashboard in MicroStrategy? MicroStrategy – Creating Dashboard A dashboard is made up of multiple visualizations. Right-click the metric sales, and we get the option to choose the threshold as shown in the following screenshot. KB46894: How to directly email a link to a report and dashboard in MicroStrategy Analytics Enterprise 9. x. A product bundle (including Web, Intelligence, Analytics, and Distribution) designed to meet the specific needs of power users who create, design, analyze, share, and save MicroStrategy Dossiers, reports, and documents. Value prompts are typically used in filters, but they can also be part of a metric formula or a custom group. Express Mode (formerly named View Mode) Intended for document analysts that need to view information rather than create and edit documents. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. In MicroStrategy Web, you can interact with a dashboard in the following ways: View the data as a grid, graph, or widget. Click the name of a report to execute it. The 'Choose a Prompt Style' dialog box opens. "System Prompt" is a system object that was introduced back in version 8. Yon can use an object prompt in your report to select attributes on. A dossier is an interactive display that you can create to showcase and explore business data. "KB11113: How to use prompts to return attribute element values within an Apply statement in MicroStrategy Developer and Web When using any of the Apply statements in conjunction with prompts used to select attribute element values, it is necessary that a value be returned as an argument into the function of the statement. Create Dashboard A with the above report as the dataset. 2. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. x - 10. Companies that use MicroStrategy may need skilled professionals to fill the following roles: MicroStrategy developers: Create and maintain tools that simplify business data analysis within MicroStrategy. 1 introduces a new feature - the ability for users to define a freeform condition in a Freeform SQL or XQuery report that can be targeted by a Unit Condition selector on a grid in a Report Services document or dashboard in MicroStrategy Web. But it is easily accessible to everyone thanks to its sophisticated analytics. Build a User attribute that maps to this column in each fact table and define a security filter User = ? so that each query will qualify on User to restrict access to data. You can create two security filters, let call them: MyAttributeEqual1. Create a Child selector inside the Child. MicroStrategy Visual Insight was included with the standard user licenses, had a flash based engine and it was working only on web (and mobile). More than 90% of field employees at Merck now use the MicroStrategy app—and it’s helped grow their bottom line. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. For example: OR. Create a blank dossier or open an existing one. Experience the platform yourself! Request a pilot and a member of our team will contact you to understand your business needs and demonstrate how MicroStrategy can help. You can: View the results of the document. Right-click on a dossier. The prompt wizard will be launched. MicroStrategy Intelligence Server also provides scalability to analyze any amount of data, support for any number of users and a 24 X 7 operating environment, with robust security. In the database warehouse, there is a table called. and 10. Level prompts – One can determine the level of aggregation calculation of metrics. Create a filter on attribute "Month" and click "Prompt. Click Certify. When you create a metric there are two tabs (in developer/desktop), on the first tab you enter the formula for the metric, on the second page you can set what formulas to use for aggregation, (i. The platform can be implemented on a gradual and as-needed basis, so users can start small and scale to enterprise-level deployment. What is percent-to-total shortcut metric in Microstrategy? Percent-to-total shortcut metrics display the percent in relation to a selected total of each item affected by the metric. Save the filter as "Region Filter". I could read on the MSTR site that the difference between Dashboards and Documents is the following: Document is a editing and formatting of report in a prescribed manner. It also provides resources to add functionality such as controlling navigation, retrieving and applying filters, setting properties, and managing events, and supports several different authentication environments. In the list of categories on the left, expand Grid, then select General. In MicroStrategy Web, navigate to and click on the report to be displayed as a Lipstick or Overlapping Bar graph. No answer is provided to the required prompt so MicroStrategy cannot complete the report without user interaction. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. Locate the report: 2. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. In addition, you can use the view filter functionality for Freeform SQL reports in the same way as for regular reports. That is, we will not be able to create these elements using the. Ritinder Kaur Business Intelligence 1 comment. MicroStrategy Visual Insight has view filters or visualization-specific filters that can target individual visualization. In MicroStrategy Developer, go to File > New > Metric. Use the steps below to add a Text prompt to a filter. 11 will support prompts for end users. Choose Format > Graph. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. There are two ways to display the prompt selections for the object prompt in the document. MicroStrategy Mobile is an interactive interface of the MicroStrategy BI platform that lets mobile business users harness the analytical power of MicroStrategy through the use of their mobile devices. 0. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. In this case, you would need to create a user connection mapping within MicroStrategy for the CEO. The box represents the second and third quartile (50%) of data points and the line within the box represents the median. The MicroStrategy analytics platform is a cloud-based and on-premise self-service business intelligence platform that supports both data mining and visualization. Click on 'Modify' to determine how the prompt will appear in MicroStrategy Web. To use, enter a valid Command Prompt command. If you single click on the icon, or make any manual selection on the filter, the icon is grayed out, indicating dynamic selection is OFF. Java example demonstrating how element prompt answers can be set within a custom prompt event handler in the MicroStrategy Web SDK. KB5828: How to use pre and post macros when exporting a report to Microsoft Excel in MicroStrategy Developer 9. First, define one visualization as the source. Provide support for all phases of testing such as integration testing, and user acceptance testing. Tableau faceoff. This guide is organized into the following sections:Add an Image and HTML file to MicroStrategy . To add a prompt to the report, drag and drop the prompt from the All Objects pane onto the report. Metric definition: Sum (IF (Employee@ID In (1,2,4,5),Revenue,0)){~+} This is good as a quick solution, since. The Embedding SDK allows you to quickly integrate a MicroStrategy dossier into a web application in a responsive manner. An online search reveals that MicroStrategy has less market penetration than Tableau. 1. In MicroStrategy Analytics Express, you can export the document with advanced templates as Dashboard file (. You have now selected your prompt answer. The major usage of the tool is for analytical purposes (reporting) by interacting with Hadoop, Microsoft SQL Server Tables, and SSAS MDX. Data quality. For example, you want a report that lists all employees whose age. MicroStrategy 9. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. Click Add New Qualification. Is there any way by which I could let the user vary a single attribute while the dashboard is running. For any Apply function, the attribute form in the arguments should be a single form—not a form. 1576. Value Prompt. 1 Answer. Using system prompts, users can use. 1. Then click on New Document. "System Prompt" is a system object that was introduced back in version 8. Micro Strategy also supports mobile BI. In addition, object prompts can be created as stand-alone prompt objects and then added to the report using the Insert Prompt option under the Template menu. Click on 'Finish' and save the prompt. In this example, the filter is named 'Year =. We also added an Advanced Properties panel, SQL view in pause mode, more formatting options, customized subtotals, and support for transformations, consolidations and custom groups. If you created a new dossier, you must save the dossier before adding an existing dataset. No Filtering – Selectors do not target each other. Step 1. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics. Create an integrity test. xlsx as an example data set. Advanced Prompts: Enabling User Input. Browse and incorporate these templates into your own data dashboards. From the MicroStrategy home page, click New Metric . KB10296: Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. SecurityRegion table defines from which region a user is allowed to view data. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. WORKAROUND: Create data import cubes as standalone objects instead creating in VI, and the cube can be located from file system and able to be scheduled refresh. Create a panel stack. Value prompts – Allow a user to type a value, which can be used along with metrics. The dataset report of a document contains the MicroStrategy objects that can be displayed in the document. While this code may apply to other releases directly, MicroStrategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. Scaling a Graph in MicroStrategy Web. Create a date prompt to accept the date. Yes. To add a prompt to the report, drag and drop the prompt from the All Objects pane onto the report. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. The following steps explain the process that users can use to define and use this. Instead to run the report using MicroStrategy you can provide to each user a specific URL that, using MicroStrategy URLAPI, answer automatically the prompt. The impact is limited to the 'browse all objects' option on dashboard in MicroStrategy Web 10. Parameters create a pathway for non-technical consumers to conduct ad hoc analysis by changing what and how facts and dimensions are displayed—within the boundaries of the designer’s intended usage. You can display only those attribute elements that appear in the related lookup and fact tables in your data warehouse; or you can display all attribute elements that exist in the lookup tables in your data warehouse, regardless of whether. Include “Qualification Prompt”. On the General tab, from the Graph Type drop-down list, select Budgeting. Human. Target the grid report and the child panel stack. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). Use grids in reports that require numeric details. Click on the visualizations you want to select as targets. Industry: Finance (non-banking) Industry. It returns the value to compare the attribute or metric to. Auto apply selector changes: Applies to all selectors in the document. Create a filter on the date attribute. As described in the "filter another selector" example above, the same selector can target both a Grid/Graph report and another selector. For any Apply function, the attribute form in the arguments should be a single form—not a form group. Here you can see how to create a 3-level deep nested prompt that will prompt the user to select a year, then a quarter within that year, then a month within that quarter. Next, run the report. 4 MicroStrategy renamed Visual Insight MicroStrategy Dashboard. (You can add more than one prompt to a custom group. The current logic I've found is below. Visualization with Multiple Datasets. Place the nested prompts into the report filter. Hierarchy Qualification. Use selectors to flip through the panels in a panel stack or display different attribute elements or metrics in a grid or graph. In general, ApplySimple can be used to create the following objects: •. Limitations. Therefore, prompts allow report designers to create reports that let users change the report content at run. Click OK. g. To add a text field to a document. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. To create transformation metrics using the Metric Editor, see the Advanced Reporting Help. These are just a few ideas to visually and functionally enhance your grid. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. Selector three selects Quarter element. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. Company Size: 250M - 500M USD. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Passion, attitude, creativity, integrity, alignment, and execution are cornerstones of our behaviors. The link can pass parameters to answer any prompts that are in the target. In MicroStrategy Developer, use the Folder List on the left to navigate to the folder where you want to store your new filter. Askingforuserinput:Prompts 280 Designingareport'sstructure:Templates 343 Creatingagridreport 345 Addingfeaturesforusers 378 Modifyinganexistingreport 401Start. Follow the instructions in Creating Subscriptions. However, reports that access Intelligent Cubes can use prompts that access only data included in the Intelligent Cube. It is important to remember that prompts can be used in many objects including reports, filters, metrics, and custom groups. Value prompts are useful when the result desired on the report is a single value, such as a specific date, a number, or a specific word or phrase. When using any of the Apply statements in conjunction with prompts used to select attribute element values, it is necessary that a value be returned as an argument into the function of the statement. Additonally, this procedure does not always work on dashboards that are based on multiple cubes. Ans: Microstrategy Narrowcast Server is a software product that monitors and delivers individualized information to users via email, web portals, and wireless devices such as PDAs, pagers, and phones. Metrics that use transformations in this way can be included in Intelligent Cubes. Using this custom visualization you can easily create Bar / Line chart with animation features based on Apache ECharts open source library. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. Choose the following display defaults:Starting in MicroStrategy 2021 Update 7, administrators can enable authoring of reports in Library Web. To Answer a Prompt by Defining a Filter Based on an Attribute. Documents and dashboards can appear in almost as many ways as you can imagine and are generally formatted to suit your business needs, in a single display of presentation quality. At Customers Bank, we believe in working hard, working smart, working together to deliver memorable customer experiences and having fun. Sorting the Page. The names of the target visualizations appear on the. A prompt is a MicroStrategy object that allows user interaction at report run time. It is important to remember that prompts can be used in many objects including reports,. Create a Value Prompt To create a Value prompt from the MicroStrategy desktop: From the MicroStrategy Desktop, right click and select. The prompt object is incomplete by design. Image by author. Use thresholds within grids for highlighting deviations. Run report and. Watch the MicroStrategy team show you how to get started by using MicroStrategy for Power BI. In MicroStrategy Developer, choose File > New > Prompt. Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. An object prompt for one or more attributes placed on the rows. x and add a derived attribute, right clicking an. exe. No matter what the user chooses, only the specific month will be displayed. An overview of designing and creating documents. Changing the prompt order. 9 and 10. Several workarounds for this issue have been provided below for use in current releases. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. A metric set qualification, as the output level (see To use an object prompt as the output level for a metric set qualification for instructions) Then you add that filter containing the prompt to a report. But it’s nipping at the heels of leading BI software with cutting-edge capabilities and wins in a close MicroStrategy vs. Video Tutorials. For more information, see Prompts. Then right-click on the right side of MicroStrategy Developer and select New, then select Filter. An example is: MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesAd hoc ReportingSortingYearly Sales!i inserts the job priority of the report which is represented as an integer from 0 to 999 (can be used in all Pre/Post statements). If you are looking for a solution that will cover 80% of your needs when it comes to mobile reporting then seriously consider Microstrategy. KB419483: How to create a comparison operator prompt and use it in an applysimple. For example, the user can enter information such as the. It returns the value to compare the attribute or metric to. See the finestfoods dashboard in action. As we know, the two key factors which decide the success of BI application software implementation are. 2. "KB11113: How to use prompts to return attribute element values within an Apply statement in MicroStrategy Developer and Web When using any of the Apply statements in conjunction with prompts used to select attribute element values, it is necessary that a value be returned as an argument into the function of the statement. Understanding Attribute Join Types. Selector two selects Region element. Report distribution is automatic. This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it seems that the BBDD is ORACLE), and breaks it down by product. Click OK. Concerns regarding the efficacy of self . To create a static label, type text: a. Create Dashboard A with the above report as the dataset. Therefore, prompts allow report designers to create reports that let users change the report content at run time. Prompts in MicroStrategy Developer are used to enable metric, filter, template, custom group or report modification. New feature was introduced that allows users to add buttons to dashboards in MicroStrategy Web 9. To use the report as a data mart report, from the Data menu, select Configure Data Mart. MicroStrategy Intelligence Server provides one centralzed architecture for all users’ monitoring, reporting and analysis requirements. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. The demo is introducing the structure but you can get very creative with these URLs. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. You can create filters that prompt you for answers when you run reports. KB237469: How to define a Metric using text based value prompt in. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. Please post your code so that we can help you :) – Toma. Metrics that use transformations in this way can be included in Intelligent Cubes. In MicroStrategy Analytics Desktop, you can import a MicroStrategy file by selecting Import -->. if the report combines several records, do you want it to add the metric values or show the highest value), now the smart metrix is a tick box and is only. For this, we have to use the results of an existing report as a filter for another report. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. If you unset the filter, the icon disappears. We've expanded the content types supported in the modern content portal to ensure end users have all the data they need. (You can add more than one prompt to a filter. Derived elements are available only from MicroStrategy web. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . Ultimately, we felt that it was time to go. Cramped details create too much visual overload. Web use prompt editor: use the prompt editor, and create or modify prompts. When to use: You want to see the distribution of one or more datasets. Note: You can select more than one value as your prompt answer (see below). A prompt is a question the system presents to a user when a report is executed. While an Apply function can be used wherever the function group it belongs to is applied, you should not use any Apply. Access New > Dataset > Create New. But today I am going to show you how to pass a selector value from one dossier to another without using the prompt option and also without any custom SDK. It is important to remember that prompts can be used in many objects including reports, filters, metrics, and custom groups. Create a Prompt using Prompt Generation Wizard in MicroStrategy Desktop/Developer. Create a filter on attribute "Month" and click "Prompt. On y-axis, we can see the name of the days and the color gradient shows the amount. However passing content (dynamically or prompt answers) was difficult (if possible) to add to maintain. You can select more than one dataset report to include on the document. Splitting the fraction: Numerator: Sum (VOL) {~} Denominator: Max ( ApplySimple ("replace (#0, ',', '. Click on Dossiers in the left panel of Workstation. Choose Add Data > Existing Dataset to add data. Thanks in advance. Using the following prompt types, you can create a prompt for nearly every part of a report. A derived element allows us to group on the basis of: – List of elements. Selector two selects Region element. MicroStrategy has unveiled a multi-year partnership with Microsoft that will add generative AI capabilities to MicroStrategy's business intelligence suite. The value prompt is designed to return report results based on the data type assigned to the data in your data source. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. SYMPTOM: When Filters are added to MicroStrategy Visual Insight Dashboard with multiple visualizations, the filter applies to all the visualizations in a. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and so on. In MicroStrategy Web, log in to the Tutorial project. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. Click on MicroStrategy Web Configuration inside the Application Settings view to expand the hierarchical tree. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). What You Can Do in It. Create a grid report with the all_sales. @Iulian Lixandru (MicroStrategy Community Master) (Empower BI) -Can we achieve this functionality through user defined custom subtotal? We have a request for a prompted report and need to calculate distinct customers where we have report exist at lower level than customer and subtotal needs to happen on distinct customers like the. Business analytics platforms can include the following software. Displaying a list of selected elements in a Document or Dashboard can be easily accomplished using the ConcatAgg function. Create a panel stack. MicroStrategy Desktop 8. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. For example, in the case of a report, a user may have permission to view the report definition and execute the report, but not to modify the report definition or delete the report. The ApplySimple function is a single-value function. Select the Set the value to be used in place of empty values when the report data is sorted check box. Uncheck ‘Apply selection as filter’, and enable ‘Automatically update when there is no data for the current selection’. For filters in the filter panel, after the dynamic default selection is defined, an icon and text ('First N'/'Last N') appear indicating dynamic selection is ON. When there are multiple prompt answers,. All of these prompts will reveal themselves at report execution time, but the origin of the prompt can be within any of the objects. Select Filter definition prompt -> Choose from an attribute element list as shown below. What is an implicit attribute in MicroStrategy? Answer: The sample prompt is as show below. Add the filter to the Report Filter of the report. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. For instance an element list prompt which has a value prompt within. On expanding the button, the following screen opens showing different public. Using URL to answer prompts. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 2. Reports are designed using MicroStrategy Web. When the report is run, the user can select the Greater Than Operator and type a value to answer the prompt. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. The Report Data Mart Setup dialog box opens, as shown below: On the General tab, from the Data mart database instance drop-down list, select a database instance for the data mart table that will be created. This is an example of a manufacturing unit dashboard analyzing. Later versions, including MicroStrategy 9. The MicroStrategy Desktop User Guide describes the steps for a business analyst to execute and analyze a dashboard in MicroStrategy Desktop. Add Month as an attribute and corresponding metric. Telling a Story with MicroStrategy Dossier. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. Step 1 - Metric creation With the function ConcatAgg, create a metric for the attribute for which you want to get the selection summary. 3. For the reference, when a user defines prompted filters, the report prompt page will be displayed as below, note that there are two prompts to qualify on Day attribute: STEPS: 1. In the illustration below, the user has not been assigned the Web export privilege. Create as many object prompts as necessary.