The object's editor or wizard opens. The Open command connects to a project source in the object browser. MicroStrategy Tutorial data model. This provides data scientists access to trusted, operational. MSTR Learning Portal: How to Download Course Materials. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Most of the reports discussed in this chapter exist in the MicroStrategy Tutorial project. These fixes address performance (8), security (5), and stability (24) among other issues. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. Now, remove server was- from projectsources. List Attributes statement. 1 Download. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. The MicroStrategy Tutorial is a MicroStrategy project and a set of demonstration applications designed to illustrate the rich functionality of the MicroStrategy platform. This privilege is required to define conditional formatting. Our experts will explore popular use cases that streamline and automate your workflows—with minimal coding experience required. Click on the upgrade button. End Point: GET /projects. With the integrated option Connect to New Environment: Open Workstation window. MicroStrategy courses can be tailored to developers, analysts, and. How to Login and Create New Project in qTest. Copy the metric expression to the clipboard. Navigate to the download site and download the Workstation installation files. The tutorial is composed of a MicroStrategy 2020 project, MicroStrategy Tutorial (a metadata and sample data are included). 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. With the integrated option Connect to New Environment: Open Workstation window. The following example shows how to create the report using the Tutorial Project: In the Tutorial project, the relationship between Supplier and Item attribute is one to many. This free Visual Basic tutorial covers topics like Arrays, Strings, Operators, Switch, Loops, etc. 2. x: Navigate to Programs -> MicroStrategy -> Tools -> Project Mover. 227. An example is shown with MicroStrategy Tutorial Project: - In Microstrategy Developer, log into the project where it is desired to obtain a report's VLDB properties. eBook Preview – First Chapter FREE. Go to Administration > Projects > Project Configuration. Enable users to interact with personalized chat for further product discovery. For information on how to create fact level extensions, see Modifying the levels at. Business Intelligence with MicroStrategy 10 Analytics. Open MicroStrategy Enterprise Manager console and select the above three projects to be monitored by. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). Select project for the given connection based on project_id or project_name. End Point: GET /projects. Likewise, you make sure. Visit the MicroStrategy download site to download the latest supported version of this product. 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. Functions in MicroStrategy are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-selected calculations. The URL API allows you to directly request MicroStrategy Web to perform actions by using specific arguments in the request. MicroStrategy offers an intuitive way to create and modify business. 4. HyperIntelligence in Action. This sample uses REST APIs to authenticate the user, get all of the projects, get the configuration-level folders for a specified project, and search for objects in the root folder. The sample URL shown below illustrates how to execute the "Inventory by Subcategory" document, which is part of the MicroStrategy Tutorial project. For example, a Catalog attribute has the following description "Not yet implemented". Step 1) Open ‘Contact_Form_Split’. MicroStrategy製品にバンドルされるPostgreSQLデータベース、あるいは、お客様ご自身のPostgreSQLデータベースにMicroStrategyTutorial_2021_FilesDatabases配下の. Conceptually, a project in MicroStrategy is the environment in which all related reporting is done. Open a report. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. Click the link for the desired manual or other documentation source. Post a Discussion;The following code samples are provided with MicroStrategy Web, as additional assistance to help you get started with various types of customization tasks. Installation And Initial Setup. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. Business Analysis is the key figure in understanding business requirements and their implementation. To see sample dashboards in Developer. -u Username: Identifies the user name to be associated with the project source name. We fixed 157 total defects with Hotfix 8 (10. Open your project in MicroStrategy. Add the 'Day' attribute as level with Filtering and Grouping set to 'Standard' and remove the default 'Report Level' target. It is ready to be used and requires no additional configuration tasks. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. · Tips and tricks on using some not so well know features. Object Layer. By default, the MicroStrategy Tutorial project is provided as part of the MicroStrategy Analytics Modules project source. Centralize your team’s learning content alongside MicroStrategy Education courses and certifications. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. 3018. Advanced Apps. csv file format, will not be exported surrounded by quotes, whereas all subsequent object columns are. PrerequisitesNode. The MicroStrategy installation installs third-party software libraries to provide a streamlined user experience. If you display tables in logical view, the options in the Project Tables View area can be used to modify the display of data within tables in. Get project list. PDF Version Quick Guide MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. 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:Database Connections are created and edited in the Database Instance Editor, as shown below: To access the Database Instance Editor, log into the Project Source as a Database Instance Manager. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. 2 KILOBYTE Views 24 min read Updated on March 6, 2023 Like part of this MicroStrategy training you will learn what to get started with MicroStrategy reporting, how toward commence the MicroStrategy Office, starting this MicroStrategy Rail, opening an report, components. They are located under samples in the SDK installation directory. How to create the connection file. 2 : Right-click the MicroStrategy Tutorial project and select Architect. Optional. BUSINESS USER VIDEOS & TUTORIALS. Click within the Dataset Objects area to add datasets for the document. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. We will use the data contained within the MicroStrategy Tutorial project that is provided out-of-the-box. From the visualization gallery (vertical list of icons to the right of the dossier), double-click the Google Chart icon. Description. The ID is displayed in the dialog box. NET Tutorial Summary. Select the attributes, metrics, and filters to include. The workflow for this sample is shown below: POST /auth/login. Expand the Public Objects folder, then expand the Reports folder. Watch how you can customize and extend the impact of your intelligence applications using the MicroStrategy Web SDK. MicroStrategy Education offers a range of certifications to help individuals enhance their skills and knowledge in MicroStrategy products. 0 (Ashburn and Seattle): 1. Using the MicroStrategy Tutorial project, perform the following steps to achieve this: From the MicroStrategy Web Home page, click "Create" and choose "Custom Group". 1. 11 and change the Data Engine version to 2019, the reports which use transformation metric with multiple transformation levels show incorrect data and SQL as the data were retrieved from lower level fact tables, e. Request a demo. Our analytics and mobility platform transforms data into actionable insights that help people make better business decisions. 👉 Lesson 2. The following examples use the MicroStrategy Tutorial project for illustration purposes. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. You can view the updated status through this API. MicroStrategy tutorial project is an excellent tool for beginners and experienced MicroStrategy developers to. To view page-by section of the report, choose View > Page-by. The steps below explain what is happening as the custom ESM attempts to authenticate a user and create a session. You choose. 2. Expand the Public Objects folder, then expand the Reports folder. VB. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. The System Administration Help is to be the primary resource that system administrators use to learn about the concepts and high-level steps for implementing, deploying, maintaining, tuning, and troubleshooting the MicroStrategy business intelligence system. You are focused on making sure these data sources are available in MicroStrategy, as well as defining their data structures and relationships for advanced data queries. x and 10. To start the Report Wizard. 2. • Troubleshootingandmaintenanceguidelines Thesampledocumentsandimagesinthisguide. x-10. For a description of each area or pane of the MicroStrategy Web. This Knowledge Base article introduces "mstrio," Python and R packages which provide an interface for the MicroStrategy REST APIs. 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. Follow the steps below to set up the Tutorial environment. Top MicroStrategy Courses Online - Updated [November 2023] Save big on Black Friday | Fill your cart with skills. Argument:. Suppose that the document is based on two reports. The MicroStrategy Analytics Module project source includes the MicroStrategy Tutorial project. You cannot create fact level extensions using Architect. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. This technical note describes an issue in which using the text option in a threshold in Microstrategy Developer 9. Follow the steps below to create the Sum of Last and Last Quarter subtotals in the MicroStrategy Tutorial project:. dmg file. Step 1) Import the react packages. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. 1. For Cloud 3. Using Histogram Graphs Effectively. Download the zipped sample and extract the EmbeddingAPIWorkflowSample folder and its contents to your application server. 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. PDS file. 2. 2. This Python script example will help you to: 1) List all OLAP cubes in your project 2) Download real SQL query for each cube 3) Parse the SQL and extract details about tables and columns being used 4) Export gathered details to CSV files for further processing. The steps to perform these configurations are included in Appendix A: Connecting to Databases of the Installation and Configuration Guide. Select the LU_Year table from the Table drop-down list. Download MicroStrategy Desktop. Work-flow for this authentication customization use case. Customer Satisfaction, is available in the MicroStrategy Tutorial project. A typical project contains reports, filters to qualify the report data, metrics that calculate the data, attributes that provide context for the metric data, and mathematical functions. 3062 - fastPDFExport. Example. For those coming from previous software generations (7, 8, or 9) MicroStrategy Desktop was the tool that was used to create the metadata and reports on a Windows (PC only) environment. Pass Orientation. In this tutorial we are going to discuss Installation of MicroStrategy. htm file, French characters show up as boxes. Views 1543. 2. - modify the data a little bit. Step 8) Click on “LAUNCH” button. The sample URL shown below illustrates how to export the "Electronics Revenue vs. Even without coding skills. 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. MicroStrategy Tutorial data model A logical data model graphically depicts the flow and structure of data in a business environment. Right-click in an empty area on the right side of. Change the 'AuthMode' node to 'MWSNTCredential', as shown below: <ProjectSource> The latest hotfix for MicroStrategy 10. Privileges. MicroStrategy ONE empowers companies worldwide to seamlessly. If the user is currently not connected to the project source the command opens the login window. Now open a MicroStrategy Office application, such as Excel, and click on the MicroStrategy button. If the call is successful, the. Download the zip file that holds the CSS, JavaScript and data files used by the D3 Waterfall Chart visualization. LOAD PROJECT "project_name ";where: PROJECT "project_name" is the name of the project to be loaded, of type string. Click within the Dataset Objects area to add datasets for the document. In this tutorial video, we'll show you how to download and install MicroStrategy Workstation on your computer for free. Description. The user can use the search bar to narrow down the documents they are. 3 or higher MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, By default, the MicroStrategy Tutorial project is provided as part of the MicroStrategy Analytics Modules project source. You can fast-track onboarding new employees. MicroStrategy is a leading Business I. The table below shows the URL parameters used to export a report to PDF using the URL API. This template uses a single. Step 5) Once the download is completed click on the setup file. 3. This video demonstrates overview of MicroStrategy Architect and schema objects. Create a document from report A. …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. Open the database instance for the project. If the call is successful, the. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. The newly created folder in. Functions Reference. To explore this sample project data, in the Folder List expand MicroStrategy Tutorial, then expand Public Objects, then expand Reports. Types of Filters in Tableau — Condition by Formula, Extract, Context. Note that the option to Create a Document in MicroStrategy Web from an iCube it is also available. The MicroStrategy Tutorial project has been tested on a warehouse and metadata in Microsoft Access. The default folder is: C:Program Files. Device id will be detected automatically. This business analyst tutorial for beginners is designed to help you understand Business Analysis right from Software Engineering Methods & Lifecycles to Requirements Preparation, analysis, and presentation. - push data back to MicroStrategy and save it as a new cube. Specifies the ID of the report services document to export to PDF. src. Data Warehouse (DWH), is also known as an Enterprise Data Warehouse (EDW). The steps also include an example for most steps, based on Tutorial sample data in the MicroStrategy Tutorial project. x. You will be able to: - connect to MicroStrategy Server. 1. Download course catalog Instructor Office Hours Pass Orientation FAQ MicroStrategy Education offerings Purchase annual subscription pass Our training is delivered with a. From the visualization gallery (vertical list of icons to the right of the dossier), double-click the Google Chart icon. Click on download community edition your download will begin. Forecast" report, which is part of the MicroStrategy Tutorial project, as HTML. Click here to view help for the latest version of this product or search MicroStrategy Community. To display one gauge that displays data for every item, place both the metric and attribute in the columns. reportViewMode. The LU_YEAR and LU_REGION tables from the MicroStrategy Tutorial project shown below are used to illustrate the various logical view options available for displaying columns and attribute forms in tables. Cards. · How to use all the main visualizations. Three main types of Data warehouses are Enterprise Data Warehouse (EDW), Operational Data Store, and Data Mart. The Open command searches for the project source by name. · Best practices on creating dashboards. Select Project Sources and click Next. reportViewMode. The MicroStrategy Tutorial is an interactive product demonstration designed to showcase the rich functionality of the MicroStrategy 2020 Platform. 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. The Report. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. To know more details on Microstrategy click here :- ,visit: +91 800 811 4040MicroStrategy online tra. By default, certain custom visualizations such as the WhatIf visualization are restricted to only the MicroStrategy Tutorial project. 👉 Lesson 2. g. Cloudera CDH Hadoop Gateway System. When you create a Boxplot graph you must include the correct number of metrics for the graph to resemble the example above. For this example, an 'End on hand' metric must be created based on the 'Item inventory' fact. If installed over previous versions of the product, the folder remains the same. List Attributes statement. When the user clicks a document in the list, it is embedded as a dossier in the right pane of the web page. xml file under C:\Program files\MicroStrategy\Web Services. Assign a friendly environment name. x. Deploy the ojdbc8. In this case, a sample of 500 customers is used, as indicated by the. It can connect to data warehouses, relational systems, flat files, web. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. MicroStrategy Desktop's intuitive toolset and built-in templates make it easy to build compelling analytical books of visualizations, dashboards, and reports in a matter of minutes—we call these MicroStrategy Dossiers TM. Exploring Sample Dossiers in Library. Right-click the project and select Project Configuration. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. Schema objects include facts, attributes, hierarchies, and other objects which are stored in the Schema Objects. Double-click the Region attribute to add it to the. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions; Resources;. Even without coding skills. The MicroStrategy Engine has a work flow to calculate Aggregate from base metrics. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. All articles. InExamples based on the MicroStrategy Tutorial project have been provided to explain this information. List Project Configuration Properties statement. After the project source is found, it is expanded. Link a MicroStrategy user to a windows user in MicroStrategy Developer, by going to Authentication - Metadata, as shown below: Go to the MicroStrategy Web Services machine and locate the ProjectSource. The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. !Now, let’s create create a dashboard. Connecting to Environments in Workstation. Enter the Intelligence Server address (IP or FQDN): Enter the port that the Intelligence Server service is running on. Open each email's invitation link to individually download both badges for your MicroStrategy Identity network. To plot a sales line for the expected future sales data, apply linear extrapolation techniques to the historical data. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Select the folder to open based on the device you are using. The default folder is: C:\Program Files (x86)\MicroStrategy\Product Name when installed on a 64-bit Windows environment. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. Published: Jun 23, 2017. 4. 2 : Right-click the MicroStrategy Tutorial project and select Architect. JAR files, property files, etc. The MicroStrategy Tutorial project has sales data for multiple years. Your contribution will go a long way in helping us serve more readers. Log in to the MicroStrategy Tutorial sample project. Navigate to the My Personal Objects folder, and open the My Objects folder. ), and execute Java programs. Create a metric 'MTD Revenue' with fact 'Revenue'. App Description: This App is a sample demo app to show the users how to use MicroStrategy REST APIs as well as how to embed dossier (s) into a 3rd party application. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Open the MicroStrategy Configuration Wizard. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Metric Editor -> Tools -> Metric Joint Type. Welcome to Platform Analytics! The vision of MicroStrategy is Intelligence Everywhere. Connecting to Environments in Workstation. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. A component in this context is the basic building block of your data app. 3. This endpoint allows the caller to get the list of projects with the MicroStrategy REST Server. create. Every request to a MicroStrategy Web product corresponds to a specific event or action, which. Be careful to select the option "None" under users and user groups. In this brief video tutorial, Jaime Garcia of our Customer Education team explains how to connect to an Intelligence Server in MicroStrategy Desktop in order to make use of existing datasets in a MicroStrategy project. Go to Command Manager and login the project source. MicroStrategy download site to. It will enable you to gain in-depth knowledge on MicroStrategy architecture, designing schema objects using MicroStrategy web and desktop, scorecards, etc. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. To view sample RS documents created for each mobile device, in the MicroStrategy Tutorial project, navigate to the Shared Reports folder. 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. To benefit from the latest functionality available in this version of MicroStrategy Platform Analytics, an administrator must upgrade the MicroStrategy system, including Platform Analytics. Privileges allow users to access and work with various functionality within the software. On the top right side click on tab Free trial from the main page. The. js — How to Download & Install Node. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. Step 10) Click on “Create a new Java project” link. Extract the downloaded file. Method 1: The following steps assume that in the data warehouse, the lookup table used for the attribute in question contains a column whose data type is text which defines the link to be used as a hyperlink or uniform resource locator (URL). Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or a Data Scientist. Then, you will learn the advanced stuff for C# programming like C# data types, variables, classes & objects, interface, collections, file operations, etc. Note: When the MicroStrategy Analytical Engine cannot resolve the correct datatset as explained in the cases below, the data displayed for these will correspond to the value chosen for the missing object display under Project Configuration. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. This statement can only be executed in a Windows. Ports and connectivity informationIn MicroStrategy Web, log in to the Tutorial project. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!When using the subtotal feature to sum the metric values for the N-tile metric, the user cannot select to apply the subtotal to calculate across the N-tile metric level to show the total value for each of the rank in MicroStrategy Developer 9. 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. . The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. After changing the description for a project in MicroStrategy Developer 9. Click on the plus symbol with the label of Connect to a New Environment. Page component that should handle the action and the event. reportViewMode. Change the metric join type to 'Outer'. MicroStrategy Architect opens. Executes the report services document specified by the documentID argument. Make sure not to duplicate users and groups, and use the destination ACLs. MicroStrategy-provided applications demonstrating platform capabilities, as well as tutorials, documentation, and education materials of how to effectively implement those capabilites. Click on the plus symbol with the label of Connect to a New Environment. Note: The user can also do the same for any other out-of-the-box Microsoft Access databases in the MicroStrategy Analytics Modules (CAM, FRAM, HRAM, SAM and SDAM). 1. Initially, all of the documents in the MicroStrategy Tutorial project under the Public Objects folder are displayed on the left side of the web page. Use the sample Tutorial project to create a new report with Customer Region as the attribute and Revenue as the metric. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. This video explains how to find and download the course PDF and other training materials needed. This scenario uses the steps below: Connect to server was- and open Supplier and Sales Report in Microsoft Excel. Execute command "PURGE ALL CACHING IN PROJECT "MicroStrategy. ITIL framework helps in improving project delivery success and managing constant business and IT change. SAP HANA can load data from SAP and Non-SAP data source through SLT, BODS, DXC, and Sybase. Select Blank Report. Click the MicroStrategy icon, and select Create Document. To view the structure of the MicroStrategy Tutorial. 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. The default folder is: C:Program Files (x86)MicroStrategyProduct Name when installed on a 64-bit Windows environment. In MicroStrategy Desktop, log in to a project. Click Blank Report. Get project list. Following is the architecture of MicroStrategy: 1. Enter your API Server and select your authentication mode and enter your credentials. The MicroStrategy platform includes a Tutorial project, which is a sample data warehouse and a demonstration project you can use to learn about the various features that MicroStrategy offers. Open the Attributes folder and then the Geography folder. We fixed 157 total defects with Hotfix 8 (10. com. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. Using system prompts, users can use. documentID. For technical details on the MicroStrategy Tutorial, see the MicroStrategy Project Design Guide. To see sample dashboards in Developer. Download the O’Reilly App. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. js Basics for Beginners. This behavior is inherent to Microsoft Excel. In. microstrategy. xxx. MicroStrategy provides a step-by-step guide to downloading and installing the tutorial project on your system. From the File menu, select New, and select the type of object to create, such as a report or a filter. Careers. Demo Applications Homepage. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". Drag and drop the attribute Category from the Object Browser into the Report View: 'Local Template' section to break the report into pages. This document uses the MicroStrategy Tutorial project to demonstrate how to create a custom subtotal using the "Last" function to display the subtotal of an 'End on hand' metric. Right-click on the right-hand side of Desktop, select New, and then select Report.