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. MicroStrategy provides business intelligence solutions to enterprise companies. Gather information about your data source. Another benefit is the consistency of information and calculations. The goal is to derive profitable insights from the data. What is a smart metric in MicroStrategy? Ans: Smart metric allows the user to change the default evaluation order of the metric. Following are the three report types used in MicroStrategy Desktop. Using Power BI to author new requirements, while you plan and conduct the formal migration, will help gain buy-in. Predictive analytics is a powerful tool to forecast trends within a business, industry, or on a more macro level. The REST API is designed to help developers build data-driven client applications quickly. 215 Embedding Analytics with MicroStrategy REST API 2022. 6. Click Modify to open the Properties dialog box: Security tab. Metric - MicroStrategy. Chapter 2: Administering Big Data with MicroStrategy Chapter 3: Data warehouse performance tuning Chapter 4: Optimizing data: Strategies and techniquesThe Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. Gateways and Connectors. KB19194: Considerations for the use of star schemas with MicroStrategy SQL Generation Engine 9. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 1How to build and manage Intelligent Cubes. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. When you add MicroStrategy business data to a map, Esri Maps for MicroStrategy creates a layer and displays it on the Contents pane. Synopsis: Figure 1 describes different scenarios that are described later in greater detail. There should be at least ten input records in the training data. - modify the data a little bit. 3. 3. EN. OLAP Services view filters and regular filters. This tutorial steps through how to switch to Free-form Layout within a Dossier. Devising a logical data model for your business. The data model has two layers: The default view that you first see in the Data Source page canvas is the logical layer of the data source. There are mainly three different types of data models: Conceptual: Conceptual data model defines what should the system contain. Click here to view help for the latest version of this product or search MicroStrategy Community. A column alias specifies both the name of the column to be used in temporary tables and the data type to be used for the fact. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. The User Editor opens. You will gain expertise to do multidimensional data modeling involving hierarchies, levels, measures and schemas. arima () function. The New Grid dialog box opens. The MicroStrategy Analytical Engine prepares data for display in the cross-tabbing step by extracting, from the result table, several normalized tables for each attribute and. The MicroStrategy Project Design Guide provides comprehensive information on planning, creating, and modifying a project in MicroStrategy and covers a wide range of project-related topics, including the following: BI Architecture and the MicroStrategy Platform, provides an introduction to business intelligence architecture and some of the main. Calculating business data: Metrics. Run a training report to create the regression model. MicroStrategy describes its core reporting. Hi Friends,Prince Tech Solutions, is a leading brand of Online and Corporate Training in India. For example, the YR_CATEGORY_SLS table includes the attributes Year and Category, along with facts such as Revenue, Cost, Profit, and so on. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct formatting. Modeling is creating information that describes another set of data. 17K KB7453: When creating a new report in the Design Mode, the ’Schema Objects’ folder does not appear in. project_name ¶ Name of the connected MicroStrategy Project. Now available for feature release—MicroStrategy 10. 710 Introduction to Data Science. Since it enforces MicroStrategy’s user and object security model, you don’t need to worry about setting up separate. It has a simple menu to import data for analysis and export the result of analysis. To Create an Attribute Qualification Using a Dynamic Date Create the Today FilterMicroStrategy Quick Guide - As a Business Intelligence tooling with wide range of capabilities, MicroStrategy has powerfully features that helps to find answers and insights in business information analysis. a governed, scalable, and uniquely adaptable data model that unifies and fuels your. If the New Grid dialog box does not open, in MicroStrategy Developer, from the Tools menu select Developer Preferences. (i. If prompted for file conflicts, select 'Replace'MicroStrategy Project Design Guide. This Microstrat. Click "Configuration" , Advanced, then "Analytical Engine VLDB Settings" under Project Definition-> Details. Upon opening your Project Source for a particular environment, the 'Administration' section provides all the tools. CONTENTS 1. 3) Erwin Data Modeler. Taking advantage of the online resources, tutorials, and support services. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Within each hierarchy, the directLogical data model represents the flow of data in an organization. Note: MicroStrategy Tutorial ships with a many-to-many relationship between Catalog and Item. It also allows for different modeling notations and can be extended by using LUA a scripting language. MicroStrategy Education Overview. 2. For example, on a road map, roads, national parks, political boundaries, and rivers might be considered different layers. A description form. To view the structure of the MicroStrategy Tutorial. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. The menu also provides features to connect to a server if required, view the data sets available, the visualization gallery, and data filtering options, etc. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. This will launch the "Select Data Source" window. It is a Business Intelligence (BI) tool. In the first section of the course,we will be discussing data warehousing and dimensional modeling concepts. 3. Data Modeling Homepage MicroStrategy’s semantic graph capabilities help you keep a structured data model and maintain a single version of the truth across your enterprise in all reporting. Here's how sql server is used on microstrategy developer resumes:Freeform SQL Report Error. It can connect to data warehouses, relational systems, flat files, web. Undo and redo the wrangling operations that are done on a dataset. 7/24/2019 microstrategy_2. PMML is an XML standard that represents data mining models developed and trained by data mining tool. Adding Filters (Page level and Global) Adding Links, text and images. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. To overcome, the proposed method presents a new strategy to automate the multidimensional design of Data Warehouses; this algorithm uses an enterprise schema of an operational database as a starting point to design data warehouse schema. Creating Attributes and Metrics. A report filter sifts the data in your data source to bring back the information that answers exactly what you require. 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. The main objective of building a data lake is to offer an unrefined view of data to data scientists. Following are multiple of that significant features. login_mode ¶ Authentication mode. It is part of Microsoft SQL Server and helps perform analysis using various dimensions. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. Create a second metric identical to the first, but add the predefined Year to Date transformation. Gather information about your user audience. seq. Oracle. Twenty-seventh Edition, version 9. This part of the MicroStrategy tutorial will familiarize you with how to analyze data, how to do quick sort, finding values, searching by row and column, narrowing a search for SQL syntax and more. A logical data model graphically depicts the flow and structure of data in a business environment. Modeling is creating information that describes another set of data. 02:18. MicroStrategy today announced the launch of MicroStrategy AI. Click within the Dataset Objects area to add datasets for the document. After analyzing the dataset with a third-party data mining application, a predictive model is developed and the PMML representation of that model is imported into MicroStrategy. 2. Separating the data model from reports is encouraged for data reusability purposes, but isn't required. The purpose is to organize, scope, and define business concepts and rules. Simultaneous phases provide content. MicroStrategy Project Design Guide. Type the Name for the object and click OK to save your changes. New in MicroStrategy 2021. Expand the Object Templates category, select General, and from the. Analysts must organize data to align with a model so computers can create forecasts and outputs for hypothesis tests. 227-7013 et. In MicroStrategy Web, log in to the Tutorial project. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Browse courses: Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Microstrategy is rapidly increasing in popularity and is being leveraged across. Tutorial | 2009 Views | Oct 4, 2021. Controlling Access to the Database: Connection Mappings. In the Form expression pane, place the cursor to the right of [CUST_LAST_NAME] and type + ", " +. Look for "Tutorial Data" and "Operational Datamart". HBase is an open-source, column-oriented distributed database system in a Hadoop environment. For this, it uses a relational OLAP architecture. Go to MicroStrategy Web. Data Mining and Predictive Analysis You can deploy a wider range of data mining and data modeling tools along with MicroStrategy to augment its native analytical capabilities. 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. After user upgraded the project to MicroStrategy 10. Tutorial Data Model • Dimension Hierarchies: Customer, Geography, Product and Time. Explore the folders and double-click any report or dashboard to run it and see the sample data results. MicroStrategy has to support double-type attribute IDs comparison. In the Public Objects folder, select Metrics. 3. REPOSITORY_MODEL MicroStrategy Tutorial (Direct. In MicroStrategy Developer, choose File > New > Report. 0. In the Metrics folder, open the Sales Metrics folder. You use the authorization token returned during login as the value for X-MSTR-AuthToken. To maintain a competitive advantage, it is critical to have insight into future events and outcomes that challenge key assumptions. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Install and configure MicroStrategy, and connect to data sources. MicroStrategy comes with a sample project called MicroStrategy Tutorial. Dimensional Modeling. You must log in as a user with administrative privileges. The Category attribute of the MicroStrategy Tutorial project shown below is used as an example of how you can modify and view attributes using Architect. On the Freeform Sources tab, select Create Freeform SQL report. Select the Tutorial Data database instance. Query and reporting, tools 2. We would like to show you a description here but the site won’t allow us. Go to Format tab → Text and Forms → Shape → Threshold. It describes how MicroStrategy works with and stores the data you import. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. model = auto. The MicroStrategy dashboard: Become acquainted with the dashboard, which is the. x. The project schema refers to an internal map that MicroStrategy uses to keep track of attribute relationships, fact levels, table sizes, and so on within a project. MicroStrategy is an enterprise business intelligence ( BI) application software vendor. For information on connecting to databases, see Connect to Databases. Watch this video on ‘Microstrategy Full Course Tutorial for Beginners’:restrictions as set forth in subparagraph (c)(1)(ii) of the Rights in Technical Data and Computer Software clause at DFAR 252. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. 2987. Power Query: It can be used to search, access, and transform public and/ or internal data sources. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. The video also covers MicroStrategy web and MicroStrategy web dashboards in detail. EN. Switch from Developer to the modern Workstation to empower your architects with a one-stop shop for all things MicroStrategy. This model has been designated by its producer as a Non-Scoring Model. • It permits you to directly access a database with in. This article explains how to model recursive hierarchies in MicroStrategy. This MicroStrategy tutorial is designed for readers who want to learn the fundamentals of Microstrategy such as how to read, create, write, and modify BI Reports and dashboards using MicroStrategy reporting tools. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. Administrator. Please follow this product guide to MicroStrategy is a vendor of Business Intelligence application software. The example after the procedure shows what happens to report data when the filter is used on a report. Right-click the attribute and select Add to Filter. The Rename/Edit Objects dialog box (DHTML) or panel (HTML) is displayed. x, "Use relational model" is selected by default. This endpoint allows the caller to get the list of projects with the MicroStrategy REST Server. Generally, you build a compound attribute when your logical data model reflects that a compound key relationship is present. 1. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Metadata partition mapping defines data slices by filters, where each slice maps onto a physical partition in the warehouse. x. In the Source area, select a database instance for the data source to access using Query Builder. This means that, while the PMML may contain valuable descriptive information about the model creation process, it does not contain a model worthy of deployment for scoring. Database Design is a collection of processes that facilitate the designing, development, implementation and maintenance of enterprise data management systems. 013 Developer (DVL) 2 2022. If you are working with your own data, rather than Tutorial data, the current date calculation works if the project contains data for the current date. From Enterprise Manager to Configuration Wizard to Architect, find anything and everything you need to know about our Tools in this section. Physical Data Model is the default schema in Erwin format that can be used to generate scripts for creating tables and/or as an initial design for a new data warehouse. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and Microstrategy Office. 55. Reporting remains consistently accurate in OLAP servers as the speed of data sharing does not impede the process. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. MicroStrategy Delivery Engine, MicroStrategy 구독 포털, MicroStrategy Tutorial – Delivery Installation 및 MicroStrategy Tutorial – Delivery Configuration을 사용하려면 MicroStrategy Narrowcast Administrator와. A project is the highest-level intersection of a dataColumn data descriptions and identifiers: Attribute forms. This ensures that the report can be executed in a reasonable amount of time, while also providing enough data to provide relevant market basket analysis of the order information. 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. Database Instance. MicroStrategy applications are then defined entirely in. You can easily copy a threshold to multiple metrics on a. Both partitioning schemes depend on proper treatment of attribute data. It is ready to be used and requires no additional configuration tasks. It can connect to data warehouses, relational systems, flat files, web. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. This business analyst course. In the Source area, select a database instance for the database to access using Freeform SQL. CONTENTS 1. Logical table: A logical representation of a physical table that MicroStrategy uses to generate SQL. This metric definition is shown below:Custom expressions are written so that data can be tested against them, and whatever data qualifies as true when it is inserted into the custom expression is returned in the data result set. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Advanced Data Science with MicroStrategy 2022. HBase can store massive amounts of data from terabytes to petabytes. Second section is on MicroStrategy Desktop and the last part will be on MicroStrategy Web. Next are some the the important face. One is known as a transaction data model setup. Erwin is a data modeling tool that is used to create logical, physical, and conceptual data models. MicroStrategy Project Design Guide. Hyperion Essbase, Microsoft Analysis Services, and other data sources. xIn 2022, architects have everything they need to build and manage the data model in just minutes through Workstation. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. The default Microstrategy Tutorial (Direct) project is simply pointing to the 3 local MS Access databases for the data and metadata. Application Development tools, 3. Clean and Transform data. Platform: Intellipaat. MicroStrategy Quick Guide - As a Business Intelligence tool with wide range concerning capabilities, MicroStrategy has powerful features that helps to detect answers and understandings in trade data analysis. Customers wishing to use Platform Analytics in 11. All Rights Reserved INTRODUCTION This. Second section is on MicroStrategy Desktop and the last part will be on MicroStrategy Web. Description: This Intellipaat MicroStrategy certification training course is meant for an in-depth understanding of the MicroStrategy platform, its architecture, the significance of business intelligence, etc. In the relational database, a compound key is a primary key. A logical data model represents the definition, characteristics, and relationships of data in a technical, conceptual, or business environment. The count function parameters used in the metric should be changed to Distinct Count and a suitable FactID should be selected in order to use the correct fact to calculate the customers. Physical Data Model is the default schema in Erwin format that can be used to generate scripts for creating tables and/or as an initial design for a new data warehouse. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. pdf 1/451MICROSTRATEGYARCHITECT: PROJECTDESIGNESSENTIALSCourse GuideVersion: PRJESS-941-Mar14-Color7/24/2019 microstrategy_2. There are Power BI components are 5 main components released in the market. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. Watch on. Frequently Asked Questions: Teradata Parallel Transporter In MicroStrategy. MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web applications, etc. To build a report using the Report Wizard: To start the Report Wizard. Combined Reports − These reports can show the combination of both the Grid. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. 4 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the softwareWhat is the MicroStrategy Tutorial? The MicroStrategy Tutorial is a MicroStrategy 7 i project (metadata and warehouse are included) and a set of demonstration applications designed to illustrate the rich functionality of the MicroStrategy 7 i platform. x offers data discovery capabilities that allow user to connect to any data source and visualize information using a variety of graphs and charts. Regression analysis using data mining functions is described in. It is a theoretical presentation of data objects and associations among various data objects. MicroStrategy Tutorial Reporting. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Data Mining. This type of logical table maps directly to physical tables in the data warehouse. Gather information about your MicroStrategy project. MicroStrategy Project Design Guide. Users can also utilize historical. Step 3: Modeling. The physical warehouse schema is based on the logical data model, such. In this example, you get the list of projects in the MicroStrategy Tutorial metadata. For more information on how MicroStrategy can access your data sources, see. In the pane on the left, navigate to the attribute with the date data type on which you want to qualify. MicroStrategy’s ability to build a modeled schema has historically been the standard for ensuring a single version of truth across the enterprise. On expanding the button, the following screen opens showing different public. MicroStrategy provides an extensive library of native analytical functions and scoring algorithms, along with an SDK to integrate with 3 rd-party and open source statistical and data mining products. You will be able to: - connect to MicroStrategy Server. CONTENTS 1. Visit the MicroStrategy download site to download the latest supported version of this product. Visit the MicroStrategy download site to download the latest supported version of this product. Data Wrangling. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. This cube has two attributes and two metrics. The MicroStrategy metadata maintains a single list of available columns per table name. Power Pivot: It is used for data modeling for in-memory analytics. Attributes are grouped by hierarchies. The threshold can be selected from list of built-in colors or configured manually. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the report results. Logical Data Model Components. Check Query DetailsThe process of creating a model for the storage of data in a database is termed as data modeling. Microstrategy Tutorial. Products; What's New; HyperIntelligence; Workstation; Cloud Platform; Interact; Documentation Feedback; Idea Exchange; Community Discussions. For more information about the Tutorial, refer to the Basic Reporting Help. URL of the MicroStrategy REST API server. Jobs and TasksMicroStrategy Desktop - The MicroStrategy Desktop environment is very intuitive. The Tutorial is a sample data warehouse and demonstration project you can use to learn about the various features of the MicroStrategy platform. This template uses a single. You use the authorization token returned during login as the value for X-MSTR-AuthToken. The SSAS full form is SQL Server Analysis. Home; Microstrategy Tutorial ; Data Mining Services - Microstrategy; Data Mining Services - Microstrategy. 2) Explain various types of data models. Some of the main features offered by MicroStrategy are Advanced. Opening the login page to gather user for credentials. Intermediate. MicroStrategy is a Business Intelligence (BI) and On-line Analytical Processing (OLAP) software which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files, and Hadoop distributions. Login to MicroStrategy Web, go to Add External Data -> Databases -> Pick Tables and pick the following tables and columns; Click Finish to Import as an In-memory Dataset and save as MTDI01Chapter 1: Defining and analyzing data requirements: Data modeling Chapter 2: Developing and maintaining schema objects Chapter 3: Optimizing the schema. Learn how to build powerful and insightful Dossiers in MicroStrategy with the tutorials below. Diagnostic Analytics. Number of Views1. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Section:1. Create a metric that sums the fact Units Sold. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Click ' Choose files' and select your Excel file or drag and drop the Excel file into the window. Due to the limitation of some WH, e. HyperIntelligence® Smarter, Faster Decisions HyperIntelligence® embeds analytics, suggestions, and actions directly into the applications delivering insights in seconds and zero clicks. Data preparation: Explore how to connect various data sources to MicroStrategy as well as configuring connections and importing data from other BI tools, databases, or spreadsheets. This new addition to its AI/BI platform allows organizations to integrate transformative AI experiences into their applications and products, all based on trusted data. 65K. As such, the upgrade between Enterprise Manager and Platform Analytics is not supported. The retail store sells electronics, books, movies, and music. For details on general project design and data modeling, see the Project Design Guide. Microstrategy web. It provides a way of organizing facts so that they can be analyzed from different business perspectives. IntroductiontoMicroStrategy:EvaluationGuide 7 ©2016,MicroStrategyInc. 7. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. Even without coding skills. Graph Reports − These reports show various graphs created from the data sets. Description: This Intellipaat MicroStrategy certification training course is meant for an in-depth understanding of the MicroStrategy platform, its architecture, the significance of business intelligence, etc. offset is the start point of your response. e. The database designer decides how the data. Platform: Intellipaat. Download and unzip "Tutorial Project Files" from the download site according to the. Explanation: MicroStrategy is a powerful data analytics and business intelligence tool that helps organizations to analyze large amounts of data and make informed business decisions. The metric condition Current year in sample DB is also applied to calculate the data for the current year available in the MicroStrategy Tutorial data. DATA SCIENTIST RESOURCES & TUTORIALS. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. It is known as star schema as its structure resembles a star. In MicroStrategy, there are two different types of hierarchies: System hierarchies are automatically generated when a project is created and are maintained by the. Perform transformation functionality as the editor provides correction suggestions as you go through the data transformation process. 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 datasets, and manage Users/User Groups, Servers, Projects, and more. Creating a filter based on business attribute forms. It wraps MicroStrategy REST APIs into simple workflows, allowing users to connect to their MicroStrategy environment, fetch data from cubes and reports, create new datasets, and add new data to existing datasets. AngularJS is an open-source Model-View-Controller framework that is similar to the JavaScript framework. 4. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. It is particularly relevant when exporting metadata to a target tool which supports two views of the model: a logical view and a physical view. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. What is the MicroStrategy Tutorial? 235 B MICROSTRATEGY TUTORIAL Introduction This appendix provides information on the MicroStrategy Tutorial,… Log in Upload FileAttributes Finally, create all 30 attributes as diagrammed in the MicroStrategy Tutorial logical data model in Appendix A. A database table used to store sales data (revenue, profit, cost, and so on) at different logical levels. EN. Projects generally also contain other. Click “Prepare Data” to enter the Preview window. To effectively use MicroStrategy for data visualization, it's important to have a backup and recovery plan in place. 0 can do so by running the MicroStrategy. 3. It collects and consolidates analytics data from various sources, such as databases and cloud services, which helps organizations gain valuable insights to make efficient business decisions. Select MicroStrategy Tutorial as data source and choose table “LU_MONTH”. MicroStrategy Tutorial : Login user:.