A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. A Compound Grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Export server-level settings and import them for use with another server. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. Order: The sort order of the row or column. x, follow the steps below:. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. With a few lines of code, data scientists can extract data from cubes and reports and publish entirely new datasets for consumption by other analysts. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Tasks. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. The compound join saves memory space and processing time on the Intelligence Server executing the document. Insert an HTML container (and not an image) and insert the script below. Visualize Data Trends: Create intuitive visualizations to present data after it is parsed, structured and analyzed. Portion displayed only (only the displayed page if multiple pages). In the drop-down on the selection bar, select. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms . In the right corner of the dashboard, change the. Create a Report Services Document 2. In the Editor panel, click Add Column Set to create another column set. The compound join saves memory space and processing time on the Intelligence Server executing the document. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. For example, there. Filter data in a second visualization by selecting attribute elements or metric values in. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. 3. How to use the. 4 and later. The graph legend or axes can be formatted as well. All Grid Fonts: Select font formatting options for all text. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. For details, see Viewing a Grid/Graph displayed as a grid. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. of distributed under each attribute element. This document provides the steps to accomplish the same. Transformations allow you to apply an attribute-element based offset to compare metric data. Click the Options icon . The graph shows revenue by category and region. See the previous images above to see how the row headers should now appear. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. From the Visualizations panel, select Grid . Add, rearrange, or remove data from a visualization in a dossier. Relationship Tables. A normal attribute represents a single hierarchy level (for example, Month). x, non-aggregatable metrics are used for this kind of calculation. The only solution that I can think of is to create a FreeForm SQL Report. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. Metric Qualification (MQ) Tables. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Use compound. Follow the steps below for an example of how to do this. View standard reports in MicroStrategy Library to get a simple, grid view of data. This will enable the option to use ApplyComparison’s in Filters. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. . Compensating Transactions. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. 1 and 10. A recursive hierarchy or recursive dimension, usually consists of elements that point to other elements pertaining to the same attribute with a parent-child relationship. Access. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Type a name for the metric in the Metric Name field. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. To change how it is displayed, do one of the following: To display it as a grid (a standard MicroStrategy grid report with rows and columns of attributes and metrics), in the Property List: Appearance section, select Grid from the View mode drop-down. In this case, only one form exists for each, as shown below:Microstrategy Document Editor Sections Important Notes: The Layout area is in the center of the Document Editor interface and provides the framework for precisely controlling where controls (such as text fields, grid and graph reports, images, and widgets) are displayed when the document is viewed in different display modes, printed,. Creating metrics on-the-fly: derived metrics, Defining attribute elements on-the-fly: derived elements, Filtering data on the fly: view filters and metric filters, Importing data as an. Overview of level metrics in MSTR. The contents of the grid report are displayed, separated by commas. Notice that a joint child relationship can be one-to-many or many-to-many. . MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. x-10. E2open - MicroStrategy Training. A Compound Grid stitches multiple simple Grid visualizations together to. of data from digital manage digital identity. Click Insert Visualization to add a new, blank visualization to the dossier. Here the many-to-many relationship is converted into a compound attribute relationship. Select any project that is in the project source that. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. Because element prompt answers are matched with prompts using the AttributeID, the order of the prompt answers does not determine the order in which prompts are answered. The content of the report is displayed. xls format. Invoke the MicroStrategy Integrity Manager executable MIntMgr. 4 and later. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Method 2: Document with a Grid without the Grid Title Bar. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. Unfortunately I have a limitation/bug to report and ask about. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. Hover over the visualization to use as the source and click More in the top right and choose Select Target. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the Metric Join Type set at the Database Instance Level: The subject of Outer Joins is a very broad one, however, as a. Step 2: Connect the atoms to each other with single bonds to form a “skeleton structure. Create a report with Year on the rows and Revenue on the columns. Introduction to Grids You can display data in a grid layout. To export a report while viewing it, click the name of a grid report to display it. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Set Data Engine Version setting to 11 or. Ultimately, it was. Compound metrics are the ones that are derived by some specific expression involving the different simple metrics. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. Create a metric that sums the fact Units Sold. 3K views 3 years ago What's new in MicroStrategy 2020 Learn how to use compound grids in dossier. In MicroStrategy Web, edit or execute a report. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. And leverage the Page-By function to focus your analysis on one element. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. A blank visualization appears in the dossier. 5. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. The syntax is: FileLocation is the path to the saved test file. (Highly recommend for understanding your exported data). Copy individual cells from grid visualizations to the clipboard. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. The Metric Editor opens in either Function Editor mode or Formula Editor. To determine how null and zero metric values are displayed or hidden in a grid report Open the report in Edit mode. The new grouped attribute appears in the Attribute Name field as. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. You need to compare the number of units sold today to the number of units sold from January 1 through today. But, this can also be done with this. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. A grid is an essential element of data analysis. In our. Custom grids allow you to utilize dynamic text fields in order to create grids that provide more. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. Creating Box Plots. Excel: This allows the user to export the document to Microsoft Excel in . compound attributes. To export a report while viewing it: Click the name of a report to display it. Make two grids with different attributes and metrics in each 3. Input connection parameters for the connector:MicroCharts are visualizations that MicroStrategy has in Document, but not in Dossier. 2. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Line: Select the style of the grid lines from the drop-down list. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. 4 and later. A Grid/Graph is a container that is placed in a document and which displays a standard MicroStrategy grid or graph report. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. MicroStrategy Library is an interactive application of the MicroStrategy Business Intelligence platform that lets business users harness the analytical power of MicroStrategy in a simple, clean and modern user interface. This can be in the form of graphs, charts, maps or other graphic depictions that. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. Eine zusammengesetzte Tabelle ist eine Visualisierung, die es Ihnen ermöglicht, komplexe Tabellen zu erstellen, die verschiedene Aspekte von Daten über eine gemeinsame Dimension analysieren. Relationship tables in Microstrategy. Format the grid. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. This article describes how to merge the row headers in Visual Insight MicroStrategy Web 9. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. NOTE: Modifying the key form will trigger required updates when saving. If the document is being displayed on an iOS device, you can link the report to the cells of a transaction table. This design may look strange, but in most cases there are. Tasks. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The following procedure describes how to achieve this: Create the highest level filter. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. This may make related application objects (reports, filters and. On the Overview page, click the Comments icon. MicroStrategy Desktop's basic set of 40 colors matches the Excel colors. 9, we’ve taken a leap forward in our dashboarding capabilities. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. This means that every metric is evaluated in separate SQL passes. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. Steps to Reproduce on a Compound Grid. I'm showing on a grid visual unique IDs from the fact table and a measure that checks if there is value in a specific column in the fact table for the selected id. Select the entire visualization or just the area you want to format. Creating a Compound Grid Visualization. x - 10. MSTR Secure Enterprise. When users make selection on grid selector in MicroStrategy Web 9. promptAnswerMode *. For SAP BW, the following syntax may be used. This section shows the effects of different element settings on a single metric when used in the same report. Click Switch to Function Editor. Lookup Tables. A normal attribute represents a single hierarchy level (for example, Month). The example above will now return 77. Create two compound metrics C1_R=Cost(1)/Revenue and C1_R_PM=C1_R/. A dataset is a standard MicroStrategy report. To do so, you must link a Transaction Services report to a grid or to text fields in a panel stack. Users may want to display MicroStrategy Web 10. Erstellen einer zusammengesetzten Tabellen-Visualisierung. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. You treat one attribute as a child of the other and have a compound key for the lower level attribute. The option to Delete unused managed objects allows a MSTR Admin to force a search and delete of those managed objects which no longer are in use by the project (no longer have dependants). Microstrategy Dossiers With the release of MicroStrategy 10. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. A compound attribute is an attribute with multiple columns specified as the ID column. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. HTML: The grid report is exported to an HTML file. Panel Stacks. Follow the steps below. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Create a Compound Grid. General Settings. In this brief video tutorial, Jason Hudson from our Customer Education team explains how to create a grid visualization in a dossier. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. Creating a Compound Grid Visualization. The name of the source visualization. 3. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis. So the row for Music will not display in the grid. A heat map visualization requires a minimum of one attribute and one metric to display correctly. An input box will be displayed with a list of recommended questions based. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. Subscribe. Create a Report Services Document 2. Use the links below to create visualizations using the Visualization Gallery:Considerations for the use of star schemas with MicroStrategy SQL Generation. DAY_DESC. View data in simple grid format and leverage page-by options. x SYMPTOM When users create a Grid visualization in Visual Insight using MicroStrategy Web 9. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. September 06, 2018. 1 - Answers all required prompts and optional prompts with default answers. Introduction to Visualizations. Cross-tab Stage: Pivot and display sorting and page-by. Each conditional metric contains a copy of employee list (in an IF statement) Employee list filter is moved to a separate metric (Flag metric) Employee list filter is moved to a Filter object. 6. For example, a document contains two Grid/Graphs. MicroStrategy AI is here. Double-click the Column Set name to rename the set. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. J2EE environment:Year-To-Date Transformation Example. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Learn more. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Measure: SLA Status = ISBLANK(SELECTEDVALUE('Alerts'[handledAt])) the results before adding data from dimension: everything works fine until I add data from dimension. Create or edit reports with authoring functionality. Notice that some metrics from the right grid are missing. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . You can define metrics by using the available functions to analyze your data and determine business measures. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. General Settings. This may make related application objects (reports, filters. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. This is now feasible beginning in MicroStrategy 2019. Format Panel for Grid Visualizations. In Comments, enter @. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. In the Editor panel, click Add Column Set to create another column set. The Compound Grid supports similar operations as regular grids, such as: Notice that a joint child relationship can be one-to-many or many-to-many. Each custom format can have up to four. While all metrics have a formula, not all of them have. Note that only the naming convention has changed, as the functionality remains the same. The simple key shows how you can identify a calling center with only its Call_Ctr_id. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Introduction to Visualizations. And leverage the Page-By function to focus your analysis on one element. Microstrategy Dossiers With the release of MicroStrategy 10. This document provides the steps to accomplish the same. Excel with plain text: Export the report to Microsoft Excel as plain text. In the new fix, Data Engine fixes the problem of not using the Metric Guide in the component metrics of Compound Metrics. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. In a document, you can display a report by adding a Grid/Graph to the document. This calculation can be aggregated from the Employee level to the Region level. 4 and later. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. The compound join saves memory space and processing time on the Intelligence Server executing the document. Related articles from the Community: Knowledge Base: Dossier is no longer certified when downloaded as a . The selection bar opens, and the heat map is labeled as the Source. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. A compound grid with more than one column set is being used (image for reference): While looking normal in the dossier: After exporting to excel, the rows are not. In the left toolbar, click Format. Dependiendo del número de elementos hijos que tenga definido el contenedor grid en su HTML, tendremos una cuadrícula de 2x2 elementos (4 ítems), 2x3 elementos (6 ítems), 2x4 elementos (8 ítems) y así sucesivamente. In MicroStrategy SQL Generation Engine 9. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. Connecting Tableau to TDV Using ODBC. 4. x and 10. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. My org. This means that two calling centers from different regions can share the same Call_Ctr_id. x, users may notice that the row headers are not merged, like shown below:Design compound visualizations or add rich text boxes and images. Click Certify. Note the picture with the definition. Copy individual cells from grid visualizations to the clipboard. Select Custom as the Category and create the format using the number format symbols listed in the table below. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Double-click the Column Set name to rename. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. Despite the name, it only support Database Specific OLAP functions like Rank, Tile and RunningSum (assuming your DB supports those). Insert an HTML container (and not an image) and insert the script below. 1/10. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Grid Panel. Microstrategy Dossiers With the release of MicroStrategy 10. Labels: #Prompts in URL API #mstr urlapi. A compound grid requires at least one attribute and one metric. V. Indexes Panel. Microstrategy Dossiers With the release of MicroStrategy 10. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. The following errors were encountered while parsing the POD: Around line 3444: Non-ASCII character seen before =encoding in '·'. The "Grouping" property has six possible. 4074 views · September 04, 2020. Create or edit reports with authoring functionality. Template Select template style and color. The Grouping Properties dialog box opens. When users make selection on grid selector in MicroStrategy Web 9. in Microstrategy Dossier, is it possible to create 2 rows of header, such that the first row is the grouping information and spans to number of columns to identify as a. This video show how to share a filter with other MicroStrategy Library users. Upgrade to MicroStrategy 11. You cannot place the widget in the Detail section of a document. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Creating Histogram Charts. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Ragged Hierarchies. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. The multiple columns are joined with other attributes, typically in a many-to-many relationship. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. x-10. replace (truncates and replaces the data) This Knowledge Base article introduces "mstrio," Python and R packages which provide an interface for the MicroStrategy REST APIs. 3. Slicing means that the data for each available item in the selector is calculated in advance when the document is first displayed. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Create a report with the Region and Month attributes and the Revenue metric in the grid and filter. This document provides the steps to accomplish the same. The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. In the Run Modes area, select the format (s) in which the document can be exported: •. A blank visualization appears in the dossier. Choose Excel-compatible colors for objects as well as grid and graph formatting. Click the vertical eclipse icon (More) on the top right of the visualization. After creating a grid, interact with its data to customize your view, by performing the following tasks: Add and display. 1, the value range of the metric slider keeps the same when the grid selector answer is changed, as. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. MicroStrategy Geospatial Services is automatically enabled in these. If an error does not appear, view your Compound Grid and notice the subtotals on the grid are not appearing for the attributes from the second column set. Export Report Title: Selected by default. 5. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. This article outlines an issue when using a Compound Grid there is a missing row after exporting to Excel. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Note: This fix changes CSI and data. Run the document on iPad, as shown below: 12. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. - Program Files (x86)Common FilesMicroStrategyimages. Fields. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. The graph legend or axes can be formatted as well. This groups them, but doesn't label them quite yet. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. Create a compound metric "Count Employee" as "Count Employee temp" + "Zero" with the definition: ( + Zero) Under the "Subtotals/Aggregation" tab, enable the setting "Allow Smart Metric", at the bottom of the pane: Use the compound metric "Count Employee" on. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. 1919 views | September 04, 2020. 3. 5. In the Datasets panel, double-click attributes and metrics to add them to the visualization. But, this can also be done with this. ”. Note the next figure. MicroStrategy Parallel Relational In-Memory Engine (MicroStrategy PRIME), MicroStrategy R Integration, MicroStrategy Report Services, MicroStrategy SDK, MicroStrategy System Manager, MicroStrategy Transaction Services, MicroStrategy Usher, MicroStrategy Web, MicroStrategy Workstation, MicroStrategy World, Usher, and Zero-Click Intelligence. A Grid/Graph acts as a standard MicroStrategy report. x-10. 4 and later. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Go to project configuration by right clicking on specific project (You need admin rights to do this). 4 and later. By default, the MicroStrategy SQL Generation Engine orders the tables in the following way: Fact Tables. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10.