how to find microstrategy metadata. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. how to find microstrategy metadata

 
 In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Managerhow to find microstrategy metadata  Enter the user name and password you wish to use to connect to the Narrowcast Server

In the Open drop-down list, type cmd and click OK. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. mstrio: Simple and Secure Access to MicroStrategy Data . Runs the client in Prompted mode. Open both folders in which the user is located for each project source. If the description for the ODBC DSN does not match "MySQL ODBC 5. There's a reason we're at the top of the list. Users of MicroStrategy Web can also connect to data sources using database connections. Required Status to Perform Action. In MicroStrategy Developer, the project source appears in the Folder List with an icon that varies depending on the type of connection it represents. Users are defined in the MicroStrategy metadata and exist across projects. There's a reason we're at the top of the list. 9% of resumes. 9. Configuring and Connecting Intelligence Server: After installing and activating MicroStrategy products, you must use the MicroStrategy Configuration Wizard to configure the MicroStrategy metadata repository, statistics tables, history list tables, Intelligence Server, and project sources. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. It supports for all new and updated features in MicroStrategy. From the DSN drop-down list, select the DSN used to connect to the metadata repository. In MicroStrategy, a security filter is a filter object that is used to narrow down the result set that users or groups can view when they execute reports or browse elements. MicroStrategy manages the mapping between the logical table and the physical tables. The timestamp of when the session was opened. and run another dependency search and so on. Object Layer. After you install an ODBC driver, you can define one or more data sources for it. Report SQL, report data, and graphs can be executed and compared in Integrity Manager to help customers verify change success. Click "Next". This video walks users through the process of installing and running the mstrbak tool and how to use it. This procedure provides the steps on how to return the latitude and longitude for a single address. The MicroStrategy Repository Administration tool’s backup operation is based on the database information in DBAdminConfig. The Mapping pane in the Freeform SQL Editor is where you map the columns in your SQL query to attributes and metrics that will appear in a MicroStrategy report. You can use MicroStrategy Web to import data from different data sources into MicroStrategy metadata with minimum project design requirements. After you find the microstrategy. Our top marks in this year’s new category follow 3+ years of #1 ratings in the now-retired Enterprise Analytics use case. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. 11 Critical Update 1 (v10. Configure and store credentials for the login. In the Source area, select the database instance for your Excel file. The following sample code shows how to search for "My Reports" folder inside MicroStrategy. Incentivized. In MicroStrategy 10. However, in the cases where there is an existing MicroStrategy user structure and fewer users, a simpler strategy would be to link. ' next to the Source folder text field to select the 'src' folder and click OK. <None>. Select Display Managed Objects. 1) • Support extended through June 30, 2019. Click on OK to save the preferences. Before running ScanMD, a database backup of the metadata must be made. exe. 825. ), it is the IP address of the machine from which the session was created. Before discussing the details of the LDAP integration the following commonly used terms are explored in some detail:KB215812: How to send a MicroStrategy Web virtual directory to MicroStrategy Technical Support to troubleshoot MicroStrate…Below is a list of the tables contained in a MicroStrategy metadata repository. On Windows from the command line, perform the following steps: From the Windows Start menu, select Run. The results will appear in grid which is more readable. Enter user information in the Create New User dialog. MicroStrategy has a metadata-driven architecture. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. x and later. This is a userStand out in a crowd. In the following sample code, several parameters must be adjusted to match environment specific values, such as project names and login information. Here is a link to the documentation, which is much clearer and provides the opportunity to test out some of the code using MicroStrategy's demo server:The status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Highlight the table and select the arrow pointing to the right. It also has a more powerful and easy to use. Enter the user name and password you wish to use to connect to the Narrowcast Server. The DSN and Login ID are provided based on the server configuration that you did previously. 1) Create a DSN that connects to the MicroStrategy 9. Also see additional information regarding Object GUIDs, please see the below Technotes: To check the Data Source Name (DSN) in use by the MicroStrategy Intelligence Server, users must perform the steps outlined below on the Intelligence Server machine: In MicroSoft Windows follow the menu options - Start > Run > type 'Regedit' and click on 'Enter' to open the registry editor. In some business scenarios, it is required to duplicate a project's metadata to a Microsoft Access file. Parallel Upgrade or Metadata Migration with Platform Analytics. 54K KB35860: MicroStrategy Object Manager is unable to migrate subscriptions from one environment to another. NOTE: To perform this audit, queries are run against the MicroStrategy metadata database. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. Going to the basics, below is the basic outline of the MicroStrategy architecture: I've been working in the past few years with Cognos 10 and Cognos 11 but my company has Microstrategy (I'm a newbie in Microstrategy). In simple terms, it detects physical inconsistencies by running SQL against different metadata tables and then comparing. Login to Postman and search for MicroStrategy in the homepage search bar. Regardless of your synchronization settings, if a user's password is modified in the LDAP directory, a user must log in to MicroStrategy with the new password. 02:41 01:34 Still need help? Open a support case Watch this video on how to upgrade the Microstrategy 10. Access the database using MicroStrategy Desktop for Mac. If you. Now available for feature release—MicroStrategy 10. Run MicroStrategy Backup. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. <None>. 11. 1. 2) Run the following SQL against Metadata Tables: Sql select PROP_VAL from DSSMDOBJPROP. 1, you must. Upgrade this test environment to validate the upgrade before using in your production environment. util. Check the Validate Server Certificate checkbox. Configuration Wizard fails when configuring the MicroStrategy Intelligence Server. To help reduce deployment complexity MicroStrategy now includes an embedded repository that can support the following MicroStrategy products: Metadata Repository; Collaboration Server; Platform Analytics; The infrastructure is installed and ready for use should this be the right fit for your deployment. The user should locate the VLDB. ODBC drivers translate MicroStrategy Intelligence Server requests into commands that the DBMS understands. Defining DSNs. Click User Manager . That you can find from your metadata. Open the odbc. You are now positioned to run the MicroStrategy Backup client. Select Metadata, History List and Statistics Repository Tables and click Next. Although it is possible to use the Microsoft Access database. This is a Microsoft Access file called "EM_Proj_MD. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Create a new database instance. Select Metadata, History List and Statistics Repository Tables and click Next. MicroStrategy Backup Preparations. Start the Command Manager graphical interface: In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Your MicroStrategy Backup is restored on your new environment. Click 'Browse. GET PROPERTIES NAME FROM ATTRIBUTE "Customer" IN FOLDER "Schema ObjectsAttributesCustomers" FOR PROJECT "MicroStrategy Tutorial"; ResultSet columns CREATION_TIME : The date and time of the creation of the object, returned as a date/string. 4. Response File: The MicroStrategy Configuration Wizard response file that defines how to upgrade Intelligence Server components or migrate your History List from a file-based system to a database-based system. Smart. Metadata Doctor (MD Doctor) is a utility that detects and fixes certain physical inconsistencies in MicroStrategy 9. Type todbcx. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. In the MicroStrategy architecture, each object is identified by its unique Object ID. Type your MicroStrategy login and password for the selected Intelligence Server and click Connect. This video shows basic steps of MD upgrade process. A DN is the unique identifier of an entry in the LDAP directory. Before running ScanMD, a database backup of the metadata must be made. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. On the File menu, point to Connect, and then choose Narrowcast Metadata. The NCS Authentication dialog box opens. x has the capability to authenticate and import users and groups from an existing LDAP Server into the MicroStrategy Metadata. Additional tables are added to the metadata in MicroStrategy 9. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. This Knowledge Base article describes a known issue in MicroStrategy 10. Now, enter your username and hashed password copied from the database and login. i686 package included with your install media. On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. Click Show Advanced Options. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. This demo will guide you through creating a Data Source Name, and a database connection to a Microsoft SQL Server Database in both Developer and Web. Response File: The MicroStrategy Configuration Wizard response file that defines how to upgrade Intelligence Server components or migrate your History List from a file-based system to a database-based system. Platform Analytics has a unique way to identify each metadata connection to the Intelligence Server. " It is usually a file or database that describes another set of data or information. Click the folder icon to browse to and select a response file. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. x to PostgreSQL 9. How to Analyze the Size of Metadata Tables The MicroStrategy Administrator should work with the DBA to find the tables which consume the largest amount of memory. Always upgrade the Intelligence Server before upgrading client applications such as MicroStrategy Web, Mobile, Library, and Developer. Click Next. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. Specifically, ODBC connects to. How to Analyze the Size of Metadata Tables The MicroStrategy Administrator should work with the DBA to find the tables which consume the largest amount of memory. x using the MicroStrategy Configuration Wizard. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. Define the statistics and enterprise warehouse database. Select Display Managed Objects. Steps to enable Scheduler: Open Developer. The below are examples for a few of the common metadata database platforms. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. KB442628: Platform Analytics Kafka Topics and mapping tables in MicroStrategy 11. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . The Metadata is where all the MicroStrategy definition is stored. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. By default, MicroStrategy Web supports the following authentication modes for verifying the user's credentials. x metadatas that may prevent MicroStrategy 9. Enumeration; import. 4. Become a More Intelligent Enterprise. From the drop-down menu, choose the database instance against which the user ID should be verified. For instance, if a translator finishes only some of the translations, it may be desirable to import back into the metadata only the completed strings. MicroStrategy is usable in both forms, web and desktop tools, whereas Cognos is a web-based reporting tool mechanism. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Click Next. In certain senarios, it is helpful to find out the metadata shell version by running SQL against the metadata in MicroStrategy DB Query Tool (or ODBC Test Tool in version 8. Before discussing the details of the LDAP integration the following commonly used terms are explored in some detail: MicroStrategy on AWS: Metadata Backup and Restore. Open a browser and access the SAML configuration page with a URL in this format: Copy. Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Find MicroStrategy’s public API in Postman and make your own copy (Fork). is stored in the. Collect this file along with the DUMMYMDT DSSErrors. Operations cannot be performed from a newer metadata to an older one. Each user has a unique profile folder in each project. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. 5 (9s) out of the box Enterprise Manager Metadata. To access the configuration page, you need admin privileges. yaml. Configure Metadata Connection. For information on how to create a Configuration Wizard response file, see. The Object Telemetry dossier contains a great deal of subscripton information. You can also view Intelligent Cube information for a specific Intelligent Cube, by double-clicking that Intelligent Cube in the Intelligent Cube Monitor. To search for managed objects only, select Display Managed Objects Only. However, a report with only the "User" attribute will list out all the users, regardless of their activity. Chose IBM Cognos Analytics. Select “MicroStrategy SDK”. MicroStrategy의 강력한 클라우드 네이티브 플랫폼, 멀티 클라우드 전략 및 컨테이너화 기능은 가장 리스크가 적은 방식을 채택하여 제품 출시까지 소요되는 시간을 단축합니다. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. MicroStrategy metadata. The Back Up Database windows will open, ensure that Full is selected under Backup type. There's a reason we're at the top of the list. Designed with automatic alerts, Insights is powered by machine learning (ML) models to analyze data behind the scenes and surface key trends, outliers, or anomalies. Refer to your MicroStrategy contract and any accompanying contract documentation for descriptions of the different MicroStrategy license types. Select Project Sources and click Next. It provides information about peak usage, most. In order to create an ODBC DSN in MicroStrategy Intelligence Server Universal, it is possible to use the utility mstrconnectwiz. Go to the component 'Database Classes' and dispatcher 'SQL Trace'. ), by default returns all tables in all databases and schemas. Creating the Enterprise Manager project. List of metadata repositories tables for MicroStrategy 10. On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. A Project Source can be created using the MicroStrategy Configuration Wizard or the Project Source Manager. 825. 1. Starting in MicroStrategy 2019 it is possible for administrators to track the state and usage of subscriptions through Platform Analytics. In the available columns, select the Last Month ID column (Prev_Month_ID in MicroStrategy Tutorial) and drag and drop it into the expression field on the left, as shown below: Click 'OK' and save the transformation: For details on how to. Option 2: Upgrade using MicroStrategy MDUpdateUtil Tool. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. While trouble shooting cases, sometimes it is helpful to find out the dependencies between objects by running sql directly against the metadata in MicroStrategy DB Query Tool. config. In MicroStrategy 2020, there are several ways to programatically retrieve a list of schedules and subscriptions, besides using Command Manager. The second most common hard skill for a microstrategy developer is bi appearing on 5. Create a new two-tier project source using the DSN created. SQL scripts transform the statistics data into a form that can be useful for administrative reporting. To view this field, the Intelligent Cube must be published at least once. If a matching user is found, the project. The Windows domain is the authentication authority. There are two methods of determining a Project's version: Using the MDUpdateUtil tool Access MDUpdateUtil. Create an Amazon Redshift DSN using the MicroStrategy Connectivity Wizard. If this is not the correct path, you can find the path by running locate MSIReg. TO LEARN MORE: To Learn More about Enterprise Manager, please see Chapter 17 in the System Administrator's Guide. The information is stored in a proprietary format. In some cases, users may want to see the direct object dependencies of objects in the MicroStrategy metadata. A list of. The RDBMS for the metadata and warehouse do not need to be the same. Response File: The MicroStrategy Configuration Wizard response file that defines how to upgrade Intelligence Server components or migrate your History List from a file-based system to a database-based system. For detailed information, query the INFORMATION_SCHEMA. Follow these guidelines when you search by a. Identify your tables in the 'Tables'. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. While there is no location within the MicroStrategy products Graphical Unit Interface (GUI) where a user can determine the DSN being used by MicroStrategy Intelligence Server to connect to the metadata, it is possible to determine this information by looking in the registry. List the names of any additional DSNs that will be needed in the new environment. DSN: Select the data source name for your metadata repository. Please contact Microstrategy Technical Support if you still need further assistance. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. Input Location; BakFileLocation. Step 2. Additional information regarding where the enterprise manager dataload is failing can be obtained by tracing the SQL during dataload. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. If necessary, enter the database you wish to use for this Narrowcast Server. There's a reason we're at the top of the list. This mode asks the user for information about the location of various. The DSN and Login ID are provided based on the server configuration that you did previously. On Metadata Repository Connection Information, click Apply. For each Table object, right click on the table and choose 'Search. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct. import com. ; In the Project Source Name field, type a name for the project source. The preferences are stored in memory. User Name: Enter the user name for the user that can connect to the data source. MicroStrategy users need connectivity to the metadata so that they can access projects, create objects, and execute reports The username of a metadata user with full administrative privileges (Administrator is recommended). MicroStrategy does not pass the report back and forth between the engines, returning to the SQL. a lookup table. A list of the users that belong to the selected group is displayed. The DSN is the name for a pointer used by a client application (in this case MicroStrategy) to find and connect to a data source. Then click 'OK'. This setting is ideal if you have numerous. Published: Dec 5, 2017. Selected. The recipient_id column is recorded along with job executions in MicroStrategy. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. Open the MicroStrategy Configuration Wizard. Defining DSNs. Tap on the photo and go to the share icon in the bottom-left corner of the screen. There is a distributed and highly available database for the MicroStrategy Metadata and Statistics. It also stores other types of objects that allow you to access that information. x - 9. x and above. The third most common microstrategy developer skill is templates on 5. The utility is found under Program FilesCommon FilesMicroStrategy. Along with a backup of the metadata (MD), cache files can be restored on MicroStrategy Technical Support environments to troubleshoot report or document-specific issues. The example below shows the analysis for a MySQL Metadata: SQL to find the tables in a given schema SELECT table_name FROM information_schema. This table is used for defining some property values which will be used in certain DS tables. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Open the terminal and run the command locale to check the current system locale. There's a reason we're at the top of the list. Select Metadata, History List and Statistics Repository Tables and click Next. Information on the MicroStrategy Tutorial project is provided in the Project Design Help. This opens a Quick View of the Intelligent Cube information and usage statistics. From the Metadata drop-down list, specify the language in which to display the. REL_. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a User. In the MicroStrategy 9. Create a DSN named "MS Access Shell" for Microsoft Access database with MicroStrategy Connectivity Wizard. Enter the User Name and Password for the database. Locate the web. Forexample,ifyoudon’tC. xml) for configuring SAML. Starting Oracle Data Pump Export. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. To support the use of a graphical user interface for MicroStrategy tools and installing MicroStrategy products on Red Hat Enterprise Linux 6, you must install the libstdc++-4. Launch the Configuration wizard and choose to create repositories then select metadata. I know which tables to query because I googled it and I found this blog entry, but I don't know. Windows NT authentication: The Windows NT SID. From the DSN drop-down list, select the DSN used to connect to the metadata repository. The TABLES and TABLE_OPTIONS views also contain high-level information about views. Contact MicroStrategy Technical Support. 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. Select the table that was created in Step #1 (or the lookup table where the Last Month column was added). Launch the Configuration wizard and choose to create repositories then select metadata. Open the key named 'LOCATION'. Find an event in a city near you. For steps to create a project source, see the. Under Collections, click on the the “…” next to. Select Export Translations as a translation action and click Next. To launch the Database Administration Tool: Open the command prompt and navigate to the repository-administration bin folder: C:\Program Files (x86)\Common Files\MicroStrategy\<MSTR_INSTALL>\Repository\repository-administration\bin. /mstrcfgwiz. WCCA, Worcester, Hidden Treasures. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. Data loading. With your own customized SQL statements, you can retrieve data from various data sources that are relational databases as long as the database instances for. x product family, the metadata used by the MicroStrategy Intelligence Server(s) will be periodically scanned for the total number of named users assigned for each MicroStrategy component based upon the user privileges assigned in the metadata repository. Required permissions. The INFORMATION_SCHEMA. The password can be updated in the 'Connect to Metadata Repository' window as shown in the image below. Enter the User Name and Password for the database. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. This project contains out-of-the-box reports to demonstrate the various features of MicroStrategy ONE. Platform Analytics. There's a reason we're at the top of the list. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. ini file. KB441192: Configuration Wizard fails when configuring the MicroStrategy Intelligence Server 10. Exported data files can be later used in dossier for further analytics or visualization. Restoring with MicroStrategy Backup allows you to create mirror environments to test new projects, create disaster recovery environments, migrate current MicroStrategy deployment to the cloud, and more in a same or newer MicroStrategy version. MicroStrategy AI is here. Right mouse click the grid and choose 'Export Results -> to Excel'. Select Configure Intelligence Server, and click Next. Hover over the Properties column and click Open Intelligence Server Administration Portal . Following is the architecture of MicroStrategy: 1. This tech note is an explanation of how to check the size (row count) of a table in MicroStrategy 9. For information on how to create a Configuration Wizard response file, see. The Enterprise Manager project can be created on a machine with your production metadata. There's a reason we're at the top of the list. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. How to Update the Database User Password. With the latest Visual Insight tool, MicroStrategy brings the power of BI to the business users. x when configuring Intelligence Server via Configuration Wizard on Windows OS to point to a metadata in PostgreSQL 9. x metadata repository to a newer version. This embedded repository is. Runs the client in Prompted mode. MicroStrategy REST API allows browsing metadata objects. On the next screen do not enter any password, just click Next. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. The following is a standalone Java example to check the different preferences level for a given user's session. MicroStrategy Integrity Manager is an automated report comparison tool. el6. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. This KB article describes how on Windows and Linux systems. x will not exclusively show the result with user A only but the result will show all users who belong to one of groups, as illustrated below. With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize data and better reflect relationships. A MicroStrategy project provides a reporting environment by making available a set of schema and application objects users can combine to create business intelligence reports and documents. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. The following steps generate the application metadata ( SPMetadata. Cloudera CDH Hadoop Gateway System. To search for managed objects only, select Display Managed Objects Only. Only executions related to subscriptions will have a valid recipient. However, you can also modify a response file with a text editor to make minor changes such as entering different user login and password information. The Scan MD tool executes tests to detect inconsistencies in the metadata. Verify the components you want to upgrade and click Next . x, an attribute form called 'Enabled Status' has. In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder. . In Command Manager, the list of enabled users in the metadata is returned by the following command: LIST LOGIN, ENABLED FOR USERS IN GROUP "Everyone"; This can also be done using MicroStrategy Web SDK 10. The MicroStrategy metadata contains all the information needed for a MicroStrategy project to function, including data warehouse connection information, project settings and MicroStrategy object definitions. The MicroStrategy REST API is a RESTful application that uses HTTP requests such as POST, GET, and DELETE. If the Configuration Wizard detects an existing metadata repository in the database location you specified, a message is displayed on whether to re-create the metadata tables. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The destination project must be of the same or greater metadata version as the source project. Create an upgrade test environment by duplicating your production environment and production metadata. x and additional columns are added to existing metadata tables to facilitate support for Internationalization, Metadata Auditing and Distribution Services. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. Open the MicroStrategy Configuration Wizard.