Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. 1. Select 'Export Project Schema. Navigate to the folder to save the file in, then click OK. Assuming that the statistics tables have already been created in the. x, open the Project Configuration window by right-clicking on a project and choosing 'Configure Project'. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. exe". Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The Page level option only provides a snapshot of each page. You can choose to duplicate user, contact, and subscription information. Go to the System Objects folder and right-click on the column that is being removed to Search for Dependents. Duplicating projects Projects created in MicroStrategy 7 can be duplicated in the same project source or in a different one. In the Project Source Name field, type a name for the project source. 1 Number of Views 1. Check the required options in the 'Export schema' dialog box and. exe -f Path\XMLFilename. Companies of all sizes use this platform to assess, visualise, and build dashboards. This tech note explains how to avoid that after duplicating a project into another project source via MicroStrategy Developer 10. In this scenario, you typically use three environments: development, test, and production. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. Starting in MicroStrategy 9. These files are used by some of the data Import Intelligent Cubes and an Xquery report. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. 1. Search for objects within a project. x can be used to create a list of users within a single project source for export to Microsoft Excel. This setting is ideal if you have numerous. Step 4. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. 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. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. Expand the destination project in which you want to paste the object, and then select the folder in which you want to paste the object. x and later. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. 3. Specify the. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. 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. Request a demo. You can access this setting through the following steps: Log in to your Project Source. Go to 'Contains' tab, and click on Add button. This is a short walk through of the main Object Manager uses including project duplication and project object change and management between different instances of the project Dev - Test - Prod. Perform a manual data load again using MicroStrategy Enterprise Manager; Run a report in the MicroStrategy Enterprise Manager project with the 'User' and 'Report' attributes on. The Full option exports a snapshot of each page and each individual visualization. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. LIST [ALL] PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT ". x can be used to change the project status programmatically. Note: The Tutorial project is designed for MicroStrategy Web JSP. Using Object Manager, you can copy objects within a project or across projects. The Project Creation Assistant opens, as shown below: 3. 4. Upon opening your Project Source for a particular environment, the 'Administration' section provides all. Rename the Project to remove these characters, after which the project can be duplicated successfully. The Duplicate. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. Expand the My Personal Objects folder, and then open the My Reports folder. Click in the right pane. Ensure that the project schema for your new attribute is available for editing. Log in to a project source in MicroStrategy Developer. The process will hang and MicroStrategy Developer will become unresponsive at any point. For more details about this setting, refer to Change Data Engine Version Detailed reproduce steps: In MicroStrategy Web, create a new Dossier and click on New Data and select Databases and pick following 2 tables ; Choose Access mode to be "In-Memory"Command Manager can connect to an Intelligence Server (metadata repository) either directly by scripts or by a project source. For managed objects, navigate to the Administration menu, and select ProjectDelete unused managed objects -- if necessary . You must first update the other project before you can copy objects between the projects. Create a new dossier, add new data, use Clipboard and input the sample data as below. 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. Supported data structure and distribution on Gateway. MicroStrategy provides modern analytics on an open,. 52K. 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. The duplicate key value is (<ID>). ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. On the report toolbar I’ve highlighted six icons, in order from. To start the Report Wizard. Set Freeform SQL and MDX objects default security. Use the project duplication function to duplicate only the Tutorial project to your metadata. Thus, the report has been moved to another folder within the same project. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. Copy objects within and across related projects. Specify the port number where the SMTP server receives incoming e-mail. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. In MicroStrategy Developer, duplicate each of the projects into this new project source. Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. x-10. Open the script. by clicking the lock icon for the project. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. MicroStrategy - Object Manager - Online Training Video by. 1 or later, or have been updated to version 9. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. 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). new_desc is the new description of the attribute, of type string,. Create a Security Role. Project (Page By) Report (Row) Report SQL Pass (Report Objects, not in the grid): Filter . Using MicroStrategy Enterprise Manager 9. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. 34K KB47745: How to add or remove existing project Database Instances to the Database connections list in the Data Import wind… Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Choose a project, right click on it and select “ Duplicate Project” 2. In the "Format: Template" window click on the "Color and Lines" tab. 3. Article. Path is the path to the saved XML settings file. Click your Account drop-down and choose Preferences. ; In the Project Source Name field, type a name for the project source. Click Add, select the elements, then click OK. 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. 11, during project duplication process between different metadatas, if objects "users and user groups" selected as 'None', the user password will be reset to the same one as the original project source after duplicate completed. Alternatively, click Add and the Add Objects window opens. MicroStrategy recommends that if you want to copy objects between two projects. Restart the MicroStrategy Intelligence Server to make the new settings take effect. Specify the IP address of the SMTP server. This document explains the reason for this behavior, and a solution which can be used to duplicate all subscriptions. DSSCSADDRESS'. 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. PAProjectEncryptPwd=Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformSubscriptions from other projects are shown when searching for dependent subscriptions in a duplicated project in MicroStrategy Desktop 10. A project created in MicroStrategy 6. In the original project, create the. If the. Refresh. " Navigate to HKEY_LOCAL_MACHINESOFTWAREWow6432NodeMicroStrategyData Sources. Create an Attribute. The document, named document_name. To copy a document between projects, follow the high-level steps below. To do so, you can take advantage of URL API. The Metadata Update Utility is a utility responsible for updating the metadata with the latest project information based on the version of MicroStrategy Developer from the machine on which the utility is installed and executed. 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. Select Create project security package and the projects to include in the security access settings. 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. This. In MicroStrategy Developer 9. Right click the Regions column header and select Advanced Formatting. In the Project Duplication window, the hang appears to occur after finishing the property set objects. Review any messages displayed when attempting to import a copy of a table from a different data. jar. Case() and CaseV() functions are Analytical Engine functions, i. x. - Administration -> Duplicate project. 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. In some scenarios, MicroStrategy administrators or other users may need to find out the Windows domain account that is linked to a MicroStrategy user. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. Options in this portion refer to creating the Platform Analytics project on this machine. 4. Exporting creates a package file with the extension . 2. From the Select a Project drop-down list, select the project for which to assign the security role. x. 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. Save the XML file of all trial upgrade. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. The Page level option only provides a snapshot of each page. Create a configuration package with user and/or user group objects and set their Action to Replace. Duplicate projects and Intelligence Servers appear in MicroStrategy Web. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. Choose 'Database Instance Wizard'. There are now two new VLDB properties that control quoting behavior. Using Object Manager, you can copy objects within a project or across projects. If you want to merge two projects, MicroStrategy recommends that the projects have related schemas. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. The duplicate key value is (<ID>). After deleting the incomplete project, the duplication. rst, is saved in the selected folder. This issue has been addresses in MicroStrategy Developer 10. Consider the two scenarios below: 1. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. Double-click the security role you want to assign to the user or group. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. When user navigates to "Project Tables View" tab in MicroStrategy Architect 10. Quoting Behavior is a setting created to control whether a project uses unified quoting. The hang will only occur when the database instance. When it’s set to 1, the project uses unified quoting. 8-1. )To create a project update package, copy the file createProjectPackage. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. MicroStrategy Developer and MicroStrategy Command Manager can be installed on the same machine, or on different machines. Assuming that the statistics tables have already been created in the. )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. 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. By default all. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. Plus, it connects business apps while integrating data. )The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. See To copy a document between projects for a detailed procedure. Select Configure Intelligence Server, and click Next. Move objects within a project. Open License Manager on the Intelligence Server machine and open Audit. 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. Go to the 'Database Instance Manager'. The Scan MD tool searches for logical errors and fixes them within the platform object structure. for Superclass and search for 'ProjectsTransform'. Click the “Select File” option. If the version is different and only project GUID is the same, the two projects are taken as different version of one same project and the operation would succeed. WORKAROUND. I have a question regarding duplicates in Microstrategy. Right-click on the right-hand side of Desktop, select New, and then select Report. 2. The Project Documentation Wizard will run for only the selected objects. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. In the 'Project Duplication - Select objects to duplicate' window in the Project Duplication Wizard, choose the 'Selected. 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. Specify the. Right-click on the Project Source and choose 'Intelligence Server Configuration'. Click Select. Launch MicroStrategy Object Manager and connect to a project that is the migration source. An object is a basic building block in MicroStrategy. Select Project Sources and click Next. You are currently using 1 named users. 1 - 10. 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. java opens in the editor. Create a copy of the Tutorial Warehouse, call it Tutorial_WH_Copy. I have a data set which has all tickets 'Not Closed' along with the 'Work Info Work Log Date' field added. You can access this setting through the following steps: Log in to your Project Source. Update the schema in 2-tier and reload the project from the Project Monitor, as described below: Update the schema in 2-tier. x from the command line by using the following command:. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Administrators no longer need to install Narrowcast Server on the machine where. 3. . For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. out l. Select an Environment from the upper-left drop-down. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. 0, this Feature Flag has been removed and replaced with a project level setting called "Data Engine Version". For information about Object Manager, see Copy Objects Between Projects: Object Manager. I have to duplicate the project, change the fact table and change the related items. 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. Note: We recommend you enable Add All Used Dependencies. SELECT project_id, object_id, object_type, subtype, object_name, abbreviation, description, version_id, parent_id, owner_id,. The duplication log shows the duplication is stuck while duplicating a specific user object. Click Create a new Security Role next to Security Roles. Log into command manager in 2-Tier(direct connection to the metadata) 2. This knowledge base article explains how to migrate projects from one metadata database to another in MicroStrategy 9. x - 9. 11?; Knowledge Base: Annotate. There's a reason we're at the top of the list. Go to Connection Type > Direct (2-tier), and click Next. Full control. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. If the preference is set. Our vision is to enable Intelligence Everywhere. In the Navigation pane, click Users and Groups. The reason why this method is required is that certain settings and features are set only upon the creation of a metadata and are database specific. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. To do this, select the first option in MicroStrategy Configuration Wizard and follow the steps from there. In the original project, create the document to be used as a portable document. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. Click OK. x. In the Log Options screen, leave the default log locations and select Next . KB13782: After duplicating a project in MicroStrategy Developer 10. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. Was this post helpful? thumb_up thumb_down. 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. List Project Configuration Properties statement. MicroStrategy recommends that if you want to copy objects between two projects. You can unlock the schema in the Schema Editor . 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. x and later. This is by design. 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). Provide a Project Source name. 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. Now, enter your username and hashed password copied from the database and login. e. 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. location_path is the folder where the attribute resides, of type string, between double quotes ("). Step 2: View the Dockerfile in your project folder. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. 8. 4. This data is stored as Intelligent Cubes. In the left pane, click All Settings. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. x, create a new report with the following definition: Attributes . flag Report. For a smooth and easy migration, it's recommended to review the attached PDF containing Object Migration best practices. 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. Note: This setting has to be check for every MicroStrategy project logging statistics. . x-10. 'Product 01' is licensed for 0 named users. There's a reason we're at the top of the list. To invoke the "ProjectDuplicate. 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. /mstrcfgwiz. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. 2 and above. x and 10. Rename objects within a project. Open the MicroStrategy Configuration Wizard. Open Command Manager and type the following commands to execute the Intelligent Cubes. Project duplication wizard hangs when attempting to duplicate a project in MicroStrategy Developer 9. This is a known issue in MicroStrategy 10. If all of the required conditions to import multiple copies of the table (listed in Supporting duplicate tables in multiple data sources ) are met, an Options dialog box opens. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. While Technical Support can help to resolve these issues, the user would like to know how to avoid them in the future. Unlock Project statement. After every project duplicate, disconnect and reconnect to Project Source. Unlocks a project in the metadata. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. x-10. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. 2. 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. 'Product 02' is licensed for 0 named users. One workaround is to check each DBI and make sure all DBI including system DBI have database connection. 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. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. In this example, the project source is APS-CLIENT-2, as shown in the image below. Create a database instance that references the intended datamart location by performing the following steps. This article explains how to to copy Partition Mapping tables and objects from one project to another in MicroStrategy Object Manager 9. To do so, you can take advantage of URL API. 4. use the function "Remove Duplicate Rows". 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. 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. What permissions are needed to allow a user to duplicate projects in MicroStrategy Developer Project duplication failed when duplicating project related configuration objects in MicroStrategy Developer 10. Open the Workstation window with the Navigation pane in smart mode. 2012-04-25T09:22:00Z. In MicroStrategy 10. 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. Cannot insert duplicate key in object 'dbo. There are other Configuration Objects, but these will be covered in Chapter 6, Security – Managing Your Users and Their Access and Chapte r 7, Administration – Maintaining and Monitoring Your Project. Step 2. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. To export a project schema to an Excel file in MicroStrategy Developer 9. 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. I have to duplicate the project, change the fact table and change the related items. 2. 4. Microsoft released the following security and nonsecurity updates for Office in November 2023. x, only schema objects are migrated to the new project. 0. 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 . Project: the project containing the objects to include in the update package. Delete objects within a project. Under the Tools menu, select Project Documentation. This technical article explains a defect where users can see duplicate rows for a Dossier against a Data Import Cube when the fact table used contains duplicate rows. Sometimes you need to deal with a data source that has duplicated data. If the Starburst menu is clicked again, the user will see that the font of. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. 1 or later using the Perform system object ID unification optionFor Cloud 3. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. pkg. There's a reason we're at the top of the list. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In the Project Source Manager click on 'OK' to exit the window. This technical note describes how to use the persisted project source name to refresh report using MicroStrategy Office 10. For this Click on Schema and Click on Create New Project. KB290890: Project duplication wizard hang when attempting to duplicate a project in MicroStrategy Developer 9. Log into Desktop 9. One example is registering and loading a project at startup. 4. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. Select from the following: To duplicate the database connection, click Duplicate. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. Microstrategy developers responsibilities require that "developers must be able to give clear instructions to others working on a project.