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. How to Update the Database User Password. Click 'Browse. MicroStrategy supports multiple languages, whereas Cognos provides a customizable dashboard. The latest innovation from the product labs, MicroStrategy Insights fundamentally transforms how users interact with data. This is a Microsoft Access file called "EM_Proj_MD. 0 and above Topic location: C:Program Files (x86)MicroStrategyMessaging Services mpkafka-logs. MicroStrategy actions (executions, session, etc. VIEWS view. 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. util. Run the file mstr-repo-ondemand-dba-operations. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. 2 Enterprise Architecture Enterprise Architecture consists of a two to eight node highly available cluster for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. To set up MicroStrategy Intelligence Server. For detailed information, query the INFORMATION_SCHEMA. The MicroStrategy analytics platform is consistently rated as the best in enterprise analytics and is used by many of the world’s most admired brands in the. For details for creating a backup of your metadata, see KB441138. Open Command Manager and connect to the. Incentivized. Go to the following path: HKEY_LOCAL_MACHINE\Software\Wow6432Node\MicroStrategy\Data Sources\CastorServer . 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. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. 1. For customers on MicroStrategy 10. On the Audit tab, expand the Intelligence Server folder. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. MicroStrategy does not pass the report back and forth between the engines, returning to the SQL. 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. Run following SQL: Cloud. From the DSN drop-down list, select the DSN for your statistics and Enterprise Manager repositories. The most fundamental objects stored in the metadata are schema objects. The user can also write the SQL Trace to a new log file by selecting the option from the drop down. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. The destination project must be of the same or greater metadata version as the source project. x has the capability to authenticate and import users and groups from an existing LDAP Server into the MicroStrategy Metadata. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. Required Status to Perform Action. The project source is a configuration object which represents a connection to a metadata repository. MicroStrategy metadata. It is designed to help developers build data-driven client applications quickly and easily. 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. The Scan MD tool executes tests to detect inconsistencies in the metadata. MicroStrategy has a metadata-driven architecture. There's a reason we're at the top of the list. Open Windows Services and locate MicroStrategy Platform Analytics Consumer and MicroStrategy Usher Metadata Producer. Even if the Administrator user, re creates the folders with the same exact name, some of the out of the box objects might not work the same wayThis video will help you get started using the MicroStrategy REST API. It also has a more powerful and easy to use. In MicroStrategy 10. x metadatas that may prevent MicroStrategy 9. Enable SAML authentication for 2021 Update 1: In the Default Properties section of the Web Administrator page, enable SAML authentication and click Save. The Save dialog box opens. If necessary, enter the database you wish to use for this Narrowcast Server. From the DSN drop-down list, select the DSN used to connect to the metadata repository. If you are working on a report that has already been saved, a confirmation message appears. On Windows from the command line, perform the following steps: From the Windows Start menu, select Run. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. Click the link for the desired manual or other documentation source. Before running ScanMD, a database backup of the metadata must be made. This table is used for defining some property values which will be used in certain DS tables. 4. In the Navigation pane, click Users and Groups. For each project requiring database authentication: Open Project Configuration. Select Display Managed Objects. It will not show users whose number of jobs is 0. Go to the 'Schema Objects' folder. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. For 'Enabled=true' means the user is enabled in metadata while 'Enabled=false' means the user is disabled. In MicroStrategy Developer, the project source appears in the Folder List with an icon that varies depending on the type of connection it represents. This mode asks the user for information about the location of various. 2) Run the following SQL against Metadata Tables: Sql select PROP_VAL from DSSMDOBJPROP. The Datasets API family allows developers to push external data directly to the MicroStrategy Intelligence Server. There's a reason we're at the top of the list. The Scan MD tool searches for logical errors and fixes them within the platform object structure. x level and not on the cluster level. For example, users might want to create a dossier that shows all dossiers and the component datasets on dossiers. 825. MicroStrategy recommends that you always create the response file through the GUI mode of the Configuration Wizard. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. 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. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. 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. Start the Oracle Data Pump Export utility by using the expdp. Select Export Translations as a translation action and click Next. In this document, you will find a database function “MSTRUID” used in multiple places. A DN is the unique identifier of an entry in the LDAP directory. Cloudera CDH Hadoop Gateway System. x, MDMover should be used to migrate the Metadata database between database server. Follow steps below to find out all the Freeform SQL Reports in a project in MicroStrategy Developer: Go to Tools > Options > Enable "Show 'Contains' and 'Contained by ' tabs" as shown below: Click OK > Go to "Contains" tab and select Logical Table for "Contains any object of this type" as shown below: Then go to Object Types tab and select. | Meet MicroStrategy AI on the road. The following steps generate the application metadata ( SPMetadata. This opens a Quick View of the Intelligent Cube information and usage statistics. Overview of Freeform SQL reports. Ensure telemetry service is enabled by running below query in Command Manager: LIST ALL PROPERTIES FOR SERVER CONFIGURATION;Click Next. Follow these guidelines when you search by a. x metadata and the MicroStrategy Enterprise Manager 9. Click on OK to save the preferences. 825. x. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. 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. In order to get the user names, the metadata table DSSMDOBJINFO should also be referred, follow the below steps to get the user names by querying against statistics table IS_SESSION_STATS and metadata table DSSMDOBJINFO:. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. The NCS Authentication dialog box opens. Select Configure Intelligence Server, and click Next. To search for managed objects only, select Display Managed Objects Only. 93K KB428983: The “List_Server_Config_Properties_Outline” script in MicroStrategy Command Manager 10. That you can find from your metadata. 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. If you type Y and press Enter, all information in the existing metadata repository is overwritten when the response file is executed at a later time. The Metadata is where all the MicroStrategy definition is stored. This is necessary in order to properly set the Windows registry keys. comCreate a DSN using the steps below: Launch the MicroStrategy Connectivity Wizard. They typically consist of descriptions of dimensions. Launch the Configuration wizard and choose to create repositories then select metadata. In simple terms, it detects physical inconsistencies by running SQL against different metadata tables and then comparing. The utility is found under Program. Go to Database Instances > Authentication > Metadata. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. Dependencies. 4. Create an upgrade test environment by duplicating your production environment and production metadata. For a progress Postgre driver: InitializationString=SET SEARCH_PATH to 'test'. . 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. 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. MicroStrategy Workstation puts the full capabilities of your MicroStrategy environment just a couple of clicks away. Upgrade this test environment to validate the upgrade before using in your production environment. x products from functioning correctly. Enter user information in the Create New User dialog. . Cube details, projects, folders or events in the json request can be discovered by GUID or name, since MSCT will search the MicroStrategy metadata for the objects it needs to complete the request and find any missing data; Logging of all json request messages, updated versions of requests and status of requests that are executed;. Users can do it from MicroStrategy Desktop > Project Configuration > Statistics > General. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Before running ScanMD, a database backup of the metadata must be made. The Enterprise Manager metadata contains all the facts, attributes, hierarchies, metrics, filters, and reports that are predefined as part of the Enterprise Manager project. 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. With the default 300 seconds time-out setting, the end user will wait 120 seconds for the request time-out first, and then log. ”. For example, the login information for the History List database. In MicroStrategy Configuration wizard on Node-1, select the required DSN to connect to the metadata, as shown below: Select to create a new server definition or choose to use the existing server definition depending on the user's requirements, as shown below: Select the required projects to be loaded on startup, as shown below: Go through. Open the MicroStrategy Configuration Wizard. 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. Type N and click Enter to provide different. 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. Platform Analytics is a telemetry tool that supports telemetry capture from multiple MicroStrategy deployments simultaneously. MicroStrategy licenses are managed differently according to the license type that is purchased. A list of Web Preferences can be found in the MicroStrategy Enumeration EnumWebPreferences in the MicroStrategy Developers Library Java API Reference. This is a userStand out in a crowd. To set up MicroStrategy Intelligence Server. Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. Type, Subtype and extType parameters of objects can be used to narrow down the search. <. Note: MicroStrategy metadata will be created in the metadata2019 database in MySQL Server. 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. ACTION: This is working as intended. x - 10. This example assumes the metadata includes three projects that are using three different database instances with different DBMS and using different quoting patterns. You are now positioned to run the MicroStrategy Backup client. 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 access documentation resources on Windows. ), by default returns all tables in all databases and schemas. MicroStrategy has a metadata-driven architecture. ' (or something like that. From MicroStrategy documentation: "Project sources represent a connection to a metadata database or a MicroStrategy Intelligence Server. Enable users to interact with personalized chat for further product discovery. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Open the key named 'LOCATION'. You do not have to define users for every project you create in a single metadata repository. Select Metadata, History List and Statistics Repository Tables and click Next. MSTRPwd. Open both folders in which the user is located for each project source. log and MicroStrategy License Manager is the version of the base build installed in that machine. The following steps generate the application metadata ( SPMetadata. In the following sample code, several parameters must be adjusted to match environment specific values, such as project names and login information. Platform Analytics. Host Bill Safer helps you learn how to find that hidden antique or collectible that just may add cash to your life at either a yard,. The third most common microstrategy developer skill is templates on 5. Specify a name and location to save the response file, and click Save. This number is set from registry [HKEY_LOCAL_MACHINESOFTWAREMicroStrategyDSS. DSN: Select the data source name for your metadata repository. Browse resources on demand or contact support directly. A list of the users that belong to the selected group is displayed. x to 9. You can create the metadata repository in the database location of your choice. Click Next. Select Metadata, History List and Statistics Repository Tables and click Next. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. This approach makes it easier for you to specify a flexible partitioning. Transform description: This transform displays project status on the Projects page. You are returned to the Summary page. Follow steps below to achieve this: Connect the the metadata DSN from DB Query Tool. Click the folder icon to browse to and select a response file. In Windows, choose Start > Programs (or All Programs) > MicroStrategy Documentation > Product Manuals. x project, the attribute 'Schedule' stores information about schedule objects in MicroStrategy projects. xml file located in the WEB-INF folder of the MicroStrategy Web installation directory. 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. Access the database using MicroStrategy Desktop for Mac. MicroStrategy remains ranked #1 in Portfolio Capabilities in the 2023 edition of the BARC Score. Object Layer. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. use the function "Remove Duplicate Rows". Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. x). 825. MicroStrategyTo Execute a Script from the Command Manager Graphical Interface. x and additional columns are added to existing metadata tables to facilitate support for Internationalization, Metadata Auditing and Distribution Services. If the connection information to the MicroStrategy Repository has changed since the last installation, you are prompted to provide the database login username. x to PostgreSQL 9. Click Next. In Platform Analytics, application and schema objects are captured by the object attribute with the. On the General tab, type the following information:The PAConsumerConfig file consists of the following parts: paParentConfig: Common configurations for the Telemetry Server (Kafka) and Telemetry Manager (Zookeeper) across TopicsGroups. To import strings from the translation database back into the metadata, select the Import Translations option from the Metadata Repository page in the wizard. 0. " It is usually a file or database that describes another set of data or information. x, create a new report with the following definition: Attributes . Cloud. Database Instance. MicroStrategy | 4 4. You have the option to connect to. 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. In a server (three-tier) environment, Developer metadata connectivity is established through the project source. The Windows domain is the authentication authority. For information on how to create a Configuration Wizard response file, see. Enter the connection information for the SQL Server and click Finish. The objects stored in the metadata are reusable. Download the software from the MicroStrategy download site. 5/5 videos | 17M 9S total runtime. On the next screen the DSN information will be pre-populated. Open the Repository Translation Wizard. yaml. Hover over the Properties column and click Open Intelligence Server Administration Portal . Schema objects are logical objects that relate application objects to data warehouse content. MicroStrategy metadata is a repository that stores MicroStrategy object definitions and information about your data warehouse. x, select 'Preferences'. Become a More Intelligent Enterprise. Verify the components you want to upgrade and click Next . 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. The Search Options dialog box opens. Tables are created through the MicroStrategy Warehouse Catalog. This video walks users through the process of installing and running the mstrbak tool and how to use it. In warehouse partition mapping, a table in the warehouse associates attribute elements with the table names of the individual partitions. For each project requiring database authentication: Open Project Configuration. For information on how to create a Configuration Wizard response file, see. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Each login mode specifies a particular mechanism or authority to be used for authentication. The Scan MD tool searches for logical errors and fixes them within the platform object structure. Enter the following information for the rest of the text fields. x. 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. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend >and integrate the MicroStrategy business intelligence functionality into other applications. The version displayed in the DSSErrors. Create the statistics database instance. config. EXE ). Contact MicroStrategy Technical Support. Find an event in a city near you. Database requests from either the MicroStrategy metadata or the data warehouse; SQL generation; Analytical Engine processing (subtotals, cross tabulation, analytic functions). MicroStrategy Tutorial Reporting. Creating the Enterprise Manager project. Introduction The MicroStrategy Metadata (MD) is usually stored in an RDBMS and contains 3 sets of tables, namely: DSSMD* tables (this set of tables that start with. Select the Statistics & Enterprise Manager Repository check box and click Next. Change the system locale to English-US or another supported locale by running the command: ocalectl set-locale LANG=en_US. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Select Configure Intelligence Server, and click Next. In the Open drop-down list, type cmd and click OK. If you. ServerDefTo set up MicroStrategy Intelligence Server. Open a browser and access the SAML configuration page with a URL in this format: Copy. This GUID is created at the time of Metadata creation, and is unique to each metadata. The tutorial is composed of a MicroStrategy project, MicroStrategy Tutorial (a metadata and sample data are included). Type. 23K. Click on 'Browse . When this utility is run with no arguments, it launches a graphical application for creating and managing DSNs. Thus, while the engine attribute role option makes it more convenient to use. 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. Note: This setting has to be check for every MicroStrategy project logging statistics. MicroStrategy Integrity Manager is an automated report comparison tool. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. The Object Telemetry dossier contains a great deal of subscripton information. Chose IBM Cognos Analytics. Click Yes. Once a table is moved from left to right, its definition is saved in. x metadata Number of Views 2. MicroStrategy metadata. This approach makes it easier for you to specify a flexible partitioning. x does not return full c…What is MicroStrategy Metadata? The Metadata is where all the MicroStrategy definition is stored. ; Backup the database containing the MicroStrategy 9. The Back Up Database windows will open, ensure that Full is selected under Backup type. Named User Licenses, in which the number of users with access to specific. Select Metadata, History List and Statistics Repository Tables and click Next. 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. 0 - 10. Go to Database Instances > Authentication > Metadata. 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. In MicroStrategy, the metadata repository is a database that contains the definitions of database objects such as tables and fields in a way that developers and users can easily understand. From the Language drop-down list, specify the language in which to display MicroStrategy Web pages. idx index files; The Intelligence Server operating system platform. It is installed in the form of a MicroStrategy Object. MicroStrategy also supports using API calls to retrieve catalog information. In MicroStrategy 8. I have below following all the required. Launch the Configuration wizard and choose to create repositories then select metadata. Connecting to the metadata in DB Query tool shows all metadata tables, but no server definition can be found in the tables. 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. It is used by MicroStrategy Developer and other client interfaces to build, interact, and manage the contents of the MicroStrategy metadata. This example checks the preference WebPreferenceDpiConversion. 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. In the MicroStrategy 9. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. 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. Right-click on the project "MicroStrategy Tutorial" and select Project Configuration. 3%. The configuration is different in MicroStrategy Developer and in MicroStrategy Web as described below: MicroStrategy Developer: 1. Specifically, ODBC connects to. You can map columns to: Managed object attributes and metrics: Managed objects are created on the fly and only exist in the context of Freeform SQL. Warehouse Catalog. x, select 'Preferences'. Add the following parameter to the file: For a native Postgre driver: ConnSettings=SET SEARCH_PATH to 'test'. It connects to Metadata, downloads all needed information and creates four CSV files with information needed to visualize user structure. x. The metadata repository is a collection of tables that contain the definitions for nearly all MicroStrategy objects including database logins, server definitions, database instances. Only the database names listed in DBAdminConfig. Select Configure Intelligence Server, and click Next. Manually editing values in the MicroStrategy Metadata incorrectly may cause serious, project-wide. On the MicroStrategy Authentication page, type the username and password of a MicroStrategy system administrator. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. In the Source drop-down list, select Google. Find out the Object name from DSSMDOBJNAMES table, using object id found. MicroStrategy REST API allows browsing metadata objects. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. A Project Source can be created using the MicroStrategy Configuration Wizard or the Project Source Manager. The image below shows that the projects are of version 8. exe. Users are defined in the MicroStrategy metadata and exist across projects. A command prompt opens. 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. From the left, select General. 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. MicroStrategy Schema Modeling. Contact MicroStrategy Technical. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. This opens a Quick View of the Intelligent Cube information and usage statistics. In the image above, the SQL is being logged to. In the Source area, select the database instance for your Excel file. If the metadata server instance is shutting down unexpectedly, very likely a core file will exist in the MicroStrategy folder structure. 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. Create a database connection that points to the DSN. For each Table object, right click on the table and choose 'Search. Metadata is stored in a relational database with a predefined structure. KB442628: Platform Analytics Kafka Topics and mapping tables in MicroStrategy 11. You do not have to define users for every project you create in a single metadata repository. This KB article describes how on Windows and Linux systems. mdb. In MicroStrategy 8. For more information, see KB43491. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. " I-Server configuration error: "The metadata you selected has not been upgraded to the current version of Intelligence Server. 0. Proactive. Then click 'OK'. MicroStrategy environments prior to MicroStrategy 2020 use MySQL. KB441192: Configuration Wizard fails when configuring the MicroStrategy Intelligence Server 10. A database connection supports connecting to data sources through the use of DSNs, as well as through DSNless. Login, Full name and Email address of the new user, and a Description. The following steps describe how to delete Data Source Names (DSN) on a Unix machine in MicroStrategy 9. Starting Oracle Data Pump Export. Watch this video on how to upgrade the Microstrategy 10. Set up the Enterprise Manager. Object layers contain and store the objects created in MicroStrategy. Edit the line within the function that takes your login input. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. properties file stores the values of how often caches are loaded into memory. It also stores other types of objects that. Open the MicroStrategy Configuration Wizard. In the screenshot above, the SQL is being logged to the metadata SQL. This table is used to store binary data like image/video. The Repository Translation Wizard allows users to set flags in the translations table to control which strings are imported back into the metadata. Platform Analytics provides an out-of-the-box dossier, Subscription Analysis, which can show statistical information and usage trends for subscriptions. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. In this instance, find the one associated with SQL Server. So in most scenarios, deadlocks in the MicroStrategy metadata are overcome since the transaction will be retried 3 times. usherServerConfig:. Copy the JDBC driver to a folder on the local Mac machine. To access the configuration page, you need admin privileges. 1) Connect to Metadata through DB Query Tool or other SQL tool. KB484282: MicroStrategy Db2 connection times out after Db2 backup and restore. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. 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. Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. MicroStrategy Backup Preparations. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. The results will appear in grid which is more readable.