Refer to the following MicroStrategy Knowledge. 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. log and contact MicroStrategy Technical Support in this case. The MicroStrategy system uses the metadata to know where in the data warehouse it should look for information. Project default level preferences are set at the MicroStrategy Intelligence Server 8. Configure Intelligence Server with restored metadata with Configuration Wizard 8-2. Data loading. If MicroStrategy Platform Analytics was selected in a previous installation, it is automatically selected in Select Components. In the Source area, select the database instance for your Excel file. In MicroStrategy Desktop > Administration > Configuration Managers > Database Instances, edit the Database Instance associated to the DSN then select the Database connection associated to the DSN and. In simple terms, it detects physical inconsistencies by running SQL against different metadata tables and then comparing. Creating the Enterprise Manager project. In the screenshot above, the SQL is being logged to the metadata SQL. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Please contact Microstrategy Technical Support if you still need further assistance. 4. To create a metadata repository. Mapping columns to metadata objects. 4. This raw data must be processed further to support administrative analysis and reporting requirements. In MicroStrategy 10. Step 1. Once a security filter is created for. Once the data has been pushed to the Intelligence Server, developers can use the Cubes API or the Reports API to manipulate. ForaLinuxinstallationandWindowscustominstallation,onlytheselectedcomponents' correspondingwarehouseisinstalledinMicroStrategyRepository. x metadatas that may prevent MicroStrategy 9. MicroStrategy also supports using API calls to retrieve catalog information. Open the key named 'LOCATION'. In the following sample code, several parameters must be adjusted to match environment specific values, such as project names and login information. Introduction to the REST API. Select an Environment from the upper-left drop-down. SQL scripts transform the statistics data into a form that can be useful for administrative reporting. I know which tables to query because I googled it and I found this blog entry, but I don't know. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. xml) for configuring SAML. The steps to create the MicroStrategy metadata are: Open the MicroStrategy Configuration Wizard ( macfgwizw. Click Next. KB442629: How to check topic data in Linux for MicroStrategy Platform Analytics 11. Option 2: Upgrade using MicroStrategy MDUpdateUtil Tool. Open the MicroStrategy Configuration Wizard. Open the registry on the machine where users installed MicroStrategy Intelligence Server. It does this by providing light-weight JSON data that is easy to consume because it includes raw data without direct. To search for managed objects only, select Display Managed Objects Only. There's a reason we're at the top of the list. Double-click a project source name (PSN). Find the folder 'Version Update History' and collect a screenshot of showing all the entries within that folder. Set Data Retrieval Mode to the setting Allow Native API at the report level: 2. 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. Hive. comCreate a DSN using the steps below: Launch the MicroStrategy Connectivity Wizard. For information on how to create a Configuration Wizard response file, see. Type N and click Enter to provide different. Although it is possible to use the Microsoft Access database. Right-click each service and select Stop. yaml. Third Party Software Installation Warning: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. 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. Open the MicroStrategy Configuration Wizard. cube files corresponding to the cube instance ID; The complete set of *. Select Configure Intelligence Server, and click Next. These objects are reusable for all products. Server definitions can be listed, created, and set for use with a MicroStrategy Intelligence Server 9. Transform description: This transform displays project status on the Projects page. 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. /mstrcfgwiz. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. The DSN and Login ID are provided based on the server configuration that you did previously. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x to PostgreSQL 9. Additional information regarding where the enterprise manager dataload is failing can be obtained by tracing the SQL during dataload. Then click 'OK'. Collect this file along with the DUMMYMDT DSSErrors. Access MDUpdateUtil. The API exposes a way to fetch data using HTTP requests such as POST, GET, and DELETE. Run following SQL: Cloud. Backing up and restoring metadata on a cloud environment. 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. web. It also has a more powerful and easy to use. Change the system locale to English-US or another supported locale by running the command: ocalectl set-locale LANG=en_US. The information is stored in a proprietary format within a relational database. If necessary, enter the database you wish to use for this Narrowcast Server. Within the Registry Editor go to: 32 bits: HKEY_LOCAL. 2. These two tables are introduced for mobile push notification to store information for mobile device key. On Metadata Repository Connection Information, click Apply. The metadata maps MicroStrategy objects—which are used to build reports and analyze data—to your data warehouse structures and data. 842 views. Defining DSNs. ; Create a new Data Source Name on the MicroStrategy Intelligence Server 9. From the Home menu, select one of the following: To save a report, select Save. Stop the MicroStrategy Web application server. There's a reason we're at the top of the list. Click "Next". x, select 'Preferences'. Click Configure Intelligence Server. MicroStrategy metadata. The Object Telemetry dossier contains a great deal of subscripton information. 3. MicroStrategy Intelligence Server connects to several databases (at a minimum, the data warehouse and the metadata repository) to do its work. Create a database connection that points to the DSN. MicroStrategy Integrity Manager is an automated report comparison tool. There are a lot of opportunities from many reputed companies in the world. 4. Always upgrade the Intelligence Server before upgrading client applications such as MicroStrategy Web, Mobile, Library, and Developer. The Python script below was written for that purpose. Windows NT authentication: The Windows NT SID. For steps to create a project source, see the. Go to Project access, to give Public/Guest basic access to the project. Create a new DSN using the new connection from step 1 using MicroStrategy Connectivity Wizard. The password of a metadata user with full administrative privileges (Administrator is recommended). The project source is a configuration object which represents a connection to a metadata repository. From the DSN drop-down list, select the DSN for your statistics and Enterprise Manager repositories. You do not have to define users for every project you create in a single metadata repository. A list of. Click Next to begin. 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. The Search Options dialog box opens. 0 and above Topic location: C:Program Files (x86)MicroStrategyMessaging Services mpkafka-logs. mstrio: Simple and Secure Access to MicroStrategy Data . , Unified. ODBC is a standard method of communicating with database servers. If you're looking for MicroStrategy Interview Questions for Experienced or Freshers, you are in the right place. Deleting a project from the MicroStrategy metadata can be achieved by using the Delete method of the IDSSDelete interface, supported by the DSSDataSource object. To restore a specific cube, MicroStrategy requires: A database backup of the metadata (to preserve the project ID); The two . Click 'Browse. The Repository Translation Wizard allows users to set flags in the translations table to control which strings are imported back into the metadata. User Name: Type the user name for the user that can connect to the data source. 0 and above. So I want to create an embedded query to know which last objects were modified by an user and that sort of things. x when configuring Intelligence Server via Configuration Wizard on Windows OS to point to a metadata in PostgreSQL 9. x warehouse and statistics tables. Click tab 'Display' and select 'Results to grid' in the dropdown list. KB205798: How is information about subscriptions stored in the DSSCSPSNLZTN Metadata table in MicroStrategy 9. Report SQL, report data, and graphs can be executed and compared in Integrity Manager to help customers verify change success. TABLES view contains one row for each table or view in a dataset. Select Metadata, History List and Statistics Repository Tables and click Next. *; import com. Glossary . metadata_connection_string The connection string Intelligence server uses to connect to the metadata database. The modeling tool allows architects to transform a complex enterprise data environment. yaml are backed up by this tool. The Snowflake API call we used, for example, get Tables (null, null,. Open MicroStrategy Desktop, Click Add new Data -> Database -> Add new data source. Specifically, ODBC connects to and transfers. The MicroStrategy configuration wizard is used to upgrade the metadata from 8. 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. Select “MicroStrategy SDK”. bat. Scorecards, dashboards, and reports can be explored and delivered on desktop, the Web, mobile devices, and the Cloud. Launch the Configuration wizard and choose to create repositories then select metadata. Add the following parameter to the file: For a native Postgre driver: ConnSettings=SET SEARCH_PATH to 'test'. From the DSN drop-down list, select the DSN used to connect to the metadata repository. xml) and SAML configuration files ( MstrSamlConfig. On Windows from the command line, perform the following steps: From the Windows Start menu, select Run. Related articles from the Community: Knowledge Base: Troubleshooting Metadata Upgrade Issues; Knowledge Base: How to upgrade. This is a Microsoft Access file called "EM_Proj_MD. xml) and SAML configuration files ( MstrSamlConfig. 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. MicroStrategy Tutorial Reporting. The users' Partition Mapping Table appears in the left window. The queries can be modified syntactically for other databases. The Backup file can only be restored to environments with the same or higher version numbers. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformScan MD. /mstrcfgwiz. For more details about implementing single sign-on in MicroStrategy, see Enabling Single Sign-On Authentication. On the File menu, point to Connect, and then choose Narrowcast Metadata. Connect the metadata update utility to a two-tier project source whose Data Source Name (DSN) points to the metadata. The Enterprise Manager metadata contains all the facts, attributes, hierarchies, metrics, filters, and reports that are predefined as part of the Enterprise Manager project. In the menu, go to 'Tools -> Options'. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. Enable users to interact with personalized chat for further product discovery. ImpalaThe failure point is indicated in the Enterprise Manager Dataload log, mstrmigration. MicroStrategy uses the credentials provided by the user to search for and validate the user in the LDAP directory. Delete the first and the last line of the web. Click the folder icon to browse to and select a response file. You can run MicroStrategy Backup in one of three modes and, depending on the mode you select, running the MicroStrategy Backup client will differ. 54K KB35860: MicroStrategy Object Manager is unable to migrate subscriptions from one environment to another. After you install an ODBC driver, you can define one or more data sources for it. Create an Amazon Redshift DSN using the MicroStrategy Connectivity Wizard. x has the capability to authenticate and import users and groups from an existing LDAP Server into the MicroStrategy Metadata. Click the folder icon to browse to and select a response file. You can find the list of supported RDBMS. Although it is possible to use the Microsoft Access database. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. It also stores other types of objects that allow you to access that information. Connect the metadata update utility to a three-tier project source pointing to the UNIX Intelligence Server. 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. EXE ). List of metadata repositories tables for MicroStrategy 10. Watch this video on how to upgrade the Microstrategy 10. It is a database where the whole “skeleton” of the tool is located. x to 9. Database Instance. Connecting to the metadata in DB Query tool shows all metadata tables, but no server definition can be found in the tables. From the Windows Start menu, go to Programs > MicroStrategy Tools > DB Query Tool. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. The MicroStrategy architecture is a meta-driven type where metadata is the central repository of all the objects and can be used by all of the MicroStrategy products. The RDBMS for the metadata and warehouse do not need to be the same. Attempting to access /MicroStrategy or /MicroStrategyMobile should redirect the user to first authenticate. x and later. Locate the web. MicroStrategy Tutorial Reporting is a sample MicroStrategy project with a warehouse, and a set of demonstration dossiers, reports, and other objects, designed to illustrate the platform's rich functionality. Number of Views 8. *; This customization is provided as a convenience to. This is any location on the Linux or Windows machine where the backup file is written. In warehouse partition mapping, a table in the warehouse associates attribute elements with the table names of the individual partitions. The REST API is designed to help developers build data-driven client applications quickly. Under Desktop/Developer browsing options, choose 'Display hidden objects'. Intelligence Server uses ODBC to connect to and communicate with all database servers in the system. TABLES WHERE table_schema = "TEST_md" Database Administration Tool. Manage and Verify Your Licenses. x. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. With a backup of the metadata in place, proposed fixes should only be accepted if the full impact of the fix is understood. Select the object that will replace the dependee, the object type must be the same. Defining DSNs. For each Table object, right click on the table and choose 'Search. For a Linux DSN. Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. When setup successfully, it is recommended to follow. On the metadata Connection page, enter the database password to access the MicroStrategy metadata. On the Select Components page, select the check boxes for each Intelligence Server you want to upgrade. x, select 'Preferences'. Click the link for the desired manual or other documentation source. Configure Metadata Connection. Click the New User icon on the toolbar. Become a More Intelligent Enterprise. In the Platform Analytics directory, located in C:\Program Files (x86)\MicroStrategy\Platform Analytics\, open the bin folder. MSTRInstallPath: By default, on cloud environments it is /opt/mstr/MicroStrategy/. You then save and publish it as an Intelligent Cube. Open the MicroStrategy Configuration Wizard. 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. This mode asks the user for information about the location of various. The version displayed in the DSSErrors. The Metadata Update Utility is a utility responsible for updating the metadata with the latest project information based on the version of MicroStrategy Developer from the machine on which the utility is installed and. 1, you must. Third Party Software Installation: WARNING: The third-party product(s) discussed in this technical note is manufactured by vendors independent of MicroStrategy. Click on OK to save the preferences. The below are examples for a few of the common metadata database platforms. x. The Intelligence Server can now be pointed to any desired Metadata by using Configuration Wizard. Required permissions. Launch Configuration Wizard and choose to create repositories then select metadata, you will see a page includes fields to define how to create your metadata tables and where they should be stored. 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. Open the terminal and run the command locale to check the current system locale. In my opinion, MicroStrategy has a better product architecture. When this utility is run with no arguments, it launches a graphical application for creating and managing DSNs. And by this, I mean all objects: Attributes, tables, names, users, states, object information, etc. On the Metadata Connection page, enter the database password to access the MicroStrategy metadata. 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. The DSN and Login ID are provided based on the server configuration that you did previously. Navigate to the Security tab and configure the following parameters. Select Configure Intelligence Server, and click Next. Metadata Doctor (MD Doctor) is a utility that detects and fixes certain physical inconsistencies in MicroStrategy 9. 825. Additional DSNs require the same credential and server location as the metadata. . x to PostgreSQL 9. Open the Workstation window with the Navigation pane in smart mode. Go to the following path: HKEY_LOCAL_MACHINE\Software\Wow6432Node\MicroStrategy\Data Sources\CastorServer . Configuration Wizard fails when configuring the MicroStrategy Intelligence Server. A list of user groups that reside on the Intelligence Server appears. The Metadata is where all the MicroStrategy definition is stored. 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. This is necessary in order to properly set the Windows registry keys. ”. " I-Server configuration error: "The metadata you selected has not been upgraded to the current version of Intelligence Server. ; Restore the backup from step two into a new database. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. When a Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. 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. This chapter addresses the processes necessary to. If you use Windows NT/2000 or later as. Starting in MicroStrategy 2019 it is possible for administrators to track the state and usage of subscriptions through Platform Analytics. From the left, select General. 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. Connecting to the MicroStrategy Metadata. As a reporting and analysis platform, MicroStrategy allows developers to build reports and dashboards using an integrated development tool for all capabilities. Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. Steps to enable Scheduler: Open Developer. Click Next. And by this, I mean all objects: Attributes, tables, names, users,. Prompts guide you through testing your ODBC. The MicroStrategy Intelligence Server 9. WCCA, Worcester, Hidden Treasures. For information to create the language, see the product manuals. Unlike major releases and service packs, hotfixes and patches are differential updates of the product, meaning that only a few of the binaries are rebuilt and re-stamped with the hotfix or patch version. 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. 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. The project default level preferences are accessed by the Web server at connection time. 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. Find MicroStrategy’s public API in Postman and make your own copy (Fork). This KB article describes how on Windows and Linux systems. MicroStrategyTo Execute a Script from the Command Manager Graphical Interface. Now available for feature release—MicroStrategy 10. From the Tools menu in MicroStrategy Developer 9. In MicroStrategy Developer, the project source appears in the Folder List with an icon that varies depending on the type of connection it represents. A command prompt opens. 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. You are now positioned to run the MicroStrategy Backup client. 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. After you find the microstrategy. Ensure telemetry service is enabled by running below query in Command Manager: LIST ALL PROPERTIES FOR SERVER CONFIGURATION;Click Next. 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). , Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the, metadata. ODBC is a standard method of communicating with database servers. Follow these guidelines when you search by a. Open the MicroStrategy Configuration Wizard. MicroStrategy has a metadata-driven architecture. Right click the database and under “Tasks” choose “Backup”. Use the project duplication function to duplicate only the Tutorial project to your metadata. a lookup table. 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. MicroStrategy is configured, and a user is able to run the report and retrieve the data via ODBC. However, due to the slow performance of Snowflake driver’s metadata operations, this option is generally not recommended. For example: Some objects' dependencies cannot be searched or do not appear through Desktop, like a Database Instance. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. This opens a Quick View of the Intelligent Cube information and usage statistics. It will not show users whose number of jobs is 0. util. This file can be found under the Program Files -> Common Files -> MicroStrategy ->Log folder in a Windows Machine. ; Go to Connection Type > Direct (2-tier), and click Next. Overview of Freeform SQL reports. x, fact tables may be partitioned using warehouse partition mapping tables or metadata partition mapping tables. Select the table that was created in Step #1 (or the lookup table where the Last Month column was added). 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. Access the database using MicroStrategy Desktop for Mac. Go to the. This example checks the preference WebPreferenceDpiConversion. The Back Up Database windows will open, ensure that Full is selected under Backup type. This video shows how and where to check the latest MicroStrategy release. It is designed to help developers build data-driven client applications quickly and easily. Create an empty metadata shell in a Microsoft Access file. x. Open the ODBC Administrator and edit the pre-created Amazon Redshift DSN. Open the MicroStrategy Configuration Wizard. Defines whether to upgrade the metadata, as determined by the following. MicroStrategy metadata is like a road map or an index to the information that is stored in your data warehouse. Identify those objects in their own folders. The DSN should provide a unique description of the data, for example, Payroll_Project_Metadata or Payroll_Warehouse. With these files, Technical Support can execute reports or documents that have corresponding caches without having to connect to your data warehouse. MicroStrategy ranks #1 in the Analytics Developer use case in Gartner's 2023 Critical Capabilities report. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For information on how to create a Configuration Wizard response file, see. There's a reason we're at the top of the list. The following information assists you in setting up ODBC between Intelligence Server and your metadata database and data warehouse. 2 Enterprise Architecture Enterprise Architecture consists of a two to eight node highly available cluster for MicroStrategy Intelligence Server, Web, Mobile, Collaboration, and Identity. x and additional columns are added to existing metadata tables to facilitate support for Internationalization, Metadata Auditing and Distribution Services. Operations cannot be performed from a newer metadata to an older one. The user should locate the last <Setting> XML entry in the file similar to the following entries:<Setting>MicroStrategy is an enterprise BI application software. In MicroStrategy 10. Browse resources on demand or contact support directly. Runs the client in Prompted mode. 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. MicroStrategy - Architecture. 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. From the Metadata drop-down list, specify the language in which to display the. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. How to display a list of users that are currently enabled in the MicroStrategy metadata using MicroStrategy Enterprise Manager In MicroStrategy Enterprise Manager 9. ), by default returns all tables in all databases and schemas. This table is used to store binary data like image/video. Metadata is stored in a relational database with a predefined structure. Incentivized. Step 2. x, the correct results were shown even if a user activity metric was on the report. If you are configuring MicroStrategy on: Windows, go to Start > Programs > MicroStrategy Tools > Configuration Wizard. 3% of resumes. The destination project must be of the same or greater metadata version as the source project. KB484282: MicroStrategy Db2 connection times out after Db2 backup and restore. The Object Telemetry dossier contains a great deal of subscripton information. The following. " It is usually a file or database that describes another set of data or information. All articles. In MicroStrategy 8. Only executions related to subscriptions will have a valid recipient. From the DSN drop-down list, select the DSN used to connect to the metadata repository. x products from functioning correctly. The module consists of a MicroStrategy project in a metadata, a reference guide, and a default data model. The value of this key is the name of the DSN that MicroStrategy Intelligence Server uses to connect to the Metadata. Forexample,ifyoudon’tC. There is a dialog that includes fields to define how to create your metadata tables and where they should be stored. ) 3. It is used by MicroStrategy Developer and other client interfaces to build, interact, and manage the contents of the MicroStrategy metadata. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. Enter the User Name and Password for the database. The Freeform SQL functionality allows you to use your own SQL statements to generate reports, instead of using the MicroStrategy Engine-generated SQL. In general, report creation in MicroStrategy is. MicroStrategy environments 2020 and onward use PostgreSQL.