02K subscribers 26 7. 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. To create a MicroStrategy Environment connection file . 1/10. Turning on totals returns a row for the total, even though there are not rows of data to show. Graph: Displays the data visually like a standard MicroStrategy graph report. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. 4 and. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. 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. Creating a 'Compound Grid' 4085 views | September 04, 2020 02:40. The new grouped attribute appears in the Attribute Name field as. 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. To reproduce in MicroStrategy Tutorial: Create a simple report with one attribute and one metric. September 06, 2018. 2. Metric Expressions. 02:40. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. How the user answers the question determines what data is displayed on the report when it is returned from your data source. This version of the product is no longer supported in accordance with MicroStrategy's support lifecycle. Type a name for the metric in the Metric Name field. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. A heat map visualization requires a minimum of one attribute and one metric to display correctly. A classic example is an organization chart: This information can be stored in a recursive fashion using only one table with two ID columns: Problem. In general, a user specifies a list of conditions and corresponding return values. NOTE: Modifying the key form will trigger required updates when saving. Step 2: Connect the atoms to each other with single bonds to form a “skeleton structure. 4. When drawing the structure of an ion, be sure to add/subtract electrons to account for the charge. x, non-aggregatable metrics are used for this kind of calculation. Using a combination of filters and metric dimensionality, the same results can be achieved. Profit is not displayed on the Grid/Graph, nor is it in the data source for the Grid/Graph. MicroStrategy is an enterprise BI application software. You can import business data from many different sources, including local files, databases, Google Drive, etc. 4. Click More in the top right of the heat map and choose Create Contextual Link and select This Dossier. Community & Support Search Discussions Open A Case View My CasesExample 1: Compound key with Effective Date and End Date. This case is also explained with an example based on the MicroStrategy Tutorial project. Create an empty MD shell in Microsoft Access. Export a dossier when viewed in presentation mode. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. For now, derived metric based on different datasets is not supported in field group (which would be on the Detail section). How to use the MicroStrategy 2020 compound grid. Click Advanced, then New to create a custom subtotal. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. You can define metrics by using the available functions to analyze your data and determine business measures. In the Editor panel, click Add Column Set to create another column set. Wählen Netz > Zusammengesetztes Gitter . Power BI's dashboards update in real time from all data sources. Create a report as shown below: When Category=Music, the Cost(1) and C1_R_M will have null values. Filename. The data from the report is used to populate the Grid/Graph. 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. 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. New workaround Attribute left outer join effect in MicroStrategy Web. The simple key shows how you can identify a calling center with only its Call_Ctr_id. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. To enable a visualization to filter or highlight the data in another visualization. How to Share a Dossier. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Below are the steps to enable/disable the settings of data blending: 1. Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. In the compound key, calling centers are identified by both Call_Ctr_id and Region_id. 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. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Click Insert Visualization . Click Share > Library Access. compound attributes. Use the links below to create visualizations using the Visualization Gallery:The grid is targeted by a grid selector and a metric slider selector. 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. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. mstrc, please open something similar to Notepad. 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. Select any project that is in the project source that contains the users and groups and click Next. 4. This means that two calling centers from different regions can share the same Call_Ctr_id. Enable the Show attribute names parameter. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. September 18, 2018. This document provides the steps to accomplish the same. Back to the Report. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 4. Insert an HTML container (and not an image) and insert the script below. The effects are summarized in Level metrics. This calculation can be aggregated from the Employee level to the Region level. 11. Populate & Evaluate Stage. Explanation. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. You cannot place the widget in the Detail section of a document. View standard reports in MicroStrategy Library to get a simple, grid view of data. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Relate tables are often used to create relationships between attributes. Steps to Reproduce on a Compound Grid. . Even if the source attribute is not included in the Grid/Graph, the data is still. Note that only the naming convention has changed, as the functionality remains the same. Microstrategy Dossiers With the release of MicroStrategy 10. Use the links below to create visualizations using the Visualization Gallery:Considerations for the use of star schemas with MicroStrategy SQL Generation. 4 and later. Tasks. exe to this machine. 364 subscribers. Click the Options icon . Insert an HTML container (and not an image) and insert the script below. To export the report to Microsoft Excel as plain text, select Excel with plain text. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Upon making this selection, the row headers will now be merged. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. The syntax is: FileLocation is the path to the saved test file. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. '. 5. A blank visualization appears in the dossier. Microsoft Analysis Services supports it; SAP BW has returned errors in MicroStrategy's testing. We'll cover how to include repeated rows,. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. cube architecture each other identity. Finally, just create the report with the attribute (Category) and the third metric. Create a report with Year on the rows and Revenue on the columns. However, o n iPad with MicroStrategy Mobile 9. The Grid/Graph is displayed as a grid or as a graph, depending on how the report is displayed. Do not forget to enable Subtotal (F11). But, this can also be done with this work around, here are three tables in warehouse. 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. microstrategy. Compound Statements. Microstrategy Dossiers With the release of MicroStrategy 10. Here the many-to-many relationship is converted into a compound attribute relationship. KB483841: Known issues when using a slicing selector to target a. Step 2. A blog on Microstrategy development and issues faced during development, deployment and maintenance. The Shapes and Data Labels options are available to format the graph items, such as graph markers and data labels, in. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. A heat map visualization requires a minimum of one attribute and one metric to display correctly. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. [ONAME:Compound Grid]: This is the name of the object. Upgrade to MicroStrategy 11. To display a pop-up tooltip, enter the text in Tooltip. A Compound Grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. You can explore the relationships between data elements by creating a network visualization, or create. (Highly recommend for understanding your exported data). This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. Once you add a grid visualization to a dossier, you can format it. 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. This will allow you set the different sets of columns that behave differently. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This calculation can be aggregated from the Employee level to the Region level. To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . From the Visualizations panel, select Grid . When a display alias is set for objects in a grid, the object alias is not displayed in the report filter in MicroStrategy Developer. Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. Learn more. Microstrategy Dossiers With the release of MicroStrategy 10. The Insert Function dialog box opens. 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. A dataset is a standard MicroStrategy report. Custom number formatting symbols. Note: This fix changes CSI and data. Right-click on a dossier. Locate the Request Geospatial key button above the products session and click on Mapbox Key : Each key is DSI specific. Populate & Evaluate Stage: Fill report data for display. A normal attribute represents a single hierarchy level (for example, Month). 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. 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. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. Visualization Options . Color from the Advanced Color Picker will. The only solution that I can think of is to create a FreeForm SQL Report. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Create a Report Services Document 2. 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. For details, see Viewing a Grid/Graph displayed as a grid. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. Make two grids with different attributes and metrics in each 3. From the 'Edit' menu, choose 'Group'. 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. Step 2. 4 and later. Execute the report and view the SQL:Open the document in Design or Editable Mode. 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. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. x. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. Insert an HTML container (and not an image) and insert the script below. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Click the location on your document in which to place the widget. In the report, the attribute with the compound key is Distribution Center. of data from digital manage digital identity. Using the Connector. The Compound Grid supports similar operations as regular grids, such as: Sorting. The one on the left, which is displayed as a grid, shows revenue by region. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . This video show how to share a filter with other MicroStrategy Library users. We recommend the latest version. Metrics are MicroStrategy objects that represent calculations performed on data. Export: Choose Whole report vs. This feature is only implemented for element list prompts. Using Compound Grids. This case is also explained with an example based on the MicroStrategy Tutorial project. Micro Strategy also supports mobile BI. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. This article describes how to display username on the report grid with MicroStrategy Developer 9. Incluso, si. It is used to apply database (row-level) security to a MicroStrategy user. Create a Compound Grid. x. mstr file; Knowledge Base: Best Practices for Library from Product; Knowledge Base: Using REST API to find all certified dossiers within a project; Knowledge Base: How to certify. Data from the input objects defined in the Transaction Services report is displayed in the grid, text fields, or cells for users to. This article outlines an issue when using a Compound Grid there is a missing row after exporting to Excel. Type the following for the name: "Total for the #P #0". #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. 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. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. A Grid/Graph is created for the Regional Revenue dataset. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. We recommend the latest version. From the Home menu, select Export. In the top toolbar, click Insert Visualization . In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. . The Grid/Graph (referred to simply as a report) can be directly associated with one dataset or with multiple datasets. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. From the Tools menu, select Grouping. Create a report with the Region and Month attributes and the Revenue metric in the grid and filter. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. MicroStrategy Tutorial. Compound Grid Generator (Large preview)A prompt is a question the system presents to a user when a report is executed. In the report, the attribute with the compound key is Distribution Center. Navigate to the first page of the Office Royale Sales dossier. September 18, 2018. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. Create a Compound Grid. Export filter details: Select this option to include the report’s filter details. Template Select template style and color. For example, a document contains two Grid/Graphs. Subscribe. x SYMPTOM When users create a Grid visualization in Visual Insight using MicroStrategy Web 9. Creating Combo Charts (Line & Bar Graphs) Creating Smart KPI Visualizations. When users make selection on grid selector in MicroStrategy Web 9. 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. Another important observation is not to forget to enable "Smart Metric”. Microstrategy Dossiers With the release of MicroStrategy 10. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Tag Users in Microstrategy Dossier. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Ahora, ten en cuenta que corre de nuestra cuenta vigilar que el número de elementos hijos en el grid es el que debería. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. Compound grid export via Office add-in Hi there @Cheng Guo (Inactive) (Microstrategy, Inc. And leverage the Page-By function to focus your analysis on one element. Search for users or add users by clicking on the add icon. MicroStrategy recommends that when choosing your colors, to keep the 60-30-10 rule in mind. Creating Geospatial Service Maps. 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. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Portion displayed only (only the displayed page if multiple pages). Ø Local Transaction options. Open a new or existing dossier. 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. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. If installed over previous versions of the product, the folder remains the same. Note the picture with the definition. 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. The smart metric and the component metric are from different datasets. For example, users can have a smart compound metric and a component metric of this compound smart metric on the grid in the document. Erstellen einer „zusammengesetzten Tabelle“. The same metric exists multiple times on the grid. The compound join saves memory space and processing time on the Intelligence Server executing the document. 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. Labels: #Creat transaction services photo uploader #transaction. 97%, and this is true whether Data Engine Version is set to 10 or 11. 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. From the 'Edit' menu, choose 'Group'. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. For the Time hierarchy, the offset can. This prompt is used in a filter. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 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 the top toolbar, click Insert Visualization . Information is arranged in rows and columns,. Begin by choosing a dominant color which will dictate the look and feel of 60% of your dossier, or the majority of the interface. This metric should be used on compound grid (rather than standard one). CSS Compound Grids Generator. Join data visualization specialist Len OToole of InfoCepts for this interactive. This means you can have multiple. Hover over the visualization to use as the source and click More in the top right and choose Select Target. Order: The sort order of the row or column. Connecting Tableau to TDV Using ODBC. intelligence platform that adds in-memory delivery applications. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. In Desktop 2020 you can only use attributes in rows. 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). Creating a grid report. 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. Export server-level settings and import them for use with another server. Microstrategy Dossiers With the release of MicroStrategy 10. Eg, total (profit/units Sold). The Export to Excel option will now appear. 最上部のツールバーで、 [ビジュアリゼーションを挿入] をクリックします。. Users may want to display MicroStrategy Web 10. Click Insert Visualization . Create a filter with an element list or qualification prompt on an attribute. Export a dossier when viewed in presentation mode. A Grid/Graph can be directly associated with one dataset report. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 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. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. 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. This setting has four values:To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. The graph shows revenue by category and region. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. 2) Create Metric2 as the RunningSum of Metric1. Note: If a user enters more than 15 digits for a. Theoretically the element qualification is what we are looking for, but as stated before there are certain limitations. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). 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. 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. 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. This tutorial will guide MSTR users to share dossiers through Web and Library. 6. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. However, the SQL used to execute the report can still be viewed and obtained. Export Report Title: Selected by default. Notice that some metrics from the right grid are missing. You want to tag the team leader responsible for creating the dossier. Set Data Engine Version setting to 11 or. 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. 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. The report execution is typically a 3 step process process of the below: Query Stage. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and. In the Run Modes area, select the format (s) in which the document can be exported: •. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. Compensating Transactions. A compound grid requires at least one attribute and one metric. MicroStrategy Dossier makes it easy to build insightful and engaging dashboards—and with the free-form canvas, the latest 2020 platform release has introduced new game-changing, design-focused features. In the Editor panel, right-click the attribute or metric to sort and choose Advanced Sort. Choose Grid > Compound Grid . The Compound Grid supports similar operations as regular grids, such as: Sorting. 3. 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. 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. A Grid/Graph is a container that is placed in a document and which displays a standard MicroStrategy grid or graph report. Create a compound metric called B with expression "RunningSum(A)" as shown below. x and 10. 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. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. 4 and later. Choose Excel-compatible colors for objects as well as grid and graph formatting. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 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. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. Ragged Hierarchies. To enable totals or subtotals for a metric. 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. View data in simple grid format and leverage page-by options. Select one of the following export formats: To export the report to an Adobe PDF file, select PDF. 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. Export a dossier when viewed in presentation mode. A ragged hierarchy is the one in which the parent attribute element of one or more. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. 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. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. Tasks.