MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. STEPS TO REPRODUCE. Minimum MicroStrategy version: 10. Adding a Designer Filter to a Dossier. Number of Views. 5258 views | December 16, 2021 00:57. In MicroStrategy Tutorial, share the Dossier URL API with. Select one: To create a new security filter, click New. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. To access a MicroStrategy page, you use the evt and src parameters in the URL. Go to Command Manager and login the project source. See Introduction to Visualizations for more information about the available types of visualizations. 2 release, the driver file is called odbc8. This video shows how to certify a dossier. 1649 views | May 27, 2022 01:29. add the Supplier attribute to the filter pane. In MicroStrategy Tutorial, create an Intelligent Cube with. Using the Filter Panel in a Dossier. Click Finish. selection : the dynamic value that you want to pass to the dossier (attribute element). Create a level metric, "Cost@Year," using MicroStrategy Developer. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. Cliquez sur Entrer. Next,. These new features. Log in to the project in which you want to create a report. First, you'll learn what a dossier is and how to import data into it. dossier. The value from of visualizationKey is necessary to specify which single. MicroStrategyDesktopQuickStartGuide ©2017,MicroStrategyInc. Using the MicroStrategy Tutorial project, perform the following steps to achieve this: The first element will be called "Top 10 Customers" and will be a set qualification on the "Revenue" metric, which is a rank on the top ten, and where the output level is the Customer attribute. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. See Introduction. This tool can be accessed from Start -> Programs -> MicroStrategy -> Tools -> Connectivity Wizard. 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. MicroStrategy offers an intuitive way to create and modify business. Even without coding skills. This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. If you are working with your own data, rather than Tutorial data, the current date calculation works if the project. MicroStrategy Tutorial. You can see this in the diagram in Testing an Environment for the First Time, or by looking at the Intelligence Servers on your MicroStrategy Web Administrator page. x. For details to create metrics and reports, see the MicroStrategy Web Help. 3. Next, you'll discover how to use data visualizations to help bring your data to life. About sample data and. The body of the request contains the information needed to create the session. The Export Reports preferences page opens. Privileges and Security Access in Workstation. In this course, Building Your First Dossier in MicroStrategy, you'll gain the ability to visualize and explore your data using the MicroStrategy Dossier. Put the attributes Business line, Category in the grid along with the metric sales. Using Access Control Lists. Go to Format tab → Text and Forms → Shape → Threshold. In Name, enter a descriptive name for the subscription. MicroStrategy. By default, it is 34952, but ask your MicroStrategy. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. MicroStrategy courses can be tailored to developers, analysts, and architects, each focusing on different topics tailored to the respective job roles. 2. One or more of the following patents may apply to the product sold herein: U. This Microstrat. Visualizations in MicroStrategy Dossier, Part 1: Understanding a Dataset. Describe joint child? The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as. Used dataset "Category Sales Report" from "MicroStrategy Tutorial" project. The Security Filter Editor opens. In free-form layout, we provide an intuitive way to let you visually “group” containers together. Paste the created link in the HyperIntelligence card. Related versions:En este video podrás conocer las nuevas capacidades de autoservicio (self-service data discovery) de la versión 10 de MicroStrategy y un paradigma conocido c. Solution: This issue has been addressed in MicroStrategy 2021. Create a heat map. LIST ALL PROPERTIES FOR PASTATISTICS IN PROJECT "MicroStrategy Tutorial"; ResultSet Columns. TheLogicalDataModel 19Diagnostic Analytics. Adding Filters (Page level and Global) Adding Links, text and images. Adding Data to a Dossier. What you'll learn. It wraps MicroStrategy REST APIs into simple workflows, allowing users to connect to their MicroStrategy environment, fetch data. MSTR Learning Portal: How to Download Course Materials. standalone; import java. Learn how to create a simple Visual Insight Dashboard in MicroStrategy Web. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. In this tutorial, we will review sample dossiers in MicroStrategy's public "Demo". 2. Patent Information This product is patented. You can import business data from many different sources, including local files, databases, Google Drive, etc. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. Create dashboard from data that contains nulls or zeros. If you are using MicroStrategy 10. Data can be connected through an API, flat file, or database. Define a threshold, click apply and select Advanced Thresholds Editor. One or more of the following patents may apply to the product sold herein: U. It assumes that you are familiar with designing MicroStrategy reports and documents and have the. It introduces a free-form canvas that lets. The following examples use the MicroStrategy Tutorial project for illustration purposes. If installed over previous versions of the product, the folder remains the same. Finally, This Dossier makes our analytics powerful. Footnote 1 Enhancing enterprise analysis with data science. The examples shown below were created in the MicroStrategy Tutorial project. If present, the report is fetched from memory and the reportID argument is ignored. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. First, create an attribute that contains the latitude of each store and assign it the Latitude geo role. Controlling Access to the Database: Connection Mappings. The Dynamic Aggregation - Region - Employee from the MicroStrategy Tutorial project is used as the base report to illustrate this tactic. En esta primera lección del curso veremos como importar un conjunto de datos a la herramienta. BIArchitectureandtheMicroStrategyPlatform 1 Businessintelligencearchitecture 2 TheMicroStrategyplatform 8 Theprojectdesignprocess 18 2. Create a Visual Insight dashboard from the report. A dossier is an interactive display that you can create to showcase and explore business data. Connect to #Workstation applications (MicroStrategy projects), which organize your reporting objects. The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. MicroStrategy – Dossiers – Online Training Video by MicroRooster. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. In the top right corner, click MSTR User and then click. MicroStrategy Tutorial Reporting. allowing a dossier author to make changes to specific dossiers and have those changes reflected in each user's Library. Using natural language, ask questions about the. 6,154,76 6, 6,173,310, 6,260,050,. Store data in pandas data frame import pandas as pd. Within MicroStrategy Web 10. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. Navigate to the appropriate location, name the file, and save it. Import “LU_MONTH” and “MNTH_CATEGORY_SLS” Table from the Tutorial warehouse. Save the document. Dossier. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (In MicroStrategy Web, create a new Dossier > New Data > Databases > Select Tables. Enter your credentials. In MicroStrategy Developer, create an attribute mapped to the LU table. STEPS TO REPRODUCE. About us. Modifying the underlying data source structure requires a new import of the data by using the Replace Dataset. New features include data import, reusable dashboard and mobile apps, expanded mapping capability, and more Mobile enhancements. Each dot on the graph represents the intersection of the data on the X and Y axes. This on-demand webinar provides a foundational understanding of how you can leverage URL APIs to perform a variety of actions for MicroStrategy Web with a single click. About prompts. Jobs and Tasks Open the Workstation window in smart mode. 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. . MicroStrategy has a rich security model that consists of three major components - privileges, security filters, and permissions. 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. Published: Mar 15, 2018. There are a lot of opportunities from many reputed companies in the world. Platform: Udemy Description: Learn the essentials of MicroStrategy 10 through this step-by-step tutorial. 4. Micro Strategy also supports mobile BI. 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. Connect to MSTR using `Connection` object # 3. Select the fact, "Cost," and add "Year" to the level. It uses. In the top toolbar, click Insert Visualization . Using the Preview Page with Dossiers (Importing) Creating a Grid Visualization. Functions Reference. x-10. Get Started. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize data into multiple chapters and pages to provide a. already tried with the solution mentioned before with no results. Creating Compound Grids. Refer to the What's New page in the MicroStrategy 2021 Readme. Starting a Dossier 2020. You can also select an existing template (see How to Create a Report Based on an Existing Template ). This article describes a scenario where incorrect filtering is applied to a grid when an attribute filter qualification using an OR is converted to a set qualification on a dashboard/dossier. exe est stocké. - modify the data a little bit. Drag a connection file into the Add New Environment Connection window. name: the exact name of the attribute on the filter panel in your dossier. Saisissez la commande suivante dans la ligne de commande Windows : <Chemin> setup. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. Show or hide panels used to create and format your visualization. Developer Zone. · Tips and tricks on using some not so well know features. Opening a New Dossier in MicroStrategy Web. KB80548: Workstation Feature: Privileges and Security Access. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. 5. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Define different types of attributes in Microstrategy desktop? Q9. Without data, the dashboard will not show the user anything. Move all the attributes and metrics to the Report Objects pane except for the attribute Region and the metric Standard Deviation of Revenue. He wants the option “Create Personal View" being available in Presentation display mode of the already opened and shared Dossier. After giving the conference keynote, MicroStrategy chairman, president and CEO Michael Saylor answered a series of. create(props) This method creates an iFrame on the web page (in the location specified by the placeholder property) and inserts a link to the URL (specified by the url property) where the dossier to be embedded is located. In this brief video tutorial, Richard Kapupu from our Customer Education team explains how to configure one visualization as a selector to filter other. Now we look to leverage operating system capabilities to enable more cubes to be ‘loaded’ between RAM and disk. Open a grid report. 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. Description: This video introduces the newly minte. Open a blank dossier. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. You can set the direction of the Sankey diagram and color of the nodes. Specifying Warehouse Connection Information. mstr file below and deploy it in MicroStrategy Desktop or MicroStrategy Web. You can open a working demo by uploading the . 1 these privileges can be found in the MicroStrategy Supplemental Reference for System Administration guide. Nested functions. A sales team might use a business dashboard to connect. A compound grid requires at least one attribute and one metric. Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create filters, prompts and metrics. util. Navigatetothefile,selectit,andchooseOpen>PrepareData. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. You will be able to: - connect to MicroStrategy Server. Choose Create New > Dossier. User without the Web edit Dossier privilege cannot edit a dossier by navigating from Library Web to MicroStrategy Web. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. mstrio: Simple and Secure Access to MicroStrategy Data. In the sample that was provided, you create an instance of the dossier “Dossier for Advanced sort” in the “MicroStrategy Tutorial” project. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. Authenticate a user and create an HTTP session on the web server where the user’s MicroStrategy sessions are stored. exe --ResponseFile="C: esponse. ssl_verify ¶ If True (default), verifies the server’s SSL certificates with each request. Once data flows into the interface, the dashboard will come to life. Open MicroStrategy Web and click New Dossier. MicroStrategy - Architecture. Empower your analysts to plot non-standard geographic attributes (like department, sales territory, or region) as area maps within a dossier. Log into the machine where you are installing MicroStrategy Workstation. Using the Filter Panel in a Dossier. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. Right-click the metric sales, and we get the option to choose the threshold as shown in the following screenshot. For example, you could create qualifications for six months ago and for 8 months ago. You can follow onlineitguru for more information about MicroStrategy library. It's different than a Google sankey diagram which requires parent-child attribute. Show totals. Specifies the ID of the report to execute. First, you'll learn what a dossier is and how to import data into it. This not only allows for dossiers to have personalized information, but also improves performance by processing only the. Create a derived metric 'DM01 = [Tot Dollar Sales]-[Tot Cost], and add to template. 8 to help improve the performance of Quick Search on MicroStrategy Web. Steps to reproduce The following steps were used to reproduce the issue in the MicroStrategy Tutorial Project. com : Donate if my videos helps. - pull data out of it. The following is to provide instruction on how to configure library to use SSL encryption to communicate to an I-Server that also has SSL encryption set up and. mstr file below and doing the following: MicroStrategy is a business intelligence tool that is widely used for deriving valuable insights from data in the form of visually insightful reports, graphs and charts. Returned as a boolean value. MicroStrategy - Pivoting. The objects stored in the metadata are reusable. How to Create a Dossier You must create and save a dossier before you can save visualizations of your data. . You will learn about a couple of Level Metric. 听听领先的产品团队如何在与 MicroStrategy 的合作中超越客户期望、打破市场并变现数据。. Instruction steps: Create a dossier, insert a text/image box. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1 For the first-time user, see Getting Started with Documents for a brief overview of documents and dossier-style documents. Run the document and save it with a default value "Movie" for the selector. Save and run the report. 1925 views | September 04, 2020 02:01. 9 / 10. Working around the limitations of documents in a creative way. 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. 9 Publisher: MicroStrategy Installation Instructions: To view this dossier with the visualization, download the . 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. Linking can improve dossier performance by eliminating the need to include all possible datasets for a single workflow in the same Dossier. Description of the new dossier layout including the visualization gallery and shapesThis beginner course will help you in learning on how to create a dossier (analytical dashboard) in Microstrategy desktop/web and will prepare you to become a. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. 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. 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. Dossiers automatically adjust to look great on any screen. The Document Editor allows you to create, customize, and save documents and dossier-style documents to be used across the MicroStrategy platform. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. 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. Method microstrategy. We empower you with the skills to get the most out of your analytics investment. Starting in MicroStrategy 9. 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. The Full option exports a snapshot of each page and each individual visualization. Para recibir el conjunto de datos que vamos a usar en todo el. Create a second metric identical to the first, but add the predefined Year to Date transformation. Drag and drop attributes and metrics to display data, create filters, group data, and more. 1 CONTENTS BookOverviewandAdditionalResources vi Aboutthisbook vii Resources viii Feedback xvi 1. Watch a quick tutorial video on importing custom visualizations in Workstation. A Scatter plot is a graph showing points of data that are not connected by a line. Data Wrangling. En esta primera lección del curso veremos como importar un conjunto de datos a la herramienta. Navigate MicroStrategy Library. 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. 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 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. These fixes address performance (2), security (3), and stability (12), among other issues. Create a new dossier, and add data. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the platform's rich functionality. Click "Configuration" , Advanced, then "Analytical Engine VLDB Settings" under Project Definition-> Details. To view page-by section of the report, choose View > Page-by. Customize, extend, integrate, and embed MicroStrategy analytics into your Web and Mobile applications. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy Connectivity Wizard. ANALYST VIDEOS & TUTORIALS Architect Create, deploy, and optimize components of the Intelligence Platform. 6,154,76 6, 6,173,310, 6,260,050,. Check out the five modern tools you should be using to ensure you are getting the most out of the MicroStrategy platform: 1. Choose an environment and project, then click Select. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Dossiers go beyond traditional dashboards and reports by adding collaboration, responsive design, and a variety of different content such as charts, grids, visualizations, images, reports, multimedia, and any web-based content. · How to use all the main visualizations. When you run this report, null values are displayed for the metric. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2020 or above. MicroStrategy Library provides MicroStrategy reporting and analysis capabilities across all of. Create dossier instance -> get instance ID # 6. Published: Sep 8, 2020. The Lead function can be used in the same way. About installing and configuring the sample Tutorial system 16 Installing Narrowcast Server 18 Configuring Narrowcast Server 22 3. 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. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. Number of Views 644. 联合健康集团的 OptumInsight 通过一款分析应用程序在支付方和提供方之间架设了桥梁，扩展了数据访问并提高了结算效率。. Define a Many-to-Many relationship between Category Id and Month Id. Transformations are schema objects and therefore only a project designer with Create schema object privileges can create them. STEPS TO REPRODUCE. The instructions below apply to Dossiers created using MicroStrategy Web, Desktop and Workstation: Onboarding Users in Workstation. Select "Import as an In-memory Dataset". 4. x, using URL API. This tutorial steps through the various capabilities and pages within the Administration portion of a MicroStrategy Project Source. . Standard = 1 (default) or LDAP = 16. Creating a Visualization as Filter in a Dossier. Some attributes can have additional descriptive forms that do not serve as the primary description form. The Dossier upgrade is designed to enable more self-service analytics. . Cloudera CDH Hadoop Gateway System. In the Navigation pane, click Environments. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. 4. Login to MicroStrategy Developer, create two Filters: F01:Region=South with. A prompt allows a user to provide an answer to restrict or filter data during report execution. You can also maximize the amount of space available for data display by viewing dossiers in Presentation Mode. This video explains how to find and download the course PDF and other training materials needed for class. Accordingly, this topic focuses on how to use transformations in metrics and reports, and provides only an overview. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. 3. You can follow online guru for important updates. 99 until Nov 24. In MicroStrategy tutorial project, create a Data Import cube. Home Published: April 30, 2020 • 7605 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-changing, design-focused features. Mapbox partners with community mapping. One of the main responsibilities of the Platform Administrator is to. Extract the downloaded files. 0+, you have the ability to see how long it takes each visualization to execute, what query is being sent to the DataWarehouse, or what request is being done to an In-Memory intelligent cube. MicroStrategy comes with a sample project called MicroStrategy Tutorial. View changes and push updates to end users in seconds. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. Open a dossier. Click within the Dataset Objects area to add datasets for the document. 265 views | June 24, 2022 02:13. * PDF Export * Set Target Visualization * Set Target Page & Dossier (Only on Web) Publisher: DongHyub Lee (Sales Engineer in MicroStrategy Korea) Visualization Disclaimer. Learn how to create, edit, and share reports, dashboards, and documents using Excel, PowerPoint, Word, and Outlook. xlsx as an example data set. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Dossier’s intuitive, drag-and-drop interface enables you to display and explore your data in seconds. . Adding Data to a Dossier. This case is built upon the MicroStrategy Tutorial project. evt. MicroStrategy Tutorial Reporting. It's now easier than ever to visualize geospatial information and extend mapping functionality beyond standard geographic attributes such as country, state, and. Republishing and wrangling depend upon a consistent data source structure. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. Compared to other Business Intelligence tools, MicroStrategy is capable of providing a complete enterprise-level reporting solution that is flexible, scalable, robust, and user-friendly. For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. In this tutorial, we will review sample dossiers in MicroStrategy's public "Demo" environment Library. Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on the canvas. Select the folder you want save the level metric in. mstr. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click. 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. 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. 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. This course takes you through the basics of MicroStrategy, how to integrate your application with different data sources, manage data, build visualizations and sheets and. In MicroStrategy Developer, from the File menu, select New, and then choose Report. create (props); This method creates an iFrame on the web page (in the location specified by the placeholder property) and inserts a link to the URL (specified by the url property) where the dossier to be embedded is located. Under Export Header and Footer section, click the Edit Custom Settings button. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. To alias an object name in MicroStrategy Web: 1. 9, but the slider will not move. Use MicroStrategy. This java snippet explains how to delete history list subscriptions using the MicroStrategy Web SDK. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. The same report accessed in web. The list of privileges and their descriptions can also be found in the MicroStrategy - System Administration Guide that comes with the product documentation. S. For example, the user can answer the Northeast region or 2002, and the appropriate data is returned from the data warehouse. Re-run the Dossier, notice DM01 still return data even if [Tot Cost] metric is missing in the. Users can now export full dossiers to Excel and get all the raw data for every visualization on every page and chapter to a specific tab in an Excel spreadsheet. 3. The MicroStrategy connector allows users to fetch data from reports or cubes that reside on other MicroStrategy projects or environments. OR, to convert an existing filter into a security filter, click Import.