Community & Support Search Discussions Open A Case View My Cases The following procedure describes how to merge users from two different metadata repositories using the Project Duplication Wizard in MicroStrategy Developer. There's a reason we're at the top of the list. 1. The report can be executed in MicroStrategy Web. To add the dependents of all objects to the package, click Add all dependents. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. You are currently using 1 named users. If an Universal version of the Intelligence Server is used, the Query Engine is a 64-bit component and will not encounter the same memory limitation as the 32-bit version of the Query Engine that. In the Device Editor, click the Delivery Options tab. Create a database instance that references the intended datamart location by performing the following steps. This means that one must have originally been a duplicate of the other, or both must have been duplicates of a third project. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. MicroStrategy 10 will report the following errors if the path specified in Project Configuration>Intelligent Cubes>General>Intelligent Cube file directory is not accessible:On the upper right of any page, click your user name, and then select Preferences from the drop-down list. MicroStrategy Web. 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). Object Manager and Project Merge both copy multiple objects between projects. x. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. Was this post helpful? thumb_up thumb_down. Use Object Manager when you have only a few objects that need to be copied. 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. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. 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. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". 1 - 10. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. You cannot move Project A objects to an exact copy of Project A. FOLLOW THESE STEPS: Create Object Manager Package: 1. Change Journaling; The information which user made a change in the configuration is visible in the Change Journaling option. There are now two new VLDB properties that control quoting behavior. Choose the individual modules to be logged. Create a configuration package with user and/or user group objects and set their Action to Replace. Right-click on the right-hand side of Desktop, select New, and then select Report. Please subscribe to the channel to get an update with videos and help us to get 5000. 3. 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. Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data. This software features interactive dashboard, monitoring company's assets, and finance operations, enabling them to. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformChoose a project, right click on it and select “ Duplicate Project” 2. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. Click Add, select the elements, then click OK. 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. MicroStrategy 10 will report the following errors if the path specified in Project Configuration>Intelligent Cubes>General>Intelligent Cube file directory is not accessible:Detail Levels You can now select the level of detail exported from your dossier. This will open project Creation Assistant / Wizard. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Note: The Tutorial project is designed for MicroStrategy Web JSP. new_attr_name is the new name of the attribute, of type string, between double quotes ("). If one of the attributes is removed from the template, the Cost is aggregated. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. Right-click on the project name and select Duplicate Project. In MicroStrategy Web 9. Using MicroStrategy Enterprise Manager 9. 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. To start the Report Wizard. for Superclass and search for 'ProjectsTransform'. /mstrcfgwiz. 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. 5. If not, create those DSNs before proceeding with the steps below. Operations cannot be performed from a newer metadata to an older. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. New user and application requirements make attribute creation and modification an important part of the entire project life cycle. In the original project, create the document to be used as a portable document. Enable the statistics logging for the project. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. 4. jar file to i-server machine. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. Right-click the dossier and choose Copy To. The highlighted setting can be used to refresh MicroStrategy office report. 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. x, all users are able to see. The duplicate connection is automatically created and displayed in the Database Connections panel. Export the document from the original project. Connect to a project source or Narrowcast Server. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. 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. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Import the document into the replacement project. Log into the 3-tier project source. The Project Documentation Wizard will run for only the selected objects. For information. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Enter a name and description for the new security role. x, all users can see the project even if they could not see the project before duplication. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. ACTION Modify the project configuration of source project or destination project and save it. To do this, follow the steps below: Open MicroStrategy Developer 10. 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. exe". • 0: Do not create the Platform Analytics project. Copy and Paste them into the MicroStrategy Common Files Directory: C:Program Files (x86)Common FilesMicroStrategy; Section 6: Load images into the MicroStrategy Web and Mobile Servers. No users should be connected to the project. 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. 0 (Ashburn and Seattle): 1. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. If you like the video, please subscribe to my channel. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. 0 (Ashburn and Seattle): 1. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. Create a configuration package with user and/or user group objects and set their Action to Replace. x. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. use the function "Remove Duplicate Rows". The copy of the child will not be used by the parent. x and M8MulPrc_32 in 7. x?How to prevent content spoofing on projects page affecting Intelligence Server name using MicroStrategy Web 10. 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. 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. 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. 3. 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". Click OK. Delete objects within a project. Select the Members tab. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Select and edit the specified. All dependent objects of all objects currently listed in the package. For this Click on Schema and Click on Create New Project. 4. Each environment contains a MicroStrategy project. by clicking the lock icon for the project. MicroStrategy is a BI and analytics software, providing its clients big data processing, actionable across various deployments and devices. By default all. After deleting the incomplete project, the duplication. DSSCSADDRESS'. 2. 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. If you are leveraging Web ASP, see KB484127 to use this feature. In order for objects of two projects to be copied across, the schema IDs of the projects must match. use the function "Remove Duplicate Rows". Go to the System Objects folder and right-click on the column that is being removed to Search for Dependents. MicroStrategy recommends that if you want to copy objects between two projects. x, execute the following steps: Connect to the project source and expand the project that is to be duplicated, as shown below: Right-click on the project name and select Duplicate Project. If you are working on a report that has already been saved, a confirmation message appears. For a smooth and easy migration, it's recommended to review the attached PDF containing Object Migration best practices. Open a project source in MicroStrategy Object Manager. To copy a document between projects, follow the high-level steps below. In the Navigation pane, click Users and Groups. You can unlock the schema in the Schema Editor . Rename the Project to remove these characters, after which the project can be duplicated successfully. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Users' profile folders are project specific, unlike users, which are system wide objects. 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. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. Select 'Export Project Schema. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Edit the line within the function that takes your login input. Click Add, select the elements, then click OK. Select an Environment from the upper-left drop-down. (the target objects of those shortcuts) to the new project. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. Update packages are part of Object Manager. Once the metadata shell is created, create a project source using this DSN. 1 or later, or have been updated to version 9. Import the document into the replacement project. 1 or later using the Perform system object ID unification option For Cloud 3. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. Navigate to C:\Program Files\Common Files\MicroStrategy. 1. x SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. When Windows Authentication is used, users are able to log in to the MicroStrategy projects using their respective Windows domain accounts. 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. x and how duplicate columns can be created. One example is registering and loading a project at startup. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. There's a reason we're at the top of the list. 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. )To create a project update package, copy the file createProjectPackage. 4. . Create a DSN to Tutorial_WH_Copy, call it Ttrl_WH_Cpy_DSN; Connect to Ttrl_WH_Cpy_DSN with DB. it is then acceptable to. From the Tools menu, select ExportDocument Template. flag Report. Deploy the ojdbc8. 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. x. List Project Configuration Properties statement. Go back to MicroStrategy Desktop, right mouse click on the project -> Search for Objects. This knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. 3 and click an attribute, no lines are being graphically displayed to reflect mapping to some tables. x, create a new report with the following definition: Attributes . FORCE forces the project to unlock. Application objects include reports and documents, and the objects used to create them,. To export a project schema to an Excel file in MicroStrategy Developer 9. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Add Category, SubCategory, and Cost to the dossier. A Administrator decides to run a project merge against a newly duplicated project in MicroStrategy 9. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. 1. MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. rst, is saved in the selected folder. From the Warehouse Tables pane, right-click the table to add to the project and select Add Table to Project. x. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. To do so, you can take advantage of URL API. The Security Role Editor opens. SUMMARY: This document shows one known issue that p roject duplication would fail when duplicating project related configuration objects if there is one database instance (DBI) without database connection in MicroStrategy Developer 10. Instead, there is a report called 'Copy of Profit Forecast' and it can be found under the Product Sales Reports folder. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform The project duplication xml file fed into System Manager was generated with a setting that instructs System Manager to copy project related users. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. x. 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. Administrators no longer need to install Narrowcast Server on the machine where. Click Save. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. This document shows how to create a MicroStrategy Object Manager package to prevent a dependent object from being migrated over. I have a question regarding duplicates in Microstrategy. Select the appropriate options to define the dynamic recipient list, as described above. Project: the project containing the objects to include in the update package. Click Add a New Dynamic Address List. )The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. 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. log (C:Program FilesCommon FilesMicroStrategy) DuplicateCorruptedObjects. To create to a direct project source. From the Select a Project drop-down list, select the project for which to assign the security role. Otherwise, the link to History List will keep the same as before. Quickly integrating data into MicroStrategy as part of a proof-of-concept. Save the XML file of all trial upgrade. 4. In MicroStrategy Developer, duplicate each of the projects into this new project source. Using Object Manager, you can copy objects within a project or across projects. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. After duplicating a project in MicroStrategy Developer which uses LDAP Authentication, subscriptions may be missing. In the source project, all dependents of the report are stored in the Public Objects\Report Dependents folder. For project: MicroStrategy Tutorial number of cubes:21 Info for cache: Actual vs Forecast Performance Cube Status: Ready Loaded Filed Active Info for cache: Copy of CrimesInLondon Status: Imported Ready Loaded Filed Active The example provided in this document is provided “as-is” to the user and assumes that the user:. This is because. To invoke the "ProjectDuplicate. 2. Specify the project source and project information that you are copying from (the source). 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. Under Preferences Level, click Project Defaults. After every project duplicate, disconnect and reconnect to Project Source. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). Transform description: This transform displays project status on the Projects page. This is a known issue in MicroStrategy 9. Across corporate functions. The Duplicate. Project duplication setting is heart of the migration. Specify the port number where the SMTP server receives incoming e-mail. A Dockerfile describes what goes into a. When it’s set to 1, the project uses unified quoting. Click 'Next' after the introduction. Step 2. Each environment contains a MicroStrategy project. The Scan MD tool executes tests to detect inconsistencies in the metadata. To duplicate a project with subscriptions, follow the steps provided in "KB 45537 How to duplicate a project without subscriptions for MicroStrategy Cloud Enterprise" adjusting the following steps:. For information about duplicating projects, including instructions, see Duplicate a Project. WORKAROUND. 2. x. In the source metadata, create an empty. Click on Next. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. 8. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Unlocks a project in the metadata. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Run this script to delete the project (this step could take several minutes) a. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . To list and count unique users per project, project documentation can be used from within MicroStrategy Developer 10. 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. 2. The important thing here is we do this in 2-Tier or Direct mode. 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. xAs an example, consider the fact 'Copy of Units Sold' defined as shown: Consider that this fact needs to be modified using MicroStrategy Command Manager 9. Exporting creates a package file with the extension . 5. pkg. MicroStrategy Administrator - Object Manager is built with the assumption that two projects are related. Expand Administration, and then expand System Monitors. One workaround is to check each DBI and make. Open License Manager on the Intelligence Server machine and open Audit. See To copy a document between projects for a detailed procedure. )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. This tech note explains how to avoid that after duplicating a project into another project source via MicroStrategy Developer 10. So I want to create an embedded query to know which last objects. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Create a new dossier, add new data, use Clipboard and input the sample data as below. exe -f Path\XMLFilename. For. MicroStrategy recommends that if you want to copy objects between two projects. Duplication is the only way to get the projects into another environment. out l. currentFactDataKeepDays:. 4. How to duplicate the Project:- Object Manager in MicroStrat…In MicroStrategy Desktop, log onto the source project containing the project to duplicate and. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. '. Create a new dossier, add new data, use Clipboard and input the sample data as below. The following. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. Every object in a MicroStrategy project has a unique ID. Click Next. Move objects within a project. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. Rename objects within a project. 3. 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. . In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. The issue stems around the Database Instances warehouse connections when project related configuration objects are being duplicated. There are three types of objects: schema objects, application objects, and configuration objects. Choose File > New Attribute. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. 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 new project using the Project Creation Assistant. If you want to merge two projects, MicroStrategy recommends that the projects have related schemas. 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. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. For information about duplicating projects, including instructions, see Duplicate a Project. with the MicroStrategy sample project called Tutorial - Delivery. ; Go to Connection Type > Direct (2-tier), and click Next. Line 2 qty_sold number is updated. An object is a basic building block in MicroStrategy. 52K. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. 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. Plus, it connects business apps while integrating data. In MicroStrategy Developer, duplicate each of the projects into this new project source. 6. 5. x. KB14574: How to list duplicate users per project in MicroStrategy Developer 10. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. Log into Desktop 9. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. This setting is ideal if you have numerous. For all projects, enter *. This is by design. Restart the MicroStrategy Intelligence Server. x-10. 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. x. 0. The user logging in to Developer must be granted the "Audit Change Journal" privilege. Duplicate projects and Intelligence Servers appear in MicroStrategy Web. In the Log Options screen, leave the default log locations and select Next . ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a. 7. Cannot insert duplicate key in object 'dbo. In MicroStrategy reports, attributes are identified by the column headers of the reports. 3. Browse to and select a previously saved Intelligent Cube on which to build your report. 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. Step 5. x Loading × Sorry to interruptFor this particular error, a database instance object is involved and when MicroStrategy Developer 10. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. When duplicating a project, the following options apply to subscriptions for the selected users: Include user delivery subscriptions – This will duplicate cache update, History List message, Mobile, Intelligent Cube update, email, file, and print subscriptions for the duplicated users. The Page level option only provides a snapshot of each page. For the default contact for the user, this will duplicate. The destination project must be of the same metadata version or older metadata version as the source project. There's a reason we're at the top of the list. 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. Step 2: View the Dockerfile in your project folder. In MicroStrategy Desktop, log in to a project. Computation is separate from storage, which. users can. 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. MicroStrategy - Object Manager - Online Training Video by. 2987. The user can do this by importing the layout of the second document into the first document. 2. I have a data set which has all tickets 'Not Closed' along with the 'Work Info Work Log Date' field added. To create to a direct project source. x, only schema objects are migrated to the new project. Use Object Manager when you have only a few objects that need to be copied. Review any messages displayed when attempting to import a copy of a table from a different data. To log in to a specific project, see Starting MicroStrategy, page 2. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10.