Starting in MicroStrategy 9. 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). . Search for objects within a project. 2. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In MicroStrategy 10. No errors are thrown,and nothing is written to the duplication log. Sometimes you need to deal with a data source that has duplicated data. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. Cannot insert duplicate key in object 'dbo. 1. 2. Right click the Regions column header and select Advanced Formatting. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. If one of the attributes is removed from the template, the Cost is aggregated. - Administration -> Duplicate project. 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. Detail Levels You can now select the level of detail exported from your dossier. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. NOTE: Only users with administrative privileges are able to select this option. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. 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. Follow these steps to create it from MicroStrategy Developer: Go to Tools Menu | Project Source Manager. x?How to prevent content spoofing on projects page affecting Intelligence Server name using MicroStrategy Web 10. 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. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a. 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. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. 7. Request a demo. The Full option exports a snapshot of each page and each individual visualization. Double-click the security role you want to assign to the user or group. Using Object Manager, you can copy objects within a project or across projects. exe", the syntax is: ProjectDuplicate. Rename the Project to remove these characters, after which the project can be duplicated successfully. In the original project, create the document to be used as a portable document. The duplicate connection is automatically created and displayed in the Database Connections panel. The process will hang and MicroStrategy Developer will become unresponsive at any point. new_desc is the new description of the attribute, of type string,. When Windows Authentication is used, users are able to log in to the MicroStrategy projects using their respective Windows domain accounts. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. Please subscribe to the channel to get an update with videos and help us to get 5000. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. In the Navigation pane, click Users and Groups. The report can be executed in MicroStrategy Web. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. Click on Next. A warning message like the following can be observed:. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. In the Project Duplication window, the hang appears to occur after finishing the property set objects. There's a reason we're at the top of the list. 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. Right-click the dossier and choose Copy To. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. Connect to a project source or Narrowcast Server. They may be compared in either 2-tier or 3-tier. What action should be taken? The incomplete project cannot be repaired, therefore it must be deleted. Self-Service Analytics with Amica. Open both folders in which the user is located for each project source. These updates are intended to help our customers keep their. 3. For example, a user copies a report from the source project to the destination project. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. java opens in the editor. How to duplicate the Project:- Object Manager in MicroStrat…In MicroStrategy Desktop, log onto the source project containing the project to duplicate and. A project is duplicated between a 3-tier project source and a 2-tier project source. 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. Click Save. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. Delete objects within a project. This issue has been addresses in MicroStrategy Developer 10. You can choose to duplicate user, contact, and subscription information. To invoke the "ProjectDuplicate. Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. Specify the IP address of the SMTP server. No users should be connected to the project. The report can be executed in MicroStrategy Web. for Superclass and search for 'ProjectsTransform'. 1 and 10. To create to a direct project source. is the project for which the project configuration properties will be listed, of type string. 3. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. Click Continue if the Preview Connector warning message pops up. DSSCSADDRESS'. Click Export and save the file. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. Our vision is to enable Intelligence Everywhere. x. If you like the video, please subscribe to my channel. x and later. In the New Metric Editor, manually add the metric definition using this expression: max (<attribute>@<form>) {~} The new metric below will display the DESC column of the Country attribute and was created using the metric. In MicroStrategy Developer 10. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. When it’s set to 1, the project uses unified quoting. Each environment contains a MicroStrategy project. xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. And then in the first document, import the. In the left pane, click All Settings. Configure Intelligence Server with restored metadata with Configuration Wizard . x Loading × Sorry to interruptFor this particular error, a database instance object is involved and when MicroStrategy Developer 10. This document shows how to create a MicroStrategy Object Manager package to prevent a dependent object from being migrated over. If not, create those DSNs before proceeding with the steps below. 52K. process, which is named M8DBMPE1 in MicroStrategy 7i - 7. 4. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data. To combine two documents. 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. Each environment contains a MicroStrategy project. The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. Log into the 3-tier project source. For information about duplicating projects, including instructions, see Duplicating a Project. 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. For multiple projects, add brackets with each project name in quotations separated by commas. High-Level Steps to Duplicate a Project with the Project Duplication Wizard From Object Manager select the Project menu (or from Developer select the Schema menu), then select Duplicate Project. Select the Members tab. KB13782: After duplicating a project in MicroStrategy Developer 10. In the MicroStrategy system, every object has an ID (or GUID) and a version. Move objects within a project. 4. Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. e. The MicroStrategy Intelligence Server API call related is IDSSProjectInstance::Load. 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. 3. 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. This is by design. " Then copy that folder. See To copy a document between projects for a detailed procedure. 2. Microsoft released the following security and nonsecurity updates for Office in November 2023. 1. For this Click on Schema and Click on Create New Project. 1. You are currently using 1 named users. For the default contact for the user, this will duplicate. 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 duplicate key value is (<ID>). l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. 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. In the left pane, click All Settings. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. x, follow the steps outlined below: In MicroStrategy Developer, log into the project source and open the project. 2 release, the driver file is called odbc8. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. Rename the Project to remove these characters, after which the project can be duplicated successfully. We decided to gather them in one placing using our experience and MicroStrategy materials. It is available as web-based or on-premise platform, along with native mobile apps. To list and count unique users per project, project documentation can be used from within MicroStrategy Developer 10. See full list on Duplicating Projects. To determine how many connection maps a project is using in MicroStrategy Developer 9. In some scenarios, MicroStrategy administrators or other users may need to find out the Windows domain account that is linked to a MicroStrategy user. 3. x. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. Step 2. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. . 5. Select Project Sources and click Next. 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. From the Warehouse Tables pane, right-click the table to add to the project and select Add Table to Project. If all of the required conditions to import multiple copies of the table (listed in Supporting duplicate tables in multiple data sources ) are met, an Options dialog box opens. In the Device Editor, click the Delivery Options tab. 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. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For information about duplicating projects, including instructions, see Duplicate a Project. Right-click on the Project Source and choose 'Intelligence Server Configuration'. 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. DSSCSADDRESS'. From the command line: MicroStrategy provides a command line utility for importing update packages. In this scenario, you typically use three environments: development, test, and production. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. 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:. In MicroStrategy Web, users can import data from different data sources, such as a database or the results of a SQL query, then create reports, documents, and dossiers to report on their imported data. Users' profile folders are project specific, unlike users, which are system wide objects. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformI am new to the Microstrategy, I need some tips to do my task involves change of fact table in a project. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). When a MicroStrategy Administrator duplicates a user, the security filters tied to the original user are not tied to the new user. Copy the object by right-clicking and selecting Copy. For information about duplicating projects, including instructions, see Duplicate a Project. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. 4. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform The project duplication xml file fed into System Manager was generated with a setting that instructs System Manager to copy project related users. Click your Account drop-down and choose Preferences. Published: Jun 3,. To export a document template. In MicroStrategy 10. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). In order for objects of two projects to be copied across, the schema IDs of the projects must match. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. Rename objects within a project. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. 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). use the function "Remove Duplicate Rows". Open the MicroStrategy Configuration Wizard. For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. Choose Get Info if you are using a Mac. In the Project Source Name field, type a name for the project source. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. KB14574: How to list duplicate users per project in MicroStrategy Developer 10. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Select the Members tab. 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. Input connection parameters for the connector:Click Create on any folder page, point to New Report, and select Intelligent Cube Report. Step 3. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 6. 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. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. 2. 4. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. In. For information about Object Manager, see Copy Objects Between Projects: Object Manager. Under the Tools menu, select Project. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. 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: Step 8: Change the migrating objects to the following: Click on "Select users. 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. A Administrator decides to run a project merge against a newly duplicated project in MicroStrategy 9. There's a reason we're at the top of the list. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. 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. Using the Connector. This is because. For the default contact for the user, this will duplicate. For. 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. To delete a dossier, right-click it and choose Delete. 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. DSSErrors. The process will hang and MicroStrategy Developer will become unresponsive at any point. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. 3. For Oracle 12. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Open MicroStrategy Web. For managed objects, navigate to the Administration menu, and select ProjectDelete unused managed objects -- if necessary . Run this script to delete the project (this step could take several minutes) a. Use Object Manager when you have only a few objects that need to be copied. MicroStrategy recommends that if you want to copy objects between two projects. (the target objects of those shortcuts) to the new project. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. This can be achieved as:This tutorial will guide MSTR users to share dossiers through Web and Library. x: Use the "CREATE USER" outline to write a script to create a new user. 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. 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. Move objects within a project. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. Open the script. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. FOLLOW THESE STEPS: Create Object Manager Package: 1. Click the Connect button to launch the connector. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Select 'Export Project Schema. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. On the report toolbar I’ve highlighted six icons, in order from. 5. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . x, right-click on the project and select Delete, as shown in the following image: Method 2 - Via MicroStrategy Command Manager: A command in MicroStrategy Command Manager allows for the deletion of projects from the Command Manager. Unlock Project statement. ' from the MicroStrategy Developer 'Schema' toolbar menu. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. In this scenario, you typically use three environments: development, test, and production. Select the appropriate options to define the dynamic recipient list, as described above. 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). This knowledge base article explains how to migrate projects from one metadata database to another in MicroStrategy 9. MicroStrategy - Object Manager - Online Training Video by MicroRooster. )The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. Type "regedit. From the Select a Project drop-down list, select the project for which to assign the security role. 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. Using MicroStrategy Enterprise Manager 9. Operations cannot be performed from a newer metadata to an older. x. Click on Next. 3. Under Preferences Level, click Project Defaults. Import the document into the replacement project. 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. 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. To do this, follow the steps below: Open MicroStrategy Developer 10. x-10. This MicroStrategy tool can be used to test and troubleshoot. The data returned by the Platform Analytics project schema is never limited. 0 (Ashburn and Seattle): 1. Launch MicroStrategy Object Manager and connect to a project that is the migration source. Navigate to C:\Program Files\Common Files\MicroStrategy. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. 1 or later, or have been updated to version 9. In this scenario, you typically use three environments: development, test, and production. Duplication is the only way to get the projects into another environment. And check the option to Show 'Contains' and 'Contained by' tabs, as shown below: Go to 'Object Types' tab, and select 'Report' and 'Document'. 4. The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. by clicking the lock icon for the project. The duplicate key value is (<ID>). This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. One example is registering and loading a project at startup. Alternatively, click Add and the Add Objects window opens. To start the Report Wizard. Select Create project security package and the projects to include in the security access settings. 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. UNLOCK PROJECT project_name [FORCE]; where: PROJECT "project_name" is the name of the project to be unlocked, of type string. 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. In any case, a MicroStrategy Project helps developers and users to organize their reporting and analytics applications. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. So I want to create an embedded query to know which last objects. Applications of MicroStrategy. Specify the. Twenty-seventh Edition, version 9. 1 or later, or have been updated to version 9. 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. Log into command manager in 2-Tier(direct connection to the metadata) 2. 4. Deploy the ojdbc8. Create an Attribute. This is how the behavior is set and displayed from within MicroStrategy Developer 9. Click Add a New Dynamic Address List. There's a reason we're at the top of the list. x and 10. pimiento. An administrator user may duplicate projects from one project source to another project source, with the destination project source being a 3-tier project source. Go to the 'Database Instance Manager'. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. Select Create project security package and the projects to include in the security access settings. You can access this setting through the following steps: Log in to your Project Source. Specify the project source and project information that you are copying from (the source). 6. Add Category, SubCategory, and Cost to the dossier. with the MicroStrategy sample project called Tutorial - Delivery. MicroStrategy - Object Manager - Online Training Video by. Computation is separate from storage, which. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. This article explains how to to copy Partition Mapping tables and objects from one project to another in MicroStrategy Object Manager 9. Under Preferences, click General. '. 2 release, the driver file is called odbc8. Duplication is the only way to get the projects into another environment. For information about duplicating projects, including instructions, see Duplicate a Project. MicroStrategy provides modern analytics on an open,. 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. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. 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. 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. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. A list of security roles in the project source opens in the main Developer pane. 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. ACTION: Close the project source in MicroStrategy Object Manager to the MicroStrategy Tutorial metadata and then the user has the option of performing the duplication by clicking on Project -> Duplicate Project from the Object Manager menu as shown in the image below instead of MicroStrategy Developer if desired:Choose one of the following options: List all elements (no restriction): This option displays all of the attribute's elements to the user when he is answering the prompt. For example, [“MicroStrategy Tutorial”, “Enterprise Manager”] ProjectSourceName. Create a database instance that references the intended datamart location by performing the following steps. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. Duplicating projects Projects created in MicroStrategy 7 can be duplicated in the same project source or in a different one. The following window appears. ProjectsTransformCustomStatus. x. 5. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. Once the metadata shell is created, create a project source using this DSN. 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. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. 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. 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. Plus, it connects business apps while integrating data. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. Click Create a new Security Role next to Security Roles. x. The same report accessed in web. Copy objects within and across related projects. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. e. WORKAROUND.