I have to duplicate the project, change the fact table and change the related items. 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 select Duplicate Project. You can choose to duplicate user, contact, and subscription information. KB13782: After duplicating a project in MicroStrategy Developer 10. DSSCSADDRESS'. 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. This document provides steps to merge the Enterprise Manager warehouse fact data on an Enterprise Manager report for a duplicated project and the original projectThere's a reason we're at the top of the list. 'Product 02' is licensed for 0 named users. Removing duplicates (cross joined data) in MicroStrategy Desktop. Type "regedit. 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. There's a reason we're at the top of the list. Step 3. Unlocks a project in the metadata. is the project for which the project configuration properties will be listed, of type string. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. configure a project to collect statistics. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Right-click the project where you want to use the exported settings and choose Properties. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. 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). In the source metadata,. 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. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingALTER ATTRIBUTE "Copy of Day" IN FOLDER "Schema ObjectsAttributes" HIDDEN FALSE FOR PROJECT "MicroStrategy Tutorial"; UPDATE SCHEMA REFRESHSCHEMA RECALTABLEKEYS RECALTABLELOGICAL RECALOBJECTCACHE FOR PROJECT "MicroStrategy Tutorial";To rename a dossier, right-click it and choose Rename. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. Step 8: Change the migrating objects to the following:. exe", the syntax is: ProjectDuplicate. 2. Click on Next. After deleting the incomplete project, the duplication. 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. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. 2. . After duplicating a project into another project source via MicroStrategy Developer 10. In this scenario, you typically use three environments: development, test, and production. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. Note: We recommend you enable Add All Used Dependencies. Refresh. Users' profile folders are project specific, unlike users, which are system wide objects. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. 1. In MicroStrategy reports, attributes are identified by the column headers of the reports. )The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. process, which is named M8DBMPE1 in MicroStrategy 7i - 7. There's a reason we're at the top of the list. Assuming that the statistics tables have already been created in the. The document, named document_name. 1. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. In this scenario, you typically use three environments: development, test, and production. x, below cross site scripting issue was. In the original project, create the document to be used as a portable document. xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Applications of MicroStrategy. new_desc is the new description of the attribute, of type string,. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. Enable the statistics logging for the project. Create a configuration package with user and/or user group objects and set their Action to Replace. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. MicroStrategy recommends that if you want to copy objects between two projects. 3. Create a new dossier, add new data, use Clipboard and input the sample data as below. 2. spicehead-tvkpqyiu. x. Create a DSN to Tutorial_WH_Copy, call it Ttrl_WH_Cpy_DSN; Connect to Ttrl_WH_Cpy_DSN with DB. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. ConnectionMode: - 2-tier for a direct (2-tier) project source connection. Using Object Manager, you can copy objects within a project or across projects. Provide a Project Source name. Click Next and Finish. Example: #Todumpalldatabases pg_dumpall>db. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. 8-2. Move objects within a project. . x, create a new report with the following definition: Attributes . For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. pkg. If you are leveraging Web ASP, see KB484127 to use this feature. Choose a Source Project Source and Source Project as well as a Destination Project Source and Destination Project. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. jar. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. Delete objects within a project. In the left pane, click Privileges. Open both folders in which the user is located for each project source. To include a copy of the table in the project, select Indicate that TABLE_NAME is also available from the current DB instance, and click OK. 2. 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. Specify the. x and later. Duplication is the only way to get the projects into another environment. x-10. Open Command Manager and type the following commands to execute the Intelligent Cubes. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Using MicroStrategy Enterprise Manager 9. Use the project duplication function to duplicate only the Tutorial project to your metadata. From the Home menu, select one of the following: To save a report, select Save. A list of security roles in the project source opens in the main Developer pane. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Click 'Next' after the introduction. 2. In the Project Source Name field, type a name for the project source. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). x. There's a reason we're at the top of the list. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. Change Journaling; The information which user made a change in the configuration is visible in the Change Journaling option. Click the “Select File” option. x and 10. 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. This MicroStrategy tool can be used to test and troubleshoot. java opens in the editor. Select and edit the specified. 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. Restart the MicroStrategy Intelligence Server. 1. There's a reason we're at the top of the list. Using Cache Monitor From the Cache Monitor under Administration for a Project Source, it is easy to identify to which project does each cache belong or to filter all the caches for a project identifying one of the caches for that project. Go to 'Contains' tab, and click on Add button. with the MicroStrategy sample project called Tutorial - Delivery. x. Was this post helpful? thumb_up thumb_down. use the function "Remove Duplicate Rows". DSSErrors. 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. Click on Create Project and Give suitable Project name and Click OK. From the Select a Project drop-down list, select the project for which to assign the security role. 2012-04-25T09:22:00Z. x SYMPTOM: When use 3rd party security scan tool such as Acunetix Web Vulnerability Scanner or IBM Security AppScan Standard to implement the security scan toward MicroStrategy Web 10. 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. 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. ' from the MicroStrategy Developer 'Schema' toolbar menu. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. 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, runs out of memory. Select Create project security package and the projects to include in the security access settings. Create a Custom Group with only one element "Year In list (2010)" in MicroStrategy Developer. Note: The Tutorial project is designed for MicroStrategy Web JSP. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. 0 (Ashburn and Seattle): 1. Right click a project and select Duplicate Project. 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. " Navigate to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicroStrategyData Sources. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. If the Starburst menu is clicked again, the user will see that the font of. 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. 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. Next we will delete the project. Browse to and select a previously saved Intelligent Cube on which to build your report. Starting MicroStrategy 11. FORCE forces the project to unlock. And check the option to Show 'Contains' and 'Contained by' tabs, as shown below: Go to 'Object Types' tab, and select 'Report' and 'Document'. Specify the port number where the SMTP server receives incoming e-mail. 3. Managing Data Source Connections. Request a demo. 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 achieve this, there are two ways:When logging into MicroStrategy Developer (formerly Desktop), it can be seen that Profit Forecast no longer can be seen under the Financial Reports folder. xAs an example, consider the fact 'Copy of Units Sold' defined as shown: Consider that this fact needs to be modified using MicroStrategy Command Manager 9. Some uses for this data include: •. I have to duplicate the project, change the fact table and change the related items. For information. /mstrcfgwiz. There's a reason we're at the top of the list. 2. 2 release, the driver file is called odbc8. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. Ensure that the project schema for your new attribute is available for editing. Database Connections are created and edited in the Database Instance Editor, as shown below: To access the Database Instance Editor, log into the Project Source as a Database Instance Manager. Exporting creates a package file with the extension . For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. If you are working on a report that has already been saved, a confirmation message appears. - Administration -> Duplicate project. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Click Next. Case() and CaseV() functions are Analytical Engine functions, i. To duplicate a project in MicroStrategy Develper 10. Once the metadata shell is created, create a project source using this DSN. MicroStrategy Command Manager 9. 0. In the left pane, click All Settings. 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. 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. AuthenticationMode: the authentication mode used to connect to the project source, either Standard or Windows. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. 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. Microsoft released the following security and nonsecurity updates for Office in November 2023. The Table Viewer allows users to view the tables and relationships used in a project in MicroStrategy Developer in two views: The logical view displays the tables, with the attributes and facts contained in each. 1 or later using the Perform system object ID unification option For Cloud 3. 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. Scan MD. If one of the projects is updated to a new MicroStrategy release, but another project is not updated, you cannot move or copy objects between the projects. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. - 3-tier for a server (3-tier) project source connection. This setting is ideal if you have numerous. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. Transform description: This transform displays project status on the Projects page. The Project Documentation Wizard will run for only the selected objects. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. Create the respective DSN's in the Intelligence Server machines. 3. 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. After every project duplicate, disconnect and reconnect to Project Source. If one of the attributes is removed from the template, the Cost is aggregated. Open the script. Select the Members tab. In the destination project source, administrator privileges are required. Case() and CaseV() functions are Analytical Engine functions, i. pimiento. Specify the IP address of the SMTP server. 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. 0. 5. 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. 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. In the Project Duplication window, the hang appears to occur after finishing the property set objects. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Export the document from the original project. 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. 1. There are three types of objects: schema objects, application objects, and configuration objects. This can be achieved as:This tutorial will guide MSTR users to share dossiers through Web and Library. Quoting Behavior is a setting created to control whether a project uses unified quoting. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. Creating a new project at the Source environment called P1. And then in the first document, import the. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. 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. In. Navigate to the folder to save the file in, then click OK. Required Status to Perform Action. x: Use the "CREATE USER" outline to write a script to create a new user. In MicroStrategy Web 9. Expand Administration, and then expand System Monitors. x. flag Report. 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. Self-Service Analytics with Amica. Choose Get Info if you are using a Mac. . There's a reason we're at the top of the list. " Then copy that folder. 1. The Security Role Editor opens. Each environment contains a MicroStrategy project. Create the respective DSN's in the Intelligence Server machines. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. 1 Number of Views 1. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. Click your Account drop-down and choose Preferences. x. For example, a user copies a report from the source project to the destination project. For information about duplicating projects, including instructions, see Duplicate a Project. Then click OK. 2. 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. 4. The highlighted setting can be used to refresh MicroStrategy office report. 2 release, the driver file is called odbc8. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. To determine how many connection maps a project is using in MicroStrategy Developer 9. 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. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. This article explains how to to copy Partition Mapping tables and objects from one project to another in MicroStrategy Object Manager 9. e. 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. It is recommended that, if you plan to try the Tutorial - Delivery sample project to learn about Narrowcast Server, you perform theSelect the Do not merge or duplicate headers when exporting to Excel/Word checkbox to repeat the table headers when exporting a report or a document to an Excel sheet or a Word document, as per MicroStrategy 8. For information about duplicating projects, including instructions, see Duplicating a Project. 3. This is how the behavior is set and displayed from within MicroStrategy Developer 9. Object Manager and Project Merge both copy multiple objects between projects. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. 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. " and select all users and groups, except for. Run this script to delete the project (this step could take several minutes) a. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. See To copy a document between projects for a detailed procedure. To move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. In MicroStrategy Developer 9. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. KB290890: Project duplication wizard hang when attempting to duplicate a project in MicroStrategy Developer 9. To duplicate a project in MicroStrategy Develper 10. In MicroStrategy Developer, duplicate each of the projects into this new project source. 2 and above. It is available as web-based or on-premise platform, along with native mobile apps. The user can do this by importing the layout of the second document into the first document. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. In the Device Editor, click the Delivery Options tab. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. 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). NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. 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. Project: the project containing the objects to include in the update package. (the target objects of those shortcuts) to the new project. x SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. 1. Go to the Project Monitor under Administration, as shown below:Description. x:. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Why MicroStrategy Why MicroStrategy; Customer Stories; Platform To include a copy of the table in the project, select Indicate that TABLE_NAME is also available from the current DB instance, and click OK. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. Select Project Sources and click Next. 1 as the administrator user in MicroStrategy. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. 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. Choose the individual modules to be logged. x. x and M8MulPrc_32 in 7. - Administration -> Duplicate 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. Duplicate projects and Intelligence Servers appear in MicroStrategy Web. use the function "Remove Duplicate Rows". Supported data structure and distribution on Gateway. 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. 2987. You cannot move Project A objects to an exact copy of Project A. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Step 2. 1. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. Delete objects within a project. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. 'Product 01' is licensed for 0 named users. Explanation: The name will use the browser default language preferences, English (United States) in this case. 1. 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. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Operations cannot be performed from a newer metadata to an older. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. Each environment contains a MicroStrategy project. It gives you the leverage of generating real-time reports and monitoring. In MicroStrategy 10. You can use a scheduler such as Windows Scheduler to import the package. Click Add, select the elements, then click OK. 3. There's a reason we're at the top of the list. ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. 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. Open MicroStrategy Developer 10. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. I have a question regarding duplicates in Microstrategy. To log in to a specific project, see Starting MicroStrategy, page 2. 0. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. When it’s set to 0, the project does not use unified quoting. 3. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. There's a reason we're at the top of the list. If one of the attributes is removed from the template, the Cost is aggregated. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. In MicroStrategy Developer 10. 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. Deploy the ojdbc8. 1 - 10. Go to each of the attributes and facts returned by the dependency search. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. x can be used to change the project status programmatically. Click on "Select users. 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. Selecting a database instance check box makes that database instance available in the project for standard MicroStrategy. The issue stems around the Database Instances warehouse connections when project related configuration objects are being duplicated. Object Manager and Project Merge both copy multiple objects between projects. This is by design. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. The hang will only occur when the database instance. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). If you like the video, please subscribe to my channel. location_path is the folder where the attribute resides, of type string, between double quotes ("). 5. Hey even if it doesn't work you can unload and load the Project that's definitely works. After duplicating a project in MicroStrategy Developer which uses LDAP Authentication, subscriptions may be missing. Cannot insert duplicate key in object 'dbo. 0. Configure Intelligence Server with restored metadata with Configuration Wizard . In the Device Editor, click the Delivery Options tab. jar file to i-server machine. 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. If normal logical table objects remain that are dependent upon the object trying to be removed from the project, then remove them from the project in Warehouse Catalog . Select an Environment from the upper-left drop-down. Create a database instance that references the intended datamart location by performing the following steps. Click Add a New Dynamic Address List. From the Schema menu, select Create New Project. NOTE: Only users with administrative privileges are able to select this option. MicroStrategy provides modern analytics on an open,. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. bat, as shown below, to run PurgeObjectCache. In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project.