location_path is the folder where the attribute resides, of type string, between double quotes ("). x, the warning message that follows is faced during the project duplication across two different metadata repositories from 3-tier in a Microsoft SQL Server 2008 R2 instance to 2-tier in a Microsoft Access 2007 instance: Operation must use an updatable query. Click the Connect button to launch the connector. Duplicate this new empty project P1 from the Source to the Destination environment, selecting in the configuration ONLY the affected user and the ADD Option. x:. FOLLOW THESE STEPS: Create Object Manager Package: 1. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. Rename objects within a project. 3. Refresh. Delete objects within a project. This tech note explains how to avoid that after duplicating a project into another project source via MicroStrategy Developer 10. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. Deploy the ojdbc8. (the target objects of those shortcuts) to the new project. There's a reason we're at the top of the list. If the version is different and only project GUID is the same, the two projects are taken as different version of one same project and the operation would succeed. A warning message like the following can be observed:. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. Using Object Manager, you can copy objects within a project or across projects. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. e. In MicroStrategy Developer 10. 1. Project Comparison looks at each object ID in the source project, and compares it to the object in the destination project with the same ID. It is recommended that, if you plan to try the Tutorial - Delivery sample project to learn about Narrowcast Server, you perform the Click Modify to open the Properties dialog box: Security tab. AuthenticationMode: the authentication mode used to connect to the project source, either Standard or Windows. Drag and drop objects from the Object Browser into the Create Package dialog box. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. How to duplicate the Project:- Object Manager in MicroStrat…In MicroStrategy Desktop, log onto the source project containing the project to duplicate and. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. Search for objects within a project. Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. Step 3. From the Select a Project drop-down list, select the project for which to assign the security role. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. 2. x-10. From the Warehouse Tables pane, right-click the table to add to the project and select Add Table to Project. Specify the port number where the SMTP server receives incoming e-mail. The same report accessed in web. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. Click on 'Browse . SYMPTOM: When trying to do a project duplication selecting the options to migrate subscriptions for the users being migrated, the subscriptions do not get migrated. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. If an Universal version of the Intelligence Server is used, the Query Engine is a 64-bit component and will not encounter the same memory limitation as the 32-bit version of the Query Engine that. Starting in MicroStrategy 9. There's a reason we're at the top of the list. Using Object Manager, you can copy objects within a project or across projects. In the source metadata, create an empty. An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x. There's a reason we're at the top of the list. 'Product 02' is licensed for 0 named users. 3. This document shows how to create a MicroStrategy Object Manager package to prevent a dependent object from being migrated over. To export a document template. 4. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. 1 - 10. The duplicate connection is automatically created and displayed in the Database Connections panel. The following window appears. Go to Menu -> Tools -> Options. If all of the required conditions to import multiple copies of the table (listed in Supporting duplicate tables in multiple data sources ) are met, an Options dialog box opens. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In the Project Source Manager click on 'OK' to exit the window. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. Create a configuration package with user and/or user group objects and set their Action to Replace. In the Project Duplication window, the hang appears to occur after finishing the property set objects. In the menu bar, go to Tools > Preferences. x and later. x, all users are able to see. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. x. use the function "Remove Duplicate Rows". Twenty-seventh Edition, version 9. Step 2: View the Dockerfile in your project folder. Delete option is performed on the Intelligent Cube, and data is not compared with the warehouse. 4. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Options in this portion refer to creating the Platform Analytics project on this machine. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. 0. Specify the project source of the project to be duplicated in the Direct Project Sources section. 6. x-10. After loading, MicroStrategy will present a window like this. with the MicroStrategy sample project called Tutorial - Delivery. with the MicroStrategy sample project called Tutorial - Delivery. 1 Hotfix 7, if a user navigates to the "Shared Reports" folder, then clicks on the top left MicroStrategy Startburst icon, and navigates to "My Reports", the page will reload, but the page will still show the contents of the “Shared Reports” folder. If an Universal version of the Intelligence Server is used, the Query Engine is a 64-bit component and will not encounter the same memory limitation as the 32-bit version of the Query Engine that. The Allow URLs to Export setting allows administrator's to specify the only URLs and URL paths that can be exported to PDF or Excel. To add the dependents of all objects to the package, click Add all dependents. The following procedure describes how administrators can enable or disable Change Journaling for all projects within a project source: In MicroStrategy Developer, log into a project source. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. After deleting the incomplete project, the duplication. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformI am new to the Microstrategy, I need some tips to do my task involves change of fact table in a project. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. For project: MicroStrategy Tutorial number of cubes:21 Info for cache: Actual vs Forecast Performance Cube Status: Ready Loaded Filed Active Info for cache: Copy of CrimesInLondon Status: Imported Ready Loaded Filed Active The example provided in this document is provided “as-is” to the user and assumes that the user:. . Select the element, and go to Menu -> Custom Group -> Show Display Options, as shown below: Select the last option "Show the element names, individual items within this element and also, expand these individual items if possible",. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. Detail Levels You can now select the level of detail exported from your dossier. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. From the command line: MicroStrategy provides a command line utility for importing update packages. In the Navigation pane, click Users and Groups. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. pimiento. 2. A document with ‘Year’ in Grouping, and attribute ‘Year’ in row, metrics ‘Revenue’ and ‘Cost’ in column as shown below: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 merging or removing duplicate columns. x. 5. The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. SYMPTOM: Project. When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. Example: #Todumpalldatabases pg_dumpall>db. Right-click a project in that project source and select 'Compare projects' or select. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. This issue has been addresses in MicroStrategy Developer 10. Click in “Add new data”. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThe following procedure describes how to merge users from two different metadata repositories using the Project Duplication Wizard in MicroStrategy Developer. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. 0. MicroStrategy - Object Manager - Online Training Video by. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. Under the Tools menu, select Project Documentation. In the source project, all dependents of the report are stored in the Public Objects\Report Dependents folder. SYMPTOM: When trying to do a project duplication selecting the options to migrate subscriptions for the users being migrated, the subscriptions do not get migrated. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results Pane -> Results -> To Text; Copy Application and Schema Objects. Select from the following: To duplicate the database connection, click Duplicate. Click the “Select File” option. The hang will only occur when the database instance. See full list on Duplicating Projects. Note the project source that connects the Intelligence Server. KB38452: What can cause profile folders to get duplicated after a MicroStrategy Developer Project Duplication? Number of Views 916. 0. To delete a dossier, right-click it and choose Delete. by clicking the lock icon for the project. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. Object Manager and Project Merge both copy multiple objects between projects. Right click a project and select Duplicate Project. x and how duplicate columns can be created. You cannot move Project A objects to an exact copy of Project A. Another option when running a report inside MicroStrategy Web is to select the REPORT HOME dropdown, which will allow a user to access the sharing options. There's a reason we're at the top of the list. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. ProjectsTransformCustomStatus. The Security Role Editor opens. Go to Connection Type > Direct (2-tier), and click Next. In the Device Editor, click the Delivery Options tab. 2987. Create a Custom Group with only one element "Year In list (2010)" in MicroStrategy Developer. Intelligence Everywhere ; Talk to an expert ; Get startedThis knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. While Technical Support can help to resolve these issues, the user would like to know how to avoid them in the future. Step 8: Change the migrating objects to the following:. Duplication is the only way to get the projects into another environment. This is a short walk through of the main Object Manager uses including project duplication and project object change and management between different instances of the project Dev - Test - Prod. In the New Metric Editor, manually add the metric definition using this expression: max (<attribute>@<form>) {~} The new metric below will display the DESC column of the Country attribute and was created using the metric. Line 2 qty_sold number is updated. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. MicroStrategy provides modern analytics on an open,. DSSErrors. 2. new_desc is the new description of the attribute, of type string,. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in. Import the document into the replacement project. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Click in the right pane. Companies of all sizes use this platform to assess, visualise, and build dashboards. This is by design. 4. Plus, it connects business apps while integrating data. After duplicating a project in MicroStrategy Developer which uses LDAP Authentication, subscriptions may be missing. Alternatively, click Add and the Add Objects window opens. exe". UNLOCK PROJECT project_name [FORCE]; where: PROJECT "project_name" is the name of the project to be unlocked, of type string. Copy and Paste them into the MicroStrategy Common Files Directory: C:Program Files (x86)Common FilesMicroStrategy; Section 6: Load images into the MicroStrategy Web and Mobile Servers. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. Specify the. Sainsbury’s, a leading UK retailer deployed a comprehensive suite of applications that deliver best-in-class analytics experiences—powered solely by Snowflake, AWS, and the MicroStrategy Cloud. 1. 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 executed. Expand the My Personal Objects folder, and then open the My Reports folder. There's a reason we're at the top of the list. /mstrcfgwiz. NOTE: Only users with administrative privileges are able to select this option. Type "regedit. Double-click the security role you want to assign to the user or group. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. 1. x and later. See To copy a document between projects for a detailed procedure. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformChoose a project, right click on it and select “ Duplicate Project” 2. Click on Create Project and Give suitable Project name and Click OK. log has the following entries: The steps below desmonstrate how to use the project duplication in command-line mode: Go to Start > Run, and type in "cmd. Learn on how to create filters in Microstrategy Web (dossier), both page level as well as global filter. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. Create a new dossier, add new data, use Clipboard and input the sample data as below. In the MicroStrategy system, every object has an ID (or GUID) and a version. This can be achieved as follows: Connect to a project. In this scenario, you typically use three environments: development, test, and production. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. Input connection parameters for the connector:Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Thus, the report has been moved to another folder within the same project. Click Next and Finish. To create the Enterprise Manager project, run Configuration Wizard on the MicroStrategy Intelligence Server machine that uses the Metadata where the project should be created, and select the Create Enterprise Manager project option. The users and the user groups from the source environment will be copied over to the destination environment along with the empty project (which can be deleted at a later time). DSSCSADDRESS'. For information about Object Manager, see Copy Objects Between Projects: Object Manager. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. " Microstrategy developers also use communication skills in their role according to a real resume snippet: "created various dashboards using report studio and implemented portal communication in the. Follow Steps 1 to 10 to decide the parameters of the duplication process . Choose the individual modules to be logged. Copy objects within and across related projects. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. Go back to MicroStrategy Desktop, right mouse click on the project -> Search for Objects. Assuming that the statistics tables have already been created in the. 4. These updates are intended to help our customers keep their. Select 'Export Project Schema. To do so, you can take advantage of URL API. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. Hey even if it doesn't work you can unload and load the Project that's definitely works. In this scenario, you typically use three environments: development, test, and production. 6. Using the Connector. Drag and drop the objects into the report grid. 4. Perform a manual data load again using MicroStrategy Enterprise Manager; Run a report in the MicroStrategy Enterprise Manager project with the 'User' and 'Report' attributes on. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). 4. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. Click Add, select the elements, then click OK. Move objects within a project. This is a known issue in MicroStrategy 10. 3. MicroStrategy recommends that if you want to copy objects between two projects. KB13782: After duplicating a project in MicroStrategy Developer 10. When using the project duplication wizard in Developer to duplicate projects within the same project source, the option 'project-related users and group only' is disabled as shown below:To create a project source which connects to your data through Intelligence Server, see the Configuring and Connecting Intelligence Server chapter of the Installation and Configuration Help. x from the command line by using the following command:. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Review any messages displayed when attempting to import a copy of a table from a different data. Enter a name and description for the new security role. 1. exe", the syntax is: ProjectDuplicate. For Oracle 12. Update/Update only option does not compare all the attribute elements. From the Select a Project drop-down list, select the project for which to assign the security role. In MicroStrategy Web, users can import data from different data sources, such as a database or the results of a SQL query, then create reports, documents, and dossiers to report on their imported data. If one of the attributes is removed from the template, the Cost is aggregated. MicroStrategy 10 will report the following errors if the path specified in Project Configuration>Intelligent Cubes>General>Intelligent Cube file directory is not accessible:Detail Levels You can now select the level of detail exported from your dossier. In this scenario, you typically use three environments: development, test, and production. Select the “File from Disk” option. spicehead-tvkpqyiu. ACTION: Close the project source in MicroStrategy Object Manager to the MicroStrategy Tutorial metadata and then the user has the option of performing the duplication by clicking on Project -> Duplicate Project from the Object Manager menu as shown in the image below instead of MicroStrategy Developer if desired:Choose one of the following options: List all elements (no restriction): This option displays all of the attribute's elements to the user when he is answering the prompt. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command:During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. This will produce an html document containing the search results and any information that is selected about those objects. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. x, execute the following steps: Connect to the project source and expand the project that is to be duplicated, as shown below: Right-click on the project name and. Companies of all sizes use this platform to assess, visualise, and build dashboards. Step 5. Case() and CaseV() functions are Analytical Engine functions, i. DELETE PROJECT "[Project Name]"; Verify that in 3-Tier you dont see any duplicate project names. In MicroStrategy reports, attributes are identified by the column headers of the reports. A Dockerfile describes what goes into a. From the Schema menu, select Create New Project. Once logged on, expand the administration icon in the Folder List and browse to the Database Instance Manager. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. Right-click on the Project Source and choose 'Intelligence Server Configuration'. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. 2 release, the driver file is called odbc8. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThis is an example of how to achieve Option 2 using MicroStrategy Tutorial project in 3-tier, keeping the same Database Instance and Database Connection but changing the DSN. 3. Duplicate projects and Intelligence Servers appear in MicroStrategy Web. 2. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!Projects are related if one of the projects was created as a duplicate of the other. 11, during project duplication process between different metadatas, if objects "users and user groups" selected as 'None', the user password will be reset to the same one as the original project source after duplicate completed. The Security Role Editor opens. Navigate to the folder to save the file in, then click OK. The users and the user groups from the source environment will be copied over to the destination environment along with the empty project (which can be deleted at a later time). exe) is a utility responsible for updating the metadata with the latest project information based on the version of MicroStrategy Desktop from the machine on which the utility is installed and executed. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. Creating a new project at the Source environment called P1. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. pkg. For multiple projects, add brackets with each project name in quotations separated by commas. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. For managed objects, navigate to the Administration menu, and select ProjectDelete unused managed objects -- if necessary . The important thing here is we do this in 2-Tier or Direct mode. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. Select the Members tab. 5. In. This is because. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. )To create a project update package, copy the file createProjectPackage. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. From the Home menu, select one of the following: To save a report, select Save. 1. Open both folders in which the user is located for each project source. jar file to i-server machine. Add the following to the code: public void renderProjectStatus. Step 4. 8-2. ConnectionMode: - 2-tier for a direct (2-tier) project source connection. Select and edit the specified. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. If you are leveraging Web ASP, see KB484127 to use this feature. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. " Navigate to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicroStrategyData Sources. When it’s set to 0, the project does not use unified quoting. The Revenue metric is said to be used by these other objects. In MicroStrategy Developer, duplicate each of the projects into this new project source. Consider the two scenarios below: 1. For Oracle 12. 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 Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. One workaround is to check each DBI and make. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Example: #Todumpalldatabases pg_dumpall>db. x. Update the project schema . Create the respective DSN's in the Intelligence Server machines. Each environment contains a MicroStrategy project. Search for objects within a project. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. Click your Account drop-down and choose Preferences. In the destination project source, administrator privileges are required. An update package migrates a previously specified group of objects. Connect to the project source and expand the project that is to be duplicated, as shown below: Right-click on the project name and select Duplicate Project. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". Our vision is to enable Intelligence Everywhere. The Project Duplication Wizard command line interface enables you to duplicate a project without having to load the graphical interface, or to schedule a duplication to run at a specific time. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. When a MicroStrategy Administrator duplicates a user, the security filters tied to the original user are not tied to the new user. To edit the database connection, click Edit. ' from the MicroStrategy Developer 'Schema' toolbar menu. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. Connect to a project source or Narrowcast Server. Published: Jun 3,. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a. exe -f Path\XMLFilename.