jar. Assuming that the statistics tables have already been created in the. 1 or later, or have been updated to version 9. Export the document from the original project. Open both folders in which the user is located for each project source. In the MicroStrategy system, every object has an ID (or GUID) and a version. An object is a basic building block in MicroStrategy. Choose 'Database Instance Wizard'. Managing Data Source Connections. From Developer, you can manage multiple environments, apply and enforce security, and monitor environment usage. To log in to a specific project, see Starting MicroStrategy, page 2. UNLOCK PROJECT project_name [FORCE]; where: PROJECT "project_name" is the name of the project to be unlocked, of type string. 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. 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. UNLOCK PROJECT project_name [FORCE]; where: PROJECT "project_name" is the name of the project to be unlocked, of type string. Operations cannot be performed from a newer metadata to an older version. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. Move objects within a project. The Full option exports a snapshot of each page and each individual visualization. There's a reason we're at the top of the list. The following window appears. 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. Unlocks a project in the metadata. In this scenario, you typically use three environments: development, test, and production. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. x - 9. use the function "Remove Duplicate Rows". I have to duplicate the project, change the fact table and change the related items. Review any messages displayed when attempting to import a copy of a table from a different data. In the Navigation pane, click Users and Groups. Configure Intelligence Server with restored metadata with Configuration Wizard . 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. If you duplicate through MicroStrategy, the metadata will be the same, but Project A becomes Project B with a distinct ID. 6. 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. Search for objects within a project. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The duplication log shows the duplication is stuck while duplicating a specific user object. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. 0 (Ashburn and Seattle): 1. Create a new dossier, add new data, use Clipboard and input the sample data as below. Starting MicroStrategy 11. DSSErrors. Twenty-seventh Edition, version 9. x. Click in the right pane. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in. Log into the 3-tier project source. 2987. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. 0. 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). In the source project, all dependents of the report are stored in the Public Objects\Report Dependents folder. e. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. (From the File menu, select Open. Follow Steps 1 to 10 to decide the parameters of the duplication process . 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. Each environment contains a MicroStrategy project. This issue has been addresses in MicroStrategy Developer 10. This setting is ideal if you have numerous. A list of security roles in the project source opens in the main Developer pane. Number of Views 9. Microsoft released the following security and nonsecurity updates for Office in November 2023. Using Object Manager, you can copy objects within a project or across projects. x. You can use a scheduler such as Windows Scheduler to import the package. 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. 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. One workaround is to check each DBI and make. The report can be executed in MicroStrategy Web. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Navigate to the folder to save the file in, then click OK. And then in the first document, import the. Go to the Project Monitor under Administration, as shown below:I am new to the Microstrategy, I need some tips to do my task involves change of fact table in a project. 2 and above. You can access this setting through the following steps: Log in to your Project Source. x, below cross site scripting issue was. 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. ; In the Project Source Name field, type a name for the project source. In this scenario, you typically use three environments: development, test, and production. Delete objects within a project. The Full option exports a snapshot of each page and each individual visualization. For Oracle 12. Options in this portion refer to creating the Platform Analytics project on this machine. x?How to prevent content spoofing on projects page affecting Intelligence Server name using MicroStrategy Web 10. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. Database Connections are created and edited in the Database Instance Editor, as shown below: To access the Database Instance Editor, log into the Project Source as a Database Instance Manager. Across corporate functions. jar. Select 'Export Project Schema. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. Specify the. For information about duplicating projects, including instructions, see Duplicate a Project. The highlighted setting can be used to refresh MicroStrategy office report. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. Duplication is the only way to get the projects into another environment. Quoting Behavior is a setting created to control whether a project uses unified quoting. 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. To do so, you can take advantage of URL API. Type mstrcmdmgrw and press Enter. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. 3. x and how duplicate columns can be created. An administrator user may duplicate projects from one project source to another project source, with the destination project source being a 3-tier project source. Open a project source in MicroStrategy Object Manager. 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". Go to Connection Type > Direct (2-tier), and click Next. Select Project Sources and click Next. The process will hang and MicroStrategy Developer will become unresponsive at any point. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Click Yes. . 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. The Page level option only provides a snapshot of each page. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. 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. Double-click the security role you want to assign to the user or group. 'Product 01' is licensed for 0 named 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. Log into Desktop 9. ConnectionMode: - 2-tier for a direct (2-tier) project source connection. From the Tools menu, select ExportDocument Template. 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. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. Step 8: Change the migrating objects to the following:. 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. Please subscribe to the channel to get an update with videos and help us to get 5000. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. In the left pane, click Privileges. This can be achieved as:This tutorial will guide MSTR users to share dossiers through Web and Library. exe". This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. x. Save the XML file of all trial upgrade. There's a reason we're at the top of the list. If you are working on a report that has already been saved, a confirmation message appears. Alternatively, click Add and the Add Objects window opens. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. Move objects within a project. In the Project Duplication window, the hang appears to occur after finishing the property set objects. Synapse Analytics leverages a scale out architecture to distribute computational processing of data across multiple nodes. A project is duplicated between a 3-tier project source and a 2-tier project source. Exporting creates a package file with the extension . KB290890: Project duplication wizard hang when attempting to duplicate a project in MicroStrategy Developer 9. 2. If you like the video, please subscribe to my channel. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. Start Power BI Desktop. Open MicroStrategy Web. In the destination project source, administrator privileges are required. Restart the MicroStrategy Intelligence Server. x. For managed objects, navigate to the Administration menu, and select ProjectDelete unused managed objects -- if necessary . 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. When a MicroStrategy Administrator duplicates a user, the security filters tied to the original user are not tied to the new user. The important thing here is we do this in 2-Tier or Direct mode. For information about duplicating projects, including instructions, see Duplicate a Project. In MicroStrategy 10. Launch MicroStrategy Object Manager and connect to a project that is the migration source. Step 3. 8-2. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. Step 2. 3. In the "Format: Template" window click on the "Color and Lines" tab. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. The scenario below explains the steps to follow to configure two identical projects pointing to two different warehouses in the same Project Source in MicroStrategy 9. The following. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. Using Object Manager, you can copy objects within a project or across projects. x and later. Click OK. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. Open the script. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. The process will hang and MicroStrategy Developer will become unresponsive at any point. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. 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. 1 Hotfix 7, if a user navigates to the "Shared Reports" folder, then clicks on the top left MicroStrategy Startburst icon, and navigates to "My Reports", the page will reload, but the page will still show the contents of the “Shared Reports” folder. Deploy the ojdbc8. The user can do this by importing the layout of the second document into the first document. 1 or later using the Perform system object ID unification optionFor Cloud 3. Consider the two scenarios below: 1. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. These two components. If one of the attributes is removed from the template, the Cost is aggregated. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. Create a copy of the Tutorial Warehouse, call it Tutorial_WH_Copy. 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. Using MicroStrategy Enterprise Manager 9. KB14574: How to list duplicate users per project in MicroStrategy Developer 10. A warning message like the following can be observed:. Computation is separate from storage, which. Open License Manager on the Intelligence Server machine and open Audit. Expand Administration, and then expand System Monitors. 1. 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. I have a question regarding duplicates in Microstrategy. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. Otherwise, the link to History List will keep the same as before. Specify the project source of the project to be duplicated in the Direct Project Sources section. To see the ID and version of an object, right-click the object and select Properties. 4. Click on Create Project and Give suitable Project name and Click OK. If normal logical table objects remain that are dependent upon the object trying to be removed from the project, then remove them from the project in Warehouse Catalog . A list of security roles in the project source opens in the main Developer pane. If the preference is set. 2. MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. 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. 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. 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. From the left, select Dynamic Address Lists. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. This knowledge base article explains how to migrate projects from one metadata database to another in MicroStrategy 9. Instead, there is a report called 'Copy of Profit Forecast' and it can be found under the Product Sales Reports folder. Under the Tools menu, select Project. No users should be connected to the project. Select the element, and go to Menu -> Custom Group -> Show Display Options, as shown below: Select the last option "Show the element names, individual items within this element and also, expand these individual items if possible",. 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. SELECT project_id, object_id, object_type, subtype, object_name, abbreviation, description, version_id, parent_id, owner_id,. 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. Copy Objects Object Manager can copy application, schema, and configuration objects. 2. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. 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. ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. The Scan MD tool searches for logical errors and fixes them within the platform object structure. 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. 0, this Feature Flag has been removed and replaced with a project level setting called "Data Engine Version". Under the Tools menu, select Project Documentation. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). Choose the Statistic Database instance from 'Statistics' tab in Project Configuration. 3. 2. 2 release, the driver file is called odbc8. Check the required options in the 'Export schema' dialog box and. x. Under Preferences, click General. Edit the line within the function that takes your login input. location_path is the folder where the attribute resides, of type string, between double quotes ("). x. it is then acceptable to. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. e. Step 4. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. This restriction exists to ensure that the schema objects are compatible between the projects, as it would do considerable damage to import attributes and facts into a project to which those objects do not belong. 0 (Ashburn and Seattle): 1. If not, create those DSNs before proceeding with the steps below. 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. Choose the individual modules to be logged. Select the desired objects and click >. This is a guest blog post co-written by Amit Nayak at Microstrategy. 3. 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. Cannot insert duplicate key in object 'dbo. Restart the MicroStrategy Intelligence Server to make the new settings take effect. It is available as web-based or on-premise platform, along with native mobile apps. Another way to copy objects from multiple folders at once is to create an update package from the source project, and then import it into the target project. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. There's a reason we're at the top of the list. Note the project source that connects the Intelligence Server. 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. xml. 5. Click Next. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 11?; Knowledge Base: Annotate. Step 2: View the Dockerfile in your project folder. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. Note: We recommend you enable Add All Used Dependencies. 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. process, which is named M8DBMPE1 in MicroStrategy 7i - 7. Companies of all sizes use this platform to assess, visualise, and build dashboards. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. For the default contact for the user, this will duplicate. To do so, you can take advantage of URL API. 4. /mstrcfgwiz. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. In MicroStrategy, the metadata repository is a database that contains the definitions of database objects such as tables and fields in a way that developers and users can easily understand. MicroStrategy recommends that if you want to copy objects between two projects. exe -f Path\XMLFilename. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. 4. An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. 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 destination project must be of the same metadata version or older metadata version as the source project. out l. Click Create a new Security Role next to Security Roles. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Article. Violation of PRIMARY KEY constraint 'PK_ADDRESS'. Reload the login page. 1. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. To determine how many connection maps a project is using in MicroStrategy Developer 9. Right-click on the Project Source and choose 'Intelligence Server Configuration'. Select from the following: To duplicate the database connection, click Duplicate. Hey even if it doesn't work you can unload and load the Project that's definitely works. Duplicate the original project into the MS Access file In MicroStrategy Desktop, go to the menu Schema -> Duplicate Project; Select the project source of the original project to transfer; Login as MicroStrategy Administrator as screenshot below and click on 'Next' Why MicroStrategy Why MicroStrategy; Customer Stories; Platform To add copies of a table from other database instances. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. Run this script to delete the project (this step could take several minutes) a. Follow these steps to create it from MicroStrategy Developer: Go to Tools Menu | Project Source Manager. 5. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Consider a project (P1) in a Project Source that must be duplicated to project (P2) in the same PS but pointing to a different warehouse. Create a configuration package with user and/or user group objects and set their Action to Replace. The user logging in to Developer must be granted the "Audit Change Journal" privilege. There are now two new VLDB properties that control quoting behavior. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. with the MicroStrategy sample project called Tutorial - Delivery. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Add | select in connection mode Server. 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. Plus, it connects business apps while integrating data. If the. 3. 11: 1) Set a password for the Administrator user in the Project Source A 2) Set a different password for the Administrator user in the Project Source B 3) Open the Object Manager and duplicate a project from Project Source A to Project Source B. x. Log into the 3-tier project source. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Right-click a project in that project source and select 'Compare projects' or select. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. 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. From the Select a Project drop-down list, select the project for which to assign the security role. In the menu bar, go to Tools > Preferences. Click Export and save the file. • 0: Do not create the Platform Analytics project. 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. This method is recommended and supported by MicroStrategy. 86K KB12504: Administrator user is unable to delete unloaded projects in a 3-tier project source after project duplication in. Select and edit the specified. x. While Technical Support can help to resolve these issues, the user would like to know how to avoid them in the future. 0. Set Freeform SQL and MDX objects default security. 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. Click Add a New Dynamic Address List. x. 2. For all projects, enter *. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. new_desc is the new description of the attribute, of type string,. scp i PURGE OBJECT CACHING IN PROJECT "Project_Name"; Create a batch file named PurgeObjectCache. You can define a new database connection for users to import data from, or edit, delete, rename, or duplicate.