It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. Start building with MicroStrategy to deliver exceptional product experiences. It introduces a free-form canvas that lets. MicroStrategy fundamentals: Learn about the installation process of MicroStrategy Workstation, which is essential for configuring the development environment for. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Describe joint child? The three parts into which this comprehensive Microstrategy Interview Questions blog is divided are as. Using system prompts, users can use. TheLogicalDataModel 19Diagnostic Analytics. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. MicroStrategy Tutorial Reporting. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. To Create a Report from Scratch. This tutorial steps through the various capabilities and pages within the Administration portion of a MicroStrategy Project Source. The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. Hierarchy object - a MicroStrategy object that represents a group of related attributes that belong to the same higher-level concept Ex. Published: Jun 23, 2017. Open up MicroStrategy Enterprise Manager Console and navigate to tools>options and check the 'Log migration SQL' checkbox as shown below: Go to tools>data load options and run a custom time window for the period where data is missing as shown in the image below: The dataload will likely fail with a 'PRIMARY_KEY'. 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. Creating Free-form Dossiers. MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, MicroStrategy Email Delivery, MicroStrategy BI Author, MicroStrategy BI Modeler, MicroStrategy Evaluation Edition, MicroStrategy Administrator,A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. Controlling Access to the Database: Connection Mappings. 11. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. In order to have the "Create Personal View" option available, users must go to "Edit Mode" and access the "File" menu. In the MicroStrategy Tutorial project, Time is a user-defined hierarchy. Dossier offers element/value selectors, attribute/metric. MicroStrategy has some great features such as: Data Discovery. KB442146: Incorrect filtering is seen when converting an attribute filter qualification to a set qualification in a dossier. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. Embedding SDK. 5258 views | December 16, 2021 00:57. In the Navigation pane, click Environments. 2 release, the driver file is called odbc8. mstrio: Simple and Secure Access to MicroStrategy Data. Get inspiration at the MicroStrategy data dashboard gallery. After adding items to your library, you can view them on the Library Home page. This video explains how to find and download the course PDF and other training materials needed for class. Recommend. Store data in pandas data frame import pandas as pd. Select the new visualization as the target for the in-canvas filter created in step 3. Once data flows into the interface, the dashboard will come to life. Wherever you can define an expression, you can use a function. dossier. reportName. This dossier has two attributes and two metrics. 7. This Microstrat. First, you'll learn what a dossier is and how to import data into it. Click the MicroStrategy icon, and select Create Document. Then check if the Use parameterized queries box is selected. x, using URL API. In the Navigation pane, inside the Administration group, click next to Subscriptions. Create a cube report off of the cube in Step 1. Embedded directly in apps, end users have access to their very own AI assistant. In MicroStrategy Developer, from the File menu, select New, and then choose Report. (To follow the examples in this guide, click MicroStrategy Tutorial . The retail store sells electronics, books, movies, and music. In this course, Building Your First Dossier in MicroStrategy, you'll gain the ability to visualize and explore your data using the MicroStrategy Dossier. For example, the following Command Manager script will enable XML and HTML5 caching for "Test Dossier" at the level of the dossier. 5. 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. - pull data out of it. Follow the prompts to select your visualization type and add data to your visualization. Build beautiful, interactive dashboards with Dossier. x? Knowledge Base: How to concatenate two attribute forms by using derived attributes in MicroStrategy 10. x-10. In this tutorial, we will review sample dossiers in MicroStrategy's public "Demo" environment Library. By default, the General preferences page is displayed. MicroStrategy is a powerful Business Intelligence and Visualization software. 88K KB32618: How to provide Intelligent Cube files to MicroStrategy Technical Support for troubleshooting purposes in MicroStr…Use MicroStrategy Web to create customized, interactive dossiers for exploring your business data. Follow the below steps to change your environment's Library URL. CAUSESelect the Security Filters tab. Vertical labels truncated in bar graph in Dossier. URL API. You can also maximize the amount of space available for data display by viewing dossiers in Presentation Mode. First, you'll learn what a dossier is and how to import data into it. Right-click in an empty area on the right side of. 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. A prompt allows a user to provide an answer to restrict or filter data during report execution. This. 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. Linking can improve dossier performance by eliminating the need to include all possible datasets for a single workflow in the same Dossier. Create a new, empty report. Modifying the underlying data source structure requires a new import of the data by using the Replace Dataset. 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. Visualizations (Grid, Bar chart, Line chart, Bubble chart, Heat map, Map, Quill editor, etc. Reports. After enabling Mobile Telemetry for the project, users can run a report on the Mobile App. 2. Memory mapped files (MMF) can be used for effective RAM utilization. In MicroStrategy Tutorial, share the Dossier URL API with. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Jobs and Tasks Open the Workstation window in smart mode. MicroStrategy i About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. List; import com. Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. In the MicroStrategy Tutorial project, create a report with the attributes Region and Year and the metric Revenue as shown in the image below: Change the attribute join type to 'Preserve lookup table elements joined to final pass result table based on template attributes with filter". MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. In MicroStrategy 2019 with Data Engine Version set to 11, a large intermediate table generated from a cross join may return more rows that can be supported, leading to no data returned. 4. 환경을 최초로 테스트하기 테스트 실행 전. MicroStrategy Library provides MicroStrategy reporting and analysis capabilities across all of. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. 3. There are 3 ways of configuring thresholds: Go to Format tab → Data Points → Threshold. 클릭 저장 통계 패널을 열려면 다음을 수행합니다. Sending and Receiving Services 36 Evaluating Narrowcast Features 37 About services 37 About the MicroStrategy Tutorial -Delivery project 39 Getting started with the Narrowcast evaluation 39 Sending sample services 41Dossiers with MicroStrategy 10. Create a New Dossier. exe est stocké. Nahiyan Khan (Inactive) · Jun 21, 2017 ·. Import visualization data as a CSV file # 8. The Embedding SDK allows you to quickly integrate a MicroStrategy dossier into a web application in a responsive manner. Notice that the change cannot be applied and the aforementioned “Uncaught TypeError” can be found in the browser’s console. 3. 0 or above, the issue cannot be reproduced. 1. Micro Strategy also supports mobile BI. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. DETAIL DOCUMENT JOBS: Whether the telemetry for each processing step of a document or dossier execution is recorded. Connect to MSTR using `Connection` object # 3. First, enable Basic Authentication on MicroStrategy Virtual Site in IIS. Enter your credentials. . According to research, MicroStrategy has a market share of about 4. On the left, select Export Reports. Microstrategy Dossier creation. These new features are going to make all its users, including administrators, analysts, data scientists, developers,. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. The object's editor or wizard opens. In today's reporting systems, the amount of data available to business organization is rapidly increasing. 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. Tell a story with your data using the dossier chapter/page format. It can also be used as a non-data element, such as a dropdown, hidden menu, tooltip, pop-up tutorial…etc. As of MicroStrategy 2020, you can use dossier linking to navigate between different dossiers within the same project while preserving filtering criteria. x. Learn how to create, edit, and share reports, dashboards, and documents using Excel, PowerPoint, Word, and Outlook. Functions Reference. The threshold can be selected from list of built-in colors or configured manually. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. The Dossier also relies showcases custom visualizations: Smart KPI Widget and CardWidget with Trend Line. Click Blank Dossier. microstrategy. This javascript API is used to embed a dossier into a web page. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. Choose Grid > Compound Grid . MicroStrategy 10. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. In MicroStrategy tutorial, create an In-Memory cube using the LU_MONTH and MNTH_CATEGORY_SLS tables. Some of the. Wählen Sie die Option aus MicroStrategy Tutorial Anwendung und klicken Sie auf Auswählen. By designing dossiers with prompted datasets, end users will now be able to proactively limit the data load prior to running a dossier. In this brief video tutorial, Richard Kapupu from our Customer Education team explains how to add a Designer Filter to a visualization in a MicroStrategy Dossier. First, create an attribute that contains the latitude of each store and assign it the Latitude geo role. )Select 'Data Line' followed by 'Revenue' series, change the 'Transparency' to '100', as shown below: After apply all the changes made, the 'Revenue' metric in graph view is hidden but it still exist in grid view,. When turning an advanced filter qualification into a set qualification on a document or dossier in MicroStrategy 10. This knowledge base article describes a defect in MicroStrategy 10. ANALYST VIDEOS & TUTORIALS Architect Create, deploy, and optimize components of the Intelligence Platform. 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). You will be able to: - connect to MicroStrategy Server. Cards. Choose Databases. Navigate MicroStrategy Library. URL of the MicroStrategy REST API server. Watch a quick tutorial video on importing custom visualizations in Workstation. 4. Let's start at the beginning. This issue has been addressed in MicroStrategy 2021. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". 3. · Best practices on creating dashboards. Explore the course catalog, certification paths, bootcamp programs, and academic resources for students and educators. This will override the project level document. Migrating to a solution running on an AWS cloud platform reduced costs and allowed the company to standardize operations. · How to use all the main visualizations. S. In this article, I’ll share some cool ways to leverage modern dossier features. Execute command "PURGE ALL CACHING IN PROJECT "MicroStrategy. Place Year in the row and Profit and Cost in the columns. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click. The Dossier upgrade is designed to enable more self-service analytics. 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. Also practical examples are used in this document in order to illustrate the. In the "Format: Template" window click on the "Color and Lines" tab. Accelerate analysis with AI-powered apps. Specifies the preferences group to display if the Export Options page is to be displayed. The object's editor or wizard opens. User B has a security filter on Category and he can only view element Books and Electronics. What is the difference between a dossier and a document? A dossier is our modern product that has an intuitive authoring experience and enables. evt. Browse to the Platform Analytics Cube in the Platform Analytics Project and select the option to create a new dossier. Nested functions. This method returns a promise, which is resolved when the dossier instance is created. Python coding is short, minimal and easy. . 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 Intelligent Cube is shared as a single in-memory copy, among the different reports created by many users. This video shows you how to add a MicroStrategy dossier to your MicroStrategy Library by using both the Add to Library and Share options. 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. Month(ID) Less than or equal to Month Selection (ID) Create a logical view to serve as the lookup table for Month Selection. Data Wrangling. Selectors are very practical tools to address this issue. Using MicroStrategy Tutorial. Clean and Transform data. Extract the downloaded files. Sending a Dossier to User Libraries. Standard = 1 (default) or LDAP = 16. )Select the table that was created in Step #1 (or the lookup table where the Last Month column was added). Start building with MicroStrategy to deliver exceptional product experiences. Select the fact, "Cost," and add "Year" to the level. Parsing Cross-Tabbed Data (Importing) Using Free-Form Layout in Dossier Authoring. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. Adding a Designer Filter to a Dossier. In the MicroStrategy Tutorial project, create a Data Import cube called DS1 with the table, LU_CATEGORY. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. Some attributes can have additional descriptive forms that do not serve as the primary description form. The list of privileges and their descriptions can also be found in the MicroStrategy - System Administration Guide that comes with the product documentation. Pivotingdata 91 Specifyingmaximumandminimumvalues:Reportlimits 94 Calculatingdata 99 4. Follow the steps below to make the changes in MicroStrategy Web 9. MicroStrategy has come up with its newest version of the platform, Microstrategy 11. use the function "Remove Duplicate Rows". The Dynamic Aggregation - Region - Employee from the MicroStrategy Tutorial project is used as the base report to illustrate this tactic. This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. Learn how to connect to various different environments in MicroStrategy Workstation 2019, MicroStrategy’s tool that lets you administer and control both proj. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from cubes and reports, create new datasets, add new data to existing. Enter your credentials. The same report accessed in web. Cloudera CDH Hadoop Gateway System. It can connect to data warehouses, relational systems, flat files, web. - pull data out of it. Download the PDF manual and get started with MicroStrategy Office today. The body of the response contains the instance ID for the dossier and the status. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. Finally, This Dossier makes our analytics powerful. Identify the dossier by passing the dossier ID in the path of the request. reportID. 9 Publisher: MicroStrategy Installation Instructions: To view this dossier with the visualization, download the . For prior releases, either a cube was loaded, residing completely in RAM, or unloaded. In this example, you execute a dossier called "Filters" (located in MicroStrategy Tutorial>Shared Reports. Click "Configuration" , Advanced, then "Analytical Engine VLDB Settings" under Project Definition-> Details. Creating Compound Grids. The following examples use the MicroStrategy Tutorial project for illustration purposes. In Name, enter a descriptive name for the subscription. Related articles from the Community: Knowledge Base: Dossier is no longer certified when downloaded as a . A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. You will be able to: - connect to MicroStrategy Server. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. JOB SQL: Whether the telemetry for each processing step of a report execution is. username ¶ Username. Using natural language, ask questions about the dashboard or underlying data itself without the need to navigate complex interfaces or navigation manually. * PDF Export * Set Target Visualization * Set Target Page & Dossier (Only on Web) Publisher: DongHyub Lee (Sales Engineer in MicroStrategy Korea) Visualization Disclaimer. You can set the direction of the Sankey diagram and color of the nodes. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. Business Intelligence with MicroStrategy 10 Analytics. KB441075: When an Intelligent cube is created from an Excel file in MicroStrategy Web 10. The body of the request contains the information needed to create the session. Hive. 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. Using MicroStrategy Tutorial project as an example: 1. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. To Create and Save a Dossier Open the Workstation window. In a document, Category is defined as a selector in left grid A. Kickstart Your Career. 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. MicroStrategy Web. Working around the limitations of documents in a creative way. 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. Introduction to Dossier Authoring in MicroStrategy Web. Microstrategy is rapidly increasing in popularity and is being leveraged across. Add the attribute Category Desc of. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. After enabling Mobile Telemetry for the project, users can run a report on the Mobile App. ANALYST VIDEOS & TUTORIALS Architect Create, deploy, and optimize components of the Intelligence Platform. We empower you with the skills to get the most out of your analytics investment. Steps to reproduce The following steps were used to reproduce the issue in the MicroStrategy Tutorial Project. 0 (Ashburn and Seattle): 1. The user wants to show different metrics in different colors in a graph in Dossier ACTION: Log in MicroStrategy Tutorial and create a Dossier adding 1 attribute and at least 2 metrics; Set the visualization as Lines Graphic; Add the attribute to horizontal and the metrics to vertical; Move the Metric Names tag from Vertical to Break by Sankey diagram custom Visualization. You will learn about a couple of Level Metric. Choose Create New > Dossier. Disable Unified Quoting Behavior in Query Optimization. Dossier-style documents form the basis of the apps and dossiers you can create with MicroStrategy Mobile. Update the schema. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. User without the Web edit Dossier privilege cannot edit a dossier by navigating from Library Web to MicroStrategy Web. When creating a Dossier, it is common to add totals to your grids. By the same token, our platform is also the source of valuable data. MicroStrategy Document Creation Guide is a comprehensive manual that teaches you how to create and format various types of documents using MicroStrategy tools. Within MicroStrategy Web 10. Learn how to import data into Dossiers using MicroStrategy Workstation 2019, MicroStrategy's powerful tool that lets you administer and control both projects. 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. In a document, Category is defined as a selector in left grid A. 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. . Republishing and wrangling depend upon a consistent data source structure. Watch on. Add, rearrange, or remove data from a visualization in a dossier. Using the Filter Panel in a Dossier. 8 to help improve the performance of Quick Search on MicroStrategy Web. Utilizing the generated trendline equation, user can manually create the data point values utilizing derived metrics as part of MicroStrategy OLAP Services. Define a Many-to-Many relationship between Category Id and Month Id. Paste the created link in the HyperIntelligence card. Visit the data visualization and data dashboard galleries for inspiration. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. The Customer attribute in the MicroStrategy Tutorial has various forms, including the Customer Name and the Address forms. *; public class. Request a demo. Web Document designWatch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Advanced Apps. In order to have the "Create Personal View" option available, users must go to "Edit Mode" and access the "File" menu. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. Moving Forward. Parsing Cross-Tabbed Data (Importing) Using Free-Form Layout in Dossier Authoring. Grid (1) or Graph (2) Mode. switch to Presentation Mode, try to move the filter scroll bar up&down by dragging the. In this video tutorial, Doug Terbush from our Customer Education team describes the process of building a Transaction Services-enabled document. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. It is designed to help developers build data-driven client applications quickly and easily. This video will help you get started using the MicroStrategy REST API. Number of Views 644. You can import business data from many different sources, including local files, databases, Google Drive, etc. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. x and above, refer to KB205622: How to setup Windows Authentication with Microsoft IIS 7. Introduction to Dossiers. 5. MicroStrategy ONE introduit de nouvelles fonctionnalités qui améliorent les performances et l’extensibilité, afin de proposer une meilleure expérience utilisateur globale. So, You still have the opportunity to move ahead in your career in MicroStrategy. Run the document and save it with a default value "Movie" for the selector. If the call is successful, the resulting HTTP response returns an HTTP status code 200 and a response body containing a list of the active projects that the user session. AnsweringQuestionsaboutData 111 Filteringdata 112 Understandinghierarchies 117 Open MicroStrategy Web and click New Dossier. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. This Visualization requires more than 2 attributes and 1 metrics. 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. The recent version was released on 7th January 2019, and it introduces many new ground-breaking enhancements and features. dossier. Source: MicroRooster. To build your first dossier: Open a blank dossier. 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. Example 1: How to create a dossier that shows all dossiers and dependent datasets 1. Get certified by completing the course. Create a derived metric 'DM01 = [Tot Dollar Sales]-[Tot Cost], and add to template. Dossiers automatically adjust to look great on any screen. List dossiers to find ID -> get dossier ID # 5. creating a document. To pick up the fix, upgrade to MicroStrategy 2021 or above and enable project level setting "Data Engine Version" to 2021 or above. Benefits of creating a dossier vs. How to Create a Dossier You must create and save a dossier before you can save visualizations of your data. 4. Create a report using the attribute. If installed over previous versions of the product, the folder remains the same. Under Export Header and Footer section, click the Edit Custom Settings button. Select the object to rename from the Object drop-down list. . Mapbox partners with community mapping. In part two of this video tutorial series, our Customer Education team explains the base object drop zones available on the core set of visualizations, including what. Description. 02:26. Advanced Apps. Transformations are schema objects and therefore only a project designer with Create schema object privileges can create them. Describe Implicit Attribute? Q10. Cause: This is a known issue in MicroStrategy. - modify the data a little bit. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. x, right-click on the project and select Delete, as shown in the following image: Method 2 - Via MicroStrategy Command Manager: A command in MicroStrategy Command Manager allows for the deletion of projects from the Command. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Create a Visual Insight dashboard from the report. You use the trusted data available to you in MicroStrategy to find those insights and present them to your business stakeholders in the form of interactive, beautiful, and insightful visualizations within a Dossier. Therefore, prompts allow report designers to create reports that let users change the report content at run. In MicroStrategy Tutorial: Create a LU table in the data warehouse with State names. Python coding is short, minimal and easy. 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. Answer: Go with dossier. The focus of this example is user-defined subtotals and using the Subtotal Editor, so steps are provided to create the subtotal. Creating Compound Grids. Using MicroStrategy Tutorial project as an example: 1. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. Import your data from a file on your computer or network.