This communicates to the various data sources, and runs the reports and distributes to MSTR Desktop and Web users. We provide high earning skills MicroStrategy and live project. Building a Dossier Video Tutorials. The procedure will be illustrated using the MicroStrategy Tutorial project:. Video Tutorial - Installing a Custom Visualization for use on MicroStrategy Dashboards. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. xml. The information in a dataset can include MicroStrategy objects such as attributes, custom groups, consolidations, and metrics. This video demonstrates how to import MicroStrategy data into the Jupyter Notebook and RStudio. x. To start MicroStrategy Web. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. Consider an example where the administrator would like to deny access to the MicroStrategy Tutorial project for the 'Test' user from the. Downloading and Installing MicroStrategy Workstation Video Tutorials. 2987. Here you can also check the connector URL. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. x, connect to Project – MicroStrategy Tutorial. The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. The default Microstrategy Tutorial (Direct) project is simply pointing to the 3 local MS Access. Double-click the CUST_LAST_NAME column to add it to the Form expression pane on the right. MicroStrategy Tutorial Reporting. Click Next and select the project wanting to. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. After pressing the next button the following page will be displayed. Installing MicroStrategy is an easy process. To access a project locally on the Web Server without Internet access, a TCP/IP loopback address must be entered. the installation of MicroStrategy Desktop. In this article, we will be discussing how to. txt file. Where <Path> is the directory where the setup. Includes this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, How until install he, history, architecture, characteristics, advantages, & applications. This video demonstrates how to import MicroStrategy data into the Jupyter Notebook and RStudio. 2. 2. These two projects are installed and configured automatically. From the Schema menu, select Create New Project. 8. Data Warehouse Tutorial Summary. This chapter explains the various possibilities for performing fully automated and unattended installations within thAnalytics Modules: Installation and Porting Guide - MicroStrategyGo to Administration > Projects > Project Configuration. select_project(project_id: str | None = None, project_name: str | None = None) → None ¶. By default, this file is located under: For ASP: C:Program FilesMicroStrategyWeb Servicesprojectsources. Your First PHP project! 👉 Lesson 1. MicroStrategy Installation and Configuration provides comprehensive information on how to install and configure MicroStrategy software, as well as basic maintenance guidelines. From the list of document templates, click Blank Document. 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. Users then see the Connect to MicroStrategy window. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom. Click Yes. In MicroStrategy Web, log in to the Tutorial project. It can connect to data warehouses, relational systems, flat files, web. Move the "ActianVW20. Basically, this option will install two sample projects: MicroStrategy Tutorial and Human Resources Analysis Module. Type the following command in the Windows command line: <Path> setup. Exploring Sample Dossiers in Library. 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). Reports. Save and run the report. Command Manager. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on. ) ,. Implementing cache demo using node-cache. The primary and default DB instance(s) of the project is/are not added to the package as the object dependencies in MicroStrategy Object Manager 9. Here you can also check the connector URL. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects them have permissions. This book shows you how to implement Business Intelligence (BI) with MicroStrategy. This allows enterprise BI developers and administrators to build and administer sophisticated enterprise and mobile analytics applications, at a fraction of the effort it traditionally takes. If MicroStrategy Platform Analytics was. 最新の日本語版が提供されている場合. Click the MicroStrategy connector. The MicroStrategy Tutorial project has been tested on a warehouse and metadata in Microsoft Access. Follow the steps below to set up the Tutorial environment. Code Samples. There's a reason we're at the top of the list. I download latest MySQL-J Connector version 8. Step 2) In the Insert Panel. 👉 Lesson 2. For steps to install MicroStrategy Developer, see the Installation and Configuration Guide. Right-click the Customer attribute and select New Attribute form. Navigate to the download site and download the Workstation installation files. Advanced Apps. The following SDK sample code demonstrates how to delete a user and its profile using MicroStrategy Java Web SDK. Notice that Windows Authentication is now enabled for login to the MicroStrategy Tutorial project. Jenkins Tutorial Summary. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. He then explains how to download custom visualizations from the MicroStrategy Community and make them. Configuring MicroStrategy Using Command Line Tools: MicroStrategy tools are provided in command line mode on Linux so that you can. 2048001 - executeRWDocument. Connecting to Environments in Workstation. Follow these steps to reproduce the issue in a MicroStrategy Tutorial Project. Replace the pgWhPasswd entry with the encrypted key. For installing the missing package, run the below command: yum install <missing package>Follow the steps below to create the Sum of Last and Last Quarter subtotals in the MicroStrategy Tutorial project: Create a custom subtotal with the formula 'Last(x) {@}' as shown below: Save this subtotal as 'Last(x). 3 or highermicrostrategy. For UNIX and Linux installations, this guide assumes a basic understanding of how to use UNIX and Linux either from a UNIX/Linux server or by using a viewer on a PC. Code Samples. Click on the Load button, as shown below: 5. Step 1. Basically, this option will install two sample projects: MicroStrategy Tutorial and Human Resources Analysis Module. Click the MicroStrategy connector. For steps, see Starting MicroStrategy Developer. U. 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 software MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Extract the downloaded files. THIRD PARTY SOFTWARE INSTALLATION WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of. Click any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Create the respective DSN's in the Intelligence Server machines . Open a dossier. First, select Node type ‘Casandra Node’. Now open a MicroStrategy Office application, such as Excel, and click on the MicroStrategy button. Before we start you will either need to create a new Dossier or use an existing one. Click the project to log in to. Start the installer and select Upgrade to upgrade your local MicroStrategy version to 2021 Update 10. create. The image below shows the default projects that appear if all default installation options were accepted during MicroStrategy installation. The same is applied when deleting a user programmatically via MicroStrategy Web SDK. If an active connection is detected, the session is renewed. There's a reason we're at the top of the list. MicroStrategy Workstation is a powerful tool that lets y. js install button to start installing on Windows. Installing and configuring Enterprise Manager. This online guide covers the installation and configuration of various MicroStrategy components, such as Workstation, Library, REST Server, and Collaboration Server. Learn how to download and install the MicroStrategy Intelligent Enterprise Platform, MicroStrategy's suite of tools that lets you control and derive insights. RedirectingThe following sections provide the location of additional examples, list prerequisites for using this book, and describe the user roles the information in this book was designed for. MicroStrategy 7 The MicroStrategy Desktop environment is very intuitive. Command Manager. Make sure not to duplicate users and groups, and use the destination ACLs. Choose Add Data > New Data. In the next screen, click the Node. 15. Step 8) Complete the installation Click the Finish button to complete the installation. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. This eBook covers advance topics like Data Marts, Data Lakes, Schemas amongst others. Subscribe. Visualpath. 2. Workstation makes it easy to build compelling visualizations and interactive dossiers in a matter of minutes and then easily share those dossiers with others. Download the files from the MicroStrategy download site. 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). MicroStrategy Backup Preparations. Better to use a larger VM for quicker installation. Before you begin, exit all applications which may interfere with the installation process. Click Connect. With a few lines of code, data scientists can extract data from cubes and reports and publish entirely new datasets for consumption by other analysts. MicroStrategy provides a step-by-step guide to downloading and installing the tutorial project on your system. In this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, How to installing e, history, architektur, features, advantages, & applications. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and so on. INDOWS Introduction. Instructions on how to install MicroStrategy Desktop on a Windows or Mac machine. Conceptually, a project in MicroStrategy is the environment in which all related reporting is done. Syllabus- Here is the link. Log in to the MicroStrategy Tutorial sample project. Download your preferred platform version into the RDP. Go to Environments located under Manage on the left side. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Place the installation files directly on the machine you intend to install MicroStrategy on; Ensure that you have a License Key for the version of MicroStrategy you are trying to install; If installing MicroStrategy Office ensure that Microsoft Office is installed prior to running the MicroStrategy Installer; MicroStrategy Office InstallationSOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. Note: it is NOT recommended to install mstrio-py in an Anaconda environment. Log on to the machine where you are installing one or more MicroStrategy products. Add the attribute Subcategory and metric Revenue to the report template. They consist of the following: Project metadata configured to work with the demonstration warehouse that contains the projects. NSTALLATION ON. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. In this tutorial, we will consider only the Windows version. In the Form expression pane, place the cursor to the right of [CUST_LAST_NAME] and type + ", " +. First, you need to download the MicroStrategy free personal edition from the MicroStrategy Desktop and key in your details to register. The steps to configure this access are below. In this tutorial, we will consider only the Windows version. You choose , navigate to Shared Reports -> Subject Areas -> Customer Analysis -> . It is also available as part of the installation package in the default RScripts folder as a file called SeasonalForecasting. mstrio: Simple and Secure Access to MicroStrategy Data. Browse online MicroStrategy courses. These two projects are installed and configured. Sure, currently just exploring the mstrio. CakePHP Tutorial for Beginners — What is, Why Use & Features. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. In this online Jenkins tutorial for beginners, you will learn Jenkins basics like how to install Jenkins, create jobs, pipelines, integrate with GitHub, Selenium, and other tools. 1. Using the example below as a guide, follow the steps to access the project: NOTE: MicroStrategy Intelligence Server and Metadata must be available on the machine. (To follow the examples in this guide, click MicroStrategy Tutorial . MicroStrategy Workstation is a powerful tool that lets you administer and control both projects and environments, providing tools for data discovery and visualization. A. Procedures for installing MicroStrategy on a Linux platformIn this MicroStrategy (MSTR) tutorial, we will learn What is MicroStrategy, Select to install it, our, architecture, features, advantages, & applications. The menu also provides. Connect to your Microstrategy Tutorial (Direct) project source, right click on the Microstrategy Tutorial project, and click "Duplicate Project". Enter your API Server and select your authentication mode and enter your credentials. It also provides many examples using the sample Tutorial project that comes with MicroStrategy. GParted BigQuery Software Development Apache Kafka. - modify the data a little bit. 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. R. For UNIX and Linux installations, this guide assumes a basic understanding of how to use UNIX and Linux either from a UNIX/Linux server or by using a viewer on a PC. It has a simple menu to import data for analysis and export the result of analysis. Learn the essientials of MicroStrategy Architect with this step by step crash course tutorial! In this video I cover lookup tables, fact tables, logical tabl. Leadership. Download the MicroStrategy Tutorial Project files from the MicroStrategy Download site under the section MicroStrategy 10. In this MicroStrategy (MSTR) tutorial, are become students What is MicroStrategy, Select to install it, history, architecture, features, advantages, & applications. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single, unified Web interface. 2. Workstation is the only space for analysts and app architects to build and manage content of all types. x. MicroStrategy Tutorial - Table of Content What is MicroStrategy? Features of MicroStrategy; Installation And Initial Setup; Importing Data; Transforming Data. Select the desired Project Source (Data Source) and click on Next, as shown below: Upon clicking Next, the following window shows the. In addition, a 2-Tier Project Source is also created and accessible from MicroStrategy. Request a demo. Open a new or existing dossier. Below is the R script for the forecasting analytic. After watching this 3 minutes video you will be able to test mstrio library (based on REST API) yourself. mstrio provides a high-level interface for Python and R and is designed to give data scientists and developers simple and secure access to MicroStrategy data. PySpark Tutorial for Beginners — Learn with EXAMPLES. In DataStage, projects are a method for organizing your data. Last updated: Apr 12, 2019. The Create New Form Expression dialog box opens. Make sure that you unzip (extract) the file. and your exclusive remedy, shall not exceed, at the option of MicroStrategy, Inc. When MicroStrategy is installed, there is the option to install MicroStrategy Analytics Modules. InstallationandConfigurationGuide 9 ©2018,MicroStrategyInc. A project source is required to run MicroStrategy Command Manager and connect to a metadata repository. It is designed to help developers build data-driven client applications quickly and easily. Design workflows, create content groups, or customize application components with the no-code framework. Please contact rgs4554@gmail. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). x, on Web Administrator page, it is possible to specify the Path to MicroStrategy Office Installation, as shown below: In certain situation, when user tries to clear this text box or set "Lang_xxxx/officeinstall. Related versions: 11. I. Assign a friendly environment name. In this Hadoop for beginners tutorial, you will learn the Hadoop basics like introduction, architecture, installation, etc. These two projects are installed and configured automatically. Assign a friendly environment name. MicroStrategy provides ETL, data warehousing and data mining for data analysis. 3 or higher microstrategy. x, the Administrator must link MicroStrategy users to a Windows user account. x. Below is a high-level overview of the steps to install and configure Enterprise Manager for your MicroStrategy system. Hi Friends,Prince Tech Solutions, is a leading brand of Online and Corporate Training in India. Authenticates the user and creates a new connection with the Intelligence Server. MicroStrategy provides a step-by-step guide to downloading and installing the tutorial project on your system. To view and edit the parents and children of an attribute. Click Enter. x server. Open the PAConsumerConfig. This will basically copy over an access Metadata and a 2-tier project source already created in Desktop, so you can browse around and take a look at a pre-built environment. 1. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. MicroStrategy provides a set of packaged analytic components built using the MicroStrategy platform. IBM’s Cognos BI is a web-based reporting and analytics tool. • Open a new or existing dossier. ” in the Help menu of your software. Open the MicroStrategy Configuration Wizard. xml file is used. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (following examples use the MicroStrategy Tutorial project for illustration purposes. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Also you will learn how to get data from Excel, create various types of visualization available and convey the right message . Friends,We provide industry standard online training on MicroStrategy Development, Administration and live project development with hand-holding support of e. Copy the WAR file to the Tomcatwebapps folder. To access the Tutorial project, follow the steps in the section above to log in to MicroStrategy Web or MicroStrategy Developer. The workflow for this sample is shown below: POST /auth/login. This provides data scientists access to trusted, operational. xml. objects. In this MicroStrategy (MSTR) tutorial, we will learned Something is MicroStrategy, Like to install it, history, architektonischer, features, pros, & applications. and some advanced Apache Hadoop concepts like MapReduce, Sqoop, Flume, Pig, Oozie, etc. Select a dataset. This guide gets you started using the Linux and Windows versions of the MicroStrategy platform. Select a dataset. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other. The. select_project(project_id: str | None = None, project_name: str | None = None) → None ¶. It has a simple menu to import data for analysis and export the result of analysis. 7K views 3 weeks ago #dashboard #microstrategy #analytics Download the project file here: ―. Notice that the DB instance 'Tutorial Data' is used, as shown below:5/5 videos | 17M 9S total runtime. To connect MicroStrategy Web Services 9. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. The MicroStrategy Analytics Module project source includes the MicroStrategy Tutorial project. Windows Installer 3. About Press Copyright Contact us Creators Advertise Developers Terms Privacy Policy & Safety How YouTube works Test new features NFL Sunday Ticket Press Copyright. (To follow the examples in this guide, click MicroStrategy Tutorial . Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. See screenshot below for an example. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. It is ready to. In the Project Source Name field, type a name for the project source. Specify the port number where the SMTP server receives incoming e-mail. Deploy the ojdbc8. From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a User Name and Password. xml. 4. Helps you to manipulate the database in a single package. Type cmd in the Open drop-down list and click OK. To view and edit the parents and children of an attribute. In the next screen, click the Node. Go to the MicroStrategy website and download the MicroStrategy installer for your operating system. Open the Microsoft Access database selected in Step 3 select Database Tools > SQL Server as shown below. This chapter addresses the processes necessary to configure an installed MicroStrategy suite of products using the Configuration Wizard. Published: Sep 26, 2018. <MicroStrategy Install Path> >\Intelligence Server\Cube\<サーバ定義名>\ Server_<サーバな>_P<TutorialプロジェクトのID> ※<TutorialプロジェクトのID> は「プロジェクト構成」より確認できます。 13. Click Yes to open the command prompt with administrator privileges. Now, we need to move the metadata of the Microstrategy Tutorial (Direct) into your existing 3-tier's Metadata. MicroStrategy Backup Preparations. Note: to log into Library and use mstrio user needs to have UseLibrary privilege. ) The projects in the image below include MicroStrategy Tutorial and My First Project, as well as other sample projects. Using the URL API, there are three ways for MicroStrategy Web to obtain the information needed to authenticate a user. 3. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Where <Path> is the directory where the setup. . Specify the port number where the SMTP server receives incoming e-mail. You also provide your projects in Spanish and German. 4001 - runReport Executes the report specified by either the reportID or reportName argument. Click within the Dataset Objects area to add datasets for the document. Installation and Configuration Guide Version 10 Document Number: 09301000 Version 10 To ensure that you are using the documentation that corresponds to the software you are licensed to use, compare this version number with the software version shown in “About MicroStrategy. Download and Install MicroStrategy Desktop. MicroStrategy for Jupyter is contained within mstrio-py package and is available after. Navigate to the download site and download the Desktop installation files. You choose , navigate to Shared Reports -> Subject Areas -> Customer Analysis -> . Click within the Dataset Objects area to add datasets for the document. Investor Relations. Right-click the Customer attribute and select New Attribute form. Both the data warehouse and the metadata databases reside on Microsoft Access. #MicrostrategyTutorials #MicrostrategyTrainingDo subscribe to VisualPath channel & get. x. tips. MicroStrategy provides a set of packaged analytic components built using the MicroStrategy platform. If you are using an external dataset, you would choose and import the data you are using. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. The Platform Analytics project comes with three Intelligence Cubes that support nine Dossiers that can be run right after installation to check if everything is functioning properly. 1. PHP MVC Framework Tutorial — CodeIgniter Example. MicroStrategy for Jupyter is an extension for Jupyter Notebook which provides a graphical user interface for mstrio-py methods with the help of which user can perform all of the import and export actions without writing a single line of code manually. The theme is an Electronics, Books, Movies and Music store. In this brief video tutorial, Josef Timchenko of our Customer Education team explains how to make a custom or third-party visualization available for use in both MicroStrategy Web and MicroStrategy Desktop. GameStop Moderna Pfizer Johnson & Johnson AstraZeneca Walgreens Best Buy Novavax SpaceX Tesla. INSERT Script. Starting MicroStrategy Web: I can access MicroStrategy Web by any computer that can run a browser. We then start by referencing the MicroStrategy Javascript library that supports embedding which comes with the install. Took 3 hours to complete my installation. xml in a text editor and make a copy of the text between. x even 'Show System Objects' option is selected, as shown below: NOTE: Run the report, and check SQL View. Log on to the machine where you are installing one or more MicroStrategy products. Specify the IP address of the SMTP server. Verify the components you want to upgrade and click Next . The user profile must be deleted separately. MicroStrategy Workstation radically simplifies enterprise analytics by bringing all key workflows into a single user experience. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. 2. If no project sources are defined, then the Configuration Wizard opens. 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. MicroStrategy Analytics Modules. When a Connection object is created the user will be automatically logged-in. To start MicroStrategy Web: 1 In ampere my, enter the URL von your company’s MicroStrategy Web place. This Big Data Analytics tutorial is geared to make you a Hadoop Expert. Step 1) In the object tree. xlsx as an example data set. 3 : From the Hierarchy View, in the Hierarchies drop-down list, select System Hierarchy. This MySQL tutorial for beginners covers all concepts like MySQL basics, normalization, and MySQL Workbench installation. To explore this sample project data, in the Folder List expand MicroStrategy Tutorial, then expand Public Objects, then expand Reports. Create a metric with the ApplySimple statement below as its definition and name it. Click the Builder tab. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. This new license key can be easily attained from the MicroStrategy download site . 2. yaml file: Encrypt the pgWhPasswd using the Platform Analytics tool. Visit the data visualization and data dashboard galleries for inspiration. This will launch the Upsizing Wizard. Next. The articles and documentation referenced in this article can help provide users with the tools needed to setup and configure Enterprise Manager and to address issues encountered during the statistics logging and. •Pentaho is a Business Intelligence tool which provides a wide range of business intelligence solutions to the customers. (Metadata and Warehouse are included) • It gets installed during standard installation. Learn to enable seamless login between MicroStrategy Web and Library. Go. On your computer, tablet or phone, online courses make learning flexible to fit your busy life. MicroStrategy Tutorial teaches you Step-by-Step from the basics to more advanced topics. In save MicroStrategy (MSTR) tutorial, ourselves will learn Which is MicroStrategy, What to position it, show, architecture, visage, advantages, & applications. The table below shows the URL parameters used to execute a document using the URL API. Restoring with MicroStrategy Backup allows you to create mirror environments to test new projects, create disaster recovery environments, migrate current MicroStrategy deployment to the cloud, and more in a same or newer MicroStrategy version. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on. The object's editor or wizard opens. Learn why MicroStrategy Workstation is such a useful tool and how you can use it to manage and operate your MicroStrategy ecosystem in one place. The utility is found under Program FilesCommon FilesMicroStrategy. Copy the WAR file to the Tomcat\webapps folder. To import data from a specific database, select the corresponding logo (Amazon Redshift, Apache Cassandra, Cloudera Hive, Google. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. the user needs to install Microstrategy Architect 9. Extract the downloaded files. Using this data, you can forecast potential sales for the upcoming years.