How to duplicate project in microstrategy. xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. How to duplicate project in microstrategy

 
xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent CubeHow to duplicate project in microstrategy  Once the metadata shell is created, create a project source using this DSN

DSSCSADDRESS'. 'Product 01' is licensed for 0 named users. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. This setting is ideal if you have numerous. Add Category, SubCategory, and Cost to the dossier. There's a reason we're at the top of the list. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe project duplication xml file fed into System Manager was generated with a setting that instructs System Manager to copy project related users. Follow Steps 1 to 10 to decide the parameters of the duplication process . In MicroStrategy Developer, duplicate each of the projects into this new project source. Object Manager and Project Merge both copy multiple objects between projects. Options in this portion refer to creating the Platform Analytics project on this machine. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. Go to 'Contains' tab, and click on Add button. '. 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. If you like the video, please subscribe to my channel. 'Product 02' is licensed for 0 named users. x: Use the "CREATE USER" outline to write a script to create a new user. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. Step 8: Change the migrating objects to the following:. Find an object's parents or children. Create the respective DSN's in the Intelligence Server machines. Configure Intelligence Server with restored metadata with Configuration Wizard . SYMPTOM: In MicroStrategy Developer, users may notice that subscriptions are missing after project. 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. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Administrators no longer need to install Narrowcast Server on the machine where. Open License Manager on the Intelligence Server machine and open Audit. Add | select in connection mode Server. 1 as the administrator user in MicroStrategy. In the menu bar, go to Tools > Preferences. x. . MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. Step 2. Under the Tools menu, select Project Documentation. 11?; Knowledge Base: Annotate. 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. x from the command line by using the following command:. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. 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. Select from the following: To duplicate the database connection, click Duplicate. Update/Update only option does not compare all the attribute elements. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. An object is a basic building block in MicroStrategy. 5. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. In the source metadata, create an empty. 4. For information about duplicating projects, including instructions, see Duplicating 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. For information about Object Manager, see Copy Objects Between Projects: Object Manager. Object Manager and Project Merge both copy multiple objects between projects. 2. Consider the two scenarios below: 1. DSSCSADDRESS'. Each environment contains a MicroStrategy project. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. 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. This is a short walk through of the main Object Manager uses including project duplication and project object change and management between different instances of the project Dev - Test - Prod. Enter a new name and press the Enter key. Right-click the project where you want to use the exported settings and choose Properties. 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. Cannot insert duplicate key in object 'dbo. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. In the original project, create the document to be used as a portable document. This method is recommended and supported by MicroStrategy. x tries to upgrade the object, it detects that the definition has changed due to the concurrent project upgrades being performed, and ultimately needs to be reloaded from the MicroStrategy Metadata. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. . Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. 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. Import the document into the replacement project. with the MicroStrategy sample project called Tutorial - Delivery. 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". Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. use the function "Remove Duplicate Rows". The duplicate connection is automatically created and displayed in the Database Connections panel. 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. Create a new dossier, add new data, use Clipboard and input the sample data as below. Removing duplicates (cross joined data) in MicroStrategy Desktop. pkg. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. Select Project Sources and click Next. MicroStrategy Command Manager 9. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. Explanation: The name will use the browser default language preferences, English (United States) in this case. Project duplication setting is heart of the migration. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Rename objects within a project. 0. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. You must first update the other project before you can copy objects between the projects. You can access this setting through the following steps: Log in to your Project Source. . It is available as web-based or on-premise platform, along with native mobile apps. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a. The highlighted setting can be used to refresh MicroStrategy office report. 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. 2 release, the driver file is called odbc8. Browse to and select a previously saved Intelligent Cube on which to build your report. 4. Restart the MicroStrategy Intelligence Server. 4. Move objects within a project. Example: #Todumpalldatabases pg_dumpall>db. This Article describes an issue that occur when a project is duplicated from one 2-tier project source to another 2-tier project source in MicroStrategy Developer 10. The duplicate key value is (<ID>). DSSErrors. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. You can define a new database connection for users to import data from, or edit, delete, rename, or duplicate. If one of the attributes is removed from the template, the Cost is aggregated. 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 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. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. Under the Tools menu, select Project. Right-click on the Project Source and choose 'Intelligence Server Configuration'. To add the dependents of all objects to the package, click Add all dependents. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. When user navigates to "Project Tables View" tab in MicroStrategy Architect 10. Then click OK. Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. The duplicate key value is (<ID>). x. Starting MicroStrategy 11. MicroStrategy recommends that if you want to copy objects between two projects. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. Navigate to the folder to save the file in, then click OK. Plus, it connects business apps while integrating data. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The user can do this by importing the layout of the second document into the first document. Click on 'Browse . 1. )An example is shown with MicroStrategy Tutorial Project: - In Microstrategy Developer, log into the project where it is desired to obtain a report's VLDB properties. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. jar. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. 2 release, the driver file is called odbc8. 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. Click Add a New Dynamic Address List. x and how duplicate columns can be created. Go to Connection Type > Direct (2-tier), and click Next. Go to Menu -> Tools -> Options. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. Rename the Project to remove these characters, after which the project can be duplicated successfully. Click Create a new Security Role next to Security Roles. Enter the User Name and Password for the database. 0. 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. 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. )To create a project update package, copy the file createProjectPackage. The following. " Then copy that folder. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. For. Step 2: View the Dockerfile in your project folder. Create a new dossier, add new data, use Clipboard and input the sample data as below. If you are leveraging Web ASP, see KB484127 to use this feature. To run your code in a container, the most fundamental thing you need is a Dockerfile. Across corporate functions. There's a reason we're at the top of the list. x:. 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. A Administrator decides to run a project merge against a newly duplicated project in MicroStrategy 9. jar file to i-server machine. In the original project, create the document to be used as a portable document. In the left pane, click All Settings. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. Quoting Behavior is a setting created to control whether a project uses unified quoting. 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. Choose 'Database Instance Wizard'. From the Warehouse Tables pane, right-click the table to add to the project and select Add Table to 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. x. 11, during project duplication process between different metadatas, if objects "users and user groups" selected as 'None', the user password will be reset to the same one as the original project source after duplicate completed. Type mstrcmdmgrw and press Enter. 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. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. When Windows Authentication is used, users are able to log in to the MicroStrategy projects using their respective Windows domain accounts. For multiple projects, add brackets with each project name in quotations separated by commas. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Assuming that the statistics tables have already been created in the. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. 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. 2 and above. KB12330: How to duplicate a project in MicroStrategy Developer 10. 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. For information about duplicating projects, including instructions, see Duplicate a Project. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 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. 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. 2. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. Go to each of the attributes and facts returned by the dependency search. Click the “Select File” option. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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). After every project duplicate, disconnect and reconnect to Project Source. The administrator should stop. In the "Format: Template" window click on the "Color and Lines" tab. 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. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThis is an example of how to achieve Option 2 using MicroStrategy Tutorial project in 3-tier, keeping the same Database Instance and Database Connection but changing the DSN. Select the Members tab. 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. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. location_path is the folder where the attribute resides, of type string, between double quotes ("). • 0: Do not create the Platform Analytics project. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Change Journaling; The information which user made a change in the configuration is visible in the Change Journaling option. Using Object Manager, you can copy objects within a project or across projects. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. This. 2. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. 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 the Folder List, expand the project that contains the object you want to copy, then navigate to the object. Hey even if it doesn't work you can unload and load the Project that's definitely works. Click Save. 4. See full list on Duplicating Projects. 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. MicroStrategy recommends that if you want to copy objects between two projects. The user logging in to Developer must be granted the "Audit Change Journal" privilege. Log into the 3-tier project source. For Intelligent Cubes that are frequently used, it may be easier to send a URL to users to develop the report object that already contains a cube. From the Home menu, select one of the following: To save a report, select Save. exe". Right-click on the Project Source and choose 'Intelligence Server Configuration'. To delete a dossier, right-click it and choose Delete. 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. The Security Role Editor opens. scp in cmdmgr -n Project_Source_Name -u Username -f InputfileRight-click the project that you want to export your settings from and choose Properties. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. 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. In the destination project source, administrator privileges are required. x, below cross site scripting issue was. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results Pane -> Results -> To Text; Copy Application and Schema Objects. If the. 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. 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). When the Conflict Resolution screen appears, only select the User being replaced: After the replace has completed, close Object Manager and log. From the Schema menu, select Create New Project. Export the document from the original project. The Revenue metric is said to be used by these other objects. Scan MD. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. x and 10. Note: We recommend you enable Add All Used Dependencies. Our vision is to enable Intelligence Everywhere. This is by design. Specify the project source and project information that you are copying from (the source). 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. 3. 3. Each environment contains a MicroStrategy project. In the menu bar, go to Tools > Preferences. Right-click a project in that project source and select 'Compare projects' or select. Please contact MicroStrategy Technical Support for an update on this issue. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. 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. Once logged on, expand the administration icon in the Folder List and browse to the Database Instance Manager. 6. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. Create a configuration package with user and/or user group objects and set their Action to Replace. These files are used by some of the data Import Intelligent Cubes and an Xquery report. See To copy a document between projects for a detailed procedure. The same report accessed in web. For all projects, enter *. Search for objects within a project. Object Manager looks in the destination project's Public Objects folder for a subfolder named Report Dependents (the same path as in the source. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . x, runs out of memory. 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. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. x-10. Edit the line within the function that takes your login input. You can choose to duplicate user, contact, and subscription information. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. x. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. The destination project must be of the same metadata version or older metadata version as the source project. Note: This setting has to be check for every MicroStrategy project logging statistics. To log in to a specific project, see Starting MicroStrategy, page 2. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. Twenty-seventh Edition, version 9. " 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. You can unlock the schema in the Schema Editor . In the Device Editor, click the Delivery Options tab. Select the Members tab. e. new_desc is the new description of the attribute, of type string,. 2. Unlocks a project in the metadata. This MicroStrategy tool can be used to test and troubleshoot. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. 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. Note: We recommend you enable Add All Used Dependencies. 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 move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. To do this, follow the steps below: Open MicroStrategy Developer 10. To start the Report Wizard. On the report toolbar I’ve highlighted six icons, in order from. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. Deploy the ojdbc8. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. Open MicroStrategy Developer 10. xml. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. SYMPTOM: Project. How to delete, invalidate or expire caches from a specific project in MicroStrategy Developer. Starting from MicroStrategy 10, some additional files need to be created in the Intelligent Cube file directory during project upgrade. Expand the My Personal Objects folder, and then open the My Reports folder. ; Go to Connection Type > Direct (2-tier), and click Next. Each environment contains a MicroStrategy project. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. x, execute the following steps: Connect to the project source and expand the project that is to be duplicated, as shown below: Right-click on the project name and select Duplicate Project. Using MicroStrategy Enterprise Manager 9. There's a reason we're at the top of the list. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. x, create a new report with the following definition: Attributes . Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. 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. Specify the. x. Note: This setting has to be check for every MicroStrategy project logging statistics. Every object in a MicroStrategy project has a unique ID. out l. ProjectsTransformCustomStatus. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. 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. Open Command Manager and type the following commands to execute the Intelligent Cubes. If you duplicate through MicroStrategy, the metadata will be the same, but Project A becomes Project B with a distinct ID. 3. out l. Now, enter your username and hashed password copied from the database and login. 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. 1. Article. MicroStrategy Object Manager activates MicroStrategy Desktop Project Duplication wizard to perform the operation. 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. 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. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). A list of security roles in the project source opens in the main Developer pane. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. x, follow the steps outlined below: In MicroStrategy Developer, log into the project source and open the project. x. Use Object Manager when you have only a few objects that need to be copied. 4. 3. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. ACTION Modify the project configuration of source project or destination project and save it. The Scan MD tool searches for logical errors and fixes them within the platform object structure. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. For example, a user copies a report from the source project to the destination project. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Why MicroStrategy Why MicroStrategy; Customer Stories; Platform 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. 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. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. 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. In MicroStrategy Web 9. 1 or later using the Perform system object ID unification option For Cloud 3. On the Data Sources pane on the left, hover over the name of the database connection to modify and click the arrow icon. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. x and M8MulPrc_32 in 7. Click on "Select users. For information about duplicating projects, including instructions, see Duplicate a Project. 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. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. 3. In this example, the project source is APS-CLIENT-2, as shown in the image below. Right-click the dossier and choose Copy To. This will open project Creation Assistant / Wizard. x, right-click on the project and select Delete, as shown in the following image: Method 2 - Via MicroStrategy Command Manager: A command in MicroStrategy Command Manager allows for the deletion of projects from the Command Manager.