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. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. To do this, follow the steps below: Open MicroStrategy Developer 10. In the MicroStrategy system, every object has an ID (or GUID) and a version. 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. new_desc is the new description of the attribute, of type string,. One workaround is to check each DBI and make. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. In any case, a MicroStrategy Project helps developers and users to organize their reporting and analytics applications. x. In the source metadata, create an empty. 2. In the Project Duplication window, the hang appears to occur after finishing the property set objects. 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. 4. 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). (the target objects of those shortcuts) to the new project. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. The Duplicate. This will open project Creation Assistant / Wizard. 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. Click OK to confirm the deletion. pkg. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. The Security Role Editor opens. There's a reason we're at the top of the list. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. location_path is the folder where the attribute resides, of type string, between double quotes ("). x. x and later. The process will hang and MicroStrategy Developer will become unresponsive at any point. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. Click 'Next' after the introduction. Quickly integrating data into MicroStrategy as part of a proof-of-concept. 2987. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . bat, as shown below, to run PurgeObjectCache. 0. Right click a project and select Duplicate Project. " Microstrategy developers also use communication skills in their role according to a real resume snippet: "created various dashboards using report studio and implemented portal communication in the. Create a Custom Group with only one element "Year In list (2010)" in MicroStrategy Developer. To start the Report Wizard. Note: This setting has to be check for every MicroStrategy project logging statistics. The user can do this by importing the layout of the second document into the first document. This method is recommended and supported by MicroStrategy. Sometimes you need to deal with a data source that has duplicated data. Open a project source in MicroStrategy Object Manager. x, below cross site scripting issue was. What permissions are needed to allow a user to duplicate projects in MicroStrategy Developer. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. In the menu bar, go to Tools > Preferences. log has the following entries: The steps below desmonstrate how to use the project duplication in command-line mode: Go to Start > Run, and type in "cmd. 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. Exporting creates a package file with the extension . 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. Step 4. 6. For information about duplicating projects, including instructions, see Duplicating a Project. Use Object Manager when you have only a few objects that need to be copied. x, right click on the project of interested and select 'Project Configuration' from the menu, as shown below: Once the window for 'Project Configuration' opens, expand the 'Database instances' menu and go to the `Relational` section to see the database instance(s) currently in use for the project. 4. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. 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. Click Save. Configure Intelligence Server with restored metadata with Configuration Wizard . x-10. x. The copy of the child will not be used by the parent. There's a reason we're at the top of the list. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. In the "Format: Template" window click on the "Color and Lines" tab. 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. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 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. 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. The Browse for Folder dialog box opens. 2. x from the command line by using the following command:. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . The same report accessed in web. When copying objects across projects with Object Manager, if an object with the same ID as the source object exists anywhere in the destination project, a conflict occurs and the. To achieve this, there are two ways:When logging into MicroStrategy Developer (formerly Desktop), it can be seen that Profit Forecast no longer can be seen under the Financial Reports folder. 3. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. The destination project must be of the same metadata version or older metadata version as the source project. A document with ‘Year’ in Grouping, and attribute ‘Year’ in row, metrics ‘Revenue’ and ‘Cost’ in column as shown below: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 merging or removing duplicate columns. When it’s set to 0, the project does not use unified quoting. This article explains how to to copy Partition Mapping tables and objects from one project to another in MicroStrategy Object Manager 9. Step 2. For more details about this setting, refer to Change Data Engine Version Detailed reproduce steps: In MicroStrategy Web, create a new Dossier and click on New Data and select Databases and pick following 2 tables ; Choose Access mode to be "In-Memory"Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. 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. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Copy the object by right-clicking and selecting Copy. Explanation: The name will use the browser default language preferences, English (United States) in this case. 52K. Note: This setting has to be check for every MicroStrategy project logging statistics. 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. The duplicate connection is automatically created and displayed in the Database Connections panel. 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. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. Click Add, select the elements, then click OK. For more details, see Modify the Amount of Data Returned In-Memory for the Platform Analytics Cube. 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. x, runs out of memory. To see the ID and version of an object, right-click the object and select Properties. 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". Restart the MicroStrategy Intelligence Server. Under the Tools menu, select Project. use the function "Remove Duplicate Rows". The highlighted setting can be used to refresh MicroStrategy office report. 1 and 10. Using the Connector. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. Note: The Tutorial project is designed for MicroStrategy Web JSP. You are currently using 1 named users. 6. Connect to a project source or Narrowcast Server. There's a reason we're at the top of the list. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). 3 and click an attribute, no lines are being graphically displayed to reflect mapping to some tables. '. The Security Role Editor opens. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. 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. 3. For information about duplicating projects, including instructions, see Duplicate a Project. 3. Name: ProjectsTransformCustomStatus. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. In the menu bar, go to Tools > Preferences. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. Please subscribe to the channel to get an update with videos and help us to get 5000. Delete objects within a project. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. I have to duplicate the project, change the fact table and change the related items. I have a data set which has all tickets 'Not Closed' along with the 'Work Info Work Log Date' field added. The process will hang and MicroStrategy Developer will become unresponsive at any point. Right-click a project in that project source and select 'Compare projects' or select. (From the File menu, select Open. This can be achieved as follows: Connect to a project. Use Object Manager when you have only a few objects that need to be copied. See To copy a document between projects for a detailed procedure. 3. From the Select a Project drop-down list, select the project for which to assign the security role. 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. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. Select the Members tab. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Operations cannot be performed from a newer metadata to an older version. 86K KB12504: Administrator user is unable to delete unloaded projects in a 3-tier project source after project duplication in. Cannot insert duplicate key in object 'dbo. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Managing Data Source Connections. Log into the 3-tier project source. 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. This. How to duplicate the Project:- Object Manager in MicroStrat…In MicroStrategy Desktop, log onto the source project containing the project to duplicate and. If the Starburst menu is clicked again, the user will see that the font of. x, create a new report with the following definition: Attributes . There's a reason we're at the top of the list. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. 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. Using Object Manager, you can copy objects within a project or across projects. To edit the database connection, click Edit. Otherwise, the link to History List will keep the same as before. Select Create project security package and the projects to include in the security access settings. There are now two new VLDB properties that control quoting behavior. 2 and above. A list of security roles in the project source opens in the main Developer pane. Follow the steps below to make the changes in MicroStrategy Web 9. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. Each environment contains a MicroStrategy project. x. 4. Line 2 qty_sold number is updated. 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. x. Required Status to Perform Action. In MicroStrategy Developer, select the document to export. configure a project to collect statistics. 2 release, the driver file is called odbc8. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. x. Choose a Source Project Source and Source Project as well as a Destination Project Source and Destination Project. 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. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. • 0: Do not create the Platform Analytics 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. Specify the port number where the SMTP server receives incoming e-mail. . In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. The following steps show how to create a new user and add the user to multiple user groups in MicroStrategy Command Manager 9. Note the project source that connects the Intelligence Server. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Search for objects within a project. If the. When Windows Authentication is used, users are able to log in to the MicroStrategy projects using their respective Windows domain accounts. x, all users are able to see. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. 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 - Object Manager - Online Training Video by. Right-click the project where you want to use the exported settings and choose Properties. log (C:Program FilesCommon FilesMicroStrategy) DuplicateCorruptedObjects. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. This will produce an html document containing the search results and any information that is selected about those objects. flag Report. In the left pane, click All Settings. Ensure that the project schema for your new attribute is available for editing. 4. The document, named document_name. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. 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 is a BI and analytics software, providing its clients big data processing, actionable across various deployments and devices. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. The copy of the child will not be used by the parent. 1. 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). Navigate to the folder to save the file in, then click OK. 3. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. with the MicroStrategy sample project called Tutorial - Delivery. Perform a manual load on MicroStrategy Enterprise Manager; Delete user 'A' from MicroStrategy Developer; Create a new user 'A' with the same name as the old one. It is recommended that, if you plan to try the Tutorial - Delivery sample project to learn about Narrowcast Server, you perform the Click Modify to open the Properties dialog box: Security tab. Click on "Select users. To do so, you can take advantage of URL API. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. 3. Note: We recommend you enable Add All Used Dependencies. Log into Desktop 9. A warning message like the following can be observed:. 2. Click on Create Project and Give suitable Project name and Click OK. 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. Supported data structure and distribution on Gateway. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. 2012-04-25T09:22:00Z. In MicroStrategy Developer, duplicate each of the projects into this new project source. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. If you are leveraging Web ASP, see KB484127 to use this feature. Select and edit the specified. For. The Full option exports a snapshot of each page and each individual visualization. Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. Cannot insert duplicate key in object 'dbo. 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. This issue has been addresses in MicroStrategy Developer 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. Right click the Regions column header and select Advanced Formatting. The administrator should stop. 'Product 01' is licensed for 0 named users. Click Add a New Dynamic Address List. In this scenario, you typically use three environments: development, test, and production. 3. DSSCSADDRESS'. We decided to gather them in one placing using our experience and MicroStrategy materials. 8. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. " Navigate to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicroStrategyData Sources. Choose 'Database Instance Wizard'. You can access this setting through the following steps: Log in to your Project Source. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. Copy Objects Object Manager can copy application, schema, and configuration objects. 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. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. Select the Members tab. 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. The duplication wizard hangs at different steps during subsequent duplication attempts. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. e. MicroStrategy Administrator - Object Manager is built with the assumption that two projects are related. - 3-tier for a server (3-tier) project source connection. 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. To invoke the "ProjectDuplicate. 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. Receive a list of. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. x. The duplicate key value is (<ID>). Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. Note: We recommend you enable Add All Used Dependencies. 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. 3. Using Object Manager, you can copy objects within a project or across projects. Go to the System Objects folder and right-click on the column that is being removed to Search for Dependents. Select the element, and go to Menu -> Custom Group -> Show Display Options, as shown below: Select the last option "Show the element names, individual items within this element and also, expand these individual items if possible",. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. . 6. x cannot be duplicated until it is upgraded toThis article discusses an issue where subscriptions are marked invalid and deleted after duplicating a project to another metadata in MicroStrategy Developer 10. For managed objects, navigate to the Administration menu, and select ProjectDelete unused managed objects -- if necessary . x. For information. The duplication log shows the duplication is stuck while duplicating a specific user object. Open License Manager on the Intelligence Server machine and open Audit. x. Right-click on the Project Source and choose 'Intelligence Server Configuration'. By default all. Set Freeform SQL and MDX objects default security. 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. 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. Click the “Select File” option. If one of the attributes is removed from the template, the Cost is aggregated. In MicroStrategy, the metadata repository is a database that contains the definitions of database objects such as tables and fields in a way that developers and users can easily understand. Specify the project source of the project to be duplicated in the Direct Project Sources section. Select Project Sources and click Next. While Technical Support can help to resolve these issues, the user would like to know how to avoid them in the future. Article. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. KB38452: What can cause profile folders to get duplicated after a MicroStrategy Developer Project Duplication? Number of Views 916. The Project Documentation Wizard will run for only the selected objects. In the destination project source, administrator privileges are required. 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. Consider the two scenarios below: 1. Computation is separate from storage, which. 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. I have to duplicate the project, change the fact table and change the related items. If not, create those DSNs before proceeding with the steps below. Application objects are not seen even after selecting the option to duplicate all objects to the new project. Thus, the report has been moved to another folder within the same project. For information about duplicating projects, including instructions, see Duplicate a Project. The following window appears. authored through Developer and are tightly coupled to a MicroStrategy. 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. It gives you the leverage of generating real-time reports and monitoring. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Find an object's parents or children. 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 project. 1. Microsoft released the following security and nonsecurity updates for Office in November 2023. Rename the Project to remove these characters, after which the project can be duplicated successfully. For a smooth and easy migration, it's recommended to review the attached PDF containing Object Migration best practices. Save the XML file of all trial upgrade. The important thing here is we do this in 2-Tier or Direct mode. Using Object Manager, you can copy objects within a project or across projects. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. 3. Create a configuration package with user and/or user group objects and set their Action to Replace. Right-click on the Project Source and choose 'Intelligence Server Configuration'. 1 as the administrator user in MicroStrategy. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. 11: 1) Set a password for the Administrator user in the Project Source A 2) Set a different password for the Administrator user in the Project Source B 3) Open the Object Manager and duplicate a project from Project Source A to Project Source B. New user and application requirements make attribute creation and modification an important part of the entire project life cycle. location_path is the folder where the attribute resides, of type string, between double quotes ("). Click Yes. Select the Members tab. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. Select the appropriate options to define the dynamic recipient list, as described above. Change the password of the account. Delete objects within a project. Case() and CaseV() functions are Analytical Engine functions, i. For Oracle 12. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. Create a configuration package with user and/or user group objects and set their Action to Replace. Select 'Export Project Schema. This MicroStrategy tool can be used to test and troubleshoot. You can duplicate projects as part of a System Manager workflow. Drag and drop objects from the Object Browser into the Create Package dialog box. Next we will delete the project.