After reviewing these features, you can build your own reports and information delivery services using the MicroStrategy Tutorial database. In the Source area, select a database instance for the data source to access using Query Builder. Since MicroStrategy can be such an expensive investment, we highly recommend downloading the trial version while you begin to learn. Select the Tutorial Data database instance. Click OK. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. The metadata resides in a database, the metadata repository, that is separate from your data warehouse. Solution. x database using the MicroStrategy ODBC Driver for Greenplum Wire Protocol, MicroStrategy 9. MicroStrategy has a metadata-driven architecture. sql -tutorial_wh. 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. View the out-of-the-box Platform Analytics Project Dossier>Database Capacity Planning dossier, go to OverviewBefore creating a database instance for a project warehouse, users need to create a Data Source Name (DSN) that points to the database (which holds the project warehouse). Derived metrics have an option to do subtotal from base. In MicroStrategy 9. The same parameter can be viewed by selecting the text "Count" and choosing. For information on creating a new database connection, see Connecting to the Data Warehouse. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Extract the downloaded files. MicroStrategy AI is here. Instructor Office Hours. The system hierarchy is displayed. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. #MicrostrategyTutorials #MicrostrategyTrainingDo subscribe to VisualPath channel & get. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. x. Attribute: Year, Category. This allows end users to share data or view the raw data for further analysis. x to 9. Get an estimated database size . Open the MicroStrategy Tutorial project in Developer, go to Schema > MDX Cube Catalog and import an MDX Cube into the project. Sample URLs for exporting a Report Services document to PDF are shown below. For example, the login information for the History List database. CONTENTS BookOverviewandAdditionalResources vi 1. MicroStrategy. The Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. Centralize your team’s learning content alongside MicroStrategy Education courses and certifications. An empty database is created. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. Go to link and Download MongoDB Community Server. Click Blank Report. On the Freeform Sources tab, select Create Query Builder report. The key features include: Five hierarchies: Customer, Geography, Products, Promotions, and Time. MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Selecting a database instance check box makes that database instance available in the project for standard MicroStrategy reporting, data marts, Query Builder, and Freeform SQL. It also stores other types of objects that allow you to access that information. The MicroStrategy Tutorial project has been tested on a warehouse and metadata in Microsoft Access. Definition. Click the Add Data icon, choose Select Existing Dataset, and add a dataset with at least one attribute and one metric. Installed with MicroStrategy. pd_dump and pg_restore utility can be found in folder C:Program Files (x86)Common FilesMicroStrategyRepositorypgsqlin STEPS: 1. MicroStrategy describes its core reporting software as having a "ROLAP" or. In MicroStrategy Developer, log in to the project to create attribute roles with explicit table aliasing. This will launch the Upsizing Wizard. Facts 16. MicroStrategy provides ETL, data warehousing and data mining for data analysis. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. This statement can only be executed in a Windows. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. For more details, go to Commence ->. txt) or read online for free. The Freeform SQL Editor opens. The objects stored in the metadata are reusable. After duplicating the project, you will then need to edit the Database Connection (DBC) to point to your newly created warehouse from step 1. It can Download and Install MicroStrategy Desktop. Under this database, create two tables product and Inventory. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. SecurityRegion table defines from which region a user is allowed to view data. 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. · How to use all the main visualizations. Go to Database Instances > Authentication > Metadata. The Select Import Options dialog box opens. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. 422. CONTENTS BookOverviewandAdditionalResources vi 1. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Steps. · Best practices on creating dashboards. 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. Select Tutorial Data. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. DOWNLOAD ePAPERIn Developer, create a database instance based on an MDX data source. x, go to the menu Schema -> Duplicate ProjectTo Create a Report from Scratch. To access the Metric Editor: 1. It shows many attributes grouped into separate visualizations. Network problems causing connection failure to the database server. For instance, we run Oracle in our shop, and the database is on a Unix box while we run the I-server on a NT 4. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. g. For information on creating a new database connection, see Connecting to the Data Warehouse. The HistoryListDSN is the name of the ODBC data source in the Database Connections window. Visit the data visualization and data dashboard galleries for inspiration. Data can be connected through an API, flat file, or database. xml file under C:Program filesMicroStrategyWeb Services. A project is the highest-level of intersection of a. Micro Strategy also supports mobile BI. Expand the Public Objects folder, then expand the Reports folder. Purchase annual subscription pass. Exit all Windows applications before beginning the installation process. Download. DSSerrors. 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. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 2 Openingareport 6 Componentsofareport 7 Video Tutorials. Visit the data visualization and data dashboard galleries for inspiration. SUBCAT_ID SUBCAT_ID,MicroStrategy - Configuration Objects. Learn more about Power BI from this Power BI Tutorial! Integration with Other Tools. Using Workstation, developers and administrators can build and administer sophisticated enterprise and mobile analytics applications with a fraction of the effort it has traditionally. Database Overview Introduction of Microstrategy 1. Because the ID of the event associated with the "RW Fast Export PDF" page is "3069", the evt parameter in the URL is set to "3069". Platform Analytics and Enterprise Manager are both monitoring tools that capture data about MicroStrategy. Click the MicroStrategy icon, and select Create Document. Export all of the data from a single dossier to Excel in a matter of seconds. Click the MicroStrategy icon and select Create Report. Click within the Dataset Objects area to add datasets for the document. Have a good. MongoDB is a document-oriented NoSQL database used for high volume data storage. Log in to the project in which you want to create a report. MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Edit the Database Instance in the Database Instance Manager: . The upgrade database type window appears. Log on to the machine where you are installing MicroStrategy Workstation. The Report Data Mart Setup dialog box opens, as shown below: 4. db2 create database SALES. To Create a New Database Connection. This guide gets you started using the Linux and Windows versions of the MicroStrategy platform. The process described here is for MicroStrategy Analytics Desktop installed on Windows, but the approach is similar when using the MicroStrategy Analytics Platform with Hortonworks on non-Windows platforms (Linux, Solaris, HP-UX, AIX). AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43In the Project Source Manager click on 'OK' to exit the window. The following table lists folders and files of interest that are included in the default directory structure after installing Workstation on Windows. A project source is required to run MicroStrategy Command Manager and connect to a metadata repository. 2. MicroStrategy online training provides integrated reporting, analysis, and monitoring software that enables companies to analyze the data stored across their enterprise to make better business decisions. jar file to i-server machine. However, Platform Analytics is a new tool based on the latest technology, and as such, it offers the many advantages over its predecessor. 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 of ampere create, row and column, grids and graphs, OLAP services additionally show. Click within the Dataset Objects area to add datasets for the document. 9. For Oracle 12. 4. Patent Nos. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. In the Source area, select a database instance for the data source to access using Query Builder. 344As part of this MicroStrategy tutorial you becomes learned how to get started with MicroStrategy how, how to start the MicroStrategy Desktop, starting the MicroStrategy Webs, opening a write, components of an report, row and columns, grids and graphs, OLAP services and more. MicroStrategy Intelligence Server stopped logging statistics. To update all tables for a data source, right-click a data source, and select Update. exe. MicroStrategy - Architecture. WINDOWS | LINUX | MAC. In MicroStrategy Web, navigate to any folder page, such as Shared Reports or My Reports. The aim of this is to catalog and expedite the troubleshooting. Microstrategy Tutorial. x, a History List Messages monitor was also introduced for the administrator to track all user's history list messages. The MicroStrategy configuration wizard is used to upgrade the metadata from 8. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. On the Freeform Sources tab, select Create Freeform SQL report. Zendesk Connector. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. MicroStrategy provides Apply functions as a means of handing off these data and RDBMS-specific functions to your database, which results in your database—not. Deploy the ojdbc8. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. To access the dialog in Developer, from the ' Schema' menu, choose ' Export Project Schema'. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. Using the MicroStrategy Tutorial Project, this behavior can be reproduced with the following steps: Create a text box in a document with dynamic text (e. The VLDB. The Project Configuration Editor opens. In the Data Source dialog, select Reports. Download the software from the MicroStrategy download site. txt) or read online for free. x. The steps to perform these configurations are included in Appendix A: Connecting to Databases of the Installation and Configuration Guide. Use MicroStrategy Developer to access the. In the Source area, select a database instance for the data source to access using Query Builder. Product Demos. The Report Editor opens. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. To see sample dashboards in Developer. Preparation before taking Platform Analytics Repository dump: a. Steps to install drivers for your data source are provided in the Installation and Configuration Help. The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. Power Pivot: It is used for data modeling for in-memory analytics. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. MicroStrategy describes its core reporting software as having a "ROLAP" or. Specify the IP address of the SMTP server. Right-click the project and select Project Configuration. Functions in MicroStrategy are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-selected calculations. To Create a Query Builder Report. Download Free PDF. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. REMOVE DBINSTANCE "dbinstance_name" FROM PROJECT "project_name ";where: dbinstance_name is the data mart database instance to be removed from the project, of type string, between double quotes (" "). com” and project “microstrategy tutorial" do action updatewarehouse closesessions updateobjectdeletions begin date "10/22/2015 22:00:00 +0000" to "10/25/2015 22:00:00 +0000" frequency weekly on saturday sunday from 02:00:00 to 06:00:00 every 2 hours enabled in enterprise manager. 574 views · September 16, 2020 04:23 MicroStrategy Training Catalog Introduction to MicroStrategy Education MicroStrategy Education is committed to the success of every MicroStrategy practitioner. Patent Information This product is patented. To log in to a specific project, see Starting MicroStrategy, page 2. Helps you to manipulate the database in a single package. All articles. Manually fill in the connection information of the Presto JDBC connection string to connect. Choose Add Data > Existing Dataset to add data. Access your dossiers and HyperIntelligence cards on your desktop through the MicroStrategy Application. Run both reports after enabling the metric levels log. On logging in to MicroStrategy Developer, as a admin we get the Administration option under MicroStrategy. Double-click the new connection mapping in each column to select the database instance, database connection, database login, and language. x. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Visit the data visualization and data dashboard galleries for inspiration. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. MicroStrategy logical tables do not necessarily represent physical tables. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. S. MicroStrategy Certified Professionals: The connection process to Excel files involves the following steps: To connect to Excel file data, you must first prepare the Excel file as a valid data source and create a data source name for the Excel file. Power Query: It can be used to search, access, and transform public and/ or internal data sources. 0, Developer 2000, oracle databases. UserID/Password for the statistics database got modified. A database table used to uniquely identify attribute elements. This allows end users to share data or view the raw data for further analysis. How to Create a New Database Instance Using the MicroStrategy Web SDK 9. 2987. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. We fixed 157 total defects with Hotfix 8 (10. MySQLPwd. ePAPER READ . 1680 views ·. 621 Advanced Administration for Enterprise Mobility 2021. 1. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. Select a recipient. x logging architecture that is triggered when a database connection is set to use the 'Multi-threaded' database driver mode in the database connection settings as shown in the screenshot below:Installation And Initial Setup. Platform: Udemy Description: Learn the essentials of MicroStrategy 10 through this step-by-step tutorial. Click the MicroStrategy icon and select Create Report. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. In MicroStrategy 2021 Update 2, Platform Analytics warehouse database is not update to date. %PDF-1. When calculating the subtotal at a higher level, it just uses the data retrieved for the lower level directly. Create the Metadata DSN Create a DSN that points to the Practice_Tutorial_MD database you created in the previous step. Name the DSN Practice_Tutorial_MD_DSN. These are discussed below. In the Database Instance pane, select the check box next to the database instances for the data sources to include in a project. Step 3) Accept the End-User License Agreement. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. sql -operationaldm_wh. Expand the Public Objects folder, then expand the Reports folder. In this tutorial we are going to discuss Installation of MicroStrategy. learn how to download the MicroStrategy Mobile SDK through the MicroStrategy Community Product Download. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. Installation And Initial Setup. As parts of save MicroStrategy tutorial you will learn how to get started with MicroStrategy reporting, how to start the MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, components of a report, row and columns, lattices and graphs, OLAP ceremonies and more. PlatformAnalytics. GettingStartedwithMicroStrategyReporting 1 StartingMicroStrategy 2 Openingareport 6 Componentsofareport 7Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. The add-in introduces the ability to import and refresh reports and datasets from MicroStrategy into Microsoft Excel. Choose the Data Source as Microsoft SQL Server. jar. Accept the license agreement and continue. This issue has been identified as a code level issue with MicroStrategy Intelligence Server 10. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Within our MicroStrategy Tutorial project, we will maintain applications and demo’s that showcase a wide range of features and capabilities. MicroStrategy’s query and reporting capabilities. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. The following screen opens up showing the various schema. xxx. Make sure the folder is saved in the XAMPP PHP installation directory as shown above. Edit the Connection String. jar. Within a project, a security filter may be specified for any user. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. pdf. com EN 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ý русский български العربية UnknownAbout installing and configuring the sample Tutorial system 16 Installing Narrowcast Server 18 Configuring Narrowcast Server 22 3. . This guide gets you started using the Linux and Windows versions of the MicroStrategy platform. Click within the Dataset Objects area to add datasets for the document. 3. Accept the End-User License Agreement. javac, jikes, etc. A project is the highest-level of intersection of a. mstr File. Pages – 220+. Download Salary Trends. A dossier is an interactive display that you can create to showcase and explore business data. Click on the New connection button. 6 that will be shipped in newer MicroStrategy versions. The metadata is a central repository, which stores all the objects used by it. xStep 1) Create a source database referred to as SALES. Lists all attributes from a given location path within a project. A dossier is an interactive display that you can create to showcase and explore business data. To create a Freeform SQL report. Choose Add Data > New Data. Request a demo. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43There's a reason we're at the top of the list. 29KB. Click Modify… to edit the Database Login: . The month names do not originally reside in the warehouse tables and the user does not want to manually input the values into the warehouse. Select the Tutorial Data database instance. MicroStrategy describes its core reporting. mstrio: Simple and Secure Access to MicroStrategy Data . By default, the mstr database. Duplicate the MicroStrategy Tutorial Project to your new project source to migrate the metadata to your Linux environmnet. Advanced Metrics, explains level metrics, conditional metrics, transformation. It provides a unified environment for creating and. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Hee-Wei Tan (Inactive) · May 1, 2017 ·. An example is: MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesAd hoc ReportingSortingYearly Sales!i inserts the job priority of the report which is represented as an integer from 0 to 999 (can be used in all Pre/Post statements). In the following example, we will create a dashboard showing some common. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. Name the DSN Practice_Tutorial_MD_DSN. 'New version of Tutorial project running on MySQL database MicroStrategy 10. In MicroStrategy Developer, choose File > New > Report. Navigate to the download site and download the Workstation installation files. In Web, create a new data import database instance. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. View AllFiles. It is noticed most of the topic folders are empty such as Mstr. The latest hotfix for MicroStrategy 10. Platform: Udemy Description: Learn the essentials of MicroStrategy 10 through this step-by-step tutorial. If installed over previous versions of the product, the folder remains the same. To update all tables for a data source, right-click a data source, and select Update. In the MicroStrategy environment, when a user runs a report for the first time, the job is submitted to the database for processing. License Key: Obtained from MicroStrategy account executive. It can connect to data warehouses, relational systems, flat files,. , through real-world examples and practical executions. MicroStrategy tutorial curriculum. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. Subscribe to Dossier 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. 1. Access – LifeTime Download. To simulate Region in element browsing in the MicroStrategy Tutorial project, the counting pass requires a metric defined as follows: Note: <Distinct=True> is normally hidden, but can be displayed using the "Show Function Parameters" option in the View menu of the metric editor. Once the Export Schema dialog box opens, users can select the aspects of the schema they want to export to Microsoft Excel. Developer enables you to model applications using an intuitive, graphical interface. REL_. Beginning with MicroStrategy 2021 Update 4, you can only install an update using a full platform installer on both Windows and Linux. Introduction Of BI tools 4. MicroStrategy Installation and Configuration provides comprehensive information on how to install and configure MicroStrategy software, as well as basic maintenance guidelines. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Currently this issue is tied specifically to using Amazon Athena with a DSN-less connection in MicroStrategy Web 10. The report is displayed in Grid View, as shown below. yaml are backed up by this tool. The messages that were moved to the database in Step 5, can now be seen in this History List Messages monitor as seen below:There are various applications of MicroStrategy. TrademarkInformation. Before you begin, exit all applications which may interfere with the installation process. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). Note that in the left frame of MicroStrategy Desktop users see the new Project Source called 'MS Access shell' Duplicate the original project into the MS Access file In MicroStrategy Desktop 9. MicroStrategy courses can be tailored to developers, analysts, and architects, each focusing on different topics tailored to the respective job roles. In addition to the files. To Create a Query Builder Report. If the New Metric dialog box is displayed, click the Empty Metric. Some database-specific object definitions may need to be changed if Tutorial is used on another platform. The process described here is for MicroStrategy Analytics Desktop installed on Windows, but the approach is similar when using the MicroStrategy Analytics Platform with Hortonworks on non-Windows platforms (Linux, Solaris, HP-UX, AIX). CONTENTS BookOverviewandAdditionalResources 5 1. UserID/Password for the statistics database got modified. In MicroStrategy Web, log in to the Tutorial project. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. Download the Hortonworks Sandbox 2. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. For each project requiring database authentication: Open Project Configuration. Download operating system-specific drivers for Windows and Linux that allow you to connect to a wide range of data sources. You can also select an existing template (see How to Create a Report Based on an Existing Template ). In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. Power View: This component allows you to visualize, analyze, and display data. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. Advanced Apps. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Connecting to Environments in Workstation. Implemented drill functionality on the reports using Drill Maps. 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. In addition to the files listed in the table below, common files needed to run MicroStrategy are placed in the following directories by default: When installed on 64-bit Windows. Because part about this MicroStrategy tutorial you will learn how at get started with MicroStrategy reporting, how in start the MicroStrategy Desktop, starting an MicroStrategy Web, opening ampere report, components of a report, row and columns, grids and graphs, OLAP services additionally more. You can support data internationalization in your database by using separate tables and columns to store your translated data. 0, in addition. eBook Preview – First Chapter FREE. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. MicroStrategy Tutorial. Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Products AI / BI Platform AI Apps Multi-Cloud Dossier Library Workstation HyperIntelligence Embedded Analytics Innovation Futures Solutions Roles IT Leaders. 7. Data Warehouse Tutorial Summary. LU_. To ensure the continued security and stability of the MicroStrategy suite, MicroStrategy Repository upgrades PostgreSQL to version 14. PostgreSQL JDBC driver. However, if the results of that report are cached, the results can be returned immediately without having to wait for the database to process the job the next time the report is run. mdb The database doesn't need to be on the I-Server, although the I-server needs to be able to see the machine the database is on. Chapter 1: Understanding Big Data fundamentals. Databases can be found in almost all software applications. 0/6. For those coming from. ). Sending and Receiving Services 36 Evaluating Narrowcast Features 37 About services 37 About the MicroStrategy Tutorial -Delivery project 39 Getting started with the Narrowcast evaluation 39 Sending sample services 41The 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.