Migrate the metadata to a database that supports larger databases or reduce the size of the projects by deleting unused objects. Application objects include reports and documents, and the objects used to create them,. Open both folders in which the user is located for each project source. After loading, MicroStrategy will present a window like this. 'Product 01' is licensed for 0 named users. Update packages are part of Object Manager. The Revenue metric is said to be used by these other objects. 0 (Ashburn and Seattle): 1. Case() and CaseV() functions are Analytical Engine functions, i. x. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. Click your Account drop-down and choose Preferences. 7. In the Project Source Name field, type a name for the project source. When the highlighted is selected, MicroStrategy Office will try to find a project source name in Web Services that matches the persisted project. Transform description: This transform displays project status on the Projects page. ' from the MicroStrategy Developer 'Schema' toolbar menu. There's a reason we're at the top of the list. Double-click the security role you want to assign to the user or group. 1 or later, or have been updated to version 9. Every object in a MicroStrategy project has a unique ID. When adding such data into MicroStrategy, such duplicates can be removed through the data wrangling functionality available in MicroStrategy Desktop, Workstation, and Web. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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. 0 (Ashburn and Seattle): 1. In summary, when defining an Incremental Refresh report, take the following behavior into consideration. Log in to a project source in MicroStrategy Developer. Note: For the purposes of this example, the following steps assume that the source and destination metadatas are contained in separate databases. In MicroStrategy Developer 9. 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. Companies of all sizes use this platform to assess, visualise, and build dashboards. Click on "Select users. In the following query, the IS_PROJ_NAME field represents the name of a MicroStrategy Project. new_desc is the new description of the attribute, of type string,. 6. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Right click a project and select Duplicate Project. 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. Connect to MicroStrategy Analytics Modules in Command Manager; Run the following script: LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial"; Right mouse click on Results Pane -> Results -> To Text; Copy Application and Schema Objects. Copy Objects Object Manager can copy application, schema, and configuration objects. 1 as the administrator user in MicroStrategy. On the report toolbar I’ve highlighted six icons, in order from. This method is recommended and supported by MicroStrategy. 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. Starting MicroStrategy 11. 52K. x SYMPTOM: When use 3rd party security scan tool such as Acunetix Web Vulnerability Scanner or IBM Security AppScan Standard to implement the security scan toward MicroStrategy Web 10. 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. 4. There's a reason we're at the top of the list. 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. Select the Members tab. Enter the credentials for the Administrator account on the local Intelligence Server, and then enter the DSN and. For a smooth and easy migration, it's recommended to review the attached PDF containing Object Migration best practices. Click in the right pane. Unlocks a project in the metadata. Instead, there is a report called 'Copy of Profit Forecast' and it can be found under the Product Sales Reports folder. This would reduce the amount of clicks and streamline the process for users that are unfamiliar with the MicroStrategy Web Interface. Create a configuration package with user and/or user group objects and set their Action to Replace. )To create a project update package, copy the file createProjectPackage. Server any mappings from MicroStrategy objects to the data warehouse column being removed: Search for objects dependent on the column being removed. Please subscribe to the channel to get an update with videos and help us to get 5000 Subscribers. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. 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. If you like the video, please subscribe to my channel. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. See To copy a document between projects for a detailed procedure. And check the option to Show 'Contains' and 'Contained by' tabs, as shown below: Go to 'Object Types' tab, and select 'Report' and 'Document'. In the menu bar, go to Tools > Preferences. Click the “Select File” option. . In the source metadata,. 4. 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. 1. Add Category, SubCategory, and Cost to the dossier. The report can be executed in MicroStrategy Web. Under Preferences, click General. Rename the Project to remove these characters, after which the project can be duplicated successfully. process, which is named M8DBMPE1 in MicroStrategy 7i - 7. This knowledge base article explains how to migrate projects from one metadata database to another in MicroStrategy 9. Projects must have the same Schema ID and they must be updated to the same metadata version prior to the merge. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. 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. 8-2. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformI am new to the Microstrategy, I need some tips to do my task involves change of fact table in a project. This issue has been addresses in MicroStrategy Developer 10. Specify the project source of the project to be duplicated in the Direct Project Sources section. 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. x to use Manual mapping and remove the 'ORDER_DETAIL' fact table from the 'QTY_SOLD' expression. Export the document from the original project. To log in to a project source using Object Manager, you must have the Use Object Manager privilege for that project. Using Tutorial data: To do this the user must copy their second document into the hidden Objects Templates->Dashboards folder. /mstrcfgwiz. 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. Copy objects within and across related projects. Cannot insert duplicate key in object 'dbo. This means that either one project must be a duplicate of the other, or both projects must be duplicates of a third project. Unlocks a project in the metadata. 4. Users' profile folders are project specific, unlike users, which are system wide objects. This commonly used scenario is the project life cycle that MicroStrategy recommends you use as you develop your projects. In the left pane, click All Settings. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The MicroStrategy Engine includes three built-in functions to handle conditional expressions: IF(), Case() and CaseV(). Upon opening your Project Source for a particular environment, the 'Administration' section provides all. MicroStrategy recommends that you observe the following practices when copying objects with Object Manager in MicroStrategy 10. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. 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",. x. Thus, the report has been moved to another folder within the same project. Specify the. You can unlock the schema in the Schema Editor . Check the required options in the 'Export schema' dialog box and. There are various applications of MicroStrategy. The SMTP server should have access to the Internet and it should be configured to relay messages originated in the MicroStrategy Narrowcast Server machine. l pg_dumpallBacksupalldatabasesinagivencluster,andalsopreservescluster-wide datasuchasroleandtablespacedefinitions. Select the Members tab. So I want to create an embedded query to know which last objects. Plus, it connects business apps while integrating data. These two components. Follow the steps below to make the changes in MicroStrategy Web 9. In order for objects of two projects to be copied across, the schema IDs of the projects must match. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. Log into command manager in 2-Tier(direct connection to the metadata) 2. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 5. FOLLOW THESE STEPS: Create Object Manager Package: 1. For example, a 14- day default means that the view tables and Platform Analytics Cube will include data from the last rolling 14 days. Otherwise, the link to History List will keep the same as before. MicroStrategy recommends that if you want to copy objects between two projects. Save the XML file of all trial upgrade. The following example shows how to create a metric that displays attribute values in MicroStrategy Developer. SYMPTOM: Project. bat, as shown below, to run PurgeObjectCache. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Web. 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. What Objects are Duplicated with a Project? When you duplicate a project, all schema objects (attributes, facts, hierarchies, and transformations) are duplicated. This would change the project version so that the Copy and Paste would work. 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. There's a reason we're at the top of the list. The copy of the table is added to the project and is displayed in the Tables being Used in the Project pane. Choose a Source Project Source and Source Project as well as a Destination Project Source and Destination Project. 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. 11?; Knowledge Base: Annotate. Intelligence Servers and Projects are duplicated on the MicroStrategy Web Administrator page and on the Project page in MicroStrategy Web 9. 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. Though the 3 rows have the same Category & SubCategory, the Cost is not aggregated. Log into the 3-tier project source. x, right click on the project of interested and select 'Project Configuration' from the menu, as shown below: Once the window for 'Project Configuration' opens, expand the 'Database instances' menu and go to the `Relational` section to see the database instance(s) currently in use for the project. 1 or later using the Perform system object ID unification optionFor Cloud 3. x. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). currentFactDataKeepDays:. by clicking the lock icon for the project. Microsoft released the following security and nonsecurity updates for Office in November 2023. In MicroStrategy Developer, duplicate each of the projects into this new project source. There's a reason we're at the top of the list. Configure Intelligence Server with restored metadata with Configuration Wizard . 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:. Selecting a database instance check box makes that database instance available in the project for standard MicroStrategy. Deploy the ojdbc8. After duplicating a project into another project source via MicroStrategy Developer 10. Use the project duplication function to duplicate only the Tutorial project to your metadata. Click Add, select the elements, then click OK. 3. Consider the two scenarios below: 1. For information about duplicating projects, including instructions, see Duplicating a Project. 2 and above. - On MicroStrategy Developer main toolbar, cick on ToolsProject Documentation - Follow the wizard selecting: (1) Application Objects (2) Advanced. Consider the following example: Suppose attribute "Child" is a child of attribute "Parent". Note: The Tutorial project is designed for MicroStrategy Web JSP. The Page level option only provides a snapshot of each page. Step 3. 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. DSSErrors. To create to a direct project source. 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: Enabling this option also makes the "Hidden Objects" folder visible through 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. This data is stored as Intelligent Cubes. On the source computer, go to Start > Run. This is a known issue in MicroStrategy 9. There's a reason we're at the top of the list. MicroStrategy provides modern analytics on an open,. In MicroStrategy Developer, duplicate each of the projects into this new project source. 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). KB38452: What can cause profile folders to get duplicated after a MicroStrategy Developer Project Duplication? Number of Views 916. In MicroStrategy 10. In Linux: Browse to the MicroStrategy Home folder, then to the /bin subfolder. In MicroStrategy Web 9. Go to 'Contains' tab, and click on Add button. x. Unlock Project statement. Each environment contains a MicroStrategy project. 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. x:. Step 4. CAUSE: This issue may be caused by the Intelligence Server having multiple network cards installed. Click Export and save the file. 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. In the menu bar, go to Tools > Preferences. Under "Browsing Options", check the option "Show hidden objects" and confirm the change. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. out l. 2. e. This will only work if the DSNs related to the project sources exist with the same names on the destination computer. Application objects are not seen even after selecting the option to duplicate all objects to the new project. 2. KB16858: How to create logical tables without creating duplicate columns objects in MicroStrategy Desktop 10. Step 8: Change the migrating objects to the following:. Choose 'Database Instance Wizard'. 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. Follow Steps 1 to 10 to decide the parameters of the duplication process . 1 or later, or have been updated to version 9. Import the document into the replacement project. Note: This setting has to be check for every MicroStrategy project logging statistics. From the Warehouse Tables pane, expand the database instance for a different data source that also includes the table. Open the MicroStrategy Configuration Wizard. In MicroStrategy Developer 10. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and. 5. 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. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 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). DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. 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. Replace the text ‘MicroStrategy Tutorial’ with the name of the MicroStrategy Project you would like to purge data for. For example, a user copies a report from the source project to the destination project. jar file to i-server machine. 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. Symptom By default, a document contain group attribute will still be exported into one sheet in Excel. MicroStrategy Object Manager can help you manage objects as they progress through your project's life cycle. Duplicate 'MicroStrategy Tutorial' project from 'C009 BI Apps Tuto project' source. The duplication wizard hangs at different steps during subsequent duplication attempts. where: attr_name is the name of the attribute to be modified, of type string, between double quotes ("). Create a new dossier, add new data, use Clipboard and input the sample data as below. Restart the MicroStrategy Intelligence Server. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Duplication is the only way to get the projects into another environment. 3. Request a demo. The duplicate connection is automatically created and displayed in the Database Connections panel. Click on 'Browse . Use Object Manager when you have only a few objects that need to be copied. 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 the respective DSN's in the Intelligence Server machines. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Why MicroStrategy Why MicroStrategy; Customer Stories; Platform To include a copy of the table in the project, select Indicate that TABLE_NAME is also available from the current DB instance, and click OK. Select Project Sources and click Next. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. x-10. 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. Move objects within a project. The MicroStrategy metadata could be thought of as a logical bridge between the technicalities of the database and the business terms, measures, and contexts. There are now two new VLDB properties that control quoting behavior. 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. Published: Jun 3,. Two specific capabilities within data wrangling will be especially useful for this purpose: remove unnecessary columns. Expand Administration, and then expand System Monitors. 2012-04-25T09:22:00Z. After duplicating user (s) from the out-of-the-box Administrator user, the server becomes out of compliance. The Project Comparison Wizard is a part of Object Manager, and thus requires the Use Object Manager privilege to run. pimiento. Loading all projects: 'create a ServerAdmin Session Dim objMyserveradmin As IDSSServerAdmin Dim bfound As. For jobs executed in MicroStrategy Web, the Query Engine of the Intelligence Server is used. 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. In the data warehouse, attributes are normally identified by a unique ID column in a lookup table. Locate the Intelligent Cube directory, found in the Project Configuration panel under Intelligent Cubes > General. 4. 2. Follow these steps to create it from MicroStrategy Developer: Go to Tools Menu | Project Source Manager. 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. x and later. x-10. Open the script. Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. If you are leveraging Web ASP, see KB484127 to use this feature. Option 1 (Scheduler is turned off) Enable the Scheduler through MicroStrategy Developer. Click on Next. Was this post helpful? thumb_up thumb_down. . We decided to gather them in one placing using our experience and MicroStrategy materials. Search for objects within a project. From the DSN drop-down list, select the DSN used to connect to the metadata repository. Specify the project source and project information that you are copying from (the source). Click and drag the user from the Backup Metadata folder to the same User Group where the user is located in the Current Metadata. FORCE forces the project to unlock. Open MicroStrategy Developer 10. There's a reason we're at the top of the list. Scan MD is a utility that detects and repairs logical inconsistencies in the MicroStrategy metadata without requiring code-level changes to the core platform. One workaround is to check each DBI and make. 3. To achieve this, perform the following steps: Open MicroStrategy Command Manager and log into the appropriate Project Source and provide a user name and password for each user with access to the. 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. There's a reason we're at the top of the list. - Administration -> Duplicate project. 8-1. The user logging in to Developer must be granted the "Audit Change Journal" privilege. Under Preferences Level, click Project Defaults. LIST ALL PROPERTIES FOR PROJECT CONFIGURATION IN PROJECT "MicroStrategy Tutorial";. WORKAROUND. x and how duplicate columns can be created. Delete objects within a project. Create a configuration package with user and/or user group objects and set their Action to Replace. The report can be executed in MicroStrategy Web. Expand Administration, and then expand System Monitors. Select Configure Intelligence Server, and click Next. Once the metadata shell is created, create a project source using this DSN. By default all. 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). Select 'Export Project Schema. To do so, you can take advantage of URL API. To delete a dossier, right-click it and choose Delete. In the destination project source, administrator privileges are required. with the MicroStrategy sample project called Tutorial - Delivery. Number of Views 9. 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. 1. Activate the Tutorial project at 3-Tier using one of the following methods. Create an Attribute. Select the Members tab. Cannot insert duplicate key in object 'dbo. 1. Companies of all sizes use this platform to assess, visualise, and build dashboards. Supported data structure and distribution on Gateway. ; Go to Connection Type > Direct (2-tier), and click Next. ACTION Modify the project configuration of source project or destination project and save it. Update/Update only option does not compare all the attribute elements. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. MicroStrategy recommends that if you want to copy objects between two projects. 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. 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. PAProject= Defines whether to create the Platform Analytics project, as determined by the following values: • 1: Create the Platform Analytics project on this machine. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. ; From the DSN drop-down list, select a DSN for the data source that stores the metadata and specify a. The Security Role Editor opens. Click Save. Open License Manager on the Intelligence Server machine and open Audit. UNLOCK PROJECT project_name [FORCE]; where: PROJECT "project_name" is the name of the project to be unlocked, of type string. SOLUTION 1: Take MicroStrategy Tutorial Project for example, Command Manager can be used to get the settings. x, all users can see the project even if they could not see the project before duplication. 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. From the Tools menu, select ExportDocument Template. The data returned by the Platform Analytics project schema is never limited. Drag and drop the objects into the report grid. 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. DESCRIPTION: There are a number of scenarios in which it is desirable to automate the adding of a statistics instance i. 2. 1 - 10. 5. The Detail Level drop-down allows you to choose Full, Page level, or Visualization level. Create the respective DSN's in the Intelligence Server machines. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. Example: #Todumpalldatabases pg_dumpall>db. Unlock Project statement. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To show Developer Hidden Folders through Narrowcast, follow steps below: Launch MicroStrategy Narrowcast console. Then click OK. x. In the Project Duplication window, the hang appears to occur after finishing the property set objects. 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. 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.