Microstrategy URL API hide sections. このチュートリアルでは、複合グリッドへの切り替え方法、複合グリッド内の列セットの追加方法、およびこの新しいビジュアリゼーション タイプを活用する簡単な使用例について、順を追って説明します。. For example, there. In the list of categories on the left, click Subtotals. This design may look strange, but in most cases there are. How to use the MicroStrategy 2020 compound grid. Compensating Transactions. This is a filter which contains a prompt on an attribute element list. This URL executes a report with one prompt. Open a new or existing dossier. Profit is not displayed on the Grid/Graph, nor is it in the data source for the Grid/Graph. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. Create a metric that sums the fact Units Sold. Click Insert Visualization . 09K KB46909: Rows are missing when exporting a grid in outline mode with subtotals enabled in. Cross-tab Stage: Pivot and display sorting and page-by. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. The data from the report is used to populate the Grid/Graph. Navigate to the first page of the Office Royale Sales dossier. Insert an HTML container (and not an image) and insert the script below. Save the dashboard. 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. Query Stage: Retrieve data from the warehouse. Select the desired option for 'Show attribute names'. To enable totals or subtotals for a metric. Graph: Displays the data visually like a standard MicroStrategy graph report. 3. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. In this case, only one form exists for each, as shown below:To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. Access. An inner join between pass 1 and 2 is performed in pass 3. Access. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Turning on totals returns a row for the total, even though there are not rows of data to show. Power BI's dashboards update in real time from all data sources. Select any project that is in the project source that contains the users and groups and click Next. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. Measure: SLA Status = ISBLANK(SELECTEDVALUE('Alerts'[handledAt])) the results before adding data from dimension: everything works fine until I add data from dimension. This means you can have multiple. compound attributes. What's New;This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. The Compound Grid supports similar operations as regular grids, such as: Sorting. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. Start Power BI Desktop. Labels: #Prompts in URL API #mstr urlapi. This will allow you set the different sets of columns that behave differently. Select only Configuration Objects for documentation. A custom group is a special filter that can be placed on a template and is comprised of an ordered collection of elements called custom group elements. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In this case, the only object in the columns for this grid is the metric "Revenue". Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. To create a MicroStrategy Environment connection file . In this tutorial video, we'll show you how to modify Grid visualizations in MicroStrategy to export them to Excel. For example, a document contains two Grid/Graphs. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. 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. This document provides the steps to accomplish the same. Create a report with Year on the rows and Revenue on the columns. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. Visualize Data Trends: Create intuitive visualizations to present data after it is parsed, structured and analyzed. MicroStrategy Geospatial Services is automatically enabled in these. A Compound Grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. This metric is used for getting "1" value for all rows. 4. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. I'm working on a dossier and I have a dataset that includes customer types. This section shows the effects of different element settings on a single metric when used in the same report. 4. On the next screen, select the DSI you want, then click the Generate Geospatial Service key button. This may make related application objects (reports, filters. 1929 views | September 04, 2020 02:01. When you upgrade your MicroStrategy software version, you may not want any changes in your data or in the look and feel of your application objects. Learn how to build custom grids using MicroStrategy Documents. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure. Double-click the Column Set name to rename. 4 and later. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis when you need to analyze several KPIs across a common dimension, like investment vehicle or region. Do not forget to enable Subtotal (F11). This document provides the steps to accomplish the same. 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. Only Year 2000 data is returned in the grid:foundation of the Intelligence Server worflows scheduling and and teams to best-in-class automates the capture administrators to. Invoke the MicroStrategy Integrity Manager executable MIntMgr. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. In general, a user specifies a list of conditions and corresponding return values. DAY_DESC. 9, we’ve taken a leap forward in our dashboarding capabilities. To reference an image using relative path, the following. 2 - Closes all optional prompts with an empty answer. In the Grid/Graph, you can use MicroStrategy Web to create a threshold to change the formatting of the revenue amounts when the profit is greater than a specified amount. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. 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. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. In the Editor panel, click Add Column Set to create another column set. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. Open the dossier you want to modify. Follow the steps below: Right-click on the project and select 'Project Configuration. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. Learn how to switch to a compound grid, add column sets in this new visualization. Compound Grid visualizations. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. 4. Select the entire visualization or just the area you want to format. (Highly recommend for understanding your exported data). MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. 0 or above. Note the picture with the definition. Subscribe. xls format. 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. Filter data in a second visualization by selecting attribute elements or metric values in. In the Editor panel, click. 5. V. Choose Grid > Compound Grid . In our use case, we wanted to set up an Excel workbook to pull the contents of the compound grid using the Microstrategy for office add-in. The smart metric and the component metric are from different datasets. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. 3. The color is displayed in Presentation Mode in MicroStrategy Web. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. View data in simple grid format and leverage page-by options. Click the location on your document in which to place the widget. The syntax is: FileLocation is the path to the saved test file. Click the vertical eclipse icon (More) on the top right of the visualization. In the Visualization Gallery, click Combo Chart to create a combination graph. Click Certify. 02:40. Even if the source attribute is not included in the Grid/Graph, the data is still. You need to compare the number of units sold today to the number of units sold from January 1 through today. Choose Grid > Compound Grid . On the grid, right click on the column and select “Sort Grid”, select descending: Result when running the document, metric values not sorted as descending: CAUSE 1. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. The Excel File will contain only the selected Grid Object data from the Document. To enable totals or subtotals for a metric. x-10. KB483841: Known issues when using a slicing selector to target a. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Create a report as shown below: When Category=Music, the Cost(1) and C1_R_M will have null values. In this example, the Year attribute is used. Export Report Title: Selected by default. To enable totals or subtotals for a metric. To export a report while viewing it, click the name of a grid report to display it. Learn how to use compound grids in dossier authoring, which allow you to combine multiple lenses of the data in a single view so that they can be analyzed ac. When a display alias is set for objects in a grid, the object alias is not displayed in the report filter in MicroStrategy Developer. 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. Metric Qualification (MQ) Tables. A Grid/Graph can be directly associated with one dataset report. Enter 'Year' as the attribute and click 'Prompt' as shown below. Color from the Advanced Color Picker will. The following schema shows which setting takes precedence when set at different levels. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Continue with the previous Steps 2 and 3 above. This URL executes a report with one prompt. Portion displayed only (only the displayed page if multiple pages). Users sometimes encounter the "Report returned no data" message when executing a report and are unable to display the report result as an empty grid instead. In MicroStrategy Web 2019 and above, when running a dossier with row headers centered in the middle (vertically) of the grid, row headers do not appear correctly as you scroll down. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. In the relational database, a. The selection bar opens, and the heat map is labeled as the Source. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. 9, we’ve taken a leap forward in our dashboarding capabilities. Ø Local Transaction options. It is now possible to format column groups differently, freely alternate the placement of metrics and attributes in the column headers for each group of columns, or choose which columns of the Grid should show the subtotal value or all values. 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. 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. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. In this tutorial video, we'll show you how to modify Grid visualizations in MicroStrategy to export them to Excel. You cannot place the widget in the Detail section of a document. To do so, click Tools > Report Details Page after the report has. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. This document provides the steps to accomplish the same. Learn how to switch to a compound grid, add column sets in this new visualization. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. [ONAME:Compound Grid]: This is the name of the object. NOTE: Modifying the key form will trigger required updates when saving. Run the document on iPad, as shown below: 12. Hover over the visualization to use as the source and click More in the top right and choose Select Target. We'll cover how to include repeated rows,. Drag and drop the . 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. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. x, select 'Project Documentation' from the Tools menu to. On each column set, add at least one attribute. Name, [Measures]. From the Tools menu, select Grouping. For example, a document contains two Grid/Graphs. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. For example, there. x - 10. Create a Compound Grid. A Grid/Graph acts as a standard MicroStrategy report. Select or multi-select users as recipients of the dossier. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. x, the series lines do not inherit the color of the series markers and change depending on which metrics are displayed on the graph. Click here to view help for the latest version of this product or search MicroStrategy Community. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Create a Modern Grid with Microcharts A modern grid visualization allows you to include microcharts within cells. Open an existing dossier that contains a grid visualization. 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. x allows users and administrators to decide if the attribute titles are displayed using the attribute name or the attribute form name: The setting to control the appearance of the attribute title is located under Preferences - Grid Display: Show Attribute Form Names. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. Using the Connector. Locate the Request Geospatial key button above the products session and click on Mapbox Key : Each key is DSI specific. x, select 'Project Documentation' from the Tools menu to start the wizard. 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. It can connect to data warehouses, relational systems, flat files, web. You can explore the relationships between data elements by creating a network visualization, or create. Custom grids allow you to utilize dynamic text fields in order to create grids that provide mo. MicroStrategy AI is here. The following errors were encountered while parsing the POD: Around line 3444: Non-ASCII character seen before =encoding in '·'. Select any project that is in the project source that contains the users and groups and click Next. Here the many-to-many relationship is converted into a compound attribute relationship. This article describes how to obtain the executed SQL for a report from MicroStrategy Web. Tell the data story with top visualizations and Dossier features. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. Note how a grid is returned with the total when there are no rows of data: Cause This is a known issue in MicroStrategy 10. You can define metrics by using the available functions to analyze your data and determine business measures. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Click Advanced, then New to create a custom subtotal. The Grouping Properties dialog box opens. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). The content of the report is displayed. 4 and… Number of Views 3. From the Visualizations panel, select Grid . exe to this machine. To enable a visualization to filter or highlight the data in another visualization. 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. Visualizations provide a variety of ways for you to display and interact with the data in a dossier. Microcharts are small versions of visualizations shown without. 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. From the Visualizations panel, select Grid . Formula and dimensionality are the two important components in a metric. Data from the input objects defined in the Transaction Services report is displayed in the grid, text fields, or cells for users to. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. x and 10. Microstrategy Dossiers With the release of MicroStrategy 10. x When a security filter is used, different users get different report results when the same report is being executed, hence there might be a need to include the name of the user who generated the report in the grid to differentiate the. Here the many-to-many relationship is converted into a compound attribute relationship. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. For the Time hierarchy, the offset can. The simple key shows how you can identify a calling center with only its Call_Ctr_id. The graph shows revenue by category and region. Make two grids with different attributes and metrics in each 3. And leverage the Page-By function to focus your analysis on one element. Format the grid. Continue creating this derived metric by following the steps to create a summary metric in Using a function to create a subtotal: Creating summary metrics. 11. Click Share > Library Access. Independent Transactions. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. In MicroStrategy Web 2019 and above, when running a dossier with row headers centered in the middle (vertically) of the grid, row headers do not appear correctly as you scroll down. promptAnswerMode *. This case is also explained with an example based on the MicroStrategy Tutorial project. Columns Panel. A grid is an essential element of data analysis. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Insert an HTML container (and not an image) and insert the script below. Create a second metric identical to the first, but add the predefined Year to Date transformation. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. From the 'Edit' menu, choose 'Group'. The property is named "document grids from multiple datasets" and defaults to enabled but can be set to disabled. . Double click on your Report Filter and you’ll now have the option to add an Advanced Qualification: You can then provide the code for the ApplyComparison. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Create or edit reports with authoring functionality. In diesem Lernprogramm erfahren Sie, wie Sie zu einer zusammengesetzten Tabelle wechseln, Spaltensätze innerhalb der zusammengesetzten Tabelle hinzufügen und einen einfachen Anwendungsfall für die Nutzung dieses neuen Visualisierungstyps finden. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. The data from the datasets is used to populate the report. Microstrategy Report Services documents vs Dashboards A MicroStrategy Report Services document reading data coming from manifold reports, equal the data laid out additionally designed in presentation-quality format. Creating Network Visualizations. 2) Create Metric2 as the RunningSum of Metric1. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. In the Datasets panel, double-click attributes and metrics to add them to the visualization. x, select 'Project Documentation' from the Tools menu to start the wizard. When users make selection on grid selector in MicroStrategy Web 9. Save designs as templates. Select the 'Advanced' tab, as shown. Click Insert Visualization to add a new, blank visualization to the dossier. The "Grouping" property has six possible. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. To access the Advanced Sort dialog: Select a grid visualization. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. How to use the. Mar 17, 2022 -- 2 Working with data is fun! Recently I found myself obsessed with MicroStrategy’s grid tool. x. 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. 4 and later. You treat one attribute as a child of the other and have a compound key for the lower level attribute. 678 views 2 years ago MicroStrategy 2020. com Click Insert Visualization . mstrc”. Export Report Title: Selected by default. To export a report while viewing it: Click the name of a report to display it. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 1, the value range of the metric slider changes accordingly. MicroStrategy download site to. Choose Grid > Compound Grid . Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. View standard reports in MicroStrategy Library to get a simple, grid view of data. 11. From the Tools menu, select Report Options . Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. Why MicroStrategy Why MicroStrategy Why MicroStrategy. Create a Report Services Document 2. Each custom group element can be labeled with a header and includes. Share Get link; Facebook; Twitter; Pinterest; Email;. Turning on totals returns a row for the total, even though there are not rows of data to show. Select the Repeat attribute column checkbox to display the attribute. Export server-level settings and import them for use with another server. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. Method 2: Document with a Grid without the Grid Title Bar. x, there is an option to select which attribute would act as a selector, like shown below:. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. On the Overview page, click the Comments icon. Tasks. Microstrategy Dossiers With the release of MicroStrategy 10. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. A compound grid requires at least one attribute and one metric. Using a combination of filters and metric dimensionality, the same results can be achieved. This section helps you choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. A normal attribute represents a single hierarchy level (for example, Month). The Grid/Graph (referred to simply as a report) can be directly associated with one dataset or with multiple datasets. Insert an HTML container (and not an image) and insert the script below. 2) Create Metric2 as the RunningSum of Metric1. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. 5. {&GROUPLABEL} Name of the graph item's category. Overview of level metrics in MSTR. From the Visualizations panel, select Grid . The following procedure describes how to achieve this: Create the highest level filter. Introduction to Visualizations. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. Relate tables contain the ID columns of two or more attributes, which will define associations between them. The one on the left, which is displayed as a grid, shows revenue by region. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Compound Grid Generator (Large preview)A prompt is a question the system presents to a user when a report is executed. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. The one on the left, which is displayed as a grid, shows revenue by region. Type a name for the metric in the Metric Name field. Excel with formatting: The report is exported and displayed as a Microsoft Excel spreadsheet. A blank visualization appears in the dossier. Export Page-By Information: Selected by default. Double-click a column set name to rename it. microstrategy. In MicroStrategy Web 10, there is no SQL View execution mode as there is in MicroStrategy Desktop. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Eg, total (profit/units Sold). 4 and later. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. The third pass combines the results from the first two passes to generate data for Unit Sales and returns the final result to the end user. After creating a grid, interact with its data to customize your view, by performing the following tasks: Add and display dynamic links in the grid. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and. '. このチュートリアルでは、複合グリッドへの切り替え方法、複合グリッド内の列セットの追加方法、およびこの新しいビジュアリゼーション タイプを活用する簡単な使用例について、順を追って説明します。. 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.