How to duplicate project in microstrategy. 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). How to duplicate project in microstrategy

 
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)How to duplicate project in microstrategy x

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. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformChoose a project, right click on it and select “ Duplicate Project” 2. 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. 2. 1. Enter a name and description for the new security role. Open the Workstation window with the Navigation pane in smart mode. 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. 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. 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. bat, as shown below, to run PurgeObjectCache. A list of security roles in the project source opens in the main Developer pane. For information about duplicating projects, including instructions, see Duplicate a Project. Note: The Tutorial project is designed for MicroStrategy Web JSP. 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. Deploy the ojdbc8. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. In. To export a document template. These two components. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. pkg. In MicroStrategy Developer 10. Copy objects within and across related projects. 4. 2 release, the driver file is called odbc8. exe", the syntax is: ProjectDuplicate. 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. jar file to i-server machine. x and how duplicate columns can be created. 2. x. In the menu bar, go to Tools > Preferences. How to delete, invalidate or expire caches from a specific project in MicroStrategy Developer. This would change the project version so that the Copy and Paste would work. A Dockerfile describes what goes into a. From the Schema menu, select Create New Project. 2. In order for objects of two projects to be copied across, the schema IDs of the projects must match. To start the Report Wizard. MicroStrategy recommends that if you want to copy objects between two projects. Add the following to the code: public void renderProjectStatus. When Duplicate Cloud Wallet Connection DB Role Needs to Re-upload the Wallet Zip file in MicroStrategy 2021 Update 3Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. In some scenarios, MicroStrategy administrators or other users may need to find out the Windows domain account that is linked to a MicroStrategy user. Published: Jun 3,. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. Right-click on the right-hand side of Desktop, select New, and then select Report. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. Request a demo. . Object Manager and Project Merge both copy multiple objects between projects. x. After loading, MicroStrategy will present a window like this. Click your Account drop-down and choose Preferences. 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. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. MicroStrategy - Object Manager - Online Training Video by. You can unlock the schema in the Schema Editor . x, create a new report with the following definition: Attributes . 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. You can access this setting through the following steps: Log in to your Project Source. 0. 3. Specify the port number where the SMTP server receives incoming e-mail. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. Use Object Manager when you have only a few objects that need to be copied. 1 or later using the Perform system object ID unification option For Cloud 3. Under Preferences Level, click Project Defaults. To combine two documents. e. Select the Members tab. new_attr_name is the new name of the attribute, of type string, between double quotes ("). 6. jar. 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. PAProject= Defines whether to create the Platform Analytics project, as determined by the following values: • 1: Create the Platform Analytics project on this machine. This article explains how to to copy Partition Mapping tables and objects from one project to another in MicroStrategy Object Manager 9. Open the MicroStrategy Configuration Wizard. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. In MicroStrategy Web 9. 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. These updates are intended to help our customers keep their. x and M8MulPrc_32 in 7. Cannot insert duplicate key in object 'dbo. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. MicroStrategy 10 will report the following errors if the path specified in Project Configuration>Intelligent Cubes>General>Intelligent Cube file directory is not accessible:On the upper right of any page, click your user name, and then select Preferences from the drop-down list. In the left pane, click All Settings. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. Removing duplicates (cross joined data) in MicroStrategy Desktop. If the version is different and only project GUID is the same, the two projects are taken as different version of one same project and the operation would succeed. 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". This software features interactive dashboard, monitoring company's assets, and finance operations, enabling them to. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. 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. Now, enter your username and hashed password copied from the database and login. Double-click the security role you want to assign to the user or group. MicroStrategy recommends that if you want to copy objects between two projects. Open both folders in which the user is located for each project source. Case() and CaseV() functions are Analytical Engine functions, i. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 2 and above. Create an Attribute. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. If you have dossiers in a shared environment, you can copy the dossier to a new location in the same environment. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. (From the File menu, select Open. On the report toolbar I’ve highlighted six icons, in order from. 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. Expand the destination project in which you want to paste the object, and then select the folder in which you want to paste the object. I've been working in the past few years with Cognos 10 and Cognos 11 but my company has Microstrategy (I'm a newbie in Microstrategy). In the original project, create the document to be used as a portable document. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. This. 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. 3. There's a reason we're at the top of the list. Find an object's parents or children. So I want to create an embedded query to know which last objects. 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. MicroStrategy SDK 9. In the Device Editor, click the Delivery Options tab. Follow Steps 1 to 10 to decide the parameters of the duplication process . x. In MicroStrategy Developer, duplicate each of the projects into this new project source. Select Configure Intelligence Server, and click Next. Open the Workstation window with the Navigation pane in smart mode. When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. The destination project must be of the same metadata version or older metadata version as the source project. Change the password of the account. Right-click the project where you want to use the exported settings and choose Properties. FORCE forces the project to unlock. The Page level option only provides a snapshot of each page. In the Folder List, expand the project that contains the object you want to copy, then navigate to the object. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. In this scenario, you typically use three environments: development, test, and production. 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. Each environment contains a MicroStrategy project. 8-1. This data is stored as Intelligent Cubes. Input connection parameters for the connector:Click Create on any folder page, point to New Report, and select Intelligent Cube Report. 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. SYMPTOM: In MicroStrategy Developer, users may notice that subscriptions are missing after project. To do this, follow the steps below: Open MicroStrategy Developer 10. Click Add, select the elements, then click OK. See To copy a document between projects for a detailed procedure. Create a database instance that references the intended datamart location by performing the following steps. Drag and drop the objects into the report grid. Using Object Manager, you can copy objects within a project or across projects. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. Update packages are part of Object Manager. For information about duplicating projects, including instructions, see Duplicate a Project. Set Freeform SQL and MDX objects default security. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. In the destination project source, administrator privileges are required. x can be used to change the project status programmatically. Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. 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. If the Starburst menu is clicked again, the user will see that the font of. The highlighted setting can be used to refresh MicroStrategy office report. 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. Object Manager and Project Merge both copy multiple objects between projects. Right-click on the Project Source and choose 'Intelligence Server Configuration'. 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 . MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. 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. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. DSSErrors. - Administration -> 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. 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. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. For multiple projects, add brackets with each project name in quotations separated by commas. What action should be taken? The incomplete project cannot be repaired, therefore it must be deleted. To create to a direct project source. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. Selecting a database instance check box makes that database instance available in the project for standard MicroStrategy. Click Add, select the elements, then click OK. 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. 1. The Full option exports a snapshot of each page and each individual visualization. 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. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. This MicroStrategy tool can be used to test and troubleshoot. Go to the System Objects folder and right-click on the column that is being removed to Search for Dependents. 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. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. 1 and 10. From the Select a Project drop-down list, select the project for which to assign the security role. What permissions are needed to allow a user to duplicate projects in MicroStrategy Developer. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. This is because. Step 3. In MicroStrategy Desktop, log in to a project. A project is duplicated between a 3-tier project source and a 2-tier project source. A Administrator decides to run a project merge against a newly duplicated project in MicroStrategy 9. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. x. The Security Role Editor opens. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. 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. Application objects include reports and documents, and the objects used to create them,. 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. x. Click in the right pane. Please subscribe to the channel to get an update with videos and help us to get 5000. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. 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. Move objects within a project. The important thing here is we do this in 2-Tier or Direct mode. e. Follow the steps below to make the changes in MicroStrategy Web 9. For example, a user copies a report from the source project to the destination project. This issue has been addresses in MicroStrategy Developer 10. Select Project Sources and click Next. 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 copy of the child will not be used by the parent. Save the XML file of all trial upgrade. 4. Note: This setting has to be check for every MicroStrategy project logging statistics. Navigate to C:\Program Files\Common Files\MicroStrategy. ConnectionMode: - 2-tier for a direct (2-tier) project source connection. x - 9. The copy of the child will not be used by the parent. 'Product 01' is licensed for 0 named users. 3. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. Specify the IP address of the SMTP server. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. To create a configuration update package, copy the file createConfigPackage. This is by design. To copy the users or security filters in a group, select the users from a list of that group's used-by dependents and then copy them. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. When duplicating a project, the following options apply to subscriptions for the selected users: Include user delivery subscriptions – This will duplicate cache update, History List message, Mobile, Intelligent Cube update, email, file, and print subscriptions for the duplicated users. The following window appears. See To copy a document between projects for a detailed procedure. Quoting Behavior is a setting created to control whether a project uses unified quoting. Using Object Manager, you can copy objects within a project or across projects. Note: We recommend you enable Add All Used Dependencies. Review any messages displayed when attempting to import a copy of a table from a different data. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Twenty-seventh Edition, version 9. log (C:Program FilesCommon FilesMicroStrategy) DuplicateCorruptedObjects. x, open the Project Configuration window by right-clicking on a project and choosing 'Configure Project'. Go to Menu -> Tools -> Options. 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. I have to duplicate the project, change the fact table and change the related items. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. To duplicate a project in MicroStrategy Develper 10. In the original project, create the document to be used as a portable document. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. 5. KB12330: How to duplicate a project in MicroStrategy Developer 10. (the target objects of those shortcuts) to the new project. Using Tutorial data&colon; To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. There's a reason we're at the top of the list. To export a project schema to an Excel file in MicroStrategy Developer 9. The duplicate connection is automatically created and displayed in the Database Connections panel. 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. )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. 4. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. The data returned by the Platform Analytics project schema is never limited. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. currentFactDataKeepDays:. 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. 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. MicroStrategy recommends that if you want to copy objects between two projects. 2. Select the appropriate options to define the dynamic recipient list, as described above. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. If an Universal version of the Intelligence Server is used, the Query Engine is a 64-bit component and will not encounter the same memory limitation as the 32-bit version of the Query Engine that. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). 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. Create a new dossier, add new data, use Clipboard and input the sample data as below. out l. location_path is the folder where the attribute resides, of type string, between double quotes ("). Assuming that the statistics tables have already been created in the. x:. To create to a direct project source. with the MicroStrategy sample project called Tutorial - Delivery. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data. 5. Go to 'Contains' tab, and click on Add button. Then click OK. This method is recommended and supported by MicroStrategy. x. Click Select. Create a copy of the Tutorial Warehouse, call it Tutorial_WH_Copy. Go to each of the attributes and facts returned by the dependency search. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). 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. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". Deploy the ojdbc8. Operations cannot be performed from a newer metadata to an older version. In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. 1 Number of Views 1. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. x. Right-click a project in that project source and select 'Compare projects' or select. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. 5. From the Select a Project drop-down list, select the project for which to assign the security role. log (C:Program FilesCommon FilesMicroStrategy) From the example above, the logs are not truncated by the character length restrictions:To pick up the fix, enable project level setting “Data Engine Version” to 2020 or above. No users should be connected to the project. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. 1 - 10. ; Go to Connection Type > Direct (2-tier), and click Next. DSSCSADDRESS'. 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. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. Refresh. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 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. Log into command manager in 2-Tier(direct connection to the metadata) 2. When user navigates to "Project Tables View" tab in MicroStrategy Architect 10. 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). This is a known issue in MicroStrategy 10. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. configure a project to collect statistics. For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. A list of security roles in the project source opens in the main Developer pane. See To copy a document between projects for a detailed procedure. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. If you are leveraging Web ASP, see KB484127 to use this feature. Case() and CaseV() functions are Analytical Engine functions, i. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. Applications of MicroStrategy. Some uses for this data include: •. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. On the source computer, go to Start > Run. In the Project Duplication window, the hang appears to occur after finishing the property set objects. The Scan MD tool executes tests to detect inconsistencies in the metadata. e. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Rename objects within a project. If you want to merge two projects, MicroStrategy recommends that the projects have related schemas. In the original project, create the. The hang will only occur when the database instance. The Full option exports a snapshot of each page and each individual visualization. x. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. 8-2. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. Transform description: This transform displays project status on the Projects page. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. 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. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. 3. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. 8. Plus, it connects business apps while integrating data. Open a project source in MicroStrategy Object Manager. x and later. One means of doing this is to use the "List all metrics for project" outline under OutlinesMetrics in Command Manager and export the content for further analysis. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. Edit the line within the function that takes your login input. There's a reason we're at the top of the list. For information about duplicating projects, including instructions, see Duplicate a Project. Click on 'Browse . Log into the 3-tier project source. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. 2. Provide a Project Source name. While Technical Support can help to resolve these issues, the user would like to know how to avoid them in the future. This will open project Creation Assistant / Wizard. Update the project schema . spicehead-tvkpqyiu. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. out l. Right-click on the project name and select Duplicate Project. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. After deleting the incomplete project, the duplication.