In this scenario, you typically use three environments: development, test, and production. SUMMARY: This document shows one known issue that p roject duplication would fail when duplicating project related configuration objects if there is one database instance (DBI) without database connection in MicroStrategy Developer 10. The copy of the table is added to the project and. Expand Administration, and then expand System Monitors. x can be used to create a list of users within a single project source for export to Microsoft Excel. users can. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. location_path is the folder where the attribute resides, of type string, between double quotes ("). Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. Thus, the report has been moved to another folder within the same project. Sainsbury’s, a leading UK retailer deployed a comprehensive suite of applications that deliver best-in-class analytics experiences—powered solely by Snowflake, AWS, and the MicroStrategy Cloud. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. Was this post helpful? thumb_up thumb_down. Right-click on the Project Source and choose 'Intelligence Server Configuration'. When it’s set to 0, the project does not use unified quoting. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). Open MicroStrategy Web. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. A list of security roles in the project source opens in the main Developer pane. Copy objects within and across related projects. Note: We recommend you enable Add All Used Dependencies. I have a data set which has all tickets 'Not Closed' along with the 'Work Info Work Log Date' field added. 6. with the MicroStrategy sample project called Tutorial - Delivery. For information about duplicating projects, including instructions, see Duplicate a Project. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!Projects are related if one of the projects was created as a duplicate of the other. x. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. ' from the MicroStrategy Developer 'Schema' toolbar menu. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. 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. In some scenarios, MicroStrategy administrators or other users may need to find out the Windows domain account that is linked to a MicroStrategy user. In the Device Editor, click the Delivery Options tab. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. From the command line: MicroStrategy provides a command line utility for importing update packages. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. The destination project must be of the same metadata version or older metadata version as the source project. For example, to create a user with ID 'mstr_test' and full name "MSTR Test", type the following command:During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. The Revenue metric is said to be used by these other objects. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. 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. x, runs out of memory. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. 2. The important thing here is we do this in 2-Tier or Direct mode. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. Go back to MicroStrategy Desktop, right mouse click on the project -> Search for Objects. WORKAROUND. Note: This setting has to be check for every MicroStrategy project logging statistics. A warning message like the following can be observed:. 2 and above. Sometimes you need to deal with a data source that has duplicated data. 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. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. Select the “File from Disk” option. 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. 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. process, which is named M8DBMPE1 in MicroStrategy 7i - 7. BACKGROUND: When configuring a MicroStrategy Intelligence Server cluster, special configuration must be made in order for the Intelligence Server cluster nodes to be able to access report and document caches, intelligent cubes, history list messages, and session recovery files that were created on other nodes of the cluster. The administrator should stop. In MicroStrategy Developer, select the document to export. It is available as web-based or on-premise platform, along with native mobile apps. KB14574: How to list duplicate users per project in MicroStrategy Developer 10. . 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. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. In the Project Source Name field, type a name for the project source. When Windows Authentication is used, users are able to log in to the MicroStrategy projects using their respective Windows domain accounts. 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. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. Find an object's parents or children. x and 10. Then click OK. Log in to a project source in MicroStrategy Developer. For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. Note the project source that connects the Intelligence Server. The Scan MD tool executes tests to detect inconsistencies in the metadata. In the menu bar, go to Tools > Preferences. 2. x can be used to change the project status programmatically. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. Enter a name and description for the new security role. Search for objects within a project. x, create a new report with the following definition: Attributes . 4. 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. Copy the object by right-clicking and selecting Copy. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. 1. x-10. Step 8: Change the migrating objects to the following:. 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. Rename the Project to remove these characters, after which the project can be duplicated successfully. Click on 'Browse . Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. To create a configuration update package, copy the file createConfigPackage. Set Freeform SQL and MDX objects default security. You can define a new database connection for users to import data from, or edit, delete, rename, or duplicate. Log into Desktop 9. 1. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. Open the MicroStrategy Configuration Wizard. Click 'Next' after the introduction. For managed objects, navigate to the Administration menu, and select ProjectDelete unused managed objects -- if necessary . 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. Create a configuration package with user and/or user group objects and set their Action to Replace. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. The process will hang and MicroStrategy Developer will become unresponsive at any point. Click Next. Right click the Regions column header and select Advanced Formatting. Right click a project and select Duplicate Project. Using Object Manager, you can copy objects within a project or across projects. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. Create a DSN to Tutorial_WH_Copy, call it Ttrl_WH_Cpy_DSN; Connect to Ttrl_WH_Cpy_DSN with DB. 5. 2. Create a Custom Group with only one element "Year In list (2010)" in MicroStrategy Developer. x. In the destination project source, administrator privileges are required. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. ; In the Project Source Name field, type a name for the project source. 4. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. 1. . Instead, there is a report called 'Copy of Profit Forecast' and it can be found under the Product Sales Reports folder. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. Move objects within a project. ProjectsTransformCustomStatus. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. Search for objects within a project. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. Restart the MicroStrategy Intelligence Server. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Check the required options in the 'Export schema' dialog box and. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. ConnectionMode: - 2-tier for a direct (2-tier) project source connection. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In the destination project source, administrator privileges are required. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. 11?; Knowledge Base: Annotate. In the MicroStrategy system, every object has an ID (or GUID) and a version. Specify the IP address of the SMTP server. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. x. A project is duplicated between a 3-tier project source and a 2-tier project source. Project duplication setting is heart of the migration. 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. Click OK to confirm the deletion. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. In the Navigation pane, click Users and Groups. 4. In the Device Editor, click the Delivery Options tab. Learn on how to create filters in Microstrategy Web (dossier), both page level as well as global filter. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. Note: The Tutorial project is designed for MicroStrategy Web JSP. To do so, you can take advantage of URL API. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. Each environment contains a MicroStrategy project. This setting is ideal if you have numerous. 3. 3. For example, [“MicroStrategy Tutorial”, “Enterprise Manager”] ProjectSourceName. 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. 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. The Project Creation Assistant opens, as shown below: 3. Scan MD. 8. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. This issue has been addresses in MicroStrategy Developer 10. The reason why this method is required is that certain settings and features are set only upon the creation of a metadata and are database specific. If one of the attributes is removed from the template, the Cost is aggregated. Launch MicroStrategy Object Manager and connect to a project that is the migration source. Path is the path to the saved XML settings file. Double-click the security role you want to assign to the user or group. See To copy a document between projects for a detailed procedure. 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. with the MicroStrategy sample project called Tutorial - Delivery. Click Next and Finish. Twenty-seventh Edition, version 9. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in. 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. In MicroStrategy 10. Example: #Todumpalldatabases pg_dumpall>db. There's a reason we're at the top of the list. 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. Once logged on, expand the administration icon in the Folder List and browse to the Database Instance Manager. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. To move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. From the Tools menu, select ExportDocument Template. 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. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. 8-1. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. use the function "Remove Duplicate Rows". What action should be taken? The incomplete project cannot be repaired, therefore it must be deleted. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 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. See To copy a document between projects for a detailed procedure. In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. Right-click on the Project Source and choose 'Intelligence Server Configuration'. To do so, you can take advantage of URL API. spicehead-tvkpqyiu. 0. MicroStrategy Administrator - Object Manager is built with the assumption that two projects are related. Import the document into the replacement project. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Reload the login page. Select the appropriate options to define the dynamic recipient list, as described above. Hey even if it doesn't work you can unload and load the Project that's definitely works. 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. The Security Role Editor opens. The Project Documentation Wizard will run for only the selected objects. The document, named document_name. To create to a direct project source. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. MicroStrategy recommends that if you want to copy objects between two projects. So Since MSTR m2021 Update1, users can decide whether they want just machine name or FQDN for the server name in the link to History List. There's a reason we're at the top of the list. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. Rename objects within a project. Specify the port number where the SMTP server receives incoming e-mail. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10. 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. 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. Configure Intelligence Server with restored metadata with Configuration Wizard . Create the respective DSN's in the Intelligence Server machines. 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. Unlock Project statement. 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 Full option exports a snapshot of each page and each individual visualization. I have a question regarding duplicates in Microstrategy. exe -f Path\XMLFilename. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In this example, the project source is APS-CLIENT-2, as shown in the image below. In the left pane, click All Settings. Log into the 3-tier project source. 1. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. x. If you are leveraging Web ASP, see KB484127 to use this feature. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. x, execute the following steps: Connect to the project source and expand the project that is to be duplicated, as shown below: Right-click on the project name and. 3. 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. 1 and 10. Create a user as shown below: CREATE USER "jaime" PASSWORD "user" FULLNAME "jaime User" IN GROUP "Web Users"; Create a DbLogin for the user created in Step 2, as shown below: CREATE DBLOGIN "dblogin_ jaime" LOGIN "sa". From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. SYMPTOM: In MicroStrategy Developer, users may notice that subscriptions are missing after project. New user and application requirements make attribute creation and modification an important part of the entire project life cycle. Detail Levels You can now select the level of detail exported from your dossier. 4. UNLOCK PROJECT project_name [FORCE]; where: PROJECT "project_name" is the name of the project to be unlocked, of type string. A project created in MicroStrategy 6. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. Self-Service Analytics with Amica. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. 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). Duplicate the original project into the MS Access file In MicroStrategy Desktop, go to the menu Schema -> Duplicate Project; Select the project source of the original project to transfer; Login as MicroStrategy Administrator as screenshot below and click on 'Next' Why MicroStrategy Why MicroStrategy; Customer Stories; Platform To add copies of a table from other database instances. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. This will open project Creation Assistant / Wizard. See To copy a document between projects for a detailed procedure. While Technical Support can help to resolve these issues, the user would like to know how to avoid them in the future. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. 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. Create a database instance that references the intended datamart location by performing the following steps. 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. Please contact MicroStrategy Technical Support for an update on this issue. Unlocks a project in the metadata. Select Project Sources and click Next. Delete objects within a project. Creating a new project at the Source environment called P1. Consider the two scenarios below: 1. For more details, see Modify the Amount of Data Returned In-Memory for the Platform Analytics Cube. FOLLOW THESE STEPS: Create Object Manager Package: 1. 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. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. The user can do this by importing the layout of the second document into the first document. Run this script to delete the project (this step could take several minutes) a. MicroStrategy is a BI and analytics software, providing its clients big data processing, actionable across various deployments and devices. Select Create project security package and the projects to include in the security access settings. From the Select a Project drop-down list, select the project for which to assign the security role. Click on Create Project and Give suitable Project name and Click OK. In the original project, create the. If you like the video, please subscribe to my channel. 3. Project Comparison looks at each object ID in the source project, and compares it to the object in the destination project with the same ID. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. 1. Click Continue if the Preview Connector warning message pops up. I have to duplicate the project, change the fact table and change the related items. x Loading × Sorry to interruptFor this particular error, a database instance object is involved and when MicroStrategy Developer 10. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". 1 or later using the Perform system object ID unification option For Cloud 3. Right-click on the project name and select Duplicate Project. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. Click OK. Create the respective DSN's in the Intelligence Server machines. 4. After every project duplicate, disconnect and reconnect to Project Source. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. new_attr_name is the new name of the attribute, of type string, between double quotes ("). 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. x. Under the Tools menu, select Project Documentation. Create a new dossier, add new data, use Clipboard and input the sample data as below. Restart the MicroStrategy Intelligence Server to make the new settings take effect. x, follow the steps outlined below: In MicroStrategy Developer, log into the project source and open the project. Activate the Tutorial project at 3-Tier using one of the following methods. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Create an Attribute. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. Add | select in connection mode Server. 0. Name: ProjectsTransformCustomStatus. Click your Account drop-down and choose Preferences. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 3. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. The Scan MD tool searches for logical errors and fixes them within the platform object structure. 2. This is how the behavior is set and displayed from within MicroStrategy Developer 9. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. In the menu bar, go to Tools > Preferences. x, all users can see the project even if they could not see the project before duplication. 0, this Feature Flag has been removed and replaced with a project level setting called "Data Engine Version". Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Using Object Manager, you can copy objects within a project or across projects. In MicroStrategy 10. If you are leveraging Web ASP, see KB484127 to use this feature. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. 0. Object Manager and Project Merge both copy multiple objects between projects. Using MicroStrategy Enterprise Manager 9. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. KB12330: How to duplicate a project in MicroStrategy Developer 10. Follow the steps below to make the changes in MicroStrategy Web 9. What permissions are needed to allow a user to duplicate projects in MicroStrategy Developer. 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. Export the document from the original project. After duplicating a project in MicroStrategy Developer which uses LDAP Authentication, subscriptions may be missing. This MicroStrategy tool can be used to test and troubleshoot. For information about duplicating projects, including instructions, see Duplicate a Project. Click in “Add new data”. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. Object Manager and Project Merge both copy multiple objects between projects. Select an Environment from the upper-left drop-down. In this scenario, you typically use three environments: development, test, and production. In order for objects of two projects to be copied across, the schema IDs of the projects must match. Specify the project source of the project to be duplicated in the Direct Project Sources section. x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. 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. Our vision is to enable Intelligence Everywhere. When creating a logical table, there are two ways how the user can define the column objects. 52K. To export a project schema to an Excel file in MicroStrategy Developer 9. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. Update the project schema . And then in the first document, import the. You can. These two components. In MicroStrategy Developer, duplicate each of the projects into this new project source.