MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. for Superclass and search for 'ProjectsTransform'. For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. 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. The duplicate key value is (<ID>). In the left pane, click All Settings. See To copy a document between projects for a detailed procedure. 3. Learn on how to create filters in Microstrategy Web (dossier), both page level as well as global filter. MicroStrategy Object Manager activates MicroStrategy Desktop Project Duplication wizard to perform the operation. 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. ; In the Project Source Name field, type a name for the project source. Step 5. There's a reason we're at the top of the list. After duplicating a project in MicroStrategy Developer which uses LDAP Authentication, subscriptions may be missing. Choose 'Database Instance Wizard'. The document, named document_name. DSSErrors. MicroStrategy recommends that if you want to copy objects between two projects. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. 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. This would change the project version so that the Copy and Paste would work. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. ; Go to Connection Type > Direct (2-tier), and click Next. 2. Find an object's parents or children. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. Right click a project and select Duplicate Project. This Article describes an issue that occur when a project is duplicated from one 2-tier project source to another 2-tier project source in MicroStrategy Developer 10. Save the XML file of all trial upgrade. 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 one of the attributes is removed from the template, the Cost is aggregated. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. The data returned by the Platform Analytics project schema is never limited. 7. This restriction exists to ensure that the schema objects are compatible between the projects, as it would do considerable damage to import attributes and facts into a project to which those objects do not belong. In the original project, create the document to be used as a portable document. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. 2. 0 (Ashburn and Seattle): 1. Create a Custom Group with only one element "Year In list (2010)" in MicroStrategy Developer. Specify the. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To achieve this, perform the following steps: Open MicroStrategy Command Manager and log into the appropriate Project Source and provide a user name and password for each user with access to the. 3. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Open MicroStrategy Developer 10. 4. Select the desired objects and click >. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. From the Tools menu, select ExportDocument Template. 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. Deploy the ojdbc8. Example: #Todumpalldatabases pg_dumpall>db. There are other Configuration Objects, but these will be covered in Chapter 6, Security – Managing Your Users and Their Access and Chapte r 7, Administration – Maintaining and Monitoring Your Project. KB45837. This will open project Creation Assistant / Wizard. A Dockerfile describes what goes into a. The scenario below explains the steps to follow to configure two identical projects pointing to two different warehouses in the same Project Source in MicroStrategy 9. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. Explanation: The name will use the browser default language preferences, English (United States) in this case. Use Object Manager when you have only a few objects that need to be copied. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. SYMPTOM: In MicroStrategy Developer, users may notice that subscriptions are missing after project. 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. Right-click the project where you want to use the exported settings and choose Properties. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). x, open the Project Configuration window by right-clicking on a project and choosing 'Configure Project'. 0 (Ashburn and Seattle): 1. 3. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. x. 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. Create a Security Role. To create to a direct project source. In the left pane, click All Settings. Our vision is to enable Intelligence Everywhere. Please contact MicroStrategy Technical Support for an update on this issue. 3. This technical article explains a defect where users can see duplicate rows for a Dossier against a Data Import Cube when the fact table used contains duplicate rows. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. This will produce an html document containing the search results and any information that is selected about those objects. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Ensure that the project schema for your new attribute is available for editing. 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. Under the Tools menu, select Project Documentation. x. (From the File menu, select Open. You must first update the other project before you can copy objects between the projects. Click Save. Object Manager and Project Merge both copy multiple objects between projects. 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. If one of the attributes is removed from the template, the Cost is aggregated. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. 2. Supported data structure and distribution on Gateway. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. We decided to gather them in one placing using our experience and MicroStrategy materials. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. 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. Create a new dossier, add new data, use Clipboard and input the sample data as below. Assuming that the statistics tables have already been created in the. Update the project schema . 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. What action should be taken? The incomplete project cannot be repaired, therefore it must be deleted. If not, create those DSNs before proceeding with the steps below. In the menu bar, go to Tools > Preferences. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Select Project Sources and click Next. Some uses for this data include: •. x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. This can be achieved as:This tutorial will guide MSTR users to share dossiers through Web and Library. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. From the Home menu, select one of the following: To save a report, select Save. 2 and above. This method is recommended and supported by MicroStrategy. Use Object Manager when you have only a few objects that need to be copied. Each environment contains a MicroStrategy project. 52K. Create a configuration package with user and/or user group objects and set their Action to Replace. Microstrategy developers responsibilities require that "developers must be able to give clear instructions to others working on a project. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. Removing duplicates (cross joined data) in MicroStrategy Desktop. 0. Enter a new name and press the Enter key. ProjectsTransformCustomStatus. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. 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. Note: This setting has to be check for every MicroStrategy project logging statistics. This MicroStrategy tool can be used to test and troubleshoot. 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. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. x-10. An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. Duplicate the original project into the MS Access file In MicroStrategy Desktop, go to the menu Schema -> Duplicate Project; Select the project source of the original project to transfer; Login as MicroStrategy Administrator as screenshot below and click on 'Next' Why MicroStrategy Why MicroStrategy; Customer Stories; Platform To add copies of a table from other database instances. Choose a Source Project Source and Source Project as well as a Destination Project Source and Destination Project. 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. There's a reason we're at the top of the list. In the destination project source, administrator privileges are required. There's a reason we're at the top of the list. 4. An update package migrates a previously specified group of objects. Select the “File from Disk” option. In the source metadata, create an empty. Note: We recommend you enable Add All Used Dependencies. Export the document from the original project. Specify the port number where the SMTP server receives incoming e-mail. DELETE PROJECT "[Project Name]"; Verify that in 3-Tier you dont see any duplicate project names. To edit the database connection, click Edit. x SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. x - 9. Restart the MicroStrategy Intelligence Server to make the new settings take effect. 4. Follow Steps 1 to 10 to decide the parameters of the duplication process . 6. Create a new dossier, add new data, use Clipboard and input the sample data as below. Choose Get Info if you are using a Mac. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. " and select all users and groups, except for. Unlocks a project in the metadata. After deleting the incomplete project, the duplication. Specify the project source of the project to be duplicated in the Direct Project Sources section. x as shown below: Duplication might fail right after property transfer completed if no users were duplicated or after user objects load/save finished if all users or project related users were selected to be duplicated. For information about duplicating projects, including instructions, see Duplicating a Project. When copying objects across projects with Object Manager, if an object with the same ID as the source object exists anywhere in the destination project, a conflict occurs and the. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. Select the appropriate options to define the dynamic recipient list, as described above. 2. 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. x and 10. Plus, it connects business apps while integrating data. On the source computer, go to Start > Run. An object is a basic building block in MicroStrategy. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in the Data Import wind… Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Choose a project, right click on it and select “ Duplicate Project” 2. The Scan MD tool searches for logical errors and fixes them within the platform object structure. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. To determine how many connection maps a project is using in MicroStrategy Developer 9. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe project duplication xml file fed into System Manager was generated with a setting that instructs System Manager to copy project related users. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. To add the dependents of all objects to the package, click Add all dependents. - 3-tier for a server (3-tier) project source connection. Update/Update only option does not compare all the attribute elements. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. - Administration -> Duplicate project. To duplicate a project in MicroStrategy Develper 10. 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. . Create the respective DSN's in the Intelligence Server machines. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. This document shows how to create a MicroStrategy Object Manager package to prevent a dependent object from being migrated over. The duplicate connection is automatically created and displayed in the Database Connections panel. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. 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. • 0: Do not create the Platform Analytics project. x-10. Import the document into the replacement project. exe -f Path\XMLFilename. 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. Detail Levels You can now select the level of detail exported from your dossier. Create two Intelligent Cube Reports: C01 and C02 in the MicroStrategy Tutorial project. Across corporate functions. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In the Project Source Manager click on 'OK' to exit the window. Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. Restart the MicroStrategy Intelligence Server. Copy Objects Object Manager can copy application, schema, and configuration objects. 3. When it’s set to 0, the project does not use unified quoting. Select from the following: To duplicate the database connection, click Duplicate. Step 2: View the Dockerfile in your project folder. Line 2 qty_sold number is updated. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. . 2. This setting is ideal if you have numerous. Quoting Behavior is a setting created to control whether a project uses unified quoting. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. The report can be executed in MicroStrategy Web. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Full control. In the Folder List, expand the project that contains the object you want to copy, then navigate to the object. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. KB290890: Project duplication wizard hang when attempting to duplicate a project in MicroStrategy Developer 9. Application objects include reports and documents, and the objects used to create them,. 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. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. Object Manager looks in the destination project's Public Objects folder for a subfolder named Report Dependents (the same path as in the source. To copy a document between projects, follow the high-level steps below. 4. A project is duplicated between a 3-tier project source and a 2-tier project source. For each type of configuration object (user/group, security role, schedule, contact/contact group, database connection/instance, database login) you must choose whether to duplicate the object if it already exists in the destination project source metadata. You cannot move Project A objects to an exact copy of Project A. 3. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. And then in the first document, import the. There's a reason we're at the top of the list. In MicroStrategy Developer 9. When creating a logical table, there are two ways how the user can define the column objects. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. Enter the User Name and Password for the database. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. This issue has been addresses in MicroStrategy Developer 10. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. The Revenue metric is said to be used by these other objects. 3. 4. x, below cross site scripting issue was. I have a question regarding duplicates in Microstrategy. Unlock Project statement. 8. For this Click on Schema and Click on Create New Project. In the Navigation pane, click Users and Groups. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. 2. 3. Rename the Project to remove these characters, after which the project can be duplicated successfully. How to delete, invalidate or expire caches from a specific project in MicroStrategy Developer. x. Change Journaling; The information which user made a change in the configuration is visible in the Change Journaling option. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. To import multiple copies of the same table from different data sources into a project, the requirements listed below must be met: • The table name and column names must be. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Rename the Project to remove these characters, after which the project can be duplicated successfully. In MicroStrategy Developer 10. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. 4. ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. authored through Developer and are tightly coupled to a MicroStrategy. The following. Connect to a project source or Narrowcast Server. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. configure a project to collect statistics. x. x and how duplicate columns can be created. 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. Expand the My Personal Objects folder, and then open the My Reports folder. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. The duplication wizard hangs at different steps during subsequent duplication attempts. Enable the statistics logging for the project. Object Manager and Project Merge both copy multiple objects between projects. To create a configuration update package, copy the file createConfigPackage. Step 4. 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. xml. Go to Menu -> Tools -> Options. Exporting creates a package file with the extension . The process will hang and MicroStrategy Developer will become unresponsive at any point. To export a project schema to an Excel file in MicroStrategy Developer 9. This can be achieved as follows: Connect to a project. 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. For information. In the menu bar, go to Tools > Preferences. 'Product 01' is licensed for 0 named users. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. MicroStrategy Object Manager: A lifecycle management tool designed for MicroStrategy environments, and helps you to copy various objects inside a project or across different related projects. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. If the source attribute is defined as the project attribute on which the transformation is based and the transformation attribute as retrieving the attribute elements over which the transformation metric is actually calculated, a MicroStrategy report may display only the source attribute and only this attribute may be used to set the. What permissions are needed to allow a user to duplicate projects in MicroStrategy Developer Project duplication failed when duplicating project related configuration objects in MicroStrategy Developer 10. 2. To create to a direct project source. Select Create project security package and the projects to include in the security access settings. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. Open the MicroStrategy Configuration Wizard. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. A list of security roles in the project source opens in the main Developer pane. The hang will only occur when the database instance. 6. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. This is by design. 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. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. This is how the behavior is set and displayed from within MicroStrategy Developer 9. e. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. 3. The copy of the table is added to the project and. In MicroStrategy reports, attributes are identified by the column headers of the reports. Expand Administration, and then expand System Monitors. MicroStrategy Web. The important thing here is we do this in 2-Tier or Direct mode. java opens in the editor. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. Enter a name and description for the new security role. scp i PURGE OBJECT CACHING IN PROJECT "Project_Name"; Create a batch file named PurgeObjectCache. Sometimes you need to deal with a data source that has duplicated data. x. 'Product 02' is licensed for 0 named users. 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. x: Use the "CREATE USER" outline to write a script to create a new user. In MicroStrategy 10. The user can choose to click on the 'Add' button and will add a new entry in the columns list or the user can drag and drop from the. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). The Project Documentation Wizard will run for only the selected objects. 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. 1 - 10. There's a reason we're at the top of the list. )An example is shown with MicroStrategy Tutorial Project: - In Microstrategy Developer, log into the project where it is desired to obtain a report's VLDB properties. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. On the Data Sources pane on the left, hover over the name of the database connection to modify and click the arrow icon. You can access this setting through the following steps: Log in to your Project Source. x, all users are able to see. Click in “Add new data”. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. 3. How to duplicate the Project:- Object Manager in MicroStrat…In MicroStrategy Desktop, log onto the source project containing the project to duplicate and. The user logging in to Developer must be granted the "Audit Change Journal" privilege. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. The duplicate key value is (<ID>). For example, a user copies a report from the source project to the destination project. From the left, select Dynamic Address Lists. Click 'Next' after the introduction. 2 and above. Double-click the security role you want to assign to the user or group. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. Log in to a project source in MicroStrategy Developer. Open the MicroStrategy Configuration Wizard. Project: the project containing the objects to include in the update package. Cannot insert duplicate key in object 'dbo.