Purchase annual subscription pass. With the modeling tool, architects can map the physical database schema, model data based on business requirements and terminology, and build complex hierarchies to organize data and better reflect relationships. AboutMDXCubeSourcesinMicroStrategy 4 UnderstandingMicroStrategyArchitecture 6 RelatingObjectsfromMDXCubeSourcestoMicroStrategy 10 ConnectingtoMDXCubeSources 43In the Project Source Manager click on 'OK' to exit the window. MicroStrategy Application. Once, the download is complete; the system will initiate installing developer edition. 3. It is important to understand that certain capabilities powering the user workflows might not be supported in Snowflake. Click Show connection string and select Edit connection string. Remove DBInstance statement. Log in to the Windows server as a user with administrator privileges. a relationship table. a lookup table. MicroStrategy describes its core reporting software as having a "ROLAP" or. MicroStrategy Intelligence Server stopped logging statistics. Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. MicroStrategy is a business intelligence (BI), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Create a new dossier, and add data. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. SYMPTOM: The user wants to show different metrics in different colors in a graph in Dossier ACTION:. From the navigation bar on the left, go to Create > Access External Data > Database. For example, the MicroStrategy Tutorial project includes a Month of Year attribute which retrieves its. MicroStrategy. The process described here is for MicroStrategy Analytics Desktop installed on Windows, but the approach is similar when using the MicroStrategy Analytics Platform with Hortonworks on non-Windows platforms (Linux, Solaris, HP-UX, AIX). Download and extract the MicroStrategy installation package from the MicroStrategy download site. Deploy the ojdbc8. On the General tab, from the Data mart database instance drop-down list, select a database instance for the data mart table that will be created. Navigate to the download site and download the Workstation installation files. In the following example, we will create a dashboard showing some common. The following warning message is displayed: Once Intelligence Server has been configured to store the History List cached data in the database, this setting will apply to the entire server definition. The automatic refresh and smart download features allow you to open and explore content both online and offline with instant response times, even for your most complicated dossiers. MicroStrategy Architect provides an intuitive way to explore the MicroStrategy Tutorial schema. Expand the Public Objects folder, then expand the Reports folder. It shows many attributes grouped into separate visualizations. Derived metrics have an option to do subtotal from base. In MicroStrategy Web, log in to the Tutorial project. Platform: Udemy Description: Learn the essentials of MicroStrategy 10 through this step-by-step tutorial. . Helps you to manipulate the database in a single package. In MicroStrategy Developer, choose File > New > Report. Once data flows into the interface, the dashboard will come to life. The MicroStrategy Tutorial Reporting metadata is provided as part of the MicroStrategy Analytics Modules metadata. 8), of which 78 were reported by our customers. Within our MicroStrategy Tutorial project, we will maintain applications and demo’s that showcase a wide range of features and capabilities. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. On the Summary page, review the upgrade choices and click. MicroStrategy Tutorial (Direct) Advance Features 1. As part of this MicroStrategy tutorial you will learn how to get started with MicroStrategy reporting, how to start the MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, components of a report, row and columns, grids and graphs, OLAP services and more. This issue has been identified as a code level issue with MicroStrategy Intelligence Server 10. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. This statement can only be executed in a Windows. In MicroStrategy Developer, choose File > New > Report. To Create a Query Builder Report. Starting with MicroStrategy 2020, Tutorial Project Files for PostgreSQL databases will be provided out of the box. · Tips and tricks on using some not so well know features. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Right-click on Databases > New Database. This document describes how to connect to some databases using JDBC drivers on MicroStrategy Developer, MicroStrategy Web, and MicroStrategy Desktop on Mac/Windows. Introduction MicroStrategy Developer is the business intelligence software component that provides integrated monitoring, reporting, powerful analytics, and. Get the detailed steps on the download preparation, pre-requisite to run the tool. Syllabus- Here is the link. The objects stored in the metadata are reusable. PlatformAnalytics. Click "Next". CONTENTS 1. g. Companies of all sizes use this platform to assess, visualise, and build dashboards. 0. MongoDB is a document-oriented NoSQL database used for high volume data storage. Log into the machine where you are installing MicroStrategy Desktop. For example, in the MicroStrategy Tutorial project, navigate to Shared Reports > MicroStrategy Platform Capabilities > MicroStrategy SDK > Units Sold, Revenue by Category and click. db2 create database SALES. This import bridge imports MicroStrategy logical tables as Dimensions. Get inspiration at the MicroStrategy data dashboard gallery. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. Apply functions act as containers that hand off data from MicroStrategy to your RDBMS. In MicroStrategy Developer, choose File > New > Report. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. Open the workstation-mac-x. The theme of the Tutorial project is a retail store that sells. Click Modify… to edit the Database Connection, as shown below: . In the Source area, select a database instance for the database to access using Freeform SQL. Solution. Visit the Download site now When accessing the new Download site, you are immediately greeted with key components of our latest platform release, along with any updates or additional tooling that is available for the release. In MicroStrategy 9. Data Warehouse Tutorial Summary. 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. Definition. Before you begin, exit all applications which may interfere with the installation process. MicroStrategy’s query and reporting capabilities. Workstation. log from the Command Manager machine. In MicroStrategy Developer, open the Basic Report from the MicroStrategy Tutorial. 8. Like microstrategy has over 300 connectors and power bi has only 100 connectors. This course covers advance topics like Data Marts, Data Lakes, Schemas amongst others. This issue articulate Platform Analytics warehouse database is not update to date and Kafka topic folders are empty in MicroStrategy 2021 Update 2 due to statistics feature flag not enabled at project level. View AllFiles. MicroStrategy is a Business Intelligence(BI) and On-line Analytical Processing (OLAP) software which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files,. After changing the DBC information, an Intelligence Server restart is required. Subscribe to Dossier Learn the essientials of MicroStrategy Architect with this step by step crash course tutorial! In this video I cover lookup tables, fact tables, logical tabl. CONTENTS BookOverviewandAdditionalResources vi 1. Configuration objects include objects such as users, database instances, database login IDs, and schedules. It can Download and Install MicroStrategy Desktop. MicroStrategy. The Tutorial project includes sample data, such as actual customer names and items purchased. Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model. com” and project “microstrategy tutorial" do action updatewarehouse closesessions updateobjectdeletions begin date "10/22/2015 22:00:00 +0000" to "10/25/2015 22:00:00 +0000" frequency weekly on saturday sunday from 02:00:00 to 06:00:00 every 2 hours enabled in enterprise manager. They typically consist of descriptions of dimensions. To Create a Query Builder Report. Click OK and you will see the DB role created with the name of your Data Source. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. We will need the following logs to start the troubleshooting process: cmdmgr. Practice Project - Tutorial Microstrategy - Free download as PDF File (. û ñ5{8:ö‰ d '>• ÷Ÿ‰Oå €’Í’øT>(ÖŒ‰Oå €2ÍžøšMNN}1(Ê. On the Customer Information page, complete the following fields:This tutorial steps through the various capabilities and pages within the Administration portion of a MicroStrategy Project Source. Database Server hosting the Statistics/Enterprise Manager Warehouse database is not running. We empower you with the skills to get the most out of your analytics investment. Under the General tab, go to Database connection > Select the connection > click on ‘Modify’ > In the Database Connections window > Go to the Advanced tab > under Connection Caching > Set ‘connection lifetime’ and the ‘connection idle time out’ to. , through real-world examples and practical executions. In addition, multiple logical tables can represent the same physical table. For Oracle 12. For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. 1. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. The month names do not originally reside in the warehouse tables and the user does not want to manually input the values into the warehouse. Enter the project name as shown below. The image below shows that the projects are of version 8. MicroStrategy - Creating Dashboard. x database using the MicroStrategy ODBC Driver for Greenplum Wire Protocol, MicroStrategy 9. 2 Right-click the MicroStrategy Tutorial project and. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platform 10. To Create a Query Builder Report. The Project Configuration Editor opens. You can use various combinations of tables and columns to support and identify the translated data in your database. This upgrade: Provides resolutions to known security vulnerabilities in older versions of PostgreSQL. Export all of the data from a single dossier to Excel in a matter of seconds. MicroStrategy makes no warranties or commitments concerning the availability of future products or versions that may be planned or under development. 344As part of this MicroStrategy tutorial you becomes learned how to get started with MicroStrategy how, how to start the MicroStrategy Desktop, starting the MicroStrategy Webs, opening a write, components of an report, row and columns, grids and graphs, OLAP services and more. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. MicroStrategy - Environment Setup Download MicroStrategy Desktop. Supercharge your BI & analytics career with training and professional certifications for developers, architects, analysts, administrators, and data scientists. Log on to the machine where you are installing one or more MicroStrategy products. The logical view is also referenced in the SQL that is generated for the report; the whole SQL query is displayed in the place of physical tables, as is. Data Warehouse is a collection of software tool that help analyze large volumes of disparate data. jar file to i-server machine. Using Workstation, developers and administrators can build and administer sophisticated enterprise and mobile analytics applications with a fraction of the effort it has traditionally. The Apply functions also hand off to your RDBMS functions that are specific to your database. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Using this function and given the format in which the column is stored in the MicroStrategy Tutorial (Vmall) warehouse (integer, YYYYMM), the formula will extract the year from the date prompt, multiply it by 100 and add the day number to it, giving it the desired format. project_name is the name of the project, of type string, between double quotes ("). Microstrategy Tutorial. Step 2) Click on Setup. Now log into MicroStrategy Developer and go under Administration tab. Under this database, create two tables product and Inventory. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. x. The data mart table will be stored in this space. Manually fill in the connection information of the Presto JDBC connection string to connect. MySQLUser. In this MicroStrategy course you will learn: · How to connect data to your Dossier environment. Beginning with MicroStrategy 2021 Update 4, you can only install an update using a full platform installer on both Windows and Linux. Create one XQuery database instance for Data Source 2. Step 1) Download MongoDB Community Server. This is the username of an administrator user in the database. Step 3) Turn on archival logging for the SALES database. In the Data Source dialog, select Reports. Database Overview Introduction of Microstrategy 1. The theme of the MicroStrategy Tutorial project is activity in a retail store over a three-year time period. The following table lists folders and files of interest that are included in the default directory structure after an installation of Developer. x, Visual Basic 5. For information on creating a new database connection, see Connecting to the Data Warehouse. Under the General tab, go to Database connection > Select the connection > click on ‘Modify’ > In the Database Connections window > Go to the Advanced tab > under Connection Caching > Set ‘connection lifetime’ and the ‘connection idle time out’ to. In MicroStrategy 9. 0 - 10. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize data. Note: Users can still continue to use File-Based History list. How to Create a New Database Instance Using the MicroStrategy Web SDK 9. This tutorial is designed for all those readers who want to create, read, write, and modify Business Intelligence Reports and dashboards using MicroStrategy Desktop. Without data, the dashboard will not show the user anything. com. About the Tutorial MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. Visit the data visualization and data dashboard galleries for inspiration. Open the MicroStrategy Tutorial project in Developer, go to Schema > MDX Cube Catalog and import an MDX Cube into the project. x, a History List Messages monitor was also introduced for the administrator to track all user's history list messages. It is one of the best free database that falls under the category of a NoSQL database. Zendesk Connector. Extract the downloaded file. Download the Hortonworks Sandbox 2. RedirectingIn the Source area, select a database instance for the database to access using Freeform SQL. Below screen show installation progress. The Basic Report is used as a foundation report to create the more advanced reports used as examples in this section. To be able to use Database Based. g. xxx. JAR files, property files, etc. View changes and push updates to end users in seconds. ePAPER READ . InstallationPrerequisites 6 Networkrequirements 7 Systemhardwarerequirements 10 Systemsoftwarerequirements 15KB45459: How to migrate the MicroStrategy Tutorial Project warehouse from Microsoft Access to Microsoft SQL Server in Micr…. They typically consist of descriptions of dimensions. Aggiornamento di MicroStrategy Desktop. Use MicroStrategy Developer to access the. Schema objects are building block objects; they are. mstr file to a contact, email, another application, or save it on your device. On the Freeform Sources tab, select Create Query Builder report. Like a well-run hospital, or doctor's office there is always initial information that should be collected for different types of problems. Go to Project access, to give Public/Guest basic access to the project. Design workflows, create content groups, or customize application components with the no-code framework. The Select Import Options dialog box opens. MicroStrategy-Tutorial-Documentation . MicroStrategy objects appear in the system layer and are usable across multiple projects. yaml. MicroStrategy courses can be tailored to developers, analysts, and architects, each focusing on different topics tailored to the respective job roles. MicroStrategy Developer provides the project designer functionality essential to creating both schema and application objects necessary to serve the user communities of both MicroStrategy Developer and Web. Have a good. CONTENTS BookOverviewandAdditionalResources vi 1. Open MicroStrategy Web and click New Dossier. Click OK and you will see the DB role created with the name of your Data Source. Select Pick Tables to select single or multiple tables to import data from. Exploring Sample Dossiers in Library. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. A human reader can see from the ApplySimple SQL string that the revenue value will be returned (meaning that the datatype should be Float). To connect to this data source, it is recommended to upgrade the SQL Server driver on MicroStrategy Secure Enterprise 10. 4. Research, develop, and deploy. x to 9. In MicroStrategy Developer, open the Basic Report from the MicroStrategy Tutorial. Description. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. If we were to create a connection mapping in the MicroStrategy Tutorial project according to this example, it would look like the diagram below. It is strongly recommended to create DSN for MicroStrategy ODBC drivers (such as MicroStrategy ODBC Driver for Oracle Wire Protocol) using the MicroStrategy. Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Products AI / BI Platform AI Apps Multi-Cloud Dossier Library Workstation HyperIntelligence Embedded Analytics Innovation Futures Solutions Roles IT Leaders. MicroStrategy Education is committed to the success of every MicroStrategy practitioner, from novice analysts to the most experienced Intelligence Center architects. Using system prompts, users can use. There are Power BI components are 5 main components released in the market. The MicroStrategy Tutorial project has been tested on a warehouse and metadata in Microsoft Access. SYMPTOM: This issue only presents itself using FFSQL and is tied to number rows returned by the query. Right-click on the right-hand side of Desktop, select New, and then select Report. The goal is to derive profitable insights from the data. The Project Configuration Editor opens. From the Categories list, expand Database Instances, and then select SQL Data Warehouses. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. Creating a grid report. 4. Specifying Warehouse Connection Information. Enhancing enterprise analysis with data science. Name the DSN Practice_Tutorial_MD_DSN. REL_. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. As part in this MicroStrategy tutorial yourself will learn how the acquire starting include MicroStrategy reported, how toward start the MicroStrategy Windows, starting which MicroStrategy Web, opening a report, components is an report, row and colums, grids and graphs, OLAP services and more. Open the database instance for the project. On the left, go to History Settings > General. MicroStrategy is a powerful Business Intelligence and Visualization software. x. 4. Right-click the project and select Project Configuration. Method 1 - Via MicroStrategy Developer: To delete the incomplete project through MicroStrategy Developer 9. The HistoryListDSN is the name of the ODBC data source in the Database Connections window. As parts of save MicroStrategy tutorial you will learn how to get started with MicroStrategy reporting, how to start the MicroStrategy Desktop, starting the MicroStrategy Web, opening a report, components of a report, row and columns, lattices and graphs, OLAP ceremonies and more. Introduction to Dossiers. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. The add-in introduces the ability to import and refresh reports and datasets from MicroStrategy into Microsoft Excel. %PDF-1. dmg file. . To ensure the continued security and stability of the MicroStrategy suite, MicroStrategy Repository upgrades PostgreSQL to version 14. The following table lists folders and files of interest that are included in the default directory structure after an installation of MicroStrategy Analytics Modules. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Microstrategy Tutorial. Navigate to the download site and download the Desktop installation files. View the out-of-the-box Platform Analytics Project Dossier>Database Capacity Planning dossier, go to OverviewBefore 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). Developer enables you to model applications using an intuitive, graphical interface. 2. Read LearnSelf-Service Analytics with Amica. 4. Extract the downloaded files. For steps to deploy MicroStrategy Web on specific operating systems or application servers, see the Deploying MicroStrategy Web chapter of the Installation and Configuration Help. If installed over previous versions of the product, the folder remains the same. The following table lists folders and files of interest that are included in the default directory structure after installing Workstation on Windows. Learn more. To resolve this issue, users must execute the steps below: Log into MicroStrategy Desktop as the administrator. Step 2) To Add record, click on ‘New (blank). Some database-specific object definitions may need to be changed if Tutorial is used on another platform. exe file. It gives you the leverage of generating real-time reports and monitoring data. yaml are backed up by this tool. Download operating system-specific drivers for Windows and Linux that allow you to connect to a wide range of data sources. Right-click in the grid and select New to create a new connection mapping. When the request is received, MicroStrategy Web application uses this value to redirect the request to the target associated with this event. For steps, see Starting MicroStrategy Developer. UserID/Password for the statistics database got modified. The report is displayed in Grid View, as shown below. Step 2) Run the following command to create SALES database. · How to install additional visualizations to your profile. The objects stored in the metadata are reusable. Locate the path to the following SQL files part of the Tutorial Project Data download (within a folder titled ' Databases ') from the prerequisites section: -poc_metadata. 7 in 2021 Update 10. License Key: Obtained from MicroStrategy account executive. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. MicroStrategy Workstation is our unified product built to radically simplify enterprise analytics by bringing all key workflows into a single user experience. The same parameter can be viewed by selecting the text "Count" and choosing. It is an open source database which came into light around the mid-2000s. Using system prompts, users can use. x, a History List Messages monitor was also introduced for the administrator to track all user's history list messages. KB288847: How to configure the Express Tutorial Project in a Custom Installation of MicroStrategy Secure Enterprise Platfo…. It shows many attributes grouped into separate visualizations. In addition, multiple logical tables can represent the same physical table. If you select Pig or Web Services, the Import. jar file to i-server machine. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. 4 to version 7. 063 Mobile Architect: Pla nni g, Implementing, and OptimizingClick any of the documents listed on the right side of MicroStrategy Web, to execute it and see the results. Download operating system-specific drivers for Windows and Linux that allow you to connect to a wide range of data sources. Download. A Microstrategy course may cover the following. MicroStrategy comes with a sample project called MicroStrategy Tutorial. The New Grid dialog box opens. Custom Groups 15. In MicroStrategy Desktop, from the File menu, select New, and then select Metric. Click OK. Once installation is completed successfully, below screen will appear. Create a blank dossier or open an existing one. Connecting to Environments in Workstation. location_path is the folder from which the attributes are to be listed, of type string, between double quotes ("). To start the Express installation. The Apply functions also hand off to your RDBMS functions that are specific to your database. A database table used to uniquely identify attribute elements. Download . A solution for this issue is available in current releases. The specific code samples for each of the customization scenarios described in the Web SDK portion of the MSDL are. Instead, MicroStrategy allow one to reverse engineer and rename a logical table. Product Demos. Name your database and click OK. The upgrade database type window appears. From the File menu, select New, and select the type of object to create, such as a report or a filter. PDS file. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Steps to install drivers for your data source are provided in the Installation and Configuration Help. Access your dossiers and HyperIntelligence cards on your desktop through the MicroStrategy Application. This guide provides a description, usage scenarios, and screen shots for all the packaged reports for SFAM. An example is: MicroStrategy TutorialPublic ObjectsReportsMicroStrategy Platform CapabilitiesAd hoc ReportingSortingYearly Sales!i inserts the job priority of the report which is represented as an integer from 0 to 999 (can be used in all Pre/Post statements). The default folder is: C:Program FilesMicroStrategy<Product Name> when installed on a 64-bit Windows environment. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. tutorial”, environment “mstr102. Languages: C#, C, Java, C++, Perl, Scala, Ruby, etc. In this MicroStrategy tutorial you will learn MicroStrategy from the basics to help you learn this top Business Intelligence tool. The following image shows Design Mode displaying a blank report template in MicroStrategy Web. x, right-click on the project and select Delete, as shown in the following image: Method 2 - Via MicroStrategy Command Manager: A command in MicroStrategy Command Manager allows for the deletion of projects from the Command. Here's a Microstrategy tutorial that covers basic reports, Desktop, Web, and. To import data from a specific database, select the corresponding logo (Amazon Redshift, Apache Cassandra, Cloudera Hive, Google BigQuery, Hadoop, etc. In MicroStrategy Developer, choose File > New > Report. Specify the IP address of the SMTP server. A database table used to uniquely identify attribute elements. ), and execute Java programs. Advanced Apps. To log in to a specific project, see Starting MicroStrategy, page 2. MicroStrategy is a business intelligence ( BI ), enterprise reporting, and OLAP (on-line analytical processing) software vendor. Verify whether the option Use network login id (Windows authentication) is selected:The MicroStrategy Tutorial is a MicroStrategy project, which includes a warehouse, and a set of demonstration applications designed to illustrate the platform's rich functionality. Take the following steps: In. This allows end users to share data or view the raw data for further analysis. Starting from 8. From the list of document templates, click Blank Document. MicroStrategy - Environment Setup Download MicroStrategy Desktop. This report calculates the metrics Revenue, Cost, and Profit by the attributes of Region. Visit the Download site now When accessing the new Download site, you are immediately greeted with key components of our latest platform release, along with any updates or additional tooling that. Overview of steps: Section 1: Restoring the . Every MicroStrategy BI application requires at a minimum: 1. A MicroStrategy tutorial can help professionals build the skills to use business intelligence tools effectively. We will install the 64-bit version for Windows. mdb), as shown below: 2. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. For a description of each area or pane of the MicroStrategy Web Report Editor and Design Mode, see MicroStrategy Web Report Editor interface. x. On logging in to MicroStrategy Developer, as a admin we get the Administration option under MicroStrategy. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Published: Apr 27,. 3 or higher4 Units per Call Center Report MicroStrategy TutorialPublic ObjectsReportsJan ReportsUnits per Call Center Above object deletion is successful NOTE: The Dependent objects deletion functionality only applies to application objects (reports, metrics, filters, etc. Metric: M1=Count<Distinct=True, FactID=Cost, UseLookupForAttributes=False> (Customer)Product Demos. a relationship table. SUBCAT_ID SUBCAT_ID,There's a reason we're at the top of the list. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver.