how to tune the document in microstrategy. Display map markers as static images in the visualization, or display the map markers as dynamic bubbles. how to tune the document in microstrategy

 
 Display map markers as static images in the visualization, or display the map markers as dynamic bubbleshow to tune the document in microstrategy  Right-mouse click on fontPicker and select New Shortcut

browse button. xls format. 5. Use developer tools to view the HTML so that you can find the element ID for the group-by element. Tell a story with your data using the dossier chapter/page format. Click the location in the layout area to add the selector to. This allows users to get insights from one map rather than creating two or more maps. Show Title Bar: Determines whether the title bar of the selector is displayed when a user views the document. 2. Display map markers as static images in the visualization, or display the map markers as dynamic bubbles. 4. • Research efficient aggregation, partitioning, and indexing strategies. We decided to gather them in one placing using our experience and MicroStrategy materials. Use Aggregate tables 2. Visit the data visualization and data dashboard galleries for inspiration. A prompt is a question the system presents to a user when a report is executed. xls format. Right-click the section and select Properties and Formatting. 2. From the Home menu, point to Export. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. 1. Execute the grid, and change the results to display in Outline mode, as shown below: Save the report and exit to the folders. These values are set by default when the "Oracle 11g" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection Type ). The New Grid dialog box opens. x users have the ability to disable this option. The Select Dataset dialog box opens, allowing you to select an existing dataset or import data. WHERE (col1, col2) in (SELECT s1. The object uses a black Tahoma font and the Forecolor option is the color of the font. Designing and Creating Documents begins with a brief review of basic concepts, such as executing and printing documents, that are covered in the MicroStrategy Web help. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. Once the Grid/Graph has been added to the document, you can: Add additional objects to the Grid/Graph. x The first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. The text field for new notes closes, and all the existing notes become active. To view a custom HTML5 visualization in a document on an Android phone: Copy the visualization plug-in to the plugins folder in the MicroStrategy Web. Right-click the text field to be formatted, and select Format. Now that that’s settled, let’s jump into some best practices for. 4. This can give you insight into tuning advanced report-related project settings. 013 Developer (DVL) 2 2022. •Integrity. 1. For a list of auto text codes, see Displaying document and dataset information: Auto text codes. Export the document from the original project. When you apply the visualization to the document in MicroStrategy Web, make sure to check the iPad option in the widget editor and save the document. Selecting a display theme for an object The Light and Dark themes quickly change the overall look and feel of the selected object. From the left, click Export. Save the report. Advanced color threshold — The Advanced Threshold Editor displays a. To enable totals or subtotals for a metric. This setting needs to be at least the size of the largest cache file, or the. 3. To manage your subscriptions in MicroStrategy Web. From the Format menu, select Apply Document Theme. MicroStrategy Professional Services offers a service to tune customer environments including the optimal heap size and garbage collector parameters. There are multiple ways to intervene the database to generate a better SQL execution plan. You should be familiar with the various properties that define how a selector looks and what it controls, such as target and source. Select Load chapters on demand or Load pages on demand from the Execution Mode drop-down. MicroStrategy Web 8. In MicroStrategy Web, navigate to a document which will become a layout within the multi-layout document you are creating. To export a document template. Interactive dashboards in MicroStrategy. You can select more than one dataset report to include on the document. Likewise, if a report used as a dataset report is edited outside of the Document Editor, those changes will affect the. . When user selects nothing, both text box will be hidden so nothing displayed. Use this guide to learn about designing and creating MicroStrategy documents using MicroStrategy Developer. MicroStrategy out-of-box provides two display themes: The Light theme and The Dark theme. Select Image from the Insert menu, or click the Image icon in the toolbar. Position the MicroStrategy Developer window and the Document Editor window to view both windows at the same time. In MicroStrategy Web 9. To print all of the pages in. (A dataset is a set of data that can be displayed on a document; it can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. The use of slowly-changing dimensions is described in the following MicroStrategy Knowledge Base document: KB5200-800-0479 - How to implement slowly-changing dimensions using. Open a report. For client configuration of MicroStrategy as Db2 client, you can refer to MicroStrategy Support Document for Db2. MicroStrategy Knowledge Base document KB4100-7X0-0070 describes the steps to update table structure in the Microstrategy Developer Warehouse Catalog. In MicroStrategy Web, open the document in Design or Editable Mode. This document provides a list of settings that Administrators can tune to help improve Cube Publication times in MicroStrategy Secure Enterprise 10. In MicroStrategy Web, you can interact with a dashboard in the following ways: View the data as a grid, graph, or widget View filter can be applied after the metric calculations are done for a report. You can add documents to your Library using MicroStrategy Workstation or Web. 4. For each form listed, select or clear the corresponding checkbox in the Show on Grid column. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. To see sample documents in MicroStrategy Web: 1. From the Format menu, select Apply Document Theme. To export a report while viewing it: Click the name of a report to display it. Snowflake Specific Tuning Snowflake provides a query profile page which you can use to investigate your queries. 4) Run the document in presentation mode. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. Once the prompts are in the correct order (for the example, the order is Region and Call Center), click OK to return to the Document Editor. Select Grouping Properties. Because your system resources, application performance, and user requirements and expectations are unique, it is not. Double-click the document name or icon . . 10, 10. For details, see the MicroStrategy Tech Notes TN11275 and. In the image below, the Customer State 'Connecticut' was generated using a dynamic-text field: {[Customer State]}Launch the Web Customization Editor. To Subscribe to a Report or Document. The Document Editor has multiple toolbars you can use to access different document features. Select the theme and click OK. A MicroStrategy connection file (. Disable Highlight in Presentation Mode. From the upper left of any page, click the MicroStrategy icon , then select History List. Inside 'Panel1', add a grid by clicking Insert 'Grid. X . Dashboards in MicroStrategy Web. Another method to format all controls of the same type in a single way, or to format all documents in a single way, is to use an Autostyle, which is a saved set of formatting that can be applied to all controls of a given type or to a set of documents so that they all have the same look and feel. Computation is separate from storage, which enables you to scale computation resources independently of the data storage in your system. While dossiers are a great proposition when self-service, collaboration, responsive design, and fast content creation are key requirements; documents are still your best. During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. 0, and right click the document, you will notice that the Edit option is greyed out as seen below:. 3. Select the Dropdown Icon () on the right-hand side of the title bar. As shown in the screen shot below, in the Rename/Edit Objects Window, select the "Replace dynamic text" checkbox as shown below. In MicroStrategy 2019, exporting a dossier with a large amount of content to a PDF may result in the following error: "Dossier content size exceeds the PDF Export Engine limit. This icon becomes visible when you point to the name of the report or document. The comments written get saved when saving the report or document for which they are. Open up the same document in MicroStrategy Web 10. Choose Excel and open a workbook. To do this, select either the bar containing the section's name, or click inside the section in a blank area (not on a control). 213 SDK for Customizing Analytical Applications 2022. 215 Embedding Analytics with MicroStrategy REST API 2022. Excel: This allows the user to export the document to Microsoft Excel in . MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. Save the report in MicroStrategy Web 10. This checkbox is cleared by default. In the. view Report Services Documents in the MicroStrategy Mobile client, and create Mobile document subscriptions in MicroStrategy Web: MOBILEVIEWDOCUMENT:. Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. For steps, see Starting MicroStrategy Desktop. Click the Enterprise Reporting Documents folder. A user may want to move the objects in smaller or larger increments. x, as shown below. To specify the export options in a document. You can also apply custom themes to an object. 213 SDK for Customizing Analytical Applications 2022. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Run the document and press F12 to open the Developer Tools console. 3. The Prompt Ordering dialog box opens. The following clarifies these two possible meanings and their respective contexts:. Click in the desired section of the Layout area. The editable mode is a fantastic resource for fine-tuning the layout of a document. To add a text field to a document. Generate Oracle AWR report or monitor the database to identify the low performance query. Details for MicroStrategy Web and Web Universal follow: MicroStrategy Web (ASP. P83. For formatting ideas, see Formatting suggestions. In this grid, pull Customer attribute to the rows and Profit metric to the column as shown below:Mobile - To send the report or document execution to the mobile device. From the Tools menu, select Document Properties. In MicroStrategy Web, log in to the Tutorial project. The highlight on hover is enabled in Presentation mode by default to indicate the viewer’s mouse focus. MicroStrategy Document Creation Help. Excel: This allows the user to export the document to Microsoft Excel in . To change the grouping and sorting dataset. You can use the visualization to: Filter the map markers shown in the visualization by selecting map markers for which to display data. 215 Embedding Analytics with MicroStrategy REST API 2022. If the designers do not have access to the image, they cannot see the image while creating the document. x reports display the 'Metrics' column on the report grids by default. You use the authorization token returned in step 1 as the value for X-MSTR-AuthToken and provide the project ID. Details: With the Data Import functionality, MicroStrategy imports data from Snowflake into our fast in. MicroStrategy Optimization: VLDB Settings. Click the link for the desired manual or other documentation source. Functions —These are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-defined calculations. 9. 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 sent to the MicroStrategy Intelligence. wherever you want on the canvas and use the layers. For a document, edit the document in Design Mode or Editable Mode. Note: More elaborate programs will require additional library files and are out of the scope of this document. JSON length allowed in the POST request of exporting in the. If you hold down the CTRL key while resizing, snap to grid is temporarily turned off. The My Subscriptions page opens and displays a list of your subscriptions. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. The dataset report of a document contains the MicroStrategy objects that can be. Some document caches can be created without dataset caches, such as documents created against visual insight and so on. In MicroStrategy Developer, double-click the document name or icon. Right click on a Report Services Document. Utilize any of the following design options when creating a document: Display theme for a document; Display theme for an object Documents allow you to showcase your business data in a user-friendly, boardroom-quality way that is suitable for presentation to management. Documents 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. Expand the document section where you want the image by clicking the plus sign next to the section name. 2) Choose the End Date and set a qualification as End Date less than Start Date as seen below: 3) Double click on the threshold and check Replace Data, type a replace text like “Invalid Date”. 3. Choose Reports/Documents to be scheduled (Answer the prompts, if any) and click Next. About prompts. 4. A dataset is a set of data that can be displayed on a document, Report Services dashboard, or Visual Insight dashboard. A dataset can be a MicroStrategy report, a MicroStrategy Intelligent Cube, or data imported directly from an external data source. xls format. Include bookmarks in the PDF. On the My Subscriptions page, under the Email section, click Add email subscription. 3 : From the Format menu, select Properties and Formatting. ' Both R1 and D1 are listed as dependents as shown below:A MicroStrategy Report Services document contains objects representing data coming from one or more datasets, as well as images and shapes. Create a metric selector S2. In MicroStrategy Web, open the document in Design Mode. The term "versioning" has two different meanings in a MicroStrategy context. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. . Use the Inspector tool to select an element: 3. When you return to the Document Editor, the dataset is added and displayed in the Dataset Objects panel. Connectivity Connectivity is typically the biggest concern among customers. MicroStrategy Professional Services offers a service to tune customer environments including the optimal heap size and garbage collector parameters. By default, the document opens in Presentation Mode. txt file). On the upper right of any page, click your user name, and then select Preferences from the drop-down list. If you have a Distribution Services license, you can subscribe multiple users to an individual report or document through MicroStrategy Web (see To Create a Subscription in MicroStrategy Web). For tuning details, see the appropriate section in the Installation and Configuration Guide. The document opens in Design View in the Document Editor. The first document was technical document entitled "Narrowcast Server 7. Drilling is available for Report Services Documents starting in MicroStrategy 9. Open the document in Design Mode or Editable Mode. For a document, edit the document in Design Mode or Editable Mode. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Enterprise Manager and to address issues encountered during the statistics logging and data load processes. The text field for new notes opens. When you move the cursor to the Layout area, the pointer becomes crosshairs. This setting removes the sections that do not have any metric data. Documents in MicroStrategy Web have the same functionality as documents in MicroStrategy Developer, such as viewing, printing, and exporting. To Export a Report or Document from the History List. If users want to be able to create their own filters, thresholds, or change the graph style used to display data. * MicroStrategy does have support for dynamic sourcing with MDX sources. 0 and 6. NET) The most significant things you can do: Tune Microsoft's Internet Information Services (IIS). Users that have the "Edit Notes" privilege can edit notes as described below: Click Edit. On the Freeform Sources tab, select Create Freeform SQL report. Refresh the page, check Medium ’s site status, or find something interesting to read. You can group information in a document using the Grouping panel, located above the Layout area in the Document Editor interface. There are several important factors to consider before tuning your. This document provides best practices on maintaining the MicroStrategy metadata health by controlling the size of the Change Journaling Tables and cleaning up. Select to display the text box in the required date format s shown in the image below:When exporting a report from MicroStrategy Web to Excel, it is expected that the Excel filename will be the same filename as the report it was saved under. In the Property List Window, set the 'Hide if empty' value to 'True. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data warehouse. In Developer: In a report or document, from the File menu, select Schedule delivery to, then select History List, Update cache, or Mobile. Drilling allows users to look at specific data at levels other than that of the originally displayed Grid/Graph. To analyze the cache hit ratios for prompted jobs, select Prompted jobs at the prompt. To get all of these features and security updates, you can download the latest release from the MicroStrategy Resource Center to on-prem deployments, or access MicroStrategy on AWS or Azure via the MicroStrategy Cloud Console. Creating widgets. The governing limit for the Platform Analytics cube is 20 GB out-of-the-box. x, grid and graph displays are cut off on the right side. 2. x. Event Based Schedules Event based schedules run reports and tasks when the event associated with them is triggered. If the document is not grouped, no bookmarks are generated. All the forms for the selected attribute will be displayed. Dedicate a machine for the metadata repository. A prompt allows a user to provide an answer to restrict or filter data during report execution. Right click on the dynamic text and then click on "Format". Open Microsoft Office on the web. 4. Enter the text of the desired macro or your own static text. The schedule wizard will be displayed as shown below. Example: my_computersharedmyimage. To unsubscribe a report or document, select the checkbox in the Unsubscribe column and then click Unsubscribe. g. x and 10. If the document contains multiple layouts, click the tab of the layout whose printing options you want to modify. In the list of categories on the left, click Subtotals. MicroStrategy out-of-box provides two display themes: The Light theme and The Dark theme. The Insert Function dialog box opens. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. The modules can be mapped to a different warehouse, used as starter kits to develop custom applications or used as a source of reporting ideas for designing effective grid reports, graph reports, documents, and dashboards. To make this folder visible, in MicroStrategy Developer, click on Tools and choose Preferences. "View Notes" privilege to see any notes that have been added to the document. When you select a large amount of data in a filter, the document produces the errors shown below in both the browser and console. When viewing Report Services Documents in MicroStrategy Web 9. Designing and creating documents: An overview. Follow below steps to apply the. Excel with plain text: Export the report to Microsoft Excel as plain text. xls format. The Document and Dashboard Analysis Guide describes the steps for a business analyst to execute and analyze a document in MicroStrategy Web and MicroStrategy Developer. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. The following is an example of the syntax necessary for file delivery, the name of the file can be specified with static text and/or Information Objects:A control document is a file specified per publication that alters MicroStrategy Narrowcast Server 9. To delete a layout from a multi-layout document INTRODUCTION This knowledge base article provides best practices for configuring, monitoring and troubleshooting Enterprise Manager 10. Click the Export to Excel icon in the toolbar. it should be large enough to process it quickly. Each layout will start on a new page. Tuning a MicroStrategy system is not an exact science. P81, was entitled "MicroStrategy Narrowcast Server System Sizing Information" and was marked "MicroStrategy Inc. The second line is displayed in a blue Courier font by the HTML tags. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. Controls are shown in the document's Layout area as you design the document. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. "" -n "" -u -p -f. NET): Program FilesCommon FilesMicroStrategy directory. In MicroStrategy Web, open the document in Design or Editable Mode. We empower you with the skills to get the most out of your analytics investment. On the Freeform Sources tab, select Create Freeform SQL report. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. This article explains how to resolve IIS executionTimeout errors that occur when executing MicroStrategy Web documents with large amounts of data selected in a filter. Selecting the display theme for a document . Excel: This allows the user to export the document to Microsoft Excel in . In the Run Modes area, select the format (s) in which the document can be exported: •. Click. Using the command manager script file created in Step1, create a batch file that can be used to restart the MicroStrategy Intelligence Server. This Knowledge Base articles provides some best practices for trying to improve large cube performance in MicroStrategy. A multi-layout document contains multiple documents, each in its own layout, creating a "book" of documents. Select Export from Home menu, and then click PDF. In MicroStrategy 11. Follow the instruction below to prohibit users from exporting a specific document: 1. However the setting only takes effect for. To open and interact with a document (in default PDF View) From a project in MicroStrategy Developer, navigate to the folder containing the document. The PDF View of the document is shown in the following image. Here is what the report looks like in Developer : When exported to Excel the results are as follows:Go to Tools -> Report Options (Document Options in the case of a document/dashboard) Navigate to the Delivery tab, where the following 3 options exist: Select “Only allow specific users to subscribe to this report”. Formatting text fields. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. Interact with the data in real time (with targeting, filtering, and more). How the user answers the question determines what data is displayed on the report when it is returned from your data source. Table Of Contents MicroStrategy Report Services: Document Essentials 8 ©2011 MicroStrategy, Inc. In MicroStrategy Web, on a folder page, hover the mouse cursor over the object and click Subscription. The Document and Dashboard Analysis Guide describes the steps for a business analyst to execute and analyze a document in MicroStrategy Web and MicroStrategy Developer. For example: "C:Program FilesMicroStrategyAdministratorCommand Managercmdmgr. The data loading process gathers and prepares data for analysis and reporting in the Enterprise Manager project. A dataset is a MicroStrategy report that is used on a document. 5. In this case, change both to 116px (with 8px default left/right/top/bottom margins. Select the Show Tooltip (Web Only) check box. Go to a new blank line. On the upper right of any page, click your user name, and then select Preferences from the drop. To export a report while viewing it: Click the name of a report to display it. 4. x. Note: By clicking the "Don't show this message next time" option, the "Automatic Column Widths" option must be turned off manually. Add metric "Yesterday" to the document section as dynamic text. For documents, links are functional in Interactive Mode and Editable Mode in MicroStrategy Web. When the document is executed again, the system can quickly access the cache to display the data, rather than putting a load on the system to re-run the request to the data source. Grouping records together helps users who read the document to understand the data better. It builds on basic concepts about reporting functionality presented in the Basic Reporting Guide. x - 10. Click Click here to start a new qualification to begin to create a new view filter. For steps, see the Basic Reporting Guide. A report can link to a document instead of another report, as shown in the example above. Make two grids with different attributes and metrics in each 3. Right click on the dataset report in document design mode. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best. 411 Project. Export the document to a PDF file, Excel spreadsheet, or HTML file for further analysis. 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. A red hashed border displays around the Grid/Graph, and the menu options and toolbar change. With effect from version 9. Click the Export. Enable quick switch between graph view and grid view. 155 Derived Metrics, View Filters, and Derived Elements. To specify the group-by element in a document, you use the gkey parameter in the URL. Minimum MicroStrategy version: 10. Dedicate a machine for the metadata repository. It assumes that you are familiar with designing MicroStrategy reports and documents and have the necessary privileges to do so. The Properties dialog box opens. Below are some keyboard shortcuts to fine-tune the layers' positions. Apologies, but something went wrong on our end. In the Dataset Objects panel, right-click the dataset that you want to be the primary dataset and select Set as grouping and sorting dataset. A cache is the stored results of a document query that has already been executed. To create a static label, type text: a. Click the numbered buttons above the report to expand or collapse data for the page. Use developer tools to view the HTML so that you can find the element ID for the group-by element. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. This document demonstrates how to change the type of the date to a desired format such as 20080121 and use it as the filename. This is because editing a dataset report affects the MicroStrategy report that the dataset is based on. 2. In this Example we will use the MicroStrategy Tutorial Project using a Time Dimension Attribute going across along with the metrics where any other non-Time dimension attribute going vertically, without repeating Attribute values. Go to Properties and Formatting > Layout, change the width and height so the container is larger than the HTML body, including margin. Switch to the Document Editor to add formatting and fine-tune the document. In the Grouping panel, right-click the grouping field on which to enable page-by. If the document is open in Presentation Mode, click the menu icon on. Additionaly, pictures can be inserted borders drawn in the document. To Create the Item Order Form Document. 0 (for specific system requirements, refer to the Readme. In the upper left part of the Get Info page, notice the following link: Change Cover Page. mstrc) is a text file that contains all of the information needed to connect Workstation to a MicroStrategy environment. 4 : Do one of the following to create a new layout: •INTRODUCTION This knowledge base article provides best practices for configuring, monitoring and troubleshooting Enterprise Manager 10. Double-click any of the documents listed on the right-hand side of Desktop, to execute it and see the results. The legend frame is moved to one of the default locations on the graph report. Save reports used in documents in a well-labeled location to minimize conflicts between modified reports and documents. x. x. Here, you can select the way that you want to export grid reports, graph reports, and HTML documents. Of course, you can always export a report or document from a regular report/document folder, into several formats such as Microsoft Excel, HTML, and so on. The recommended VLDB optimizations for Oracle 11g are listed below. It builds on the basic concepts about documents presented in the Getting Started with Documents section of the MicroStrategy Web help, which helps document designers understand how end users will use. To display it as both a grid and graph simultaneously, in the Property List: Appearance section, select Grid and Graph from the View mode drop-down list. Follow the steps below to make the changes in MicroStrategy Web 9. For tuning details, see the appropriate section in the Installation and Configuration Guide. Document Editor. Note: Users cannot schedule reports with prompts unless the report has default answers. That is, the document is grouped first by the leftmost object, then by the object to the right, and so on. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. This section discusses how to analyze your users' requirements, and the ways you can configure and tune your system to meet. You can access document features such as inserting a Grid/Graph or formatting a text field using the toolbar options in the Document Editor. ACTION: The DHTML Heat Map widget can be configured as below: In a document, insert a grid with one attribute and 2 metrics. Selecting a display theme for an objectThis "How to" technical note describes a way to hide the metrics columns from a document grid in MicroStrategy 10. MicroStrategy recommends the following best practices for network design: Place the web server machines close to the intelligence server machines. Notice surprising patterns with visualizations. The HTML tags format the first line as a heading 2. MicroStrategy Desktop 8. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. Refer to the following MicroStrategy Knowledge Base document for more information: KB30866: New feature in MicroStrategy Intelligence Server 9.