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. Operations cannot be performed from a newer metadata to an older version. In the next slide, 'Database Instance Definition', choose a name and database type for the datamart. To add the dependents of all objects to the package, click Add all dependents. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. Enter a new name and press the Enter key. Note: We recommend you enable Add All Used Dependencies. KB38452: What can cause profile folders to get duplicated after a MicroStrategy Developer Project Duplication? Number of Views 916. 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. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. Click Add a New Dynamic Address List. For project: MicroStrategy Tutorial number of cubes:21 Info for cache: Actual vs Forecast Performance Cube Status: Ready Loaded Filed Active Info for cache: Copy of CrimesInLondon Status: Imported Ready Loaded Filed Active The example provided in this document is provided “as-is” to the user and assumes that the user:. It gives you the leverage of generating real-time reports and monitoring. You cannot move Project A objects to an exact copy of Project A. Object Manager copies the folder, its contents (the shortcuts), and their dependencies (the target objects of those shortcuts) to the new project. To list and count unique users per project, project documentation can be used from within MicroStrategy Developer 10. Under the Tools menu, select Project Documentation. If you are leveraging Web ASP, see KB484127 to use this feature. 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. Step 2. 52K. 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. Click in “Add new data”. Unlocks a project in the metadata. For the default contact for the user, this will duplicate. 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. The duplication log shows the duplication is stuck while duplicating a specific user object. Search for objects within a project. Click Select. x. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. x Loading × Sorry to interruptFor this particular error, a database instance object is involved and when MicroStrategy Developer 10. Example: #Todumpalldatabases pg_dumpall>db. After duplicating a project in MicroStrategy Developer which uses LDAP Authentication, subscriptions may be missing. To edit the database connection, click Edit. Create a configuration package with user and/or user group objects and set their Action to Replace. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. The scenario below explains the steps to follow to configure two identical projects pointing to two different warehouses in the same Project Source in MicroStrategy 9. To delete a dossier, right-click it and choose Delete. To export a project schema to an Excel file in MicroStrategy Developer 9. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. This setting is ideal if you have numerous. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in Presentation mode for users who open a shared Dossier via URL API in MicroStrategy Web 10. Supported data structure and distribution on Gateway. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Note: This setting has to be check for every MicroStrategy project logging statistics. Click on Next. 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. - 3-tier for a server (3-tier) project source connection. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThe following procedure describes how to merge users from two different metadata repositories using the Project Duplication Wizard in MicroStrategy Developer. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformChoose a project, right click on it and select “ Duplicate Project” 2. Open both folders in which the user is located for each project source. 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. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS;Run the MicroStrategy Configuration Wizard: cd /opt/mstr/Microstrategy/bin. New user and application requirements make attribute creation and modification an important part of the entire project life cycle. You can. In the Navigation pane, click Users and Groups. Alternatively, click Add and the Add Objects window opens. x. Managing Data Source Connections. Update packages are part of Object Manager. Each environment contains a MicroStrategy project. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Restart the MicroStrategy Intelligence Server to make the new settings take effect. In the source project, all dependents of the report are stored in the Public Objects\Report Dependents folder. x, open the Project Configuration window by right-clicking on a project and choosing 'Configure Project'. Using MicroStrategy Enterprise Manager 9. 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. This is by design. Drag and drop objects from the Object Browser into the Create Package dialog box. If you want to copy objects between two projects, MicroStrategy recommends that the projects have related schemas. To modify the status of an Intelligent Cube, right-click the Intelligent Cube in the Intelligent Cube Monitor, and select one of the actions listed below: Action. Save the XML file of all trial upgrade. . In the original project, create the document to be used as a portable document. Use Object Manager when you have only a few objects that need to be copied. Select the Members tab. The process will hang and MicroStrategy Developer will become unresponsive at any point. ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. x and later. Specify the project source and project information that you are copying from (the source). To duplicate a project in MicroStrategy Develper 10. 4. Project: the project containing the objects to include in the update package. 0. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. 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. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. new_desc is the new description of the attribute, of type string,. I have a data set which has all tickets 'Not Closed' along with the 'Work Info Work Log Date' field added. 3. SYMPTOM: Project. This is how the behavior is set and displayed from within MicroStrategy Developer 9. From the left, select Dynamic Address Lists. e. x, only schema objects are migrated to the new project. Run this script to delete the project (this step could take several minutes) a. Click 'Next' after the introduction. 2. 1. Each environment contains a MicroStrategy project. I have to duplicate the project, change the fact table and change the related items. The MicroStrategy Intelligence Server API call related is IDSSProjectInstance::Load. x. " and select all users and groups, except for. x-10. 5. Note: We recommend you enable Add All Used Dependencies. 4. xThe status of an Intelligent Cube tells you how the Intelligent Cube is currently being used and whether reports can access the Intelligent Cube. 3. Open MicroStrategy Developer 10. To achieve this, there are two ways:When logging into MicroStrategy Developer (formerly Desktop), it can be seen that Profit Forecast no longer can be seen under the Financial Reports folder. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Click on Create Project and Give suitable Project name and Click OK. x. If one of the attributes is removed from the template, the Cost is aggregated. In this scenario, you typically use three environments: development, test, and production. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. This tech note explains how to avoid that after duplicating a project into another project source via MicroStrategy Developer 10. . Copy this empty project into the destination environment using Project Duplication ensuring that all users and user groups are copied. For. What action should be taken? The incomplete project cannot be repaired, therefore it must be deleted. pkg. Plus, it connects business apps while integrating data. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. ; Go to Connection Type > Direct (2-tier), and click Next. x, runs out of memory. 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. 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. The user can do this by importing the layout of the second document into the first document. In the MicroStrategy system, every object has an ID (or GUID) and a version. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B. A list of security roles in the project source opens in the main Developer pane. )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. Name: ProjectsTransformCustomStatus. Click Export and save the file. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. 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 process will hang and MicroStrategy Developer will become unresponsive at any point. x - 9. To duplicate a project in MicroStrategy Develper 10. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. Import the document into the replacement project. Published: Jun 3,. See To copy a document between projects for a detailed procedure. Open the MicroStrategy Configuration Wizard. Select Project Sources and click Next. MicroStrategy Developer is the Administrator's Home and the primary source of administering MicroStrategy Enterprise. 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. 4. DSSCSADDRESS'. x, below cross site scripting issue was. This is a guest blog post co-written by Amit Nayak at Microstrategy. Before creating a database instance for a project warehouse, users need to create a Data Source Name (DSN) that points to the database (which holds the project warehouse). 3. 3. In MicroStrategy Desktop, log in to a project. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. Specify the port number where the SMTP server receives incoming e-mail. 2. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. 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. Please contact MicroStrategy Technical Support for an update on this issue. The Full option exports a snapshot of each page and each individual visualization. x, execute the following steps: Connect to the project source and expand the project that is to be duplicated, as shown below: Right-click on the project name and select Duplicate Project. Open MicroStrategy Command Manager and save the script below as PurgeObjectCache. 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. These files are used by some of the data Import Intelligent Cubes and an Xquery report. See To copy a document between projects for a detailed procedure. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. Starting in MicroStrategy 9. exe". When a ScanMD Fix is performed on a project, the MicroStrategy Intelligence Server should be stopped, or that Project unloaded. The game-changing enterprise analytics tool that turns data into actionable insights and intelligence. x as shown below: Duplication might fail right after property transfer completed if no users were duplicated or after user objects load/save finished if all users or project related users were selected to be duplicated. In this example, the project source is APS-CLIENT-2, as shown in the image below. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. The destination project must be of the same metadata version or older metadata version as the source project. There are three types of objects: schema objects, application objects, and configuration objects. 0, this Feature Flag has been removed and replaced with a project level setting called "Data Engine Version". When using the project duplication wizard in Developer to duplicate projects within the same project source, the option 'project-related users and group only' is disabled as shown below: To create a new project using the Project Creation Assistant. An update package migrates a previously specified group of objects. Follow Steps 1 to 10 to decide the parameters of the duplication process . Under the Tools menu, select Project. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. exe", the syntax is: ProjectDuplicate. The duplicate connection is automatically created and displayed in the Database Connections panel. Exporting creates a package file with the extension . Otherwise, the link to History List will keep the same as before. x from the command line by using the following command:. spicehead-tvkpqyiu. 1. Unlocks a project in the metadata. with the MicroStrategy sample project called Tutorial - Delivery. There's a reason we're at the top of the list. it is then acceptable to. Double-click the security role you want to assign to the user or group. Plus, it connects business apps while integrating data. Go to the 'Database Instance Manager'. Create a DSN to Tutorial_WH_Copy, call it Ttrl_WH_Cpy_DSN; Connect to Ttrl_WH_Cpy_DSN with DB. 3. Click Yes. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. Applications of MicroStrategy. In the left pane, click Privileges. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. A project created in MicroStrategy 6. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. 4. 8. users can. To create to a direct project source. There's a reason we're at the top of the list. Delete option is performed on the Intelligent Cube, and data is not compared with the warehouse. . 2. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. 1 and 10. Right click the Regions column header and select Advanced Formatting. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Specify the port number where the SMTP server receives incoming e-mail. Select Configure Intelligence Server, and click Next. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. Deploy the ojdbc8. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. Create a configuration package with user and/or user group objects and set their Action to Replace. Select 'Export Project Schema. In the Device Editor, click the Delivery Options tab. Expand Administration, and then expand System Monitors. Now Click on Select Tables from Warehouse Catalog Button and Database instance Wizard will open. No users should be connected to the project. You can unlock the schema in the Schema Editor . Why MicroStrategy Why MicroStrategy; Customer Stories; Platform In the Project Source Manager click on 'OK' to exit the window. 1, users have the ability to keep the source project's GUID as the destination project's GUID using the "Use the same identifier (GUID) as source project" setting located within the project duplication wizard as shown below. 2. For example, you may want to run the project duplication in the evening, when the load on Intelligence Server is lessened. When the Project Documentation Wizard opens, select the project to be documented and click Next. x cannot be duplicated until it is upgraded toThis article discusses an issue where subscriptions are marked invalid and deleted after duplicating a project to another metadata in MicroStrategy Developer 10. Create a new dossier, add new data, use Clipboard and input the sample data as below. 13K KB12330: How to duplicate a project in MicroStrategy Developer 10. Next we will delete the project. Go to each of the attributes and facts returned by the dependency search. Cannot insert duplicate key in object 'dbo. 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. 4. 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. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. Select from the following: To duplicate the database connection, click Duplicate. In MicroStrategy 10. Required Status to Perform Action. Select Project Sources and click Next. MicroStrategy recommends that if you want to copy objects between two projects. A list of security roles in the project source opens in the main Developer pane. From the Home menu, select one of the following: To save a report, select Save. Provide a Project Source name. Open License Manager on the Intelligence Server machine and open Audit. Activate the Tutorial project at 3-Tier using one of the following methods. This MicroStrategy tool can be used to test and troubleshoot. This issue has been addresses in MicroStrategy Developer 10. e. In MicroStrategy Developer 10. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. In the destination project source, administrator privileges are required. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MicroStrategy Administrator - Object Manager is built with the assumption that two projects are related. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. x and how duplicate columns can be created. Receive a list of. x. From the Select a Project drop-down list, select the project for which to assign the security role. DSSCSADDRESS'. From the Warehouse Tables pane, right-click the table to add to the project and select Add Table to Project. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The data returned by the Platform Analytics project schema is never limited. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. The Page level option only provides a snapshot of each page. 3. 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. jar. exe -f Path\XMLFilename. Input connection parameters for the connector:Click Create on any folder page, point to New Report, and select Intelligent Cube Report. DSSErrors. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. MicroStrategy Web. Administrators no longer need to install Narrowcast Server on the machine where. 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). 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. If the Starburst menu is clicked again, the user will see that the font of. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Specify the IP address of the SMTP server. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. Object Manager looks in the destination project's Public Objects folder for a subfolder named Report Dependents (the same path as in the source. use the function "Remove Duplicate Rows". Type mstrcmdmgrw and press Enter. 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. KB12330: How to duplicate a project in MicroStrategy Developer 10. On the Data Sources pane on the left, hover over the name of the database connection to modify and click the arrow icon. Move objects within a project. Quoting Behavior is a setting created to control whether a project uses unified quoting. 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). 1. The copy of the table is added to the project and. A user sees duplicate values when creating an element list prompt in MicroStrategy Developer 9. x. Using Object Manager, you can copy objects within a project or across projects. 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. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingThis is an example of how to achieve Option 2 using MicroStrategy Tutorial project in 3-tier, keeping the same Database Instance and Database Connection but changing the DSN. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. 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. 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. 2. 2. SYMPTOM: When trying to do a project duplication selecting the options to migrate subscriptions for the users being migrated, the subscriptions do not get migrated. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. 3. ' from the MicroStrategy Developer 'Schema' toolbar menu. 2 and above. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. 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. Each environment contains a MicroStrategy project. No errors are thrown,and nothing is written to the duplication log. Our vision is to enable Intelligence Everywhere. Copy objects within and across related projects. AuthenticationMode: the authentication mode used to connect to the project source, either Standard or Windows. Duplicate projecct to MSTR A instance (production project) This seems fairly straight forward, but this is my main problem: When deploying from MSTR B instance (development project) to MSTR B instance (test project), MSTR Object Manager attempts to move the database instance (querying the development data warehouse) as well. This document shows how to create a MicroStrategy Object Manager package to prevent a dependent object from being migrated over. Choose the individual modules to be logged. This means that one must have originally been a duplicate of the other, or both must have been duplicates of a third project. Choose File > New Attribute. x, the warning message that follows is faced during the project duplication across two different metadata repositories from 3-tier in a Microsoft SQL Server 2008 R2 instance to 2-tier in a Microsoft Access 2007 instance: Operation must use an updatable query. To allow a user to duplicate projects in MicroStrategy Developer, the following privileges are required in the source project: - Analyst -> Use Developer. 0 (Ashburn and Seattle): 1. I've been working in the past few years with Cognos 10 and Cognos 11 but my company has Microstrategy (I'm a newbie in Microstrategy). , the result set is retrieved from the warehouse after which the conditional statements within these function definitions are applied. 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. In the Device Editor, click the Delivery Options tab. Explanation: The name will use the browser default language preferences, English (United States) in this case. 4. Operations cannot be performed from a newer metadata to an older. An object is a basic building block in MicroStrategy. out l. You can choose to duplicate user, contact, and subscription information. In MicroStrategy Developer 9. 1. Step 8: Change the migrating objects to the following:. On the report toolbar I’ve highlighted six icons, in order from. 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. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. For this Click on Schema and Click on Create New Project.