Right-click on the right-hand side of Desktop, select New, and then select Report. scp i PURGE OBJECT CACHING IN PROJECT "Project_Name"; Create a batch file named PurgeObjectCache. Select 'Export Project Schema. To delete a dossier, right-click it and choose Delete. Under the Tools menu, select Project Documentation. Enable the statistics logging for the project. Rename the Project to remove these characters, after which the project can be duplicated successfully. 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. x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. NOTE 1: This option is only viable as long as the statistics tables have not been purged in MicroStrategy Desktop under the Project Configuration for the time period specified for the custom time window data load. 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. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. SELECT project_id, object_id, object_type, subtype, object_name, abbreviation, description, version_id, parent_id, owner_id,. Each environment contains a MicroStrategy project. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. Cannot insert duplicate key in object 'dbo. x cannot be duplicated until it is upgraded toThis article discusses an issue where subscriptions are marked invalid and deleted after duplicating a project to another metadata in MicroStrategy Developer 10. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. If you like the video, please subscribe to my channel. There's a reason we're at the top of the list. To run your code in a container, the most fundamental thing you need is a Dockerfile. For information about duplicating projects, including instructions, see Duplicate a Project. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. ; In the Project Source Name field, type a name for the project source. Rename objects within a project. You can duplicate projects as part of a System Manager workflow. Another way to copy objects from multiple folders at once is to create an update package from the source project, and then import it into the target project. MicroStrategy 10 will report the following errors if the path specified in Project Configuration>Intelligent Cubes>General>Intelligent Cube file directory is not accessible:On the upper right of any page, click your user name, and then select Preferences from the drop-down list. . You must first update the other project before you can copy objects between the projects. 1. 4 To ensure that you are using the documentati on that corresponds to the software you are licensed to use, compare this version n umber with the softwareDouble-click the security role you want to assign to the user or group. From the Tools menu, select ExportDocument Template. In the left pane, click All Settings. Click the “Select File” option. Creating a new project at the Source environment called P1. 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. A project created in MicroStrategy 6. See To copy a document between projects for a detailed procedure. Applications of MicroStrategy. The highlighted setting can be used to refresh MicroStrategy office report. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. 1. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. This method is recommended and supported by MicroStrategy. Specify the port number where the SMTP server receives incoming e-mail. Open the Workstation window with the Navigation pane in smart mode. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. Application objects include reports and documents, and the objects used to create them,. Once the metadata shell is created, create a project source using this DSN. Click Create a new Security Role next to Security Roles. Click the Connect button to launch the connector. new_desc is the new description of the attribute, of type string,. 6. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. To copy the users or security filters in a group, select the users from a list of that group's used-by dependents and then copy them. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. CAUSE: The 'Everyone' group is placed into the 'Normal Users' security role for the project during duplication, even if the group had been previously removed. The report can be executed in MicroStrategy Web. We decided to gather them in one placing using our experience and MicroStrategy materials. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. DSSCSADDRESS'. Import the document into the replacement project. Use the project duplication function to duplicate only the Tutorial project to your metadata. Log in to a project source in MicroStrategy Developer. To duplicate a project in MicroStrategy Develper 10. Next we will delete the project. Community & Support Search Discussions Open A Case View My Cases The following procedure describes how to merge users from two different metadata repositories using the Project Duplication Wizard in MicroStrategy Developer. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B instance (development project) to MSTR B instance (test project), MSTR Object Manager attempts to move the database instance (querying the development data warehouse) as well. After every project duplicate, disconnect and reconnect to Project Source. This setting is ideal if you have numerous. 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. The Security Role Editor opens. Line 2 qty_sold number is updated. MicroStrategy DB (Database) Query tool is a any to use MicroStrategy application that utilizes Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) to access data in any database for which there is an ODBC driver or JDBC driver, respectively. Expand the My Personal Objects folder, and then open the My Reports folder. Expand Administration, and then expand System Monitors. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. And then in the first document, import the. Unified Quoting: Solutions to Quoting Pattern Challenges. Detail Levels You can now select the level of detail exported from your dossier. The Browse for Folder dialog box opens. Go back to MicroStrategy Desktop, right mouse click on the project -> Search for Objects. Start Power BI Desktop. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. This can be achieved as follows: Connect to a project. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. 1, users have the ability to keep the source project's GUID as the destination project's GUID using the "Use the same identifier (GUID) as source project" setting located within the project duplication wizard as shown below. Use Object Manager when you have only a few objects that need to be copied. Open MicroStrategy Developer 10. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. The Full option exports a snapshot of each page and each individual visualization. 11: 1) Set a password for the Administrator user in the Project Source A 2) Set a different password for the Administrator user in the Project Source B 3) Open the Object Manager and duplicate a project from Project Source A to Project Source B. In the original project, create the document to be used as a portable document. Microsoft released the following security and nonsecurity updates for Office in November 2023. On the Data Sources pane on the left, hover over the name of the database connection to modify and click the arrow icon. The Duplicate. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 1 as the administrator user in MicroStrategy. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. 2. jar file to i-server machine. Specify the IP address of the SMTP server. x. In the Device Editor, click the Delivery Options tab. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. Consider a project (P1) in a Project Source that must be duplicated to project (P2) in the same PS but pointing to a different warehouse. Go to the System Objects folder and right-click on the column that is being removed to Search for Dependents. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. ; Go to Connection Type > Direct (2-tier), and click Next. In the Log Options screen, leave the default log locations and select Next . When duplicating a project, the following options apply to subscriptions for the selected users: Include user delivery subscriptions – This will duplicate cache update, History List message, Mobile, Intelligent Cube update, email, file, and print subscriptions for the duplicated users. The hang will only occur when the database instance. For creating new database instance click on NEW. Design intuitive analytics reports with MicroStrategy ONE. MicroStrategy recommends that if you want to copy objects between two projects. by clicking the lock icon for the project. x. Exporting creates a package file with the extension . 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. In MicroStrategy Developer, duplicate each of the projects into this new project source. DSSCSADDRESS'. use the function "Remove Duplicate Rows". The destination project must be of the same metadata version or older metadata version as the source project. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. 2. 3. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. There's a reason we're at the top of the list. How to delete, invalidate or expire caches from a specific project in MicroStrategy Developer. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Review any messages displayed when attempting to import a copy of a table from a different data. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. Right-click a project in that project source and select 'Compare projects' or select. Expand the destination project in which you want to paste the object, and then select the folder in which you want to paste the object. (the target objects of those shortcuts) to the new project. Drag and drop objects from the Object Browser into the Create Package dialog box. x tries to upgrade the object, it detects that the definition has changed due to the concurrent project upgrades being performed, and ultimately needs to be reloaded from the MicroStrategy Metadata. Browse to and select a previously saved Intelligent Cube on which to build your report. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. x Loading × Sorry to interruptFor this particular error, a database instance object is involved and when MicroStrategy Developer 10. 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. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. Open the MicroStrategy Configuration Wizard. x. To do this, follow the steps below: Open MicroStrategy Developer 10. Specify the. This is because. 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. Project duplication setting is heart of the migration. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. 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. The issue stems around the Database Instances warehouse connections when project related configuration objects are being duplicated. From the Select a Project drop-down list, select the project for which to assign the security role. Copy objects within and across related projects. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. Thus, the report has been moved to another folder within the same project. There are three types of objects: schema objects, application objects, and configuration objects. After deleting the incomplete project, the duplication. Companies of all sizes use this platform to assess, visualise, and build dashboards. To do so, you can take advantage of URL API. Object Manager and Project Merge both copy multiple objects between projects. 4. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. The copy of the table is added to the project and. 2. x. The Project Documentation Wizard will run for only the selected objects. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. Request a demo. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. How to duplicate the Project:- Object Manager in MicroStrat…In MicroStrategy Desktop, log onto the source project containing the project to duplicate and. Expand Administration, and then expand System Monitors. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. In this scenario, you typically use three environments: development, test, and production. Choose Get Info if you are using a Mac. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. Click Continue if the Preview Connector warning message pops up. Click Next and Finish. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. To list and count unique users per project, project documentation can be used from within MicroStrategy Developer 10. You can use the Import Data feature in MicroStrategy Web to import data from sources such as Microsoft Excel spreadsheets, comma-separated text files, and external databases into your project. Create a new dossier, add new data, use Clipboard and input the sample data as below. Launch MicroStrategy Object Manager and connect to a project that is the migration source. The same report accessed in web. Managing Data Source Connections. Step 2: View the Dockerfile in your project folder. New user and application requirements make attribute creation and modification an important part of the entire project life cycle. 2. Set Freeform SQL and MDX objects default security. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Before creating a database instance for a project warehouse, users need to create a Data Source Name (DSN) that points to the database (which holds the project warehouse). The Page level option only provides a snapshot of each page. Update packages are part of Object Manager. Each environment contains a MicroStrategy project. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. 4. Using Object Manager, you can copy objects within a project or across projects. DSSErrors. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Duplicating projects Projects created in MicroStrategy 7 can be duplicated in the same project source or in a different one. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. bat, as shown below, to run PurgeObjectCache. Select the Members tab. x. Select an Environment from the upper-left drop-down. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. (From the File menu, select Open. Consider the two scenarios below: 1. ConnectionMode: - 2-tier for a direct (2-tier) project source connection. Right-click on the project name and select Duplicate Project. Export the document from the original project. exe", the syntax is: ProjectDuplicate. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. pkg. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. So I want to create an embedded query to know which last objects. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. For more details, see Modify the Amount of Data Returned In-Memory for the Platform Analytics Cube. To duplicate a project with subscriptions, follow the steps provided in "KB 45537 How to duplicate a project without subscriptions for MicroStrategy Cloud Enterprise" adjusting the following steps:. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B. " and select all users and groups, except for. 8. x: Use the "CREATE USER" outline to write a script to create a new user. To combine two documents. The administrator should stop. 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. rst, is saved in the selected folder. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. xml. 4. 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. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. 1. Rename objects within a project. 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. I've been working in the past few years with Cognos 10 and Cognos 11 but my company has Microstrategy (I'm a newbie in Microstrategy). 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. 1 or later, or have been updated to version 9. 1 and 10. These updates are intended to help our customers keep their. Under Preferences, click General. x. Receive a list of. 2. Project: the project containing the objects to include in the update package. Click Add, select the elements, 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). The copy of the child will not be used by the parent. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Navigate to the folder to save the file in, then click OK. Copy objects within and across related projects. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. With the option 'Insert from file' from the Insert tab there is no access to the live model To link one file from a cloud project to another use External Resources. x. The Security Role Editor opens. I have a question regarding duplicates in Microstrategy. x and later. An object is a basic building block in MicroStrategy. To edit the database connection, click Edit. 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. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 1. Click on Next. Click Select. If you want to merge two projects, MicroStrategy recommends that the projects have related schemas. " Navigate to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicroStrategyData Sources. Export the document from the original project. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. x. Refresh. Operations cannot be performed from a newer metadata to an older. The following. 6. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. Now, enter your username and hashed password copied from the database and login. On the report toolbar I’ve highlighted six icons, in order from. 1. Click OK to confirm the deletion. 0 (Ashburn and Seattle): 1. x, all users are able to see. 0. A list of security roles in the project source opens in the main Developer pane. To create to a direct project source. If you want to copy application or schema objects between projects, MicroStrategy recommends that the two projects have related schemas (one must be a duplicate of the other or both must be duplicates of a common project). Unlocks a project in the metadata. From the command line: MicroStrategy provides a command line utility for importing update packages. This is a guest blog post co-written by Amit Nayak at Microstrategy. Using Object Manager, you can copy objects within a project or across projects. There's a reason we're at the top of the list. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. The destination project must be of the same metadata version or older metadata version as the source project. Starting MicroStrategy 11. x, all users can see the project even if they could not see the project before duplication. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. 1 or later using the Perform system object ID unification option For Cloud 3. Follow the steps below to make the changes in MicroStrategy Web 9. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. 2. 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. Select the Members tab. In the source metadata,. To determine how many connection maps a project is using in MicroStrategy Developer 9. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. 0 (Ashburn and Seattle): 1. See To copy a document between projects for a detailed procedure. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Name: ProjectsTransformCustomStatus. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10. '. 3. 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. 1. Object Manager and Project Merge both copy multiple objects between projects. Assuming that the statistics tables have already been created in the. Note: This setting has to be check for every MicroStrategy project logging statistics. For Oracle 12. Microstrategy developers responsibilities require that "developers must be able to give clear instructions to others working on a project. Starting in MicroStrategy 9. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. When logging in MicroStrategy Web, the project name is "test Project" which is the project name even though the default language is English (United Kingdom) and the name should be "Duplicate Project". To invoke the "ProjectDuplicate. Choose File > New Attribute. scp in cmdmgr -n Project_Source_Name -u Username -f InputfileRight-click the project that you want to export your settings from and choose Properties. The Full option exports a snapshot of each page and each individual visualization. 4. 4. The Scan MD tool searches for logical errors and fixes them within the platform object structure. Go to each of the attributes and facts returned by the dependency search. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In the Project Source Manager click on 'OK' to exit the window. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. The duplicate key value is (<ID>). Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. 3. x-10. When a MicroStrategy Administrator duplicates a user, the security filters tied to the original user are not tied to the new user. Click on Create Project and Give suitable Project name and Click OK. There's a reason we're at the top of the list. Case() and CaseV() functions are Analytical Engine functions, i. In the destination project source, administrator privileges are required. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). Go to the Project Monitor under Administration, as shown below:Description. In the Navigation pane, click Users and Groups. 11?; Knowledge Base: Annotate. ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. I have to duplicate the project, change the fact table and change the related items. PAProjectEncryptPwd=Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformSubscriptions from other projects are shown when searching for dependent subscriptions in a duplicated project in MicroStrategy Desktop 10. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. x SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. This is a known issue in MicroStrategy 10. For the default contact for the user, this will duplicate. When the Conflict Resolution screen appears, only select the User being replaced: After the replace has completed, close Object Manager and log. For more details about this setting, refer to Change Data Engine Version Detailed reproduce steps: In MicroStrategy Web, create a new Dossier and click on New Data and select Databases and pick following 2 tables ; Choose Access mode to be "In-Memory"Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. 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. 4. 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. In the left pane, click All Settings. 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. Select Project Sources and click Next. Click OK. The important thing here is we do this in 2-Tier or Direct mode. 2987. MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. Open a project source in MicroStrategy Object Manager. To duplicate a project in MicroStrategy Develper 10. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B instance (development project) to MSTR B instance (test project), MSTR Object Manager attempts to move the database instance (querying the development data warehouse) as well. You can use a scheduler such as Windows Scheduler to import the package. Removing duplicates (cross joined data) in MicroStrategy Desktop. x, right click on the project of interested and select 'Project Configuration' from the menu, as shown below: Once the window for 'Project Configuration' opens, expand the 'Database instances' menu and go to the `Relational` section to see the database instance(s) currently in use for the project. Move objects within a project. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. To move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. 3. Every object in a MicroStrategy project has a unique ID.