how to duplicate project in microstrategy. 0 (Ashburn and Seattle): 1. how to duplicate project in microstrategy

 
0 (Ashburn and Seattle): 1how to duplicate project in microstrategy  Click the Connect button to launch the connector

jar file to i-server machine. x, open the Project Configuration window by right-clicking on a project and choosing 'Configure Project'. 4. 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 path begins with a dot, the directory will be found in the Intelligence Server installation directory. 5. 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. " and select all users and groups, except for. x. This is a known issue in MicroStrategy 10. Expand the My Personal Objects folder, and then open the My Reports folder. 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. Click Select. 4. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. ProjectsTransformCustomStatus. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. In the source metadata,. 1. Step 8: Change the migrating objects to the following:. In MicroStrategy 10. Click on "Select users. In the MicroStrategy system, every object has an ID (or GUID) and a version. You can use a scheduler such as Windows Scheduler to import the package. Using Object Manager, you can copy objects within a project or across projects. Move objects within a project. 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. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. x. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. KB290890: Project duplication wizard hang when attempting to duplicate a project in MicroStrategy Developer 9. Add | select in connection mode Server. 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. 2. Using Cache Monitor From the Cache Monitor under Administration for a Project Source, it is easy to identify to which project does each cache belong or to filter all the caches for a project identifying one of the caches for that project. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. For this Click on Schema and Click on Create New Project. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. In MicroStrategy Developer 9. Click Yes. After deleting the incomplete project, the duplication. In MicroStrategy Developer, duplicate each of the projects into this new project source. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. The following. Companies of all sizes use this platform to assess, visualise, and build dashboards. The Full option exports a snapshot of each page and each individual visualization. Restart the MicroStrategy Intelligence Server to make the new settings take effect. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Open Command Manager and type the following commands to execute the Intelligent Cubes. 2. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. NOTE: Only users with administrative privileges are able to select this option. Sometimes you need to deal with a data source that has duplicated data. Change the password of the account. 4. Case() and CaseV() functions are Analytical Engine functions, i. 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. 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). Find an object's parents or children. Specify the port number where the SMTP server receives incoming e-mail. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. In MicroStrategy Developer, select the document to export. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. 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. To export a project schema to an Excel file in MicroStrategy Developer 9. 1. For information about duplicating projects, including instructions, see Duplicate a Project. The report can be executed in MicroStrategy Web. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. 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. x: Use the "CREATE USER" outline to write a script to create a new user. Open a project source in MicroStrategy Object Manager. Click on Next. Click in the right pane. exe". Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". Update packages are part of Object Manager. xml. On the Data Sources pane on the left, hover over the name of the database connection to modify and click the arrow icon. There's a reason we're at the top of the list. This setting is ideal if you have numerous. 1. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. 5. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. SELECT project_id, object_id, object_type, subtype, object_name, abbreviation, description, version_id, parent_id, owner_id,. Published: Jun 3,. Under Preferences Level, click Project Defaults. 8. 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. An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. See To copy a document between projects for a detailed procedure. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Object Manager looks in the destination project's Public Objects folder for a subfolder named Report Dependents (the same path as in the source. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. 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. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. Select Project Sources and click Next. In MicroStrategy Web 9. Article. The Security Role Editor opens. The same report accessed in web. 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. 4. For Oracle 12. 3. Duplicating projects Projects created in MicroStrategy 7 can be duplicated in the same project source or in a different one. In the left pane, click All Settings. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. 1. Start Power BI Desktop. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. Create the respective DSN's in the Intelligence Server machines. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. x SYMPTOM: When use 3rd party security scan tool such as Acunetix Web Vulnerability Scanner or IBM Security AppScan Standard to implement the security scan toward MicroStrategy Web 10. MicroStrategy recommends that if you want to copy objects between two projects. In the Project Duplication window, the hang appears to occur after finishing the property set objects. Select the Members tab. 8-1. 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 method is recommended and supported by MicroStrategy. 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. To invoke the "ProjectDuplicate. Select an Environment from the upper-left drop-down. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. 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. There's a reason we're at the top of the list. Create an Attribute. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Every object in a MicroStrategy project has a unique ID. Click OK. You are currently using 1 named users. for Superclass and search for 'ProjectsTransform'. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. The user can do this by importing the layout of the second document into the first document. authored through Developer and are tightly coupled to a MicroStrategy. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. 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. Specify the IP address of the SMTP server. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. 2 and above. Select Create project security package and the projects to include in the security access settings. 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. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". The process will hang and MicroStrategy Developer will become unresponsive at any point. Right click the Regions column header and select Advanced Formatting. Click in “Add new data”. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). 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. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B. 6. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. Add Category, SubCategory, and Cost to the dossier. Open the MicroStrategy Configuration Wizard. If one of the attributes is removed from the template, the Cost is aggregated. x as shown below: Duplication might fail right after property transfer completed if no users were duplicated or after user objects load/save finished if all users or project related users were selected to be duplicated. The Metadata Update Utility is a utility responsible for updating the metadata with the latest project information based on the version of MicroStrategy Developer from the machine on which the utility is installed and executed. To achieve this, perform the following steps: Open MicroStrategy Command Manager and log into the appropriate Project Source and provide a user name and password for each user with access to the. Options in this portion refer to creating the Platform Analytics project on this machine. Using MicroStrategy Enterprise Manager 9. Go to the Project Monitor under Administration, as shown below:I am new to the Microstrategy, I need some tips to do my task involves change of fact table in a project. . x, all users can see the project even if they could not see the project before duplication. 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. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). Application objects are not seen even after selecting the option to duplicate all objects to the new project. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. 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). From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. The Full option exports a snapshot of each page and each individual visualization. Design intuitive analytics reports with MicroStrategy ONE. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. 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. Reload the login page. This issue has been addresses in MicroStrategy Developer 10. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. 2 release, the driver file is called odbc8. 0 (Ashburn and Seattle): 1. I have to duplicate the project, change the fact table and change the related items. 4. Type mstrcmdmgrw and press Enter. Note: This setting has to be check for every MicroStrategy project logging statistics. The duplicate key value is (<ID>). - Administration -> Duplicate project. Add Category, SubCategory, and Cost to the dossier. x-10. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. x. In the destination project source, administrator privileges are required. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Rename objects within a project. 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). 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. The duplicate key value is (<ID>). From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. When it’s set to 0, the project does not use unified quoting. The Scan MD tool searches for logical errors and fixes them within the platform object structure. x, all users can see the project even if they could not see the project before duplication. 2. A list of security roles in the project source opens in the main Developer pane. MicroStrategy recommends that if you want to copy objects between two projects. . Use the project duplication function to duplicate only the Tutorial project to your metadata. 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. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. KB14574: How to list duplicate users per project in MicroStrategy Developer 10. (From the File menu, select Open. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. x, create a new report with the following definition: Attributes . users can. 3. Object Manager and Project Merge both copy multiple objects between projects. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. Note: The Tutorial project is designed for MicroStrategy Web JSP. KB38452: What can cause profile folders to get duplicated after a MicroStrategy Developer Project Duplication? Number of Views 916. e. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. 3. Consider a project (P1) in a Project Source that must be duplicated to project (P2) in the same PS but pointing to a different warehouse. Log into the 3-tier project source. These two components. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. 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). Across corporate functions. 3. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. 3. A list of security roles in the project source opens in the main Developer pane. Follow Steps 1 to 10 to decide the parameters of the duplication process . To start the Report Wizard. A project is duplicated between a 3-tier project source and a 2-tier project source. If the Starburst menu is clicked again, the user will see that the font of. For information. java opens in the editor. Unified Quoting: Solutions to Quoting Pattern Challenges. 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. When a MicroStrategy Administrator duplicates a user, the security filters tied to the original user are not tied to the new user. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. with the MicroStrategy sample project called Tutorial - Delivery. Click Create a new Security Role next to Security Roles. Operations cannot be performed from a newer metadata to an older version. Add the following to the code: public void renderProjectStatus. Click the “Select File” option. From the DSN drop-down list, select the DSN used to connect to the metadata repository. If you are leveraging Web ASP, see KB484127 to use this feature. Please subscribe to the channel to get an update with videos and help us to get 5000. Open License Manager on the Intelligence Server machine and open Audit. 4. x. 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. Refresh. In the menu bar, go to Tools > Preferences. x?How to prevent content spoofing on projects page affecting Intelligence Server name using MicroStrategy Web 10. MicroStrategy Object Manager: A lifecycle management tool designed for MicroStrategy environments, and helps you to copy various objects inside a project or across different related projects. spicehead-tvkpqyiu. No users should be connected to the project. 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. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. Export the document from the original project. From the left, select Dynamic Address Lists. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. Right click a project and select Duplicate Project. Required Status to Perform Action. 1 - 10. 1 or later, or have been updated to version 9. Note: This setting has to be check for every MicroStrategy project logging statistics. MicroStrategy Administrator - Object Manager is built with the assumption that two projects are related. x. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. Delete option is performed on the Intelligent Cube, and data is not compared with the warehouse. . Use Object Manager when you have only a few objects that need to be copied. In this scenario, you typically use three environments: development, test, and production. 3. Specify the port number where the SMTP server receives incoming e-mail. x-10. MicroStrategy - Object Manager - Online Training Video by MicroRooster. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. A Administrator decides to run a project merge against a newly duplicated project in MicroStrategy 9. 1 Number of Views 1. In the Device Editor, click the Delivery Options tab. Starting MicroStrategy 11. With the option 'Insert from file' from the Insert tab there is no access to the live model To link one file from a cloud project to another use External Resources. FOLLOW THESE STEPS: Create Object Manager Package: 1. 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. When the Conflict Resolution screen appears, only select the User being replaced: After the replace has completed, close Object Manager and log. 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. Open the script. There's a reason we're at the top of the list. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. 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. The following window appears. Learn on how to create filters in Microstrategy Web (dossier), both page level as well as global filter. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. Click your Account drop-down and choose Preferences. And then in the first document, import the. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. x from the command line by using the following command:. This is a known issue in MicroStrategy 9. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. Rename the Project to remove these characters, after which the project can be duplicated successfully. You can. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. Deploy the ojdbc8. 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 following example shows how to create a metric that displays attribute values in MicroStrategy Developer. Assuming that the statistics tables have already been created in the. Click 'Next' after the introduction. If the. Example: #Todumpalldatabases pg_dumpall>db. 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. 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. Explanation: The name will use the browser default language preferences, English (United States) in this case. The Revenue metric is said to be used by these other objects. In. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. They may be compared in either 2-tier or 3-tier. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingALTER ATTRIBUTE "Copy of Day" IN FOLDER "Schema ObjectsAttributes" HIDDEN FALSE FOR PROJECT "MicroStrategy Tutorial"; UPDATE SCHEMA REFRESHSCHEMA RECALTABLEKEYS RECALTABLELOGICAL RECALOBJECTCACHE FOR PROJECT "MicroStrategy Tutorial";To rename a dossier, right-click it and choose Rename. 1 Hotfix 7, if a user navigates to the "Shared Reports" folder, then clicks on the top left MicroStrategy Startburst icon, and navigates to "My Reports", the page will reload, but the page will still show the contents of the “Shared Reports” folder. 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. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in. For the default contact for the user, this will duplicate. When user navigates to "Project Tables View" tab in MicroStrategy Architect 10. Transform description: This transform displays project status on the Projects page. 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. Save the XML file of all trial upgrade. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". 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. 4. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . To move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. This. 2. 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. '. Self-Service Analytics with Amica. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. In the source project, all dependents of the report are stored in the Public Objects\Report Dependents folder. Connect to a project source or Narrowcast Server. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Step 2. The highlighted setting can be used to refresh MicroStrategy office report. 1. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. From the Schema menu, select Create New Project. Path is the path to the saved XML settings file. 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. For example, in the MicroStrategy Tutorial project, the Revenue metric has used-by dependencies of many reports and even other metrics. This is by design. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. new_desc is the new description of the attribute, of type string,. In the left pane, click All Settings. In the source metadata, create an empty. ACTION Modify the project configuration of source project or destination project and save it. Copy objects within and across related projects. In the Log Options screen, leave the default log locations and select Next . 1. e. 5. pkg. 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. There's a reason we're at the top of the list. Each environment contains a MicroStrategy project. . This will open project Creation Assistant / Wizard.