It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. Expand the Public Objects folder, then expand the Reports folder. It can connect to data warehouses, relational systems, flat files, web. This issue articulate Platform Analytics warehouse database is not update to date and Kafka topic folders are empty in MicroStrategy 2021 Update 2 due to statistics feature flag not enabled at project level. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. One or more of the following patents may apply to the product sold herein: U. Now log into MicroStrategy Developer and go under Administration tab. You can download the software from the MicroStrategy download site. Name the DSN Practice_Tutorial_MD_DSN. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. The specific code samples for each of the customization scenarios described in the Web SDK portion of the MSDL are. PDF Version Quick Guide MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To see sample dashboards in Developer. Extract the downloaded files. 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 objects appear in the system layer and are usable across multiple projects. You can support data internationalization in your database by using separate tables and columns to store your translated data. All articles. Go to Administration > Projects > Project Configuration. | Meet. MicroStrategy is a powerful Business Intelligence and Visualization software. On the Freeform Sources tab, in the Source area, select a database instance for the data source to access using Freeform SQL. The Tutorial project includes sample data, such as actual customer names and items purchased. Developer enables you to model applications using an intuitive, graphical interface. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. Installation And Initial Setup. Right click on the text box and choose 'Configure Transaction. Command Manager. This group must have the Web user privilege to be able to use MicroStrategy Web at all, and also other privileges to be able to utilize all of MicroStrategy Web functionalities. In the Database Instance pane, select the check box next to the database instances for the data sources to include in a project. 4 is also now available on our software download site and the MicroStrategy on AWS cloud provisioning console. mstr file, the file is no longer linked to the original data sources and is not updated. This import bridge imports MicroStrategy logical tables as Dimensions. 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. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. Key Highlights of DBMS Tutorial PDF: These online Database Management System notes cover basics to advance topics like DBMS architecture, data model, ER model diagram, relational algebra,. MicroStrategy-Tutorial-Documentation . g. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. To Create a Query Builder Report. Download the files from the MicroStrategy download site. Download Salary Trends. Name your database and click OK. Edit the Connection String. èÿ 4HÈ5ÞNwuÕùªž‡o UçœÁ ° ßÿùä#0r¯uí#@®Û ]• r}ÿç“Ê ¹¾ÿóIå €Óħò @¨·Ä7|> dù5ñ5»ÛÛ÷M Èo‰Oå €,ÿN|* y7ñ©| âO‰¯ÙýÁ¡ï. Implemented drill functionality on the reports using Drill Maps. OVERVIEW Microsoft SQL Server 2016 is now certified as a warehouse with MicroStrategy Secure Enterprise 10. They typically consist of descriptions of dimensions. Create one XQuery database instance for Data Source 2. Aggiornamento di MicroStrategy Desktop. MicroStrategy Installation and Configuration provides comprehensive information on how to install and configure MicroStrategy software, as well as basic maintenance guidelines. Note how no data is returned. Go to 'Project Access' and enable 'Create and edit database logins' which is under 'Administration'. In MicroStrategy Desktop, log in to a project. The Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. To Create a Query Builder Report. Read LearnSelf-Service Analytics with Amica. xxx. These fixes address performance (8), security (5), and stability (24) among other issues. Follow the steps below to set up the Tutorial environment. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. 0, Developer 2000, oracle databases. From the list of document templates, click Blank Document. Practice Project - Tutorial Microstrategy - Free download as PDF File (. 3, Tutorial was deployed with Access database, and with the latest version, the Tutorial and Usher metadata have been bundledMicroStrategy 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 one place. Dossiers. 4. Click Create on any page, point to New Report, and then select Blank Report, which provides a blank template to build your report on. The goal is to derive profitable insights from the data. The New Grid dialog box opens. From an open dossier, tap Share > Download Dossier. Data can be connected through an API, flat file, or database. This reads the settings from the updated DATABASE. 7. 1. exe. Helps you to manipulate the database in a single package. MicroStrategy has a metadata-driven architecture. Heavy load on the database causing statistics logging to fail. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. Design workflows, create content groups, or customize application components with the no-code framework. · How to professionally and effectively. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. For information on connecting to databases, see Connect to Databases. Right-click and edit the database instance you found in the Intelligence Server Configuration. An empty database is created. The modeling tool allows architects to transform a complex enterprise data environment. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. It shows many attributes grouped into separate visualizations. 4. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Familiarize yourself with data science tools, such as Jupyter Notebook and mstrio-py. Installation and Configuration Help. The procedure's output columns are mapped onto MicroStrategy attribute forms and metrics, in the usual way for Freeform SQL reports. While database instances commonly point to a relational database, you. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. DSSerrors. For steps to deploy MicroStrategy Web on specific operating systems or application servers, see the Deploying MicroStrategy Web chapter of the Installation and Configuration Help. Enable the option “Ignore current table name space when reading from the database catalog and update using new table name space. Business Intelligence with MicroStrategy 10 Analytics. A dashboard is made up of multiple visualizations. Click OK and you will see the DB role created with the name of your Data Source. Under Open Database Connection (ODBC) data sources, select the warehouse DSN. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. 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. Log in to the MicroStrategy Tutorial sample project. A solution for this issue is available in current releases. 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. A dossier is an interactive display that you can create to showcase and explore business data. Select Database based. Microstrategy Tutorial. This statement can only be executed in a Windows. MicroStrategy describes its core reporting software as having a "ROLAP" or. The 'Database Name' option allows the MicroStrategy Narrowcast administrator to create the Object Repository or the Subscription Book Repository in any of the databases that exist in the database server pointed to. View changes and push updates to end users in seconds. MicroStrategy’s query and reporting capabilities. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both MicroStrategy Developer and Web. Centralize your team’s learning content alongside MicroStrategy Education courses and certifications. MicroStrategy online training & certification course by Multisoft Virtual Academy is a valuable resource for individuals and corporate teams seeking to harness the power of this robust business. mstr File. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. jar. 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. Once created, the logical view can be used in the same way as any logical table. Accept the license agreement and continue. On the Freeform Sources tab, select Create Query Builder report. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. To update tables using Architect. IsSessionStats-0, Mstr. MicroStrategy2021 November 2023 Copyright©2023byMicroStrategyIncorporated. If installed over previous versions of the product, the folder remains the same. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. For example, the login information for the History List database. We use MicroStrategy Tutorial objects: Create a derived metric Count(Category) with the following definition: Add a filter using Year that will exclude all data: Create another metric NullToZero using Count(Category): Drag Year and NullToZero to a Grid visualization. The upgrade database type window appears. In the Source area, select a database instance for the database to access using Freeform SQL. microstrategy. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. From the drop-down menu, choose the database instance against which the user ID should be verified. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. Locate and run the Setup. Open the MicroStrategy Tutorial project in Developer, go to Schema > MDX Cube Catalog and import an MDX Cube into the project. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Overview of steps: Section 1: Restoring the . Zendesk Connector. In MicroStrategy Developer, choose File > New > Report. Optimize database performance and utilization based on query types, usage patterns, and application design requirements. Click Modify… to edit the Database Connection, as shown below: . 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. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. In addition to building dossiers and HyperIntelligence cards, you can now use Workstation to easily complete a variety of legacy architect and administrative tasks, such as creating attributes and metrics, executing Python scripts from your metadata, and monitoring and managing. The Report Data Mart Setup dialog box opens, as shown below: On the General tab, from the Data mart database instance drop-down list, select a database instance for the data mart table that will be created. This will launch the "Select Data Source" window. 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. mstrio: Simple and Secure Access to MicroStrategy Data . Use Cube Advisor to create Intelligent Cubes: 1. Also, back up the database by using the following commandsThe MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). · Best practices on creating dashboards. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. 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. 8. In addition to the files. MicroStrategy online training & certification course by Multisoft Virtual Academy is a valuable resource for individuals and corporate teams seeking to harness the power of this robust business. In the following example, we will create a dashboard showing some common. Databases can be found in almost all software applications. Learn more about Power BI from this Power BI Tutorial! Integration with Other Tools. 1. Expand the Administration section. We empower. For information on creating a new database login, see Connecting to the Data Warehouse. The following procedure describes how to migrate MicroStrategy Tutorial Project's metadata from Access to SQL Server 2005 in MicroStrategy 9. Choose the Data Source as Microsoft SQL Server. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. Click Blank Report. Click the Continue button. Data Warehouse Tutorial Summary. MicroStrategy provides ETL, data warehousing and data mining for data analysis. 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. Like a well-run hospital, or doctor's office there is always initial information that should be collected for different types of problems. Using Workstation, developers and administrators can build and administer sophisticated enterprise and mobile analytics applications with a fraction of the effort it has traditionally. 4. This import bridge imports MicroStrategy logical tables as Dimensions. Note: An upgraded. Workstation The ultimate analytics powerhouse Start building now MicroStrategy ONE Workstation Centralized hub for app design and deployment Workstation is the only space for analysts and app architects. About sample data and. The New Grid dialog box opens. In the extracted files, locate MicroStrategy. Prima di effettuare l'aggiornamento, vedere la Guida in linea di Desktop per informazioni sulla preparazione all'aggiornamento e le attività da eseguire dopo l'aggiornamento. Expand the Public Objects folder, then expand the Reports folder. Within our MicroStrategy Tutorial project, we will maintain applications and demo’s that showcase a wide range of features and capabilities. Click Blank Report. Update Schema 18. Since MicroStrategy can be such an expensive investment, we highly recommend downloading the trial version while you begin to learn. Whenever users submit an element browse request or a report. Zendesk. If we were to create a connection mapping in the MicroStrategy Tutorial project according to this example, it would look like the diagram below. #MicrostrategyTutorials #MicrostrategyTrainingDo subscribe to VisualPath channel & get. MicroStrategy AI is here. In the Data Source dialog, select Reports. Click the MicroStrategy icon and select Create Report. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize data into multiple. Zendesk Connector. 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. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. In MicroStrategy Web, log in to the Tutorial project. · Best practices on creating dashboards. Introduction to Dossiers. Link a MicroStrategy user to a windows user in MicroStrategy Developer, by going to Authentication - Metadata, as shown below: Go to the MicroStrategy Web Services machine and locate the ProjectSource. This group must have the Web user privilege to be able to use MicroStrategy Web at all, and also other privileges to be able to utilize all of MicroStrategy Web functionalities. For information about how to use MicroStrategy Platform Analytics, see Platform Analytics Help. Solution. A human reader can see from the ApplySimple SQL string that the revenue value will be returned (meaning that the datatype should be Float). In MicroStrategy Developer, choose File > New > Report. x, SQL Server 6. It gives you the leverage of generating real-time reports and monitoring data. UserID/Password for the statistics database got modified. Before you begin, exit all applications which may interfere with the installation process. Expand the Database Instances category, and then select Connection Mapping. Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create filters, prompts and metrics. Schema objects are building block objects; they are. Database Server hosting the Statistics/Enterprise Manager Warehouse database is not running. Right-click on Databases > New Database. In MicroStrategy 9. There are Power BI components are 5 main components released in the market. Step 1) Download MongoDB Community Server. x to 9. As part of this 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, grids and graphs, OLAP services and more. A database table used to uniquely identify attribute elements. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Format – PDF. License Key: Obtained from MicroStrategy account executive. Click "Next". ). Now log into MicroStrategy Developer and go under Administration tab. Select the metadata databases that contain the source project. Without data, the dashboard will not show the user anything. 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 41KB45459: How to migrate the MicroStrategy Tutorial Project warehouse from Microsoft Access to Microsoft SQL Server in Micr…. For example, consider an attribute based on a column named 'TEST COLUMN' in a table named 'GREENPLUM_TEST'. organize, and analyze #Dossiers. MicroStrategy objects appear in the system layer and are usable across multiple projects. Export all of the data from a single dossier to Excel in a matter of seconds. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Log into the machine where you are installing MicroStrategy Desktop. Before you begin, exit all applications which may interfere with the installation process. details on the MicroStrategy Tutorial, see the MicroStrategy Project Design Guide. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Log on to the machine where you are installing MicroStrategy Workstation. 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 (" "). x does not parse the contents of the SQL string and it cannot anticipate differences in database implementations of standard (or. Deploy the ojdbc8. For any Apply function, the attribute form in the arguments should be a single form—not a form group. microstrategy. To start the Express installation. x-10. MicroStrategy Intelligence Server stopped logging statistics. Check out our publicly available live demo environment where you can run reports and documents and dashboards at demo. From the drop-down menu, choose the database instance against which the user ID should be verified. 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. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. PostgreSQL JDBC driver. 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. Workstation cannot be installed on a 32-bit Windows environment. LU_. A solution. Go to Database Instances > Authentication > Metadata. exe or Setup. It is noticed most of the topic folders are empty such as Mstr. MicroStrategy - Architecture. For information about how to use MicroStrategy Platform Analytics, see Platform Analytics Help. Enter the project name as shown below. Wait until the SQL software download is complete. If you have a license for the MultiSource Option, selecting a check box for a database instance also makes the database instance available from the Warehouse Catalog to. This is the password of an administrator user in the. Select Teradata V2R4 and move it to the right using the > button. To resolve this issue, users must execute the steps below: Log into MicroStrategy Desktop as the administrator. Once download is complete open the msi file. MicroStrategy Schema Modeling. Database Server hosting the Statistics/Enterprise Manager Warehouse database is not running. 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. MicroStrategy Tutorial. MicroStrategy Architect opens. Tutorial Documentation. It is important to understand that certain capabilities powering the user workflows might not be supported in Snowflake. 0. Patent Nos. To create a user with standard authentication to use in your DSN creation, expand Security, right-click, and choose New Login. 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. Platform Analytics and Enterprise Manager are both monitoring tools that capture data about MicroStrategy. Choose Presto for Database and choose the Presto Version. As part in this MicroStrategy tutorial yourself will learn how the acquire starting include MicroStrategy reported, how toward start the MicroStrategy Windows, starting which MicroStrategy Web, opening a report, components is an report, row and colums, grids and graphs, OLAP services and more. InstallationPrerequisites 6 Networkrequirements 7 Systemhardwarerequirements 10 Systemsoftwarerequirements 15KB45459: How to migrate the MicroStrategy Tutorial Project warehouse from Microsoft Access to Microsoft SQL Server in Micr…. Click the MicroStrategy icon, and select Create Document. 2987. ” in the Warehouse Catalog Options: After enabling this option, restart the machine where you are using MicroStrategy Developer and add the tables again. Understanding microstrategy vs power bi is very important for concept clarity. Create a report with the year and quarter attributes and the profit metric. Some database-specific object definitions may need to be changed if Tutorial is used on another platform. A database table used to uniquely identify attribute elements. 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. 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. Views 1538. Then check if the Use parameterized queries box is selected. For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. For steps, see Starting MicroStrategy Developer. To start the Report Wizard. In the Source area, select a database instance for the data source to access using Query Builder. Creating a grid report. Project Configuration 2. yaml are backed up by this tool. Do not check the box for "Share this connection with all users". log from the Command Manager machine. Language – English. When the Freeform SQL report is executed in a two-tier connection, the results are the same as running the EXEC statement directly against the warehouse, using the MicroStrategy DB Query Tool or Microsoft. On logging in to MicroStrategy Developer, as a admin we get the Administration option under MicroStrategy. Right-click the project and select Project Configuration. This saves you money and allows you to learn the basics before deciding if you actually want to pay for the full version. 4. Platform Analytics and Enterprise Manager are both monitoring tools that capture data about MicroStrategy. On the Freeform Sources tab, select Create Query Builder report. Introduction to Dossiers. Manually fill in the connection information of the Presto JDBC connection string to connect. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. In Teradata, the Extract function returns the month, day or year from a date field. WINDOWS | LINUX | MAC. - Selection from MicroStrategy Quick Start Guide [Book]How part of this MicroStrategy getting you wants learn how to get started by MicroStrategy reporting, how to initiate the MicroStrategy Desktop, starting the MicroStrategy Net, opening a story, components of a message, row plus columns, grids plus graphs, OLAP services and other. It shows many attributes grouped into separate visualizations. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. Removes an added data mart database instance to a project. To access the MicroStrategy Installation Wizard. Edit the Connection String. jar file to i-server machine. MicroStrategy Installation and Configuration provides comprehensive information on how to install and configure MicroStrategy software, as well as basic maintenance guidelines. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. This will launch the Upsizing Wizard. Go to link and Download MongoDB Community Server. The Project Configuration Editor opens. Expand the Administration section. details on the MicroStrategy Tutorial, see the MicroStrategy Project Design Guide. It has a simple menu to import data for analysis and export the result of analysis. Navigate to the download site and download the Desktop installation files. From the Warehouse Tables pane, you can update all tables for a data source or update individual tables as described below: •. Open up MicroStrategy Enterprise Manager Console and navigate to tools>options and check the 'Log migration SQL' checkbox as shown below: Go to tools>data load options and run a custom time window for the period where data is missing as shown in the image below: The dataload will likely fail with a 'PRIMARY_KEY'. Before you begin exploring the Tutorial schema using Architect, there are a few conventions and fact information that can help you understand the overall Tutorial schema. Starting from 8. Select "Use an existing database" and click "Next". Purchase annual subscription pass. It can connect to data warehouses, relational systems, flat files,. About installing and configuring the sample Tutorial system 16 Installing Narrowcast Server 18 Configuring Narrowcast Server 22 3. In Web, create a new data import database instance. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. A project is the highest-level of intersection of a. Click OK. exe. Visit the Download site now When accessing the new Download site, you are immediately greeted with key components of our latest platform release, along with any updates or additional tooling that. x. . Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. Research, develop, and deploy. In. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. The add-in introduces the ability to import and refresh reports and datasets from MicroStrategy into Microsoft Excel. MicroStrategy - Creating Dashboard. x database using the MicroStrategy ODBC Driver for Greenplum Wire Protocol, MicroStrategy 9. ), and execute Java programs.