Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. Deploy the ojdbc8. Every object in a MicroStrategy project has a unique ID. To start the Report Wizard. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. xml. x. In MicroStrategy Developer, duplicate each of the projects into this new project source. The Full option exports a snapshot of each page and each individual visualization. use the function "Remove Duplicate Rows". For multiple projects, add brackets with each project name in quotations separated by commas. 0. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. 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. log (C:Program FilesCommon FilesMicroStrategy) From the example above, the logs are not truncated by the character length restrictions:To pick up the fix, enable project level setting “Data Engine Version” to 2020 or above. xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. Open MicroStrategy Developer 10. Line 2 qty_sold number is updated. Create a new dossier, add new data, use Clipboard and input the sample data as below. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Using Object Manager, you can copy objects within a project or across projects. After deleting the incomplete project, the duplication. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . In the original project, create the document to be used as a portable document. Operations cannot be performed from a newer metadata to an older version. 3. It gives you the leverage of generating real-time reports and monitoring. DSSCSADDRESS'. 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. Go to the Project Monitor under Administration, as shown below:Description. This can be achieved as follows: Connect to a project. 52K. There's a reason we're at the top of the list. Run this script to delete the project (this step could take several minutes) a. An object is a basic building block in MicroStrategy. pkg. 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. Unlock Project statement. 5. The Project Documentation Wizard will run for only the selected objects. Please subscribe to the channel to get an update with videos and help us to get 5000. In MicroStrategy 10. Delete option is performed on the Intelligent Cube, and data is not compared with the warehouse. Specify the port number where the SMTP server receives incoming e-mail. Quoting Behavior is a setting created to control whether a project uses unified quoting. x Loading × Sorry to interruptFor this particular error, a database instance object is involved and when MicroStrategy Developer 10. - 3-tier for a server (3-tier) project source connection. 0. Administrators no longer need to install Narrowcast Server on the machine where. This issue has been addresses in MicroStrategy Developer 10. New user and application requirements make attribute creation and modification an important part of the entire project life cycle. 2987. Delete objects within a project. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. Starting in MicroStrategy 9. The MicroStrategy Intelligence Server API call related is IDSSProjectInstance::Load. Import the document into the replacement project. Unified Quoting: Solutions to Quoting Pattern Challenges. Go to Connection Type > Direct (2-tier), and click Next. Design intuitive analytics reports with MicroStrategy ONE. jar. Right-click a project in that project source and select 'Compare projects' or select. ; In the Project Source Name field, type a name for the project source. 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. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. 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. 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. See To copy a document between projects for a detailed procedure. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. 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. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in. Check the required options in the 'Export schema' dialog box and. 3. Duplication is the only way to get the projects into another environment. 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. MicroStrategy recommends that if you want to copy objects between two projects. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . This document shows how to create a MicroStrategy Object Manager package to prevent a dependent object from being migrated over. The Project Creation Assistant opens, as shown below: 3. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. Create a Security Role. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Plus, it connects business apps while integrating data. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Using MicroStrategy Enterprise Manager 9. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. This is by design. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. 4. . Create a configuration package with user and/or user group objects and set their Action to Replace. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. If you have dossiers in a shared environment, you can copy the dossier to a new location in the same environment. Right-click the dossier and choose Copy To. 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. 2. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. x, all users can see the project even if they could not see the project before duplication. Using the Connector. Supported data structure and distribution on Gateway. Step 3. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects. In the left pane, click Privileges. out l. Object Manager looks in the destination project's Public Objects folder for a subfolder named Report Dependents (the same path as in the source. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. To add the dependents of all objects to the package, click Add all dependents. Choose File > New Attribute. The duplication wizard hangs at different steps during subsequent duplication attempts. Open the script. In order for objects of two projects to be copied across, the schema IDs of the projects must match. configure a project to collect statistics. Click OK to confirm the deletion. 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. 3. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. A list of security roles in the project source opens in the main Developer pane. Duplicate projects and Intelligence Servers appear in MicroStrategy Web. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. Click Create a new Security Role next to Security Roles. Update/Update only option does not compare all the attribute elements. " Then copy that folder. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. 0, this Feature Flag has been removed and replaced with a project level setting called "Data Engine Version". Some of the main components of the MicroStrategy platform include: MicroStrategy metadata —a repository that stores MicroStrategy object definitions and information about the data. Full control. To do this, follow the steps below: Open MicroStrategy Developer 10. In MicroStrategy Web 9. One workaround is to check each DBI and make. 2. Cannot insert duplicate key in object 'dbo. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Expand Administration, and then expand System Monitors. " 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. Enable the statistics logging for the project. x: Use the "CREATE USER" outline to write a script to create a new user. The administrator should stop. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In the Project Source Manager click on 'OK' to exit the window. The Security Role Editor opens. Click on Next. Path is the path to the saved XML settings file. exe", the syntax is: ProjectDuplicate. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. 1. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. Open the MicroStrategy Configuration Wizard. MicroStrategy Object Manager activates MicroStrategy Desktop Project Duplication wizard to perform the operation. For information about Object Manager, see Copy Objects Between Projects: Object Manager. Alternatively, click Add and the Add Objects window opens. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. x and M8MulPrc_32 in 7. 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. In the destination project source, administrator privileges are required. Edit the line within the function that takes your login input. Click Next. 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. ; Go to Connection Type > Direct (2-tier), and click Next. x SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. There are various applications of MicroStrategy. x, runs out of memory. 1. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformChoose a project, right click on it and select “ Duplicate Project” 2. Click 'Next' after the introduction. Restart the MicroStrategy Intelligence Server to make the new settings take effect. - Administration -> Duplicate project. 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. Go to Menu -> Tools -> Options. MicroStrategy recommends that if you want to copy objects between two projects. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. 3. log (C:Program FilesCommon FilesMicroStrategy) DuplicateCorruptedObjects. 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. Type mstrcmdmgrw and press Enter. Click on Create Project and Give suitable Project name and Click OK. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. jar file to i-server machine. If one of the projects is updated to a new MicroStrategy release, but another project is not updated, you cannot move or copy objects between the projects. pkg. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. Sometimes you need to deal with a data source that has duplicated data. 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. x. Request a demo. 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. Select the Members tab. 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. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. KB12330: How to duplicate a project in MicroStrategy Developer 10. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. MicroStrategy Command Manager 9. A list of security roles in the project source opens in the main Developer pane. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 1. Go back to MicroStrategy Desktop, right mouse click on the project -> Search for Objects. java opens in the editor. On the source computer, go to Start > Run. 8-2. For the default contact for the user, this will duplicate. 2. MicroStrategy recommends that if you want to copy objects between two projects. Creating a new project at the Source environment called P1. If you like the video, please subscribe to my channel. For information. Change the password of the account. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Note: This setting has to be check for every MicroStrategy project logging statistics. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. If you want to copy application or schema objects between projects, MicroStrategy recommends that the two projects have related schemas (one must be a duplicate of the other or both must be duplicates of a common project). Microsoft released the following security and nonsecurity updates for Office in November 2023. When the Project Documentation Wizard opens, select the project to be documented and click Next. 1. High-Level Steps to Duplicate a Project with the Project Duplication Wizard From Object Manager select the Project menu (or from Developer select the Schema menu), then select Duplicate Project. To see the ID and version of an object, right-click the object and select Properties. There's a reason we're at the top of the list. Please contact MicroStrategy Technical Support for an update on this issue. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 1 - 10. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. out l. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. What action should be taken? The incomplete project cannot be repaired, therefore it must be deleted. Specify the project source of the project to be duplicated in the Direct Project Sources section. Step 2. DELETE PROJECT "[Project Name]"; Verify that in 3-Tier you dont see any duplicate project names. Thus, the report has been moved to another folder within the same project. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. For information about duplicating projects, including instructions, see Duplicate a Project. Right-click on the Project Source and choose 'Intelligence Server Configuration'. For example, [“MicroStrategy Tutorial”, “Enterprise Manager”] ProjectSourceName. 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. For Oracle 12. 3. Click on Next. The document, named document_name. . 8. This will open project Creation Assistant / Wizard. )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. 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. If you are working on a report that has already been saved, a confirmation message appears. There are now two new VLDB properties that control quoting behavior. Choose 'Database Instance Wizard'. 8-1. On the Data Sources pane on the left, hover over the name of the database connection to modify and click the arrow icon. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. Choose Get Info if you are using a Mac. Applications of MicroStrategy. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. 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. Today, colleagues across Sainsbury’s leverage these apps to drive everyday decision-making on the store floor. Click the “Select File” option. When user navigates to "Project Tables View" tab in MicroStrategy Architect 10. 2 release, the driver file is called odbc8. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. exe -f Path\XMLFilename. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. Learn on how to create filters in Microstrategy Web (dossier), both page level as well as global filter. 4. Note: This setting has to be check for every MicroStrategy project logging statistics. 1. " and select all users and groups, except for. 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. Each environment contains a MicroStrategy project. 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. new_desc is the new description of the attribute, of type string,. In the Project Duplication window, the hang appears to occur after finishing the property set objects. x. How to delete, invalidate or expire caches from a specific project in MicroStrategy Developer. e. x. flag Report. These files are used by some of the data Import Intelligent Cubes and an Xquery report. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. From the Home menu, select one of the following: To save a report, select Save. Create a configuration package with user and/or user group objects and set their Action to Replace. 'Product 01' is licensed for 0 named users. This means that one must have originally been a duplicate of the other, or both must have been duplicates of a third project. 2. Receive a list of. x and later. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. For example, a user copies a report from the source project to the destination project. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. 3. Otherwise, the link to History List will keep the same as before. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. Navigate to C:\Program Files\Common Files\MicroStrategy. Step 2: View the Dockerfile in your project folder. 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. MicroStrategy is a BI and analytics software, providing its clients big data processing, actionable across various deployments and devices. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. Duplicate this new empty project P1 from the Source to the Destination environment, selecting in the configuration ONLY the affected user and the ADD Option. 3. Our vision is to enable Intelligence Everywhere. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. Choose the individual modules to be logged. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. Use the MicroStrategy Metadata Update Utility to recover the MicroStrategy System Prompt object. Follow Steps 1 to 10 to decide the parameters of the duplication process . It is available as web-based or on-premise platform, along with native mobile apps. Change the value ' md5 ($#####) ' with ' $##### ', (aka removing the md5hashing of your input). MicroStrategy - Object Manager - Online Training Video by MicroRooster. Specify the project source and project information that you are copying from (the source). bat, as shown below, to run PurgeObjectCache. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. The hang will only occur when the database instance. There's a reason we're at the top of the list. In the source project, all dependents of the report are stored in the Public Objects\Report Dependents folder. 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. 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 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. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. Click Add, select the elements, then click OK. Open both folders in which the user is located for each project source. These two components. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Next we will delete the project. Click on "Select users. Using Object Manager, you can copy objects within a project or across projects. Intelligence Everywhere ; Talk to an expert ; Get startedThis knowledge base article documents the best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy and how duplicate columns can be created. MicroStrategy DB (Database) Query tool is a any to use MicroStrategy application that utilizes Open Database Connectivity (ODBC) and Java Database Connectivity (JDBC) to access data in any database for which there is an ODBC driver or JDBC driver, respectively. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10. it is then acceptable to. Hey even if it doesn't work you can unload and load the Project that's definitely works. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. For information about duplicating projects, including instructions, see Duplicating a Project. When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. 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. Select 'Export Project Schema. pimiento. You can use a scheduler such as Windows Scheduler to import the package. In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. The issue stems around the Database Instances warehouse connections when project related configuration objects are being duplicated. Click Save. jar file to i-server machine. x. You are currently using 1 named users. All dependent objects of all objects currently listed in the package. From the Tools menu, select ExportDocument Template. Deploy the ojdbc8. To do so, you can take advantage of URL API. Example: #Todumpalldatabases pg_dumpall>db. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Right-click the project where you want to use the exported settings and choose Properties. )The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. To create to a direct project source. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The duplicate connection is automatically created and displayed in the Database Connections panel. Open the MicroStrategy Configuration Wizard. The Browse for Folder dialog box opens. Create the respective DSN's in the Intelligence Server machines. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. The user logging in to Developer must be granted the "Audit Change Journal" privilege. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. This method is recommended and supported by MicroStrategy. x, create a new report with the following definition: Attributes . Type "regedit. Starting MicroStrategy 11. x-10. Choose a Source Project Source and Source Project as well as a Destination Project Source and Destination Project. , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. Select Project Sources and click Next. 3. To determine how many connection maps a project is using in MicroStrategy Developer 9. 2. x and later. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. See To copy a document between projects for a detailed procedure. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. Using Object Manager, you can copy objects within a project or across projects. MicroStrategy Administrator - Object Manager allows users to perform the following actions: Duplicate and upgrade projects.