In MicroStrategy Analytics Enterprise Web 10, 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). The Delete unused managed objects option is found under. Filter data in a second visualization by selecting attribute elements or metric values in. Create a new report using the Compound metric. Tag Users in Microstrategy Dossier. The Grouping panel is displayed. Notice that a joint child relationship can be one-to-many or many-to-many. Click Advanced, then New to create a custom subtotal. 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. A heat map visualization requires a minimum of one attribute and one metric to display correctly. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Creating a. This means that every metric is evaluated in separate SQL passes. So the row for Music will not display in the grid. 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 means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. 11. Finally, just create the report with the attribute (Category) and the third metric. The contents of the grid report are displayed, separated by commas. In MicroStrategy Web 10, there is no SQL View execution mode as there is in MicroStrategy Desktop. Use compound. Make two grids with different attributes and metrics in each 3. You can explore the relationships between data elements by creating a network visualization, or create. 4 and later. An input box will be displayed with a list of recommended questions based. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. HTML: The grid report is exported to an HTML file. You want to tag the team leader responsible for creating the dossier. You can also apply a set of color and shading schemes to all the objects on a graph report. Microsoft Analysis Services supports it; SAP BW has returned errors in MicroStrategy's testing. In this brief video tutorial, Jason Hudson from our Customer Education team explains how to create a grid visualization in a dossier. Using Compound Grids. Click Insert Visualization . Click Advanced, then New to create a custom subtotal. The content of the report is displayed. This may make related application objects (reports, filters and. Create an empty MD shell in Microsoft Access. Insert an HTML container (and not an image) and insert the script below. The Excel File will contain only the selected Grid Object data from the Document. Microstrategy Dossiers With the release of MicroStrategy 10. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Export Report Title: Selected by default. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). A compound key attribute is an attribute that has two or more IDs. This means that every metric is evaluated in separate SQL passes. On the right grid, hide the attribute column by disabling the "Show Rows" option in the Grid properties as shown below: Export the dashboard to Excel. Required prompts without any default answers remain open while optional prompts without default defaults answers are closed with an empty answer. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 3K views 3 years ago What's new in MicroStrategy 2020 Learn how to use compound grids in dossier. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. NOTE: Modifying the key form will trigger required updates when saving. Slicing means that the data for each available item in the selector is calculated in advance when the document is first displayed. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and. 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. Note the picture with the definition. From the Visualizations panel, select Grid . 2987. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . A Grid/Graph is created for the Regional Revenue dataset. Micro Strategy also supports mobile BI. The syntax is: FileLocation is the path to the saved test file. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. You can define metrics by using the available functions to analyze your data and determine business measures. 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. Follow the simple steps below to create a datamart report: 1. Right-click on the dossier once again. The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. This will allow you set the different sets of columns that behave differently. Microstrategy Dossiers With the release of MicroStrategy 10. Upon making this selection, the row headers will now be merged. 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. This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. We recommend the latest version. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. The contents of the grid report are displayed, separated by commas. 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. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. You need to compare the number of units sold today to the number of units sold from January 1 through today. x-10. For example, a document contains two Grid/Graphs. But, this can also be done with this work around, here are three tables in warehouse. New workaround Attribute left outer join effect in MicroStrategy Web. Microstrategy Dossiers With the release of MicroStrategy 10. Then, choose 2 additional colors that will comprise of the remaining 30% and 10% respectively. In MicroStrategy Web, open the document in Design or Editable Mode. 5. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. 4 and… Number of Views 3. 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. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 0 and 2019, users will notice objects referred to as "Super Cubes". Microstrategy Dossiers With the release of MicroStrategy 10. {&GROUPLABEL} Name of the graph item's category. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. 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. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. 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. From the Home menu, point to Export. Line: Select the style of the grid lines from the drop-down list. You can use MicroStrategy Web to create a Grid/Graph that contains objects from multiple dataset reports. Passing prompt answers for an element prompt when the attribute has a compound ID. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. Open an existing dossier that contains a grid visualization. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. In the Editor panel, click Add Column Set to create another column set. In the drop-down on the selection bar, select. However, o n iPad with MicroStrategy Mobile 9. The property is named "document grids from multiple datasets" and defaults to enabled but can be set to disabled. xls format. MicroStrategy download site to. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. We'll cover how to include repeated rows,. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the. 9, we’ve taken a leap forward in our dashboarding capabilities. For the Time hierarchy, the offset can. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. Unfortunately I have a limitation/bug to report and ask about. Click Insert Visualization . For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. This is a filter which contains a prompt on an attribute element list. Follow the steps below: Right-click on the project and select 'Project Configuration. Select or multi-select users as recipients of the dossier. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . x, the series lines do not inherit the color of the series markers and change depending on which metrics are displayed on the graph. The graph legend or axes can be formatted as well. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. In the Editor panel, click Add Column Set to create another column set. Even if the source attribute is not included in the Grid/Graph, the data is still. Connecting MicroStrategy to TDV Using ODBC. See full list on blog. Template Select template style and color. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. Microstrategy Document Editor Sections Important Notes: The Layout area is in the center of the Document Editor interface and provides the framework for precisely controlling where controls (such as text fields, grid and graph reports, images, and widgets) are displayed when the document is viewed in different display modes, printed,. To prevent users from navigating out of the document, they might want to hide some sections from the page. Color from the Advanced Color Picker will. This will allow you set the different sets of columns that behave differently. A blank visualization appears in the dossier. Create a Compound Grid. But, this can also be done with this. Click Continue if the Preview Connector warning message pops up. Search for users or add users by clicking on the add icon. To access the Advanced Sort dialog: Select a grid visualization. The "Grouping" property has six possible. This document provides the steps to accomplish the same. Metric Qualification (MQ) Tables. 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. Turning on totals returns a row for the total, even though there are not rows of data to show. 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. The Grouping Properties dialog box opens. Compound Grid visualizations. Doppelklicken Sie im Abschnitt „Datensätze“ auf Attribute und Metriken, um sie der Visualisierung hinzuzufügen. Visualize Data Trends: Create intuitive visualizations to present data after it is parsed, structured and analyzed. 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. A Compound Grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. 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. Metric Expressions. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. You can explore the relationships between data elements by creating a network visualization, or create. This design may look strange, but in most cases there are. Upon making this selection, the row headers will now be merged. 4. A visualization is a visual representation of the data in a dossier, such as a grid, line chart, or heat map. Indexes Panel. promptAnswerMode *. In our. The following schema shows which setting takes precedence when set at different levels. But, this can also be done with this. Creating a grid report. From the Tools menu, select Report Options . The Excel File will contain only the selected Grid Object data from the Document. 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. 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. As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. On the Overview page, click the Comments icon. The one on the left, which is displayed as a grid, shows revenue by region. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. 4. It is used to apply database (row-level) security to a MicroStrategy user. Drag and drop the . 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. Eg, total (profit/units Sold). Click the Options icon . Here the many-to-many relationship is converted into a compound attribute relationship. Create a Report Services Document 2. Populate & Evaluate Stage: Fill report data for display. Use the links below to create visualizations using the Visualization Gallery:The grid is targeted by a grid selector and a metric slider selector. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. To Add a Target Visualization to Your Dossier: Open the dossier with the 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. Save designs as templates. How to Share a Dossier. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. This means that every calling center has its own unique ID. Wählen Netz > Zusammengesetztes Gitter . In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. 4 and later. A blank visualization appears in the dossier. The following steps demonstrate how to do that in MicroStrategy Tutorial project: Import data into project and create dashboard. Click Certify. x-10. This section shows the effects of different element settings on a single metric when used in the same report. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. The Metric Editor opens in either Function Editor mode or Formula Editor. However, the SQL used to execute the report can still be viewed and obtained. Follow the steps below. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. You can define metrics by using the available functions to analyze your data and determine business measures. This design may look strange, but in most cases there are. 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. MicroStrategy Community 4. For example, there. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. This is an excerpt from my presentation at the July meeting of the San Francisco Bay Area MicroStrate. However, the "Report returned no data" message does not necessarily indicate that a null value has been encountered. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Check the Merge checkbox under Rows in the Header section. View standard reports in MicroStrategy Library to get a simple, grid view of data. 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. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as. When drawing the structure of an ion, be sure to add/subtract electrons to account for the charge. Learn how to switch to a compound grid, add column sets in this new visualization. A ragged hierarchy is the one in which the parent attribute element of one or more. 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. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. In the Run Modes area, select the format (s) in which the document can be exported: •. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. Learn more. The compound join saves memory space and processing time on the Intelligence Server executing the document. Erstellen einer zusammengesetzten Tabellen-Visualisierung. Enable the Source Visualization to Update the Target Visualization. MicroStrategy Desktop's basic set of 40 colors matches the Excel colors. Symptom After setting up a dossier with a compound grid that has more than one column set there are situations in which after exporting to excel the file generated is missing the first row of information. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). Microstrategy Dossiers With the release of MicroStrategy 10. Creating Geospatial Service Maps. Click Insert Visualization to add a new, blank visualization to the dossier. There's a reason we're at the top of the list. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. This prompt is used in a filter. This document provides the steps to accomplish the same. The Compound Grid supports similar operations as regular grids, such as: Sorting. mstrc”. 4. The same metric exists multiple times on the grid. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. The Profit metric is a simple sum of the Profit fact. We recommend the latest version. In the Editor panel, right-click the attribute or metric to sort and choose Advanced Sort. In MicroStrategy Web, edit or execute a report. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 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. Formula and dimensionality are the two important components in a metric. A normal attribute represents a single hierarchy level (for example, Month). September 06, 2018. Select the Dropdown Icon () on the right-hand side of the title bar. September 18, 2018. The color is displayed in Flash Mode and Express Mode in MicroStrategy Web. Compound Grid visualizations. MicroStrategy AI is here. MSTR Secure Enterprise. View data in simple grid format and leverage page-by options. Ultimately, it was. The same metric exists multiple times on the grid. Copy cleanup. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. This document provides the steps to accomplish the same. September 18, 2018. Panel Stacks. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. Compound Grid visualizations. Create a Report Services Document 2. J2EE environment:Year-To-Date Transformation Example. 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. To Create a Graph that Displays Markers in a Grid Layout. In the Datasets panel, double-click attributes and metrics to add them to the visualization. intelligence platform that adds in-memory delivery applications. Creating Network Visualizations. You treat one attribute as a child of the other and have a compound key for the lower level attribute. A Grid/Graph can be directly associated with one dataset report. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. 1, the value range of the metric slider changes accordingly. Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. x-10. Portion displayed only (only the displayed page if multiple pages). Set Data Engine Version setting to 11 or. Create a report as shown below: When Category=Music, the Cost(1) and C1_R_M will have null values. And leverage the Page-By function to focus your analysis on one element. The following schema shows which setting takes precedence when set at different levels. Generally, you build a compound attribute when your logical data model reflects that a compound key relationship is present. 4. It can connect to data warehouses, relational systems, flat files, web. of data from digital manage digital identity. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. 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. Export Page-By Information: Selected by default. In Comments, enter @. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. Export Report Title: Selected by default. 4 and later. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. 4. Then, put the "Inbound Costs" into one column set and the "Outbound Costs" into another column set. Passing prompt answers for an element prompt when the attribute has a compound ID. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. x, there is an option to select which attribute would act as a selector, like shown below:. To display a pop-up tooltip, enter the text in Tooltip. Click Insert Visualization . Create additional visualizations to display the data in multiple ways. x - 10. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Add an attribute and a metric to both Column Set 1 and Column Set 2. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. A Grid/Graph is a container that is placed in a document and which displays a standard MicroStrategy grid or graph report. That's why it show a static text "{[New Derived. Click the location on your document in which to place the widget. Introduction to Grids You can display data in a grid layout. Introduction to Grids. This section helps you choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. x. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. A compound grid requires at least one attribute and one metric. This is easily done using the &hiddensections URL parameter that can be obtained from the folder browsing. . 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. このチュートリアルでは、複合グリッドへの切り替え方法、複合グリッド内の列セットの追加方法、およびこの新しいビジュアリゼーション タイプを活用する簡単な使用例について、順を追って説明します。. Tasks. See the previous images above to see how the row headers should now appear. In a document, you can display a report by adding a Grid/Graph to the document. Click on Dossiers in the left panel of Workstation. Using the Connector. x, select 'Project Documentation' from the Tools menu to start the wizard. The Grid Settings section allows you to select the Fit to page option, which fits the grid's width onto one PDF page width, or you can select the Allow horizontal pagination option, which breaks a wide grid onto numerous pages. In the report, the attribute with the compound key is Distribution Center. A blog on Microstrategy development and issues faced during development, deployment and maintenance. 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. x and 10. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. Name, [Measures]. Create a second metric identical to the first, but add the predefined Year to Date transformation. Selections made while viewing the document are used to determine which slices of data are combined and shown in the Grid/Graph. Select More Options at the bottom of the pane. This version of the product is no longer supported in accordance with MicroStrategy's support lifecycle. Visualizations provide a variety of ways for you to display and interact with the data in a dossier. 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. Select the Dropdown Icon () on the right-hand side of the title bar. Cross-tab Stage: Pivot and display sorting and page-by. Creating a Compound Grid Visualization. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Fields. Example 1: Compound key with Effective Date and End Date. This case is also explained with an example based on the MicroStrategy Tutorial project. MicroStrategy Tutorial. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. 6. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. 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. Join data visualization specialist Len OToole of InfoCepts for this interactive. Microcharts are small versions of visualizations shown without. 5. Portion displayed only (only the displayed page if multiple pages). 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. Below are the steps to enable/disable the settings of data blending: 1. 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. And leverage the Page-By function to focus your analysis on one element. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. Create a Report Services Document 2. View standard reports in MicroStrategy Library to get a simple, grid view of data. Go to Web Preferences and select Project Default -> Grid Display. 2 - Closes all optional prompts with an empty answer. Navigate to the first page of the Office Royale Sales dossier. Select the Repeat attribute column checkbox to display the attribute. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. The effects are summarized in Level metrics. 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. Visualization Options . Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. The graph shows revenue by category and region.