Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. The same parameter can be viewed by selecting the text "Count" and choosing. Note: An upgraded. 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. The Tutorial project includes sample data, such as actual customer names and items purchased. REL_. MicroStrategy2021 November 2023 Copyright©2023byMicroStrategyIncorporated. Data Warehouse Tutorial Summary. Click Modify. Here, we will take the Microsoft Access databases example of Split from ‘Contact_Form_Split’ created above. Below are the common database workflows MicroStrategy customers face when dealing withThe following code samples are provided with MicroStrategy Web, as additional assistance to help you get started with various types of customization tasks. Multi-Metric KPI and the Comparison KPI Visualizations. To see sample dashboards in Developer. Select Pick Tables to select single or multiple tables to import data from. With a project open in Architect, select the Project Tables View. Allrightsreserved. MicroStrategy describes its core reporting software as having a "ROLAP" or. 2. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. We will learn later in Chapter 7, Administration – Maintaining and Monitoring Your Project. Then check if the Use parameterized queries box is selected. In MicroStrategy Developer, open the Basic Report from the MicroStrategy Tutorial. After reviewing these features, you can build your own reports and information delivery services using the MicroStrategy Tutorial database. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. A project is the highest-level of intersection of a. All articles. As part of aforementioned MicroStrategy teaching you be learn how to get started with MicroStrategy reporting, how to start the MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, key of a report, rows and column, lattice and graphs, OLAP services also more. Expand the Public Objects folder, then expand the Reports folder. To Create a Query Builder Report. Within a project, a security filter may be specified for any user. 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. Once installation is completed successfully, below screen will appear. Visit the data visualization and data dashboard galleries for inspiration. From the drop-down menu, choose the database instance against which the user ID should be verified. MicroStrategy Tutorial (Direct) Advance Features 1. Log on to the machine where you are installing MicroStrategy Workstation. exe. Select the Tutorial Data database instance. The fuel for business dashboards is data, so each one needs to have one or more data sources. For information on creating a new database connection, see Connecting to the Data Warehouse. S. Language – English. Exercise – creating a dashboard In this exercise, you will create a self-service dashboard using the imported data from the (TutorialData. Exploring Sample Dossiers in Library. In the Database Instance pane, select the check box next to the database instances for the data sources to include in a project. A. MicroStrategy Workstation. CONTENTS BookOverviewandAdditionalResources 5 1. Click the MicroStrategy icon, and select Create Document. Right-click the project and select Project Configuration. 2 Right-click the MicroStrategy Tutorial project and. LU_. Zendesk Connector. 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. 1680 views ·. '{Category@DESC}') that would be retrieving the data from an empty table in your database. Overview 1. Now log into MicroStrategy Developer and go under Administration tab. To Create a Query Builder Report. Like a well-run hospital, or doctor's office there is always initial information that should be collected for different types of problems. Enable users to interact with personalized chat for further product discovery. With MicroStrategy Developer Library, learn how to download the MicroStrategy Mobile SDK through the MicroStrategy Community Product Download page. x. When calculating the subtotal at a higher level, it just uses the data retrieved for the lower level directly. Create one XQuery database instance for Data Source 2. 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. The following screenshot displays this interface: If the metadata resides on a Microsoft Access database, the following additional steps need to be performed before the upgrade: Open the Microsoft Access database selected in Step 3 select Database Tools > SQL Server as shown below. Follow the steps below to set up the Tutorial environment. Read the latest magazines about MicroStrategy-Tutorial-Documentation and discover magazines on Yumpu. To start the Express installation. 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 Web, create a new data import database instance. BUSINESS USER VIDEOS & TUTORIALS. MicroStrategy Intelligence Server stopped logging statistics. Select "Use an existing database" and click "Next". 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. 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. Verify whether the option Use network login id (Windows authentication) is selected:The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. Tables 17. This is the username of an administrator user in the database. exe file. Create the Metadata DSN Create a DSN that points to the Practice_Tutorial_MD database you created in the previous step. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click. A database table used to uniquely identify attribute elements. CONTENTS 1. Download. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. MicroStrategy Workstation is our unified product built to radically simplify enterprise analytics by bringing all key workflows into a single user experience. Wherever you can define an expression, you can use a function. Visit the data visualization and data dashboard galleries for inspiration. In MicroStrategy Web, navigate to any folder page, such as Shared Reports or My Reports. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. Before you begin, exit all applications which may interfere with the installation process. Expand the Administration section. For information about how to use MicroStrategy Platform Analytics, see Platform Analytics Help. A Microstrategy course may cover the following. We will need the following logs to start the troubleshooting process: cmdmgr. Right-click on Databases > New Database. Configuration objects include objects such as users, database instances, database login IDs, and schedules. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. All articles. In MicroStrategy Desktop, from the File menu, select New, and then select Metric. pdf. Under Database Login, select the default Database Login and click 'OK'. 1. Reports. Command Manager. Expand the Administration section. · Best practices on creating dashboards. For example, the login information for the History List database. Name your database and click OK. In the extracted files, locate MicroStrategy. The utility is found under Program FilesCommon FilesMicroStrategy. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. List Attributes statement. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. Traditionally, you use the MicroStrategy Engine to generate SQL to run against one specific relational database to get a desired report. Edit your DB instance from Developer path Administrator->Configuration Managers->Database Instances, or the DB role from Web data import page Add External Data->Oracle->Any Select Import Options. Create a new dossier, and add data. Create the SQL statement for the database maintenance task. Custom Groups 15. The retail store sells electronics, books, movies, and music. Visit the data visualization and data dashboard galleries for inspiration. 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. On the Customer Information page, complete the following fields:This tutorial steps through the various capabilities and pages within the Administration portion of a MicroStrategy Project Source. Navigate to the download site and download the Desktop installation files. The various options are as follows:Create a new table "photo_upload" in Tutorial warehouse database (the default location: C:Program FilesMicroStrategyTutorial ReportingTUTORIAL_DATA_7200. To see sample dashboards in Developer. 7. Download the Hortonworks Sandbox 2. 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. It can connect to data warehouses, relational systems, flat files,. Log in to the MicroStrategy Tutorial sample project. 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. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. LU_. The programming tools provided by the MicroStrategy SDK— including programming. A dashboard is made up of multiple visualizations. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. UserID/Password for the statistics database got modified. Installation and Configuration Help. sql Restore the SQL files to the empty databases created in step 4. Syllabus- Here is the link. Only the database names listed in DBAdminConfig. MicroStrategy Community includes technical notes that document the history of changes to. MicroStrategy logical tables do not necessarily represent physical tables. To update all tables for a data source, right-click a data source, and select Update. pdf), Text File (. yaml. 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 (" "). 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. 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. MicroStrategy - Creating Dashboard. Navigate to the download site and download the Desktop installation files. It also stores other types of objects that allow you to access that information. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. A project is the highest-level of intersection of a. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. Open MicroStrategy Web and click New Dossier. details on the MicroStrategy Tutorial, see the MicroStrategy Project Design Guide. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. Remove DBInstance statement. From the drop-down menu, choose the database instance against which the user ID should be verified. MicroStrategy objects appear in the system layer and are usable across multiple projects. In MicroStrategy Developer, choose File > New > Report. Network problems causing connection failure to the database server. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. It provides a unified environment for creating and. For a description of each area or pane of the MicroStrategy Web Report Editor and Design Mode, see MicroStrategy Web Report Editor interface. In general, ApplySimple can be used to create the following objects: Attribute form. 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 one place. MicroStrategy. All articles. Lists all attributes from a given location path within a project. Type any login and password for this database login since the credentials returned from Data Source 1 are actually used. Create a second report with the year and quarter attributes and the revenue metric. old box. Once data flows into the interface, the dashboard will come to life. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. This appendix provides information on the MicroStrategy Tutorial, including the data model and physical warehouse schema. Z:Program filesMicrostrategyTutorialReportingTutorial_Data_7200. For information on connecting to databases, see Connect to Databases. The automatic refresh and smart download features allow you to open and explore content both online and offline with instant response times, even for your most complicated dossiers. Select the desired Project Source (Data Source) and click on Next, as shown below: Upon clicking Next, the following window shows the versions of the projects found in the metadata. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. Select the Tutorial Data database instance. 422. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. 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. pdf), Text File (. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. By default, the mstr database. Click OK and you will see the DB role created with the name of your Data Source. For more details, go to Commence ->. MicroStrategy Application. Platform: Cross-platform. Select SQL Server authentication to assign a password to your user. Go to Administration > Projects > Project Configuration. They typically consist of descriptions of dimensions. Creating a grid report. To start the Report Wizard. Development products to build business abstraction objects in the metadata: MicroStrategy Architect and Desktop. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. When the IF() operator is used, a conditional statement will be generated as part of the SQL to be executed on the database as long as the calculation is not forced by the Analytical Engine (e. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43In the Project Source Manager click on 'OK' to exit the window. In the Source area, select a database instance for the data source to access using Query Builder. When connected to a Greenplum 4. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. 4. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. Chapter 1: Understanding Big Data fundamentals. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. In MicroStrategy Developer, choose File > New > Report. For information on connecting to databases, see Connect to Databases. 2 Right-click the MicroStrategy Tutorial project and select Architect. This can be initially. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Heavy load on the database causing statistics logging to fail. Copy and paste XQuery 1 to XQuery Database Connection>Advanced>XQuery authentication parameters as shown below:MicroStrategy Analytics Desktop User Guide Contents © 2015 MicroStrategy, Inc. OLAP 3. vii Creating an attribute based on existing objects: Derived attributes. Microstrategy Architecture 2. A dashboard is made up of multiple visualizations. Right click on the text box and choose 'Configure Transaction. mstr File. Step 3) Accept the End-User License Agreement. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. In MicroStrategy 9. Enhancing enterprise analysis with data science. How to Create a New Database Instance Using the MicroStrategy Web SDK 9. DSSerrors. Get an estimated database size . · How to professionally and effectively. Click Next and select the project wanting to be. In the MicroStrategy environment, when a user runs a report for the first time, the job is submitted to the database for processing. Data can be connected through an API, flat file, or database. mstr file, the file is no longer linked to the original data sources and is not updated. List Attributes statement. 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. Languages: C#, C, Java, C++, Perl, Scala, Ruby, etc. If the New Metric dialog box is displayed, click the Empty Metric. ePAPER READ . 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. The Report Data Mart Setup dialog box opens, as shown below: 4. 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. Whenever users submit an element browse request or a report. Business Intelligence with MicroStrategy 10 Analytics. If you select Pig or Web Services, the Import. A database instance specifies connection information, such as the data source name, Login ID and password, and other data source specific information. a lookup table. A database instance is a MicroStrategy object, created in MicroStrategy Developer by an administrator, that represents a connection to a data source. From an open dossier, tap Share > Download Dossier. If you downloaded all the bundles available in the XAMPP NetBeans IDE, make sure you choose PHP under project category, PHP Application under Projects then click on Next button. The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. Access MDUpdateUtil. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. The Tutorial project includes sample data, such as actual customer names and items purchased. Microstrategy 10. Geoinsyssoft Microstrategy training chennai -microstrategy. Microstrategy tutorial database download MicroStrategy is business intelligence software used to generate reports and organize information. 4. Removes an added data mart database instance to a project. To create a user with standard authentication to use in your DSN creation, expand Security, right-click, and choose New Login. To install and access MicroStrategy Server Administrator, when installing MicroStrategy Developer,. MicroStrategy - Environment Setup Download MicroStrategy Desktop. Prevents users from experiencing a product outage. Right-click and edit the database instance you found in the Intelligence Server Configuration. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. Manually fill in the connection information of the Presto JDBC connection string to connect. 8), of which 78 were reported by our customers. Enable users to interact with personalized chat for further product discovery. The ApplySimple function is a single-value function. The report is displayed in Grid View, as shown below. x, SQL Server 6. Workstation cannot be installed on a 32-bit Windows environment. For each project requiring database authentication: Open Project Configuration. The objects stored in the metadata are reusable. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. Lookup tables are usually joined to fact tables to group the numeric facts in the fact table by dimensional attributes in the lookup tables. The procedure's output columns are mapped onto MicroStrategy attribute forms and metrics, in the usual way for Freeform SQL reports. ). Go to Administration > Server > Configure MicroStrategy Intelligence Server. In the Data Source dialog, select Reports. Patent Information This product is patented. 29KB. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Expand the Database Instances category, and then select Connection Mapping. MicroStrategy is a powerful Business Intelligence and Visualization software. mstr file to a contact, email, another application, or save it on your device. 4 %âãÏÓ 2 0 obj >stream xÚìÁ € ÿ«ë €Ù±ƒ”8¶ ûº ˆƒ@@p, Bæâ Ä ¸ Ý…®A× £h¤‚ 6. 3 introduces a modern look and feel to the Tutorial project and makes it easier to identify and view the latest capabilities. Per un elenco di tutti i problemi risolti in questa versione di MicroStrategy, consultare Difetti risolti e miglioramenti introdotti in. Log into the machine where you are installing MicroStrategy Desktop. Read LearnSelf-Service Analytics with Amica. Select the metadata databases that contain the source project. Choose Data > VLDB Properties. MicroStrategy Intelligence Server stopped logging statistics. exe. The following warning message is displayed: Once Intelligence Server has been configured to store the History List cached data in the database, this setting will apply to the entire server definition. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Module metadata. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Right-click the LU_STATE table and select Create Table. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. FAQ. 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. This guide provides a description, usage scenarios, and screen shots for all the packaged reports for SFAM. In MicroStrategy Desktop, log in to a project. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. MicroStrategy - Environment Setup Download MicroStrategy Desktop. Overview 1. The theme of the Tutorial project is a retail store that sells. A dossier is an interactive display that you can create to showcase and explore business data. The Metric Editor opens. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. Problemi risolti. Workstation is the only space for analysts and app architects to build and manage content of all types. 10. We fixed 157 total defects with Hotfix 8 (10. javac, jikes, etc. The modeling tool allows architects to transform a complex enterprise data environment. Workstation. Project Configuration 2. Open the workstation-mac-x. Select Tutorial Data. An empty database is created. 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. From the Warehouse Tables pane, you can update all tables for a data source or update individual tables as described below: •. Click the MicroStrategy icon, and select Create Document. Add the two reports Report Item Orders and Revenue and Units Sold by Subcategory as datasets of the. A database table used to uniquely identify attribute elements. a lookup table. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. 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. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. a relationship table. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. A sales team might use a business dashboard to connect. Installation And Initial Setup. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. Instructor Office Hours. AutoStyles 14. ” in the Warehouse Catalog Options: After enabling this option, restart the machine where you are using MicroStrategy Developer and add the tables again. Go to Database Instances > Authentication > Metadata. Lists all attributes from a given location path within a project. Log on to the machine where you are installing one or more MicroStrategy products. The MicroStrategy Tutorial project has been tested on a warehouse and metadata in Microsoft Access. Click OK. MicroStrategy's software allows reporting and analysis of data stored in a relational database, multidimensional database, or flat data file. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. MySQLUser. The connection string is required for the application to establish a connection to the database. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. For example, consider an attribute based on a column named 'TEST COLUMN' in a table named 'GREENPLUM_TEST'. Step 3) Turn on archival logging for the SALES database. PDS file. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Step 5) Finish the installation process. In MicroStrategy Developer, choose File > New > Report. The default folder is: C:Program Files. · How to use all the main visualizations. Key Highlights of SQL Tutorial PDF for Beginners: Author – Guru99. The metadata is a central repository, which stores all the objects used by it. Change the 'AuthMode' node to 'MWSNTCredential',. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. For steps, see Starting MicroStrategy Developer. · How to install additional visualizations to your profile. Enter the project name as shown below. Specify the IP address of the SMTP server. Locate the path to the following SQL files part of the Tutorial Project Data download (within a folder titled ' Databases ') from the prerequisites section: -poc_metadata. MicroStrategy OOTB PostgreSQL JDBC driver fails to connect PostgreSQL database when authentication method is scram-sha-256 MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. g. This is the password of an administrator user in the. Use your preferred restoration method or the commands below: The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. Have a good. 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). Functions in MicroStrategy are powerful tools used in expressions to define MicroStrategy objects and initiate complex user-selected calculations. If the Use parameterized Queries is checked, then the DB instance or the DB role is ready. The recent version was released on 7th January 2019, and it introduces many new ground-breaking enhancements and features. The following screen opens up showing the various schema. Overview of steps: Section 1: Restoring the . Provide additional configuration details. Follow the next steps in order to grant the "Create and edit database logins" privilege to the user: Right click the account in 'User Manager' and select 'Edit'. The MicroStrategy for Office add-in enables you to use Microsoft Excel to connect to data in MicroStrategy. sql files of the Metadata and Warehouse into your MySQL Server Section 2: Creating DSNs for your Tutorial Databases in MySQL. The add-in introduces the ability to import and refresh reports and datasets from MicroStrategy into Microsoft Excel. View AllFiles. MicroStrategy Tutorial. These are discussed below. Learn more.