dossier microstrategy tutorial. Hierarchy object - a MicroStrategy object that represents a group of related attributes that belong to the same higher-level concept Ex. dossier microstrategy tutorial

 
Hierarchy object - a MicroStrategy object that represents a group of related attributes that belong to the same higher-level concept Exdossier microstrategy tutorial  Click Select a file to browse and select a connection file

In a document, Category is defined as a selector in left grid A. The mappings are typically used to take advantage of one of several RDBMS data security techniques (security views, split fact tables by rows, split fact. The list of privileges and their descriptions can also be found in the MicroStrategy - System Administration Guide that comes with the product documentation. . The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. Adding Data to a Dossier. Amica 通过为其团队提供简单、高效的应用程序来. In today's reporting systems, the amount of data available to business organization is rapidly increasing. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. mstrc file, users can simply import the file and enter their credentials, and then they will be connected to a MicroStrategy On-Premises Environment. The MicroStrategy connector allows users to fetch data from reports or cubes that reside on other MicroStrategy projects or environments. Display the dashboard as a Bar Chart. If you are using MicroStrategy 10. Creating a powerful dossier is as simple as importing. Show totals. Hello there! Today let’s talk about how to create a session using PHP with IIS. If installed over previous versions of the product, the folder remains the same. Added "Category" to Attribute field and "Revenue" to the Metric field. You will be able to: - connect to MicroStrategy Server. Create a report with the Region, Category, Subcategory attributes, and some metrics. Extract the downloaded files. In the MicroStrategy Tutorial project, for instance, if a report includes only the Category attribute, report level metrics could use the YR_CATEGORY_SLS table. This Visualization requires more than 2 attributes and 1 metrics. . Importing data in Microstrategy Dossier. name: the exact name of the attribute on the filter panel in your dossier. Define a Many-to-Many relationship between Category Id and Month Id. In MicroStrategy Developer, create an attribute mapped to the LU table. * PDF Export * Set Target Visualization * Set Target Page & Dossier (Only on Web) Publisher: DongHyub Lee (Sales Engineer in MicroStrategy Korea) Visualization Disclaimer. You can also maximize the amount of space available for data display by viewing dossiers in Presentation Mode. Creating Compound Grids. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. Right-click the metric sales, and we get the option to choose the threshold as shown in the following screenshot. Create the respective DSN's in the Intelligence Server machines. Execute command "PURGE ALL CACHING IN PROJECT "MicroStrategy. ) Formatting Visuals. Using MicroStrategy Tutorial warehouse, create a Data Import cube with following tables and relationships as specified: 2. x6. Each event corresponds to an event code. CONTENTS 1. Month(ID) Less than or equal to Month Selection (ID) Create a logical view to serve as the lookup table for Month Selection. Users may want to hide the Null values in a Report Service document when there is an empty value in the data retrieved from the warehouse at the project level in MicroStrategy Developer 10. 1. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. microstrategy. Add value prompts for Category and Year in the view filter of the cube report: Create a document with the cube report as the dataset. Set Up the Sample MicroStrategy Workstation Become a More Intelligent Enterprise Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Jobs and TasksDescription of the new dossier layout including the visualization gallery and shapesMicroStrategy Office is a comprehensive guide that covers how to use the MicroStrategy platform with Microsoft Office applications. MicroStrategy’s renowned bootcamp experience enables students to earn their Analyst (ANL) or MicroStrategy Architect (MCA) certifications in an accelerated timeframe. We use MicroStrategy Tutorial objects: Create a derived metric Count(Category) with the following definition: Add a filter using Year that will exclude all data: Create another metric NullToZero using Count(Category): Drag Year and NullToZero to a Grid visualization. Once data flows into the interface, the dashboard will come to life. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Choose Add Data > New Data. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. Open the Workstation window with the Navigation pane in smart mode. Log into MicroStrategy Web. Follow the prompts to select your visualization type and add data to your visualization. 2 days left!Since the MicroStrategy Tutorial project has automatic column mapping enabled by default and the same column name as the existing Month ID attribute form was used, the Month attribute has already picked up and added the Last_12_Month_Table as a source table. This will override the project level document. For the Customer attribute, Email is. In this sample, the documents returned by the GET /searches/results REST API request are listed on the left side of the web page. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. You can import business data from many different sources, including local files, databases, Google Drive, etc. In part one of this video tutorial series, Kevin Thompson from our Customer Education team describes the types of dataset objects you'll encounter on a. MicroStrategy Workstation Help. The threshold can be selected from list of built-in colors or configured manually. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. For example, you need a subtotal that always calculates at the regional level, regardless of the. The same report accessed in web. The change in such structure produces different kinds of summaries of data. Select the fact, "Cost," and add "Year" to the level. username ¶ Username. Dossier-style documents form the basis of the apps and dossiers you can create with MicroStrategy Mobile. . Add, rearrange, or remove data from a visualization in a dossier. msgID. The examples shown below were created in the MicroStrategy Tutorial project. This includes delivering prompt query answers for your analyses, streamlining your navigation across Dossiers, documents, and reports, and much more. It also provides resources to add functionality such as controlling navigation, retrieving and applying filters, setting properties, and managing events, and supports several different authentication environments. Dossier offers element/value selectors, attribute/metric. The following procedure describes how to display trendline data values on a graph utilizing sample data from the MicroStrategy Tutorial Project. It assumes that you are familiar with designing MicroStrategy reports and documents and have the. Last updated: Jun 23, 2017. Creating Free-form Dossiers. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. These fixes address performance (2), security (3), and stability (12), among other issues. Import “LU_MONTH” and “MNTH_CATEGORY_SLS” Table from the Tutorial warehouse. 4. Click Select a file to browse and select a connection file. It introduces a free-form canvas that lets. Some key benefits include: Mapbox maps use vector tiles instead of image tiles used by many competitors, which enables much smoother and more customizable zooming. For example, Name@Desc from the HyperIntelligence card. Home Published: April 30, 2020 • 7675 Views Creating Powerful (and Beautiful) Dossiers 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. Run the document and save it with a default value "Movie" for the selector. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. Go to Project Configuration>Governing Rules>Default>Result Sets, and increase the Final Result Rows for "All other reports" as below:The new version of the vendor's BI platform includes an upgrade to Dossier, MicroStrategy's data visualization tool, new connectors aimed at data scientists and a series of enhancements to the MicroStrategy Cloud Platform. Privileges and Security Access in Workstation. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Saisissez la commande suivante dans la ligne de commande Windows : <Chemin> setup. The recent version was released on 7th January 2019, and it introduces many new ground-breaking enhancements and features. Add the attribute Subcategory and metric Revenue to the report template. Browse and incorporate these templates into your own data dashboards. Finally, This Dossier makes our analytics powerful. Published: Sep 8, 2020. Refer to the What's New page in the MicroStrategy 2021 Readme. 4. Standard = 1 (default) or LDAP = 16. Diagnostic analytics shifts from the “what” of past and current events to “how” and “why,” focusing on past performance to determine which factors influence trends. This setting is ideal if you have numerous. MicroStrategy Tutorial Reporting. Also practical examples are used in this document in order to illustrate the. A compound grid requires at least one attribute and one metric. CONTENTS BookOverviewandAdditionalResources vi 1. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. For example, if you are looking at numeric profit data on a report, the profits of. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. How the user answers the question determines what data is displayed on the report when it is returned from your data source. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Exploring Sample Dossiers in Library. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. 141 Introduction to Documents 2022. DETAIL DOCUMENT JOBS: Whether the telemetry for each processing step of a document or dossier execution is recorded. For this logic to work, the user requires permissions to unsubscribe from subscriptions. · Tips and tricks on using some not so well know features. Can be used instead of reportID. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. - pull data out of it. 2. 1351 views · September 02, 2020. If you are working with your own data, rather than Tutorial data, the current date calculation works if the project. Create additional visualizations to display the data in multiple ways. 3. In part one of this video tutorial series, Kevin Thompson from our Customer Education team describes the types of dataset objects you'll encounter on a MicroStrategy Dossier and what each object type represents. The following procedure describes how to implement such selector in MicroStrategy Tutorial project. One or more of the following patents may apply to the product sold herein: U. In part one of this video tutorial series, Kevin Thompson from our Customer Education team describes the types of dataset objects you'll encounter on a Micro. Micro. Add External Data. The metadata is a central repository, which stores all the objects used by it. The object's editor or wizard opens. Hello, I try to explain what my problem is: I have a dossier with an attribute and two metrics: Pdv (attribute), “Valore Catalina” and “Valore Altro” (two. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. You use the authorization token returned by POST /auth/login as the value for X-MSTR-AuthToken , a project ID returned by GET /projects , a dossier ID returned by GET /dossiers , and a filter definition. The Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. Click the MicroStrategy icon, and select Create Document. jar file to i-server machine. This visualization draws sankey diagram with each level of attributes and one metric . It uses. From the Data menu, choose Rename/Edit Objects. MicroStrategy Objects get assigned Permissions in conjunction with Users or User Groups, just like objects in an Operating Systems (“Security” in Windows or “row” in Unix and Linux systems). This not only allows for dossiers to have personalized information, but also improves performance by processing only the. Click the MicroStrategy icon, and select Create Document. (To follow the examples in this guide, click MicroStrategy Tutorial . ARCHITECT. The URL API allows you to directly request MicroStrategy Web to perform actions by using specific arguments in the request. Select the object to rename from the Object drop-down list. Select the folder you want save the level metric in. In part three of this video tutorial series, Kevin Thompson from our Customer Education team explains some of the additional options available on a visualiza. Design workflows, create content groups, or customize application components with the no-code framework. SYMPTOM: Users will drag up&down the scroll bar slider in Dossier 10. What are Dossiers in MicroStrategy? Post By Admin Last Updated At 2020-06-11 The dossier is an Interactive Display. Q8. Connection mappings allow you to assign a user or group in the MicroStrategy system to a login ID on the data warehouse RDBMS. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. Enter your credentials. Playlist:Workstation is the only space for analysts and app architects to build and manage content of all types. Move all the attributes and metrics to the Report Objects pane except for the attribute Region and the metric Standard Deviation of Revenue. This knowledge base article describes a defect in MicroStrategy 10. You use the authorization token returned during login as the value for X-MSTR-AuthToken. Adding Data to a Dossier. Get Started Help by Role Analyst Create, share, and maintain dashboards and dossiers. In part three of this video tutorial series, our Customer Education team expands on the concepts described in the previous video, taking a specific look at the effects of leveraging multiple object drop zones in tandem when rendering your data in a visualization. The Security Filter Editor opens. In the "Format: Template" window click on the "Color and Lines" tab. This knowledge base article explains how to pass the dossier’s filter selected elements to answer the prompt of a target report service document using URL API. You can also select an existing template (see How to Create a Report Based on an Existing Template ). Build a Self-Service Dossier for Customizable Analyses. allowing a dossier author to make changes to specific dossiers and have those changes reflected in each user's Library. Dossier. Scan Barcodes for Fast Insights with Library Android. Design workflows, create content groups, or customize application components with the no-code framework. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. For example, you could create qualifications for six months ago and for 8 months ago. Under Export Header and Footer section, click the Edit Custom Settings button. 2. Finally, a tutorial explaining Level Metrics. mstrio provides a high-level interface for Python and R and is designed to give data scientists and developers simple and secure access to MicroStrategy data. The loginMode parameter. MicroStrategy. When users create a bar graph when using a derived element in the dossier, it appears the shape fill color will not change within the dossier itself. On the left, select Export Reports. At this point, Developer will be able to use the 2-Tier Tutorial project. MicroStrategy Library is an interactive application of the MicroStrategy Business Intelligence platform that lets business users harness the analytical power of MicroStrategy in a simple, clean, and modern user interface. Dossiers automatically adjust to look great on any screen. Next,. A MicroStrategy connection file (. Some attributes can have additional descriptive forms that do not serve as the primary description form. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. Re-run the Dossier, notice DM01 still return data even if [Tot Cost] metric is missing in the. To Create and Use a User-Defined Subtotal (Using a Weighted Subtotal)For example, if June 2010 is chosen in the selector, then the grid/graph returns data from January 2010 to June 2010. Enabling Row Level Security. This tutorial steps through how to switch to a compound grid, add column sets within the compound grid, and a simple use case for leveraging this new visualization type. 4. Request a demo. In MicroStrategy Tutorial, create a grid with attributes and metrics. Embedded directly in apps, end users have access to their very own AI assistant. In MicroStrategy Web, edit or execute a report. 2. This demo will guide you through creating a Data Source Name, and a database connection to a Microsoft SQL Server Database in both Developer and Web. By default, the General preferences page is displayed. 6. This tutorial shows users how to import excel files into MicroStrategy Desktop 10. Creating a Visualization as Filter in a Dossier. Identify the dossier by passing the dossier ID in the path of the request. Python coding is short, minimal and easy. 10 or earlier where outer join to lookup table not working in a dashboard/dossier based on Intelligent Cube with joint element list filter when both attributes used in the filter is present in the visualization. Click Finish. When turning an advanced filter qualification into a set qualification on a document or dossier in MicroStrategy 10. Password. Patent Nos. NOTE: “Microstrategy Tutorial” will be replaced with the project specified to have the PASTATISTCS altered for. For example, the user might change a fill color for the attribute region (containing. Enter a descriptive environment name and the MicroStrategy Library URL. Select the new visualization as the target for the in-canvas filter created in step 3. You can learn more about microstrategy Dossiers tutorial in Microstrategy training. In this example, you execute a dossier called "Filters" (located in MicroStrategy Tutorial>Shared Reports. MicroStrategy Intelligent Enterprise™ Platform Help. Disable Unified Quoting Behavior in Query Optimization. Modifying the underlying data source structure requires a new import of the data by using the Replace Dataset. Accelerate analysis with AI-powered apps. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. . Cliquez sur Entrer. In this tutorial, we will review sample dossiers in MicroStrategy's public "Demo" environment Library. MicroStrategy fundamentals: Learn about the installation process of MicroStrategy Workstation, which is essential for configuring the development environment for. Choose an environment and project, then click Select. The retail store sells electronics, books, movies, and music. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. This example uses the MicroStrategy Tutorial warehouse that is shipped with MicroStrategy products. All articles. Each dot on the graph represents the intersection of the data on the X and Y axes. Create a second metric identical to the first, but add the predefined Year to Date transformation. Reports. URL API. In part one of this video tutorial series, Kevin Thompson from our Customer Education team describes the types of dataset objects you'll encounter on a Micro. 2 release, the driver file is called odbc8. Import Librarires # 2. 5. Create functions # 4. The Export Reports preferences page opens. Grid (1) or Graph (2) Mode. Go to Command Manager and login the project source. Using Access Control Lists. In this video tutorial, Francisco de la Cruz from our Customer Education team walks you through the latest and newest feature of Natural Language querying in. xIn the Navigation pane, click Projects and browse to the location of the attribute you want to edit. 963. Use MicroStrategy. Every request to a MicroStrategy Web product corresponds to a specific event or action, which. A dossier is an interactive display that you can create to showcase and explore business data. x, using URL API. One of the main responsibilities of the Platform Administrator is to. The first dossier page is where you should guide and lead the viewers to dive deeper into your analysis flow. It wraps MicroStrategy REST APIs into simple workflows, allowing users to connect to their MicroStrategy environment, fetch data. Friends,We provide industry standard online training on MicroStrategy Development , Administration and live project development with hand-holding support of. Data can be connected through an API, flat file, or database. When trying to get an average on a metric aggregating the calculation level to an attribute that is not displayed in the grid, the table in the warehouse contains values equal to '0', and those values must not be taken to calculate the average. Import your data from a file on your computer or network. com : Donate if my videos helps. For dossier authoring, you should use MicroStrategy Workstation as the local dossier editing tool. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. Open a blank dossier. add the Supplier attribute to the filter pane. Open Preferences in MicroStrategy Tutorial Project. 417 Designing Advanced Dossiers 2022. Once in the Advanced Threshold Editor, users can see all the defined threshold conditions. Pivoting of data in tables is done when we want to swap the position of columns and rows. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Creating. 听听领先的产品团队如何在与 MicroStrategy 的合作中超越客户期望、打破市场并变现数据。. Specifying Warehouse Connection Information. Using MicroStrategy Tutorial project as an example: 1. On the left, select Export Reports. Cards. A text box can be used to navigate to a different panel within the same document in MicroStrategy Web 9. Use Case 4. So, You still have the opportunity to move ahead in your career in MicroStrategy. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. You can also choose your dossier instead by opening the dossier in Library and copying the URL. MicroStrategy Web. Learn how to build powerful and insightful Dossiers in MicroStrategy with the tutorials below. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. Starting in MicroStrategy 9. It's now easier than ever to visualize geospatial information and extend mapping functionality beyond standard geographic attributes such as country, state, and. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. 환경을 최초로 테스트하기 테스트 실행 전. For example, while the Lag function can. Dossier’s intuitive, drag-and-drop interface enables you to display and explore your data in seconds. 4. 11 will support prompts for end users. Opening a New Dossier in MicroStrategy Web. Follow the steps described below:Document caching for dashboards and dossiers can be configured at the dashboard/dossier level using the ALTER DOCUMENT outline in Command Manager. The Tutorial project includes sample data, such as actual customer names and items purchased. S. All articles. To view page-by section of the report, choose View > Page-by. MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. Microstrategy is rapidly increasing in popularity and is being leveraged across. Then check if the Use parameterized queries box is selected. 3%. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1 For the first-time user, see Getting Started with Documents for a brief overview of documents and dossier-style documents. MSTR Learning Portal: How to Download Course Materials. To access a MicroStrategy page, you use the evt and src parameters in the URL. The following example uses the MicroStrategy Tutorial attributes and metrics. Specifies the preferences group to display if the Export Options page is to be displayed. x-10. Choose Create New > Dossier. 0:00 / 20:00 MicroStrategy - Dossiers - Online Training Video by MicroRooster MicroRooster 6. Next, you'll discover how to use data visualizations to help bring your data to life. See Introduction to Visualizations for more information about the available types of visualizations. This video will help you get started using the MicroStrategy REST API. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2020 or above. Follow the below steps to change your environment's Library URL. Interfaces to create documents. Published: Jul 17, 2017. By the same token, our platform is also the source of valuable data. 3. MicroStrategy Web Administrator 페이지에 로그인합니다. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, GET, and DELETE. Patent Information This product is patented. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click. reportID. Go to Web ->MicroStrategy Tutorial ->Shared reports ->Dashoards and Scorecards and execute document Casino Visual Insight Analysis. To edit expression or property information, right-click the attribute form and choose Edit Expression or Edit Other Information. Leverage dossier design techniques, such as in-canvas filters, to make a flexible, streamlined, self-service dossier. MicroStrategy takes advantage of key Mapbox features that enable dossier authors to create beautiful and performant visualizations. Learn how to connect to various different environments in MicroStrategy Workstation 2019, MicroStrategy’s tool that lets you administer and control both proj. switch to Presentation Mode, try to move the filter scroll bar up&down by dragging the. De plus, cette version introduit de nouvelles fonctionnalités sur la plateforme de sécurité, de mobilité et d’analyse, ce qui accélère la création d. Create dashboard from data that contains nulls or zeros. 9 Publisher: MicroStrategy Installation Instructions: To view this dossier with the visualization, download the . VI Dashboards allow users to quickly and elegantly display and consume data. Please contact rgs4554@gmail. Click Continue. Interact with the data in real time (with targeting, filtering, and more). mstrc) is a text file that contains all of the information needed to connect Workstation to a MicroStrategy environment. Browse to the Platform Analytics Cube in the Platform Analytics Project and select the option to create a new dossier. In the available columns, select the Last Month ID column (Prev_Month_ID in MicroStrategy Tutorial) and drag and drop it into the expression field on the left, as shown below: Click 'OK' and save the transformation: For details on how to. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. In developer the table object appears as managed by the system, and has no dependencies, in workstation it says the same "cannot delete because of dependencies" without having them. The New Grid dialog box opens. For example, the user can answer the Northeast region or 2002, and the appropriate data is returned from the data warehouse. This case is built upon the MicroStrategy Tutorial project. Import visualization data as a CSV file # 8. Follow the steps in the example below which use MicroStrategy Tutorial project: Create and publish a cube with attributes Category and Year. Best Practices. · How to use all the main visualizations. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. Return Value. Start building with MicroStrategy to deliver exceptional product experiences. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. This article provides an example of a program that allows to list the attribute's forms namesTo correct the issue uncheck/disable Anonymous access on the Microstrategy virtual directory and reset IIS. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. Accordingly, this topic focuses on how to use transformations in metrics and reports, and provides only an overview. The Dossier upgrade is designed to enable more self-service analytics. New features include data import, reusable dashboard and mobile apps, expanded mapping capability, and more Mobile enhancements. Choose Grid > Compound Grid . Go to Add External Data > Databases > Select Tables and pick the following table and columns. Click Save . blogspot. dossier. reportName. 5 5. Click Select a file to browse and select a connection file. 6,154,76 6, 6,173,310, 6,260,050,. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. To alias an object name in MicroStrategy Web: 1. About sample data and. ArrayList; import java.