folder. Windows NT authentication: The Windows NT SID. The Scan MD tool executes tests to detect inconsistencies in the metadata. The "Find and Replace" tool can be found in the "Tools" menu of MicroStrategy Developer: To replace an object, follow these steps: Select the object to be replaced (dependee). Runs the client in Prompted mode. To view this field, the Intelligent Cube must be published at least once. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. Windows NT authentication: The Windows NT SID (security identifier) is validated against the NT logon context stored in the MicroStrategy metadata repository. Enter the User Name and Password for the database. 2) Run the following SQL against Metadata Tables: Sql select PROP_VAL from DSSMDOBJPROP. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. That you can find from your metadata. The Python script below was written for that purpose. A database table used to uniquely identify attribute elements. Tap on the photo and go to the share icon in the bottom-left corner of the screen. How to Update the Database User Password. Click Next. From the DSN drop-down list, select the DSN used to connect to the metadata repository. You are now positioned to run the MicroStrategy Backup client. From the Metadata drop-down list, specify the language in which to display the. Click the link for the desired manual or other documentation source. 2 Enterprise Architecture Enterprise Architecture consists of a two to eight node highly available cluster for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. The users' Partition Mapping Table appears in the left window. is stored in the. In Web, if the browser is set to a language unsupported in MicroStrategy and the user's preferences are set to Default, the date/time and number formatting display in English. Collect this file along with the DUMMYMDT DSSErrors. Follow these guidelines when you search by a. On Metadata Repository Connection Information, click Apply. In the bottom section, under Destination note the location of. x, the statistics tables and warehouse creation process is all handled by Configuration Wizard via the Create Metadata, History List and Enterprise Manager Repositories option. 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. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Upgrade this test environment to validate the upgrade before using in your production environment. The server definition is a set of settings stored in the metadata which contain information about configuration locations, governing settings, and other system and project specific settings. Go to the component 'Database Classes' and dispatcher 'SQL Trace'. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. Change the system locale to English-US or another supported locale by running the command: ocalectl set-locale LANG=en_US. Connecting to the metadata in DB Query tool shows all metadata tables, but no server definition can be found in the tables. <. For each project requiring database authentication: Open Project Configuration. Serves as a central point for the MicroStrategy metadata; The following capabilities are integrated into and run on the same machine as MicroStrategy Intelligence Server: MicroStrategy Distribution Services monitors data and automatically sends critical business performance information to users via email, file servers, FTP locations, and. That is, the metadata must be upgraded to MicroStrategy ONE/2021 to use MicroStrategy Intelligence server on MicroStrategy ONE/2021. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. Only the database names listed in DBAdminConfig. Once a table is moved from left to right, its definition is saved in. Choose “Save to Files. Choose the database and version, click Add driver, browse to the driver setup in step one and click OK as shown below: For all JDBC. To view this field, the Intelligent Cube must be published at least once. 2. Go to Project access, to give Public/Guest basic access to the project. log and MicroStrategy License Manager is the version of the base build installed in that machine. Manage and Verify Your Licenses. Right‑click the program icon and select Run as Administrator. ”. Below are the new features exclusive to. From the drop-down menu, choose the database instance against which the user ID should be verified. Load Metadata Object Telemetry, resume PA consumer and Healthcheck. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. ; In the Project Source Name field, type a name for the project source. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. The password of a metadata user with full administrative privileges (Administrator is recommended). However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Next to All Users, click Create a new User . xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. For information on how to create a Configuration Wizard response file, see. Choose MicroStrategy ODBC Driver for Microsoft SQL Server. Step 1. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. x to PostgreSQL 9. You do not have to define users for every project you create in a single metadata repository. x metadata repository to a newer version. Database Instance. Organizations can use Unity Catalog to securely discover, access, monitor and collaborate on files, tables, ML models, notebooks and dashboards across any data platform or cloud. Navigate to the Security tab and configure the following parameters. In addition,. To search for managed objects only, select Display Managed Objects Only. Change the password of the account. There's a reason we're at the top of the list. " I-Server configuration error: "The metadata you selected has not been upgraded to the current version of Intelligence Server. KB441192: Configuration Wizard fails when configuring the MicroStrategy Intelligence Server 10. Sample folders named as below:. With a backup of the metadata in place, proposed fixes should only be accepted if the full impact of the fix is understood. You can find the list of supported RDBMS. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. Click Configure Intelligence Server. On the otherway, you can try every object used in the report checking the location of each object one-by-one (Report Objects, Filters used etc. Type, Subtype and extType parameters of objects can be used to narrow down the search. 1) Connect to Metadata through DB Query Tool or other SQL tool. Platform Analytics has a unique way to identify each metadata connection to the Intelligence Server. Right-click the event and select Trigger . xml) for configuring SAML. Under Collections, click on the the “…” next to. Going to the basics, below is the basic outline of the MicroStrategy. Deleting a project from the MicroStrategy metadata can be achieved by using the Delete method of the IDSSDelete interface, supported by the DSSDataSource object. 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. 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. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. It provides information about peak usage, most. The server definition is a set of settings stored in the metadata which contain information about configuration locations, governing settings, and other system and project specific settings. Under Desktop/Developer browsing options, choose 'Display hidden objects'. The MicroStrategy Intelligence Server 9. Your MicroStrategy Backup is restored on your new environment. The Repository Translation Wizard allows users to set flags in the translations table to control which strings are imported back into the metadata. The below are examples for a few of the common metadata database platforms. Follow the directions below in order for managed objects to show up in a search result: In the Search for Objects dialog box, select Options on the Tools menu. Click on OK to save the preferences. specifically focusing on statistics tables for the Enterprise Manager project, but the SQL used to query for the row count can be used on metadata and history list tables as well. The search will provide you a list. The update utility, like Desktop, can use an Intelligence Server on any supported operating system interchangeably. Following is the architecture of MicroStrategy: 1. For steps to create a project source, see the. If any problems arise see section on Troubleshooting. In order to track each delivery being process on the MicroStrategy Intelligence Server, users can track the entries on ‘. Check the Validate Server Certificate checkbox. This window shows on the left pane the physical tables and views available in the warehouse database and on the right pane which of those tables have been created as MicroStrategy Tables. Open both folders in which the user is located for each project source. While some duplicate columns in a MicroStrategy schema are necessary or benign, a user may experience issues that require the assistance of Technical Support in. The metadata has now been transferred to the MS Access file MyRepository. x metadata and the MicroStrategy Enterprise Manager 9. After restore, you can find all backup files in /opt/mstr/mstrbak: Windows backup and restore: LDAP must be re-configured in the new environment. If the metadata server instance is shutting down unexpectedly, very likely a core file will exist in the MicroStrategy folder structure. Select the Statistics & Enterprise Manager Repository check box and click Next. log and contact MicroStrategy Technical Support in this case. Right mouse click the grid and choose 'Export Results -> to Excel'. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. x does not return full c… Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. Metadata Doctor (MD Doctor) is a utility that detects and fixes certain physical inconsistencies in MicroStrategy 9. Select Export Translations as a translation action and click Next. In the Source drop-down list, select Google. LDAP passwords are not stored in the MicroStrategy metadata. Required Status to Perform Action. To list all enabled users is the everyone group, here is sample code: import java. Open the Photos app and find the photo you want to view the metadata for. This setting is ideal if you have numerous. MicroStrategy recommends that you always create the response file through the GUI mode of the Configuration Wizard. 4. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. The following is a list of the different properties of a MicroStrategy metadata object that can be listed using Command Manager 8. You can find the list of supported RDBMS. With the latest Visual Insight tool, MicroStrategy brings the power of BI to the business users. 8. Type, Subtype and extType parameters of objects can be used to narrow down the search. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. However, when using the Configuration Wizard via the console administrators are not presented with a list of server definitions to choose from nor is. Schema objects are logical objects that relate application. Select Project Sources and click Next. The user should locate the VLDB. It will not show users whose number of jobs is 0. Set Encryption Method = “1-SSL”. You can choose to assign DNs to MicroStrategy users explicitly. 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 by the Data Source Name (DSN). On the Freeform Sources tab, select Create Query Builder report. 93K KB428983: The “List_Server_Config_Properties_Outline” script in MicroStrategy Command Manager 10. You can access existing projects, applications, data imports, and metadata—as well as collaborate and share dossier and documents with colleagues—by connecting Workstation to an environment. x-10. x, fact tables may be partitioned using warehouse partition mapping tables or metadata partition mapping tables. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Open the ODBC Administrator and edit the pre-created Amazon Redshift DSN. The Freeform SQL functionality allows you to use your own SQL statements to generate reports, instead of using the MicroStrategy Engine-generated SQL. 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. Users are defined in the MicroStrategy metadata and exist across projects. 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. If you are using Red Hat Enterprise Linux 6. How To Perform an Upgrade with MicroStrategy Backup. Although it is possible to use the Microsoft Access database. On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. Metadata is stored in a relational database with a predefined structure. If you are in compliance, a message appears. Secondly, you can create queries in MicroStrategy in the same way that we did in the Call REST API in MicroStrategy section:Open Repository Translation Wizard and click Next. Provide additional configuration details. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. sh file when the home and install paths are differentFor steps to complete various configurations tasks with the Configuration Wizard, see the sections listed below: Once you reach the Summary page for a configuration, click Save. Enter the User Name and Password for the database. SQL queries in this document have been written for MicroStrategy 9. Select Configure Intelligence Server, and click Next. By definition, a metadata is "data about the data. Where is the connection information stored? The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one),. '. Select Metadata, History List and Statistics Repository Tables and click Next. It is a database where the whole “skeleton” of the tool is located. Configure Metadata Connection. The metadata also stores the definitions of all objects created with MicroStrategy Developer and Web such as templates, reports, metrics, facts, and so on. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. x warehouse and statistics tables. Select Configure Intelligence Server, and click Next. In general, report creation in MicroStrategy is. ). It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. Identify those objects in their own folders. On the Metadata Connection page, type the DSN, database login, and database password to access the MicroStrategy metadata. DSN: Select the data source name for your metadata repository. x, select 'Preferences'. x. Platform Analytics consumer performs a standardization. Click on 'Browse . 5 (9s) out of the box Enterprise Manager Metadata. x metadatas that may prevent MicroStrategy 9. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. Click on OK to save the preferences. The diagram below illustrates three-tier metadata connectivity between the MicroStrategy metadata database (tier one), Intelligence Server (tier two), and Developer (tier three). Enter the User Name and Password for the database. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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. xml) for configuring SAML. Start the Oracle Data Pump Export utility by using the expdp. Another case would be where you might have data in particular space in Datasphere whose metadata you don’t want to be available in catalog; like a HR space. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. Open the Repository Translation Wizard. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. This number is set from registry [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS. The basic information for subscriptions such as ID, name, schedule, recipient, etc. NOTE: For Windows, refer to the MicroStrategy KB article - KB428146: How to determine which DSN is being used by the Intelligence Server on a 64-bit Windows machine. There's a reason we're at the top of the list. Third Party Software Installation Warning: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. . For example, if you want to create a new user in the Web Reporter group, click the Web Reporter group link. The Save dialog box opens. You then save and publish it as an Intelligent Cube. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Login, Full name and Email address of the new user, and a Description. and run another dependency search and so on. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. Click Show Advanced Options. Third Party Software InstallationTo create to a direct project source. Intelligence Everywhere. Contact MicroStrategy Technical. Use the project duplication function to duplicate only the Tutorial project to your metadata. Note: This setting has to be check for every MicroStrategy project logging statistics. Learn more. VIEWS view. mstrio provides a high-level interface for Python and R and is designed to give data scientists, developers, and administrators simple and secure access to their MicroStrategy environment. Each user has a unique profile folder in each project. Create an Amazon Redshift DSN using the MicroStrategy Connectivity Wizard. el6. Incentivized. There is a dialog that includes fields to define how to create your metadata tables and where they should be stored. The most fundamental objects stored in the metadata are schema objects. Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. Hover over the Properties column and click Open Intelligence Server Administration Portal . Once at MicroStrategy’s Collections page, select “MicroStrategy REST API Workflows”. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . In MicroStrategy Developer, the project source appears in the Folder List with an icon that varies depending on the type of connection it represents. x-10. . ), it is the IP address of the machine from which the session was created. MicroStrategy support connects you to the most helpful & experienced technical experts in the industry. NOTE: To perform this audit, queries are run against the MicroStrategy metadata database. This attribute is not directly related to the 'Report' attribute so that if 'Report' and 'Schedule' are placed on a report template by themselves, they will not be joined in a meaningful way. Type N and click Enter to provide different. Open the Warehouse Catalog under the Schema menu. 3 Metadata and Statistics tables implemented in Microsoft SQL Server. The metadata ID for which the user session was connected. In the image above, the SQL is being logged to. There's a reason we're at the top of the list. x and 10. Dependencies. The Scan MD tool searches for logical errors and fixes them within the platform object structure. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingDatabricks took a pioneering approach with Unity Catalog by releasing the industry's only unified solution for data and AI governance across clouds and data platforms. To search for managed objects only, select Display Managed Objects Only. Access MDUpdateUtil. However, when adding some arguments, as indicated in this document, the same utility can be used to. ; Backup the database containing the MicroStrategy 9. x-10. Creating the Enterprise Manager project. MicroStrategy has a metadata-driven architecture. Users are defined in the MicroStrategy metadata and exist across projects. KB35809: Using ScanMD to fix known logical metadata inconsistencies in the MicroStrategy Product Suite 9. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. Steps: 1) Identify the object ID of the Intelligent cube to be audited by checking the objects Property windowIn MicroStrategy SQL Generation Engine 8. After this change, when creating a metadata via the Configuration Wizard, the test schema will be used. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. Transform description: This transform displays project status on the Projects page. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. ACTION: This is working as intended. In MicroStrategy 8. The DSN and Login ID are provided based on the server configuration that you did previously. Refer to your MicroStrategy contract and any accompanying contract documentation for descriptions of the different MicroStrategy license types. Select Display Managed Objects. Defining DSNs. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. 1: Existing Security Roles and User Groups can be obtained from the Configuration Object within the Server Definition object. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To access documentation resources on Windows. Stop the MicroStrategy Web application server. Prompts guide you through testing your ODBC. Configure Intelligence Server with restored metadata with Configuration Wizard 8-2. ; Restore the backup from step two into a new database. This is any location on the Linux or Windows machine where the backup file is written. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. MicroStrategy licenses are managed differently according to the license type that is purchased. util. x and additional columns are added to existing metadata tables to facilitate support for Internationalization, Metadata Auditing and Distribution Services. Open the MicroStrategy Configuration Wizard. Run the. The objects stored in the metadata are reusable. The ability to import users and groups into the Microstrategy metadata from the Directory Server would be an efficient way to create or update a new MicroStrategy user structure from an existing Directory Server. A DN is the unique identifier of an entry in the LDAP directory. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data warehouse. Open the key named 'LOCATION'. 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. The Scan MD tool executes tests to detect inconsistencies in the metadata. Before running ScanMD, a database backup of the metadata must be made. KB484282: MicroStrategy Db2 connection times out after Db2 backup and restore. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MicroStrategy Intelligence Server connects to several databases (at a minimum, the data warehouse and the metadata repository) to do its work. For example: Some objects' dependencies cannot be searched or do not appear through Desktop, like a Database Instance. Platform Analytics. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. use the function "Remove Duplicate Rows". microstrategy. In some cases, users may want to see the direct object dependencies of objects in the MicroStrategy metadata. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. 1. A flag is any character allowed by the database. If there are many unused managed objects in a project then the object bulk load in project duplication will not take effect and it will cause slow performance for project duplication. The version displayed in the DSSErrors. Operations cannot be performed from a newer metadata to an older one. Open the MicroStrategy Configuration Wizard. There's a reason we're at the top of the list. MicroStrategy uses the credentials provided by the user to search for and validate the user in the LDAP directory. For customers on MicroStrategy 10. To specify a database instance, in the Intelligence Server Configuration Editor, select the General subcategory of the Server Definition category, and, in the Database Instance drop-down list, select the database instance to use for the History List. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. Configure Metadata Connection. There's a reason we're at the top of the list. Select the database instance. The DSN and Login ID are provided based on the server configuration that you did previously. x and newer, the default maximum number of concurrent connections that MicroStrategy Intelligence Server can make to the metadata, is 0x0fffffff. MicroStrategy environments prior to MicroStrategy 2020 use MySQL. MicroStrategy Backup Preparations. The preferences are stored in memory. Open the odbc. The solution is to add the following parameter in the metadata DSN: InitializationString=SET STANDARD_CONFORMING_STRINGS TO OFF if you. Additional tables are added to the metadata in MicroStrategy 9. With a backup of the metadata in place, proposed fixes should only be accepted if the full impact of the fix is understood. of objects that use that table. From the Windows Start menu, go to Programs > MicroStrategy Tools > DB Query Tool. The Back Up Database windows will open, ensure that Full is selected under Backup type. The MicroStrategy Intelligence Server 9. They are the bridge between MicroStrategy reporting environment and data warehouse. By default, this file is located in C:Program FilesCommon FilesMicroStrategy as indicated in Step 1 e) If users would like to transfer the file to another machine or send it via e-mail, they should make sure to compress the file with WinZip or a similar tool as. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. The information is stored in a proprietary format. 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). On the next screen the DSN information will be pre-populated. Hive. Additional flat files will be restored to a single directory. On the next screen do not enter any password, just click Next. MicroStrategy AI is here. Generate SAML Configuration Files. Under some circumstances, certain unused managed objects are not deleted after performing ‘delete unused managed objects’ in MicroStrategy Developer 9. xml) and SAML configuration files ( MstrSamlConfig. In the menu, go to 'Tools -> Options'. In Platform Analytics, application and schema objects are captured by the object attribute with the. 4. Always upgrade the Intelligence Server before upgrading client applications such as MicroStrategy Web, Mobile, Library, and Developer. The user can also write the SQL Trace to a new log file by selecting the option from the drop down. Overview of Freeform SQL reports. You are returned to the Summary page. There's a reason we're at the top of the list. Number of Views 2. To backup all databases in MicroStrategy Repository, add the database names to DBAdminConfig. These are discussed below. x, create a new report with the following definition: Attributes . Refer to your MicroStrategy contract and any accompanying contract documentation for descriptions of the different MicroStrategy license types. When a user with MicroStrategy administrative privileges deletes an out of the box folder, such as the ones within the Public Objects folder, metadata inconsistencies might be created. The utility is found under Program. /mstrcfgwiz. On the Audit tab, expand the Intelligence Server folder. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. 5. If you are working on a report that has already been saved, a confirmation message appears. Now, enter your username and hashed password copied from the database and login. Click Show Advanced Options. For details for creating a backup of your metadata, see KB441138. 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. It wraps MicroStrategy REST APIs into simple workflows, allowing users to fetch data from. Select Configure Intelligence Server, and click Next. When this utility is run with no arguments, it launches a graphical application for creating and managing DSNs. The steps to create the MicroStrategy metadata are: Open the MicroStrategy Configuration Wizard ( macfgwizw. The metadata repository is a collection of tables that contain the definitions for nearly all MicroStrategy objects including database logins, server definitions, database instances and connections, reports, metrics, facts, and so on. x metadata repository to a newer version. On Windows from the command line, perform the following steps: From the Windows Start menu, select Run. Number of Views 8. xml file in the "Program Files (x86)Common FilesMicroStrategy" folder on a machine with MicroStrategy Developer installed and create a backup of this file, and then edit it. 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. It also demonstrates what the Patch Installer is and how to download it. Create the statistics database instance.