To create to a direct project source. x. x SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. 2. Unlock the ultimate power play of data creativity and data horsepower to develop applications that transform. 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. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. 3. 1 and 10. The user logging in to Developer must be granted the "Audit Change Journal" privilege. 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. Was this post helpful? thumb_up thumb_down. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. '. MicroStrategy has the following tools available for updating the objects in a project: Object Manager migrates a few objects at a time. Under Preferences, click General. Under the Tools menu, select Project Documentation. 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. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. Exporting creates a package file with the extension . In the Navigation pane, click Users and Groups. Click Select. The process will hang and MicroStrategy Developer will become unresponsive at any point. Application objects are not seen even after selecting the option to duplicate all objects to the new project. If the preference is set. How to delete, invalidate or expire caches from a specific project in MicroStrategy Developer. From the drop-down list of groups, select the group containing a user or group you want to assign the security role to. )To create a project update package, copy the file createProjectPackage. Object Manager and Project Merge both copy multiple objects between projects. To export a project schema to an Excel file in MicroStrategy Developer 9. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Self-Service Analytics with Amica. This will produce an html document containing the search results and any information that is selected about those objects. There's a reason we're at the top of the list. To resolve this issue, MicroStrategy recommends disabling the feature Group recipients in a single email when device and bucketing rules are the same. All dependent objects of all objects currently listed in the package. Instead, there is a report called 'Copy of Profit Forecast' and it can be found under the Product Sales Reports folder. The hang will only occur when the database instance. 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. x. e. use the function "Remove Duplicate Rows". Right-click on the Project Source and choose 'Intelligence Server Configuration'. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. 1. From the DSN drop-down list, select a DSN for the data source that stores the metadata and. Creating a new project at the Source environment called P1. If you are working on a report that has already been saved, a confirmation message appears. xAs an example, consider the fact 'Copy of Units Sold' defined as shown: Consider that this fact needs to be modified using MicroStrategy Command Manager 9. e. " and select all users and groups, except for. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. 2987. In MicroStrategy Desktop, log in to a project. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. Go to Menu -> Tools -> Options. 2 and above. x, open the Project Configuration window by right-clicking on a project and choosing 'Configure Project'. (From the File menu, select Open. 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. I have duplicated the project from ProjA to ProjA_hist using duplicate project at project level. Step 4. A project created in MicroStrategy 6. To duplicate a project with subscriptions, follow the steps provided in "KB 45537 How to duplicate a project without subscriptions for MicroStrategy Cloud Enterprise" adjusting the following steps: Step 8: Change the migrating objects to the following: Click on "Select users. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. The process will hang and MicroStrategy Developer will become unresponsive at any point. 5. Click Add, select the elements, then click OK. Follow Steps 1 to 10 to decide the parameters of the duplication process . Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Note the project source that connects the Intelligence Server. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Import the document into the replacement project. Assuming that the statistics tables have already been created in the. Right click a project and select Duplicate Project. Using MicroStrategy Enterprise Manager 9. Hey even if it doesn't work you can unload and load the Project that's definitely works. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 4. 1 or later using the Perform system object ID unification optionFor Cloud 3. 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 Detail Level drop-down allows you to choose Full, Page level, or Visualization level. Copy objects within and across related projects. In MicroStrategy Web 9. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. Add Category, SubCategory, and Cost to the dossier. Required Status to Perform Action. x. For information about duplicating projects, including instructions, see Duplicating a Project. Click 'Next' after the introduction. In the Device Editor, click the Delivery Options tab. When a MicroStrategy Administrator duplicates a user, the security filters tied to the original user are not tied to the new user. 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. scp in cmdmgr -n Project_Source_Name -u Username -f InputfileRight-click the project that you want to export your settings from and choose Properties. 6. Operations cannot be performed from a newer metadata to an older. You can use the Import Data feature in MicroStrategy Web to import data from sources such as Microsoft Excel spreadsheets, comma-separated text files, and external databases into your project. x. Object Manager and Project Merge both copy multiple objects between projects. x. 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",. 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. Rename objects within a project. Object Manager looks in the destination project's Public Objects folder for a subfolder named Report Dependents (the same path as in the source. You cannot move Project A objects to an exact copy of Project A. The duplication log shows the duplication is stuck while duplicating a specific user object. Enter the User Name and Password for the database. An administrator user can clear the Project Monitor of these unloaded, undeletable projects by reconfiguring the MicroStrategy Intelligence Server. The copy of the table is added to the project and. Open MicroStrategy Administrator - Command Manager and log into a 3-tier mode project source. new_desc is the new description of the attribute, of type string,. Each environment contains a MicroStrategy project. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. To start the Report Wizard. KB482889: Project cannot be unloaded via Command Manager or Developer when there is user session or job execution in Micro… Number of Views 1. 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. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. Choose a Source Project Source and Source Project as well as a Destination Project Source and Destination Project. To invoke the "ProjectDuplicate. These updates are intended to help our customers keep their. STEPS TO REPRODUCE: Right click a project and select Duplicate Project…The Metadata Update Utility (located in C:Program Files(x86)Common FilesMicroStrategyMDUpdateUtil. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. FORCE forces the project to unlock. In MicroStrategy Developer 10. Select Configure Intelligence Server, and click Next. 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. Click Next and Finish. In the original project, create the document to be used as a portable document. NOTE: Enabling this option also makes the "Hidden Objects" folder visible through the. flag Report. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and. jar. Sainsbury’s, a leading UK retailer deployed a comprehensive suite of applications that deliver best-in-class analytics experiences—powered solely by Snowflake, AWS, and the MicroStrategy Cloud. currentFactDataKeepDays:. x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. 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. users can. 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. Administrators may notice that when a user is copied from one Project Source to another, the user profile folder is not copied over. The Full option exports a snapshot of each page and each individual visualization. Unlock Project statement. Computation is separate from storage, which. When it’s set to 1, the project uses unified quoting. For Oracle 12. out l. Restart the MicroStrategy Intelligence Server to make the new settings take effect. 2. Expand the My Personal Objects folder, and then open the My Reports folder. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. MicroStrategy Object Manager provides an easy and improved way for users to determine if the two projects are related. To export a document template. To create a configuration update package, copy the file createConfigPackage. for Superclass and search for 'ProjectsTransform'. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. In a project, users may wish to compare the properties of two or more metrics, to establish whether these may be duplicates. 3. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). 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. Go back to MicroStrategy Desktop, right mouse click on the project -> Search for Objects. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. 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). Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. So I want to create an embedded query to know which last objects. MicroStrategy Command Manager 9. exe) is a utility responsible for updating the metadata with the latest project information based on the version of MicroStrategy Desktop from the machine on which the utility is installed and executed. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. Add Category, SubCategory, and Cost to the dossier. For example, [“MicroStrategy Tutorial”, “Enterprise Manager”] ProjectSourceName. When creating a logical table, there are two ways how the user can define the column objects. Explanation: The name will use the browser default language preferences, English (United States) in this case. Receive a list of. Add the following to the code: public void renderProjectStatus. Open a help desk request to restore Tutorial and Operational DM WH in the customer's specific Metadata SQL server. Click the “Select File” option. After duplicating a project into another project source via MicroStrategy Developer 10. 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. 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. SELECT ‘IS_PROJ_GUID’ FROM IS_PROJ WHERE IS_PROJ_NAME=‘MicroStrategy Tutorial’; The returned value of the. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. . Run this script to delete the project (this step could take several minutes) a. Go to the 'Database Instance Manager'. out l. Add | select in connection mode Server. x. There's a reason we're at the top of the list. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. In Windows, this is Program FilesMicroStrategyIntelligence ServerCube; in UNIX, /IntelligenceServer/Cube/. 5. 4. If the path begins with a dot, the directory will be found in the Intelligence Server installation directory. This is by design. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. Click Add, select the elements, then click OK. Change Journaling; The information which user made a change in the configuration is visible in the Change Journaling option. 1 as the administrator user in MicroStrategy. exe". Follow Steps 1 to 10 to decide the parameters of the duplication process . Expand Administration, and then expand System Monitors. 2. In this example, the project source is APS-CLIENT-2, as shown in the image below. For a smooth and easy migration, it's recommended to review the attached PDF containing Object Migration best practices. They may be compared in either 2-tier or 3-tier. 8-2. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. When copying objects across projects with Object Manager, if an object with the same ID as the source object exists anywhere in the destination project, a conflict occurs and the. x. Open both folders in which the user is located for each project source. In the source metadata, create an empty. Please subscribe to the channel to get an update with videos and help us to get 5000. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. The Security Role Editor opens. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. 2. SYMPTOM: In MicroStrategy Developer, users may notice that subscriptions are missing after project. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. 86K KB12504: Administrator user is unable to delete unloaded projects in a 3-tier project source after project duplication in. KB290890: Project duplication wizard hang when attempting to duplicate a project in MicroStrategy Developer 9. Using Object Manager, you can copy objects within a project or across projects. 5. In any case, a MicroStrategy Project helps developers and users to organize their reporting and analytics applications. Type: Attribute Qualification; Attribute: Report Job SQL PassMicroStrategy provides ETL, data warehousing and data mining for data analysis. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. A list of security roles in the project source opens in the main Developer pane. To move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. Create a configuration package with user and/or user group objects and set their Action to Replace. 2. The copy of the child will not be used by the parent. rst, is saved in the selected folder. Save the XML file of all trial upgrade. Within Categories, browse into 'Server Definition' and choose the 'Advanced' subcategory. Move objects within a project. 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. Alternatively, click Add and the Add Objects window opens. 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. 1. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). ACTION: These changes can be seen by using Change Journaling and Enterprise Manager. x. KB38108: How to give a user access to modify the database instances in the Project Configuration in MicroStrategy Develope… Number of Views 1. Select 'Export Project Schema. Rename the Project to remove these characters, after which the project can be duplicated successfully. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Delete objects within a project. 11?; Knowledge Base: Annotate. Rename the Project to remove these characters, after which the project can be duplicated successfully. Then click OK. You can choose to duplicate user, contact, and subscription information. 2. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. See To copy a document between projects for a detailed procedure. 5. If the Starburst menu is clicked again, the user will see that the font of. 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. x from the command line by using the following command:. 0. There's a reason we're at the top of the list. In Windows: From the Windows Start menu, point to All Programs, then MicroStrategy Tools, and then choose Command Manager. x - 10. To duplicate a project in MicroStrategy Develper 10. with the MicroStrategy sample project called Tutorial - Delivery. MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. Create a copy of the Tutorial Warehouse, call it Tutorial_WH_Copy. Full control. This tech note explains how to avoid that after duplicating a project into another project source via MicroStrategy Developer 10. Click the Connect button to launch the connector. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Specify the IP address of the SMTP server. 2 and above. The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. x. MicroStrategy 10 will report the following errors if the path specified in Project Configuration>Intelligent Cubes>General>Intelligent Cube file directory is not accessible:On the upper right of any page, click your user name, and then select Preferences from the drop-down list. Best practices for avoiding metadata issues that result from Duplicate Columns in MicroStrategy 9. SYMPTOM: Project. In MicroStrategy Developer, duplicate each of the projects into this new project source. A business intelligence platform offers a complete set of tools for the creation, deployment, support, and maintenance of business intelligence applications. NOTE: Only users with administrative privileges are able to select this option. Edit the line within the function that takes your login input. 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. In MicroStrategy 10. )An example is shown with MicroStrategy Tutorial Project: - In Microstrategy Developer, log into the project where it is desired to obtain a report's VLDB properties. This will open project Creation Assistant / Wizard. 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. DSSErrors. Detail Levels You can now select the level of detail exported from your dossier. Otherwise, the link to History List will keep the same as before. Open a project source in MicroStrategy Object Manager. 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. Project duplication setting is heart of the migration. 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. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Step 2: View the Dockerfile in your project folder. If desired, select the Do not ask me again checkbox to avoid showing this message for any dossiers, documents, or reports in the future. Enable the statistics logging for the project. When the Project Documentation Wizard opens, select the project to be documented 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. And check the option to Show 'Contains' and 'Contained by' tabs, as shown below: Go to 'Object Types' tab, and select 'Report' and 'Document'. java opens in the editor. Deploy the ojdbc8. This can be achieved as:This tutorial will guide MSTR users to share dossiers through Web and Library. Click in the right pane. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. This method is recommended and supported by MicroStrategy. 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. These two components. 3. In the destination project source, administrator privileges are required. x?How to prevent content spoofing on projects page affecting Intelligence Server name using MicroStrategy Web 10. For information about duplicating projects, including instructions, see Duplicating a Project. Double-click the security role you want to assign to the user or group. 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. This is a guest blog post co-written by Amit Nayak at Microstrategy. x-10. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Open License Manager on the Intelligence Server machine and open Audit. One example is registering and loading a project at startup. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. This is because. 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. 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). In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. Click in “Add new data”. If not, create those DSNs before proceeding with the steps below. To move system objects between projects that do not have related schemas, the projects must either have been created with MicroStrategy 9. This knowledge base article explains how to migrate projects from one metadata database to another in MicroStrategy 9. From the Warehouse Tables pane, right-click the table to add to the project and select Add Table to Project. location_path is the folder where the attribute resides, of type string, between double quotes ("). When user navigates to "Project Tables View" tab in MicroStrategy Architect 10. The same report accessed in web. The MicroStrategy Tutorial - Delivery project contains sample services that demonstrate many of the features of MicroStrategy Narrowcast Server. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 1. Log in to a project source in MicroStrategy Developer. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. 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. Name: ProjectsTransformCustomStatus. For example, as part of a delivery mechanism, it may be necessary to activate statistics following duplication. new_attr_name is the new name of the attribute, of type string, between double quotes ("). Type "regedit. 0. The Page level option only provides a snapshot of each page. Specify the port number where the SMTP server receives incoming e-mail. 4. 2 release, the driver file is called odbc8. In order for objects of two projects to be copied across, the schema IDs of the projects must match. . There's a reason we're at the top of the list. Next we will delete the project. 8-1. configure a project to collect statistics. An update package migrates a previously specified group of objects. If one of the attributes is removed from the template, the Cost is aggregated. In their own words, “MicroStrategy is the largest independent publicly traded business intelligence (BI) company, with the leading enterprise analytics platform. After loading, MicroStrategy will present a window like this. The user can do this by importing the layout of the second document into the first document. Duplication is the only way to get the projects into another environment. 3. In the Folder List, expand the project that contains the object you want to copy, then navigate to the object. MicroStrategy recommends that if you want to copy objects between two projects. Select the Members tab.