Later, you will learn to use MicroStrategy to create advanced charts and get an overview of text, number, and date filters. MicroStrategy - Creating Dashboard. x. 2. We fixed 56 total defects in Critical Update 1, of which 23 were reported by our customers. The key to creating a properly formatted graph report in MicroStrategy Web is to build it using the advanced formatting features in MicroStrategy Desktop. Click on the grid visualization to which you want to add subtotals. Select one of the following options: Drill anywhere: Users can view data associated with the object they. Click the Enterprise Reporting Documents folder. Learn more. If desired, user can create a dashboard immediately from the imported data. Reference the image in the form of '. The course starts with an introduction to MicroStrategy, covering the basics and the installation process. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. MicroStrategy Analytics delivers reports and dashboards, and enables users to. From the Data menu, select Grid Data Options. KB43905: New Web feature - Add buttons to dashboards to facilitate different actions and boost visual appeal in MicroStrat… Number of Views 747 KB30140: How to enable the minimize and maximize buttons for a grid or graph on a dashboard in MicroStrategy Web 10. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is. Excel and Google offer free solutions that provide basic dashboarding which can be shared on an individual basis. TutorsBot's Microstrategy Desktop Training in Hyderabad will teach you how to create dashboards and reports using Microstrategy tools. Open Power BI. Add Project objects from the All Objects panel. A demo that describes how to create and use MicroStrategy Dashboards. To view this dossier with the Pie Chart visualization: Download the . Otherwise you can reach the section Titles and modify the Title. Dashboards are a powerful way to communicate data and other information, especially with a user-centered, goal-centric design that follows dashboard design best practices and proper data visualization. Select the chart, then size and format as desired from the PivotChart Tools tab. MicroStrategy 10 Secure Enterprise™ empowers leading organizations to analyze vast amounts of data and distribute actionable business insight throughout an enterprise through two distinct offerings: MicroStrategy Analytics™ and MicroStrategy Desktop™. Export to MicroStrategy File* Common Privileges. This tutorial demonstrates how to promote user's work directly in the Desktop, share it with other user groups and set access options. Run the Desktop Setup. In Web Preferences under 'Default start page,' choose the report that was just executed as shown in the image below: Click 'Apply,' and this report will now. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. 3. Get Data from Multiple Data Sources. 2. com MicroStrategy - Creating a Dashboard. In this brief video tutorial, Josef Timchenko of our Customer Education team explains how to make a custom or third-party visualization available for use in both MicroStrategy Web and MicroStrategy Desktop. Of course, you need to build a report with exactly the same attribs and configuration. x, users must open a project and then go to Tools > My Preferences > Editors > Document. In MicroStrategy Analytics Express, you can export the document with advanced templates as Dashboard file (. Execute the document in MicroStrategy Web 9. 11?; Knowledge Base: Annotate. Click anywhere in the first PivotTable and go to PivotTable Tools > Analyze > PivotChart > select a chart type. 2. Telling a Story with MicroStrategy Dossier. 1. In the Editor panel, right-click the attribute or metric for which you want to display subtotals. Create, share, and maintain dashboards and dossiers. It gives you exclusive access to MicroStrategy experts on-demand or on-schedule, as well as access to all 56 courses in the MicroStrategy Education Catalog. If so, select the theme to apply to the tile: Use destination theme: The theme of the dashboard. x. · How to use all the main visualizations. MicroStrategy is one of the leading and fastest-growing business intelligence tools. To Create a Report from Scratch. The following steps demonstrate how to do that in MicroStrategy Tutorial project: Create. If it is not already selected, select the Enable Report Drilling check box. MicroStrategy vs Tableau. MicroStrategy Speedy Guide - Because a Business Intelligence tool with wide range of features, MicroStrategy has powerful features that helps to find answers and insights in business data analysis. MicroStrategy Desktop is a powerful data discovery tool for anyone in your organization that lets you explore data and answer questions on your own. 4. MicroStrategy Customer Analyzer, MicroStrategy Desktop, MicroStrategy Desktop Analyst, MicroStrategy Desktop Designer, MicroStrategy eCRM 7, MicroStrategy. MicroStrategy Analytics Desktop. There's a reason we're at the top of the list. 3. xChange the formatting of the percent to total with the appropriate settings (decimal places, negative value formatting, etc). ; Right-click on the column header again and click Edit Selector. Related versions: Log in to vote Desktop is a fast, user-friendly desktop tool that lets you intuitively access and explore data to create visualizations in minutes on your PC or Mac. | Meet MicroStrategy AI on the road. 1 SYMPTOM: For some pie charts in MicroStrategy Web 9. x. Learn how to create insightful and interactive dashboards using MicroStrategy. When users try to republish the cube for the dashboard or dossier, they encounter the following error:Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is. Any dashboard created within MicroStrategy Desktop 10. Privileges. This course will take you through basics of MicroStrategy Desktop Application right from downloading and installation to creating beautiful dashboards. Pros and Cons. Build a new plugin or update an existing Teams message extension or Power Platform connector to increase users' productivity across daily tasks. mstr file can be opened in MicroStrategy Desktop and MicroStrategy Workstation. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Use attribute in Tutorial project as an example. x Developers can modify the background color of a layout in MicroStrategy Web. MicroStrategy 10. In the Dashboard A, create three selectors: Selector one selects Category element. 4. Learn how to create visualizations directly in Microsoft PowerPoint by linking to trusted MicroStrategy data, enhancing presentations and insights overall. Click “Create Cube Design” to have MicroStrategy Cube Advisor automatically create Intelligent Cube objects in the project. 5. By reimagining the data discovery process, we made it easier than ever for analysts and citizen data scientists to visualize data. Dossier’s intuitive, drag-and-drop interface enables you to display and explore your data in seconds. For more information about hiding containers on mobile and Desktop views, read our documentation. In MicroStrategy Web, select “Upload MicroStrategy File,” then select the dashboard created in Step 1 to upload. Finally in version 9. In the Functions pane, search for. Open a grid report. MicroStrategy ONE empowers companies worldwide to seamlessly. For example, they can help identify new SEO terms to target on a web site or they can. Get inspiration at the MicroStrategy data dashboard gallery. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. In MicroStrategy Analytics Desktops 10. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Subsequently, the objects may be edited in MicroStrategy Desktop. Add new data by either selecting “Add New Data” from the left or clicking the database icon. Views 1540. 2. Make sure you have MicroStrategy Desktop officially downloaded on your computer. Use MicroStrategy Desktop to create customized, interactive dossiers for exploring your business data. To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View Dashboard. Create apps with ultimate flexibility. | Meet MicroStrategy AI on the road. In the Properties and Formatting window, under Properties, click Widget. mstr file. MicroStrategy Desktop is a powerful data discovery tool for anyone in your organization that lets you explore data and answer questions on your. All articles. You can use MicroStrategy Mobile as a platform to create mobile business intelligence (BI) apps for your organization. 4. Watch on. For steps, see Starting MicroStrategy Web. Instructions on how to install MicroStrategy Desktop on a Windows or Mac machine. MicroStrategy AI is here. To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View Dashboard; Watch a quick tutorial video on importing custom visualizations in Workstation. To open the demo visualization in MicroStrategy Desktop, double-click the . Experience the speed and flexibility of data discovery without. MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and decision support workflow on an intuitive Windows-based interface. 9% of resumes. This feature is also available in 10. The tool brings together previous Data Studio features with Looker’s new business intelligence. You cannot directly open the demo visualization in MicroStrategy Mobile. Create a new dashboard in MicroStrategy Analytics Desktop 2. Delete the grid, then save the template. You will learn about functions such as data importation, cleaning, analysis, visualization and. 3. Timestamps: - Federated Analytics. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. In MicroStrategy Developer, double-click the document name or icon. You can do. The third most common microstrategy developer skill is templates on 5. This online Microstrategy course will prepare you for Microstrategy certification. Use OLAP Services. Get inspiration at the MicroStrategy data dashboard gallery. To open the demo visualization in MicroStrategy Desktop, double click the . The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. And let me go to the next slide. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. If you've upgraded to MicroStrategy 10. It has a simple menu to import data for analysis and export the result of analysis. you will also be able to analyze, transform and clean the data within Microstrategy. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is. Common Privileges. TL;DR: It's true often you can do a thing in desktop, but you can't do it in MicroStrategy web, or vice versa. Using visualizations and widgets, users can analyze data and make decisions based off that data as they. These transactions can include one-click approvals and denials, notes for tracking and directing business activity, and write-back to data sources in real time. blogspot. In MicroStrategy Desktop 10, a new privilege called “Use MicroStrategy Desktop” has been introduced allowing administrators to control whether or not users can connect to the Intelligence Server and log into a Project from Desktop. To do this: a. 2. The course starts with an introduction to MicroStrategy, covering the basics and the installation process. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the data (called visualizations) to the dashboard to. txt. create a derived metric named "Metric Selector". KB5221: How to create metrics based only on constant values in MicroStrategy Desktop 9. It shows many attributes grouped into separate visualizations. To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View Dashboard Visualization Disclaimer. Stay up to date on inventory needs and avoid stockouts with seamless integration to purchase order systems. MicroStrategy provides an extensive library of visualizations and an intuitive drag-and-drop interface make it easy for users to build data discovery dashboards. mstr file is bulit in MicroStrategy 2021 Update2 ) o To open the demo visualization in MicroStrategy Web, choose Create -> Upload MicroStrategy File -> View DashboardIn the Datasets panel, click More to the right of the dataset in which you are creating a derived metric and choose Create Metric. On the dataset "Revenue & Discount by Category, Country, Month" create a new derived metric "KPI" defined as follows. Request a demo. Visualization Disclaimer. The example provided in this document is provided “as-is” to the user and assumes that the user: Can program, compile (e. Enter your REST API URL and select an authentication mode using the drop-down. Under the Browsing section click on "Browsing Options". Require users to answer prompts. Enrol in this course to become more proficient in data analytics using software like MicroStrategy. Import and save data from a file in a folder location. This video covers how to manage and govern your data with self-service in MicroStrategy 10. 963. Your data could be around retail transactions, airline flight patterns, web traffic, highway traffic… the number of possible Analyst use cases is only exceeded by the sheer volume of data available to you. In some business scenarios, it is required to design conditional count metric in Dashboard in MicroStrategy Web 9. As of MicroStrategy 10. This calculation can be aggregated from the Employee level to the Region level. Create a folder for your plug-in. It has a simple menu to import data for analysis and export the result of analysis. The MicroStrategy Mobile app for the iPhone will. Clear the Totals check box to remove the standard subtotals. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. Then use the two Latitude and Longitude attributes to provide latitude and longitude information for map markers in the visualization. MicroStrategy - Creating a Simple Table; MicroStrategy - Creating a Column Chart; MicroStrategy - Creating a Bar Chart; MicroStrategy - Creating a Stacked Column Chart; MicroStrategy - Creating a Pie Chart; MicroStrategy – Creating a Pie Chart with Percentage; MicroStrategy - Creating a Multiple Pie Chart; MicroStrategy - Creating a. 4. This enables developers to have a background color for the entire document and keep an aesthetic uniform look. MicroStrategy for Tableau allows you to fetch data from reports or cubes that reside in MicroStrategy projects into Tableau Public (also known as Tableau Desktop). You can import business data from many different sources, including local files, databases, Google Drive, etc. Advanced Reporting Guide for MicroStrategy 9. Creating a powerful dossier is as simple as importing. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. The newest feature release of Microstrategy, Microstrategy 10. 4. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. Enter a name for the metric in the Metric Name field. 3. However, I felt that Power BI's visuals looked a little bit better. The dialog box for Options for PDFs opens. Design intuitive analytics reports with MicroStrategy ONE. To open the demo visualization in MicroStrategy Desktop, double click the . Create a simple dashboard in MicroStrategy Web and insert an image. After taking this course, you will feel comfortable in creating beautiful and rich dossiers (analytical dashboards) within minutes. NULL values can be treated as zeros (0) for computational purposes by enabling suitable settings in Very Large Database (VLDB) properties at different levels in MicroStrategy Desktop 9. We have MicroStrategy one of the leading and fastest growing tool. A newer version of MicroStrategy Desktop is already installed. The following kbase article explains how to convert OLAP reports to regular reports . Views 1540. ) check box to. . In MicroStrategy Web, you can interact with a dashboard in the following ways: View the data as a grid, graph, or widget. Build beautiful, interactive dashboards with Dossier. Microstrategy is a great platform for mobile analytics. mstr file. The connector supports several additional features: MicroStrategy Standard and LDAP authentication. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. 5/5 videos | 17M 9S total runtime. The Export to Excel option will now appear. You'll find user-generated examples showcasing a variety of use cases such as financial or retail. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. To support MicroStrategy Mobile of 10. 3. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. Selectors in an RS dashboard. In addition, it will also be quite useful for those readers who. 4To open the demo visualization in MicroStrategy Desktop, double click the . Easily access, explore, and analyze data in just a few clicks with self-service analytics. Send this URL to the mobile devices. With the release of MicroStrategy 10. The dataset report of a document contains the MicroStrategy objects that can be displayed in the document. For requests made from the MicroStrategy Desktop/Developer client, the Intelligence Server will send the response to the Desktop/Developer client directly without going through an additional server. Visualization Disclaimer. 1: MSTR. Save and close the filter. Access all critical KPIs at a glance, from daily revenue and product trends to employee performance. The MicroStrategy Desktop environment is very intuitive. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. This video tutorial demonstrates how to create an Agile dashboard from a classic report. Accessing an Out-of-the-Box MicroStrategy Web Page. 4. Every request to a MicroStrategy Web product corresponds to a specific event or action, which. Create a panel stack. Filter the data, by the elements of an attribute or the value of a metric. Select the dataset you want to add and click Next. Watch on. mstr file below and deploy it in MicroStrategy Desktop or MicroStrategy Web. Mastering Business Intelligence with MicroStrategy and dashboards. 3 Tier: Microstrategy Desktop - Intelligence Server/Web Server - Database/Metadata DB Suppose you already have a 3-tier set up, but your Intelligence Server tier is set up on a Linux/Unix machine, and you wish to move the Microstrategy Tutorial project to your existing 3 tier set up so that you can execute the dashboards. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. How to easily create dossiers/ portfolios with MicroStrategy through a modern and intuitive drag-and-drop-interface MicroStrategy Desktop Help. To print a MicroStrategy Web report: 1. . Check ‘Filter definition prompt’ -> select ‘Qualify on an attribute’ , and click ‘Next’. At the Project-level, null handling can be set by going to Project Configuration > Report Definition > Null Values. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. A dashboard is made up of multiple visualizations. MicroStrategy Web Server End users may render dashboards executed through MicroStrategy Web in DHTML view modes, Flash mode, or PDF. Create a document with above report, save it and select “Display prompt but discard the current answers” option. Import data from a file while creating a dashboard. Download Dashboard. To open the demo visualization in MicroStrategy Desktop, double click the . To create and apply a threshold to a grid report in Desktop: 1. Create two different templates. Open the document or dashboard in Design Mode. MicroStrategy Web 10. To open the demo visualization in MicroStrategy Desktop, double click the . Create a filter based on. Dashboards summarize key business indicators by presenting them in visually intuitive, easy-to-read, interactive documents. mstr file. Right-click the table and select Create Fact. Provides interactive functionality so users can change how they see the data. Description: A demo that describes how to create and use MicroStrategy D. Learn how to import, visualize, and create a dashboard using tables, charts and maps with this free online course on MicroStrategy Desktop 2020. Desktop is a fast, user-friendly desktop tool that lets you intuitively access and explore data to create visualizations in minutes on your PC or Mac. Next, you will learn in detail how to create. The Document Properties dialog box opens. In the Editor panel, right-click the attribute or metric for which you want to display subtotals. x-10. Opens the report in PDF format. The . Experience the speed and flexibility of data discovery without. 2: New features overview. Easily access, explore, and analyze data in just a few clicks with self-service analytics. Example: #Todumpalldatabases pg_dumpall>db. A report designer creates a report in part by determining these report column headers. New Desktop Coming Soon! A new self-service data discovery tool is in the making. Platform Analytics is a completely new product introduced in MicroStrategy 11. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Used online rather than printed out. About your question, check page 394, Dashboard Editor: Grid: Format. By downloading or using this visualization, you accept and acknowledge these terms:Watch on. exe file. easy to use dashboard. Learn how to switch to a compound grid, add column sets in this new visualization. 11 Critical Update 1 (v10. Second, create an attribute that contains the longitude of each store and assign it the Longitude geo role. With this new seamless, out-of-the-box setup, it's simple for MicroStrategy 10. These fixes address performance (2), security (3), and stability (12), among other issues. 7 (Note: Pictures may be outdated). Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. Browse courses: Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. environments. In the Property List: Appearance section, set View mode to Graph. Click on the grid visualization to which you want to add subtotals. This is where the transaction report is associated with the document. 4) Give the required HTML codes inside HTML container inserted. Create or edit reports with authoring functionality. Free access to online training, forum, and knowledge base. Dossiers. Display the data in an interactive widget, such as a Google Map, Graph Matrix, or Heat Map. Use all three prompts above as the report filter. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. x. mstr file. Desktop is a fast, user-friendly desktop tool that lets you intuitively access and explore data to create visualizations in minutes on your PC or Mac. Add the URL for the desktop view of the dashboard as the Website address. Request free demo. In Microstrategy 9. Make sure the Authentication Mode matches the one setup in step 4. 3. you will apply these concepts to create a dashboard, blend it with external datasets, and explore various visualization capabilities to find insights faster in a peer. The imported data is saved and can be used immediately in the dashboard. Creating a powerful dossier is as simple as importing. Create a document using these two reports as datasets. mstr file. Advanced Apps. 2. [. 4 MicroStrategy renamed Visual Insight MicroStrategy Dashboard. From MicroStrategy Education, this lesson teaches you how to create create dashboards using templates on the MicroStrategy Web platform. This is a first of many Dashboard videos and focuses on creating Dashboard templates that are reusable and can be moved between projects and project sources. The Excel File will contain only the selected Grid Object data from the Document. A message appears asking if you want to allow MicroStrategy Desktop application to make changes to the computer. Every MicroStrategy BI application requires at a minimum: 1. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. You can connect. You will need to use MicroStrategy Desktop to create compelling data visualizations to analyze data and acquire insights into business practices in a peer-evaluated exercise. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. A VI dashboard is a customized, interactive display that you can use to explore your business data. You can disable the setting from the menubar: Format → Dossier Formatting → Disable highlight on hover for. The Upgrade Help includes best practices and instructions to ensure that your system upgrade adheres to the interoperability rules that MicroStrategy has certified and listed in the Compatibility and Interoperability page. import data into MicroStrategy Desktop, for use in creating dashboards. Instead, users may observe that the tooltip displays, for example, "Metric: Revenue" when hovering over the object in the Report Objects or Datasets. MicroStrategy Dashboards allow any user to seamlessly transform MicroStrategy reports into interactive dashboards! So you display governed, high quality, secure and contextual data using a state of the art data visualization interface. Export the dashboard to PDF and notice that the image displays as a broken red X. When you create a document, you can specify the data that appears, control the layout, formatting, grouping,. Data sources for data importing You can import data into MicroStrategy Desktop from many different data sources, such as: From an Excel file or database By using the results of a custom database query From a MicroStrategy server by opening a dashboard or importing data You can also combine different types of data sources in a single dataset. Dossier. Once you’ve created one or more views on different sheets in Tableau, you can pull them into a dashboard in two simple steps: Step 1: Open a dashboard sheet: select Dashboard from menu, then New Dashboard. At CDO Advisors, we'll build you an amazing Power BI Dashboard at a low monthly cost. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsVitara's MicroStrategy 2020 Dashboard Competition Winners. Dashboard Business Intelligence. Vitaracharts is now FREE for Desktop and. To make it easier for new users to get started with the free version of this tool, the vendor is also rolling out a new Dashboard Gallery in the company’s user community. 5) Run the dashboard/document. If you've upgraded to MicroStrategy 10. BI Learning: Creating a Dynamic Enterprise Dashboard. This demo will guide you through creating a Data Source Name, and a database connection to a Microsoft SQL Server Database in both Developer and Web. Edit a document template used by users in MicroStrategy Desktop > Object Templates > Templates. . Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. If an environment does not already exist, an environment will need to be created first. Our Customers. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. The. x, as shown in the screenshot below: 2. MicroStrategy Desktop is built on the latest version of MicroStrategy 10, which offers data source support, expanded visualizations, and easier inter-user collaboration. Hee-Wei Tan (Inactive) · 5月 1, 2017 ·. When we place some. Tableau Dashboard 1. Introduction to Attributes. Learn more. Click license agreement and review the. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user. MicroStrategy AI is here. 2. There's a reason we're at the top of the list. 2. Get inspiration at the MicroStrategy data dashboard gallery. 4. This "How to" technical note describes a way to hide the metrics columns from a document grid in MicroStrategy 10. Create a filter. MicroStrategy Desktop allows anyone to organize data into chapters and pages, making it easy to author dossiers, navigate. mstr file below and doing the following:Present a style appropriate for the executive boardroom. Selector three selects Quarter element. The Export to Excel dialog box opens.