1. Go to Web Preferences and select Project Default -> Grid Display. Click the location on your document in which to place the widget. 678 views 2 years ago MicroStrategy 2020. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or. A Grid/Graph is a container that is placed in a document and which displays a standard MicroStrategy grid or graph report. Microstrategy Dossiers With the release of MicroStrategy 10. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. 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. J2EE environment:Year-To-Date Transformation Example. Navigate to the first page of the Office Royale Sales dossier. So the row for Music will not display in the grid. From the 'Edit' menu, choose 'Group'. Compound Grid visualizations. Run the document on iPad, as shown below: 12. This means that every metric is evaluated in separate SQL passes. {&GROUPLABEL} Name of the graph item's category. To export a report while viewing it, click the name of a grid report to display it. Check the Merge checkbox under Rows in the Header section. Input connection parameters for the connector:MicroCharts are visualizations that MicroStrategy has in Document, but not in Dossier. x, follow the steps below:. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Information is arranged in rows and columns,. Fit to grid contents, to display all of the data on the Grid/Graph. Related articles from the Community: Knowledge Base: Dossier is no longer certified when downloaded as a . x: Create a metric called A with expression "Min(1){~}" as shown below. This URL executes a report with one prompt. We'll cover how to include repeated rows,. MicroStrategy AI is here. Compound grid export via Office add-in. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. From the 'Edit' menu, choose 'Group'. We'll cover how to include repeated rows,. Create a Modern Grid with Microcharts A modern grid visualization allows you to include microcharts within cells. 9, we’ve taken a leap forward in our dashboarding capabilities. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. To select how the Grid/Graph is displayed, use the View mode property. 2. September 06, 2018. And leverage the Page-By function to focus your analysis on one element. Microstrategy Dossiers With the release of MicroStrategy 10. The simple key shows how you can identify a calling center with only its Call_Ctr_id. MSTR Secure Enterprise. The Profit metric is a simple sum of the Profit fact. x, users may notice that the row headers are not merged, like shown below:Design compound visualizations or add rich text boxes and images. Create new metric Average (Revenue) via Revenue>New Metric>Average as shown below: Edit Average (Revenue) and change level to Region as shown below: Save the dashboard and create new metric M1. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1919 views | September 04, 2020. 5. Grid Settings You can choose how to export wide grids. Note the picture with the definition. 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. HTML: The grid report is exported to an HTML file. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. The graph legend or axes can be formatted as well. promptAnswerMode *. [01]. Microcharts are small versions of visualizations shown without. The graph shows revenue by category and region. Creating Combo Charts (Line & Bar Graphs) Creating Smart KPI Visualizations. Type the following for the name: "Total for the #P #0". The "Grouping" property has six possible. MicroStrategy Community 4. Click Continue if the Preview Connector warning message pops up. Finally, just create the report with the attribute (Category) and the third metric. Type a name for the metric in the Metric Name field. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. When a display alias is set for objects in a grid, the object alias is not displayed in the report filter in MicroStrategy Developer. NOTE: Modifying the key form will trigger required updates when saving. The Configure Transactions Editor opens. In MicroStrategy Web 10, there is no SQL View execution mode as there is in MicroStrategy Desktop. Using a combination of filters and metric dimensionality, the same results can be achieved. This article describes how to merge the row headers in Visual Insight MicroStrategy Web 9. Microstrategy Dossiers With the release of MicroStrategy 10. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. 5. In a document, you can display a report by adding a Grid/Graph to the document. The graph legend or axes can be formatted as well. You can import business data from many different sources, including local files, databases, Google Drive, etc. Insert an HTML container (and not an image) and insert the script below. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. 5. For example, a document contains two Grid/Graphs. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. To export the report to Microsoft Excel as plain text, select Excel with plain text. The following errors were encountered while parsing the POD: Around line 3444: Non-ASCII character seen before =encoding in '·'. Insert an HTML container (and not an image) and insert the script below. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. The following general formatting options are available to format data cells, columns, and rows in the grid visualization: Enable Banding: Select this checkbox to apply alternating colors to rows in the grid. Copy individual cells from grid visualizations to the clipboard. If the document is being displayed on an iOS device, you can link the report to the cells of a transaction table. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. From the Visualizations panel, select Grid . In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Choose Grid > Compound Grid . Note: This fix changes CSI and data. Open the dossier you want to modify. In Workstation 2020 you can only use attributes in rows. Set Data Engine Version setting to 11 or. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. The graph shows revenue by category and region. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. A compound grid requires at least one attribute and one metric. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. This document provides the steps to accomplish the same. A dataset is a standard MicroStrategy report. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. Wählen Netz > Zusammengesetztes Gitter . This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. In the list of categories on the left, click Subtotals. How to Share a Dossier. "IIf([REGION2]. MicroStrategy AI is here. 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). Enter 'Year' as the attribute and click 'Prompt' as shown below. 4 and later. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. The one on the left, which is displayed as a grid, shows revenue by region. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. 9, we’ve taken a leap forward in our dashboarding capabilities. In MicroStrategy Web, edit or execute a report. Introduction to Grids You can display data in a grid layout. 3. Creating a grid report. This calculation can be aggregated from the Employee level to the Region level. E2open - MicroStrategy Training. Then it creates a third metric, a compound metric. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. You can also apply a set of color and shading schemes to all the objects on a graph report. Turning on totals returns a row for the total, even though there are not rows of data to show. A blog on Microstrategy development and issues faced during development, deployment and maintenance. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. From the Insert menu, point to Widgets, and then select Microcharts. The effects are summarized in Level metrics. Line: Select the style of the grid lines from the drop-down list. Choose Grid > Compound Grid . Tasks. The selection bar opens, and the heat map is labeled as the Source. Notice that a joint child relationship can be one-to-many or many-to-many. Create a Report Services Document 2. 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. 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. To create a MicroStrategy Environment connection file . Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. Metric Qualification (MQ) Tables. x and are instead displayed at the bottom of the page as shown in the image below:New Modern Grid now available in MicroStrategy Dossier. In our. x SYMPTOM When users create a Grid visualization in Visual Insight using MicroStrategy Web 9. Passing prompt answers for an element prompt when the attribute has a compound ID. SQL Panel. For example, a document contains two Grid/Graphs. 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. Invoke the MicroStrategy Integrity Manager executable MIntMgr. You can display data in a grid layout. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. To determine how null and zero metric values are displayed or hidden in a grid report Open the report in Edit mode. ”. In the Editor panel, click Add Column Set to create another column set. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure. 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. You need to compare the number of units sold today to the number of units sold from January 1 through today. Steps to Reproduce on a Compound Grid. Finally, just create the report with the attribute (Category) and the third metric. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. A Compound Grid stitches multiple simple Grid visualizations together to. 1925 views | September 04, 2020 02:01. Create or edit reports with authoring functionality. 2) Create Metric2 as the RunningSum of Metric1. The contents of the grid report are displayed, separated by commas. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Select or multi-select users as recipients of the dossier. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy 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. Select 'Export to Excel' to generate a new Excel document. This section shows the effects of different element settings on a single metric when used in the same report. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. We recommend the latest version. (Highly recommend for understanding your exported data). 4. Select the Dropdown Icon () on the right-hand side of the title bar. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. x, non-aggregatable metrics are used for this kind of calculation. Grid Panel. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). 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. Metric Expressions. MicroStrategy AI is here. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. 4. This document provides the steps to accomplish the same. Solution. Despite the name, it only support Database Specific OLAP functions like Rank, Tile and RunningSum (assuming your DB supports those). 4 and later. The Insert Function dialog box opens. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. 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. This section helps you choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. In Desktop 2020 you can only use attributes in rows. A normal attribute represents a single hierarchy level (for example, Month). A compound key attribute is an attribute that has two or more IDs. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. How to Share a Dossier. Creating Powerful (and Beautiful) Dossiers. 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. of data from digital manage digital identity. Community & Support Search Discussions Open A Case View My CasesExample 1: Compound key with Effective Date and End Date. 11. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. The Export to Excel option will now appear. 4074 views · September 04, 2020. When users make selection on grid selector in MicroStrategy Web 9. Metric Expressions. Consider the following MicroStrategy Tutorial project. Creating a 'Compound Grid' 4085 views | September 04, 2020 02:40. MicroStrategy Geospatial Services is automatically enabled in these. Microstrategy Dossiers With the release of MicroStrategy 10. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. This document provides the steps to accomplish the same. 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. In this brief video tutorial, Jason Hudson from our Customer Education team explains how to create a grid visualization in a dossier. This metric should be used on compound grid (rather than standard one). Choose Grid > Compound Grid . Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. Mar 17, 2022 -- 2 Working with data is fun! Recently I found myself obsessed with MicroStrategy’s grid tool. CurrentMember. Limit the number of attribute elements displayed in a prompt in MicroStrategy. Metrics are MicroStrategy objects that represent calculations performed on data. In the report, the attribute with the compound key is Distribution Center. This feature is only implemented for element list prompts. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. The compound join saves memory space and processing time on the Intelligence Server executing the document. Start Power BI Desktop. x, select 'Project Documentation' from the Tools menu to start the wizard. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. 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. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. 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. The report execution is typically a 3 step process process of the below: Query Stage. 3. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. Although Item Sold is not on the template, since the temporary table containing data for Item Sold is outer-joined to calculate the compound metric, Unit Sales, Year 2001 appears in the final grid view. Compound Statements. This calculation can be aggregated from the Employee level to the Region level. In the list of categories on the left, click Subtotals. How to use the. 4. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. [ONAME:Compound Grid]: This is the name of the object. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. exe to this machine. Creating a. The color is displayed in Flash Mode and Express Mode in MicroStrategy Web. . 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. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. 0 or above. Export Page. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. The one on the left, which is displayed as a grid, shows revenue by region. Wählen Netz > Zusammengesetztes Gitter . Follow the simple steps below to create a datamart report: 1. Most data on a document is free one or more underlying datasets. Power BI's dashboards update in real time from all data sources. The Profit metric is a simple sum of the Profit fact. This is an excerpt from my presentation at the July meeting of the San Francisco Bay Area MicroStrate. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. Format the grid. The content of the report is displayed. communicate with mapping. In the Editor panel, click Add Column Set to create another column set. 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. x, non-aggregatable metrics are used for this kind of calculation. 6. To enable this row display, change the Join type to “Join 92” and disable “null check” for metric in report VLDB properties. In the right corner of the dashboard, change the. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. The smart metric and the component metric are from different datasets. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. 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. This article describes how to obtain the executed SQL for a report from MicroStrategy Web. Using the Connector. Execute the report and view the SQL:Open the document in Design or Editable Mode. Create three attributes named A, B, C, and after them added in a report. 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. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. Open a new or existing dossier. 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. Each custom format can have up to four. This document provides the steps to accomplish the same. Learn more. Navigate to and select a Transaction Services report, then click OK. 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. September 18, 2018. I want to be able to make one graph that shows only customer types A, B and C, and a second graph on the same page that shows only customer type D. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. To reference an image using relative path, the following. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. 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. Insert an HTML container (and not an image) and insert the script below. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. The first pass calculates Sales; the second pass calculates Item Sold. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Microstrategy Dossiers With the release of MicroStrategy 10. Create 2 panel stacks and put the same grid consisting of 1 attribute and 4 metrics on each panel stack. Search for users or add users by clicking on the add icon. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. But, this can also be done with this. Export a dossier when viewed in presentation mode. 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. 678 views 2 years ago MicroStrategy 2020. A compound grid requires at least one attribute and one metric. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy 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 this tutorial video, we'll show you how to modify Grid visualizations in MicroStrategy to export them to Excel. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. 2. In both a Grid and a Compound Grid, checking multiple attribute display forms and displaying attribute form names will cause the enabling or disabling of other attribute's subtotals. The Compound Grid supports similar operations as regular grids, such as: Sorting. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. The Grid/Graph, which looks like a standard grid container, is displayed. In general, a user specifies a list of conditions and corresponding return values. Create a Report Services Document 2. 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. In the Run Modes area, select the format (s) in which the document can be exported: •. Measure: SLA Status = ISBLANK(SELECTEDVALUE('Alerts'[handledAt])) the results before adding data from dimension: everything works fine until I add data from dimension. Create a report with Year on the rows and Revenue on the columns. Relationship Tables. Below are the steps to enable/disable the settings of data blending: 1. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. To support best dashboard execution and concurrency performance, MicroStrategy has chosen to limit the number of logical CPUs engaged for any single grid evaluation to 4. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy 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. Custom grids allow you to utilize dynamic text fields in order to create grids that provide more. Enable the Source Visualization to Update the Target Visualization. The graph shows revenue by category and region. This will allow you set the different sets of columns that behave differently. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Create a Report Services Document 2. The data from the datasets is used to populate the report. On the Overview page, click the Comments icon. Steps to Reproduce on. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. 4. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . View the visualization's name and data requirements. Create a Compound Grid. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. All Grid Fonts: Select font formatting options for all text. 3. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. The Excel File will contain only the selected Grid Object data from the Document. Select More Options at the bottom of the pane. Export server-level settings and import them for use with another server. Click Insert Visualization . KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. How to use the MicroStrategy 2020 compound grid. Select only Configuration Objects for documentation. The data from the report is used to populate the Grid/Graph. Creating a Compound Grid Visualization. The only solution that I can think of is to create a FreeForm SQL Report. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. A blank visualization appears in the dossier. In the Datasets panel, double-click attributes and metrics to add them to the visualization. See the previous images above to see how the row headers should now appear. 4. Assuming CP1252As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. The following code sample will execute a report using a ReportBean, and output the column headers from the report grid. A heat map visualization requires a minimum of one attribute and one metric to display correctly. . A normal attribute represents a single hierarchy level (for example, Month). Right click and "Run as Administrator" to. Compound grid export via Office add-in Hi there @Cheng Guo (Inactive) (Microstrategy, Inc. This means that two calling centers from different regions can share the same Call_Ctr_id. Upgrade to MicroStrategy 11. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Labels: #Prompts in URL API #mstr urlapi. Back to the Report. Then it creates a third metric, a compound metric.