Version 2020

What's New in MicroStrategy 2020

As a new platform release, MicroStrategy 2020 introduces new features that provide better performance and scalability to enhance the overall user experience. In addition, this release introduces new features across the analytics, mobility, and security platform - making it easier for users to build applications faster.

Below are the new features exclusive to MicroStrategy 2020 and its subsequent updates. For a smooth upgrade, be sure to review the important version-specific information regarding changes in the release that could impact functionality and performance. For customers with an upgrade gap of more than one version, the Readme for all intermediate versions can be found in the Learning Center.

All 2020 Updates include the features from the 2020 Platform Release.

Use the buttons below to view what's new in the 2020 updates and platform release.

2020 Update 22020 Update 12020 Platform

2020 Update 2

MicroStrategy

MicroStrategy is the new premiere viewing platform that brings the power of analytics right to the desktop—all at a faster speed. Get the instant response experience with new features unique to the app such as Smart Download and Automatic Refresh that predict and proactively download the content you need both online and offline.

  • Use MicroStrategy on your desktop.
  • Support for Standard, LDAP, Kerberos, and Integrated Authentication.
  • Execute, view, and interact with dossiers and documents.
  • Get the latest content with Smart Download and Automatic Refresh.
  • Automatic and seamless data refresh in the background.
  • Navigate content and stay up-to-date from the main desktop menu.

MicroStrategy HyperIntelligence

HyperIntelligence for Web

  • Share cards as images to boost collaboration.
  • Search for cards directly in the extension.
  • Use pattern matching to identify keyword based on character patterns defined by the card author. This is ideal for HyperIntelligence cards based on datasets with more than 500,000 rows.
  • Support multiple matches on the same keyword within a single dataset, via a carousel.
  • Use HyperIntellignce functions with Google News, Gmail, and MicroStrategy Web.

HyperIntelligence for Mobile

  • Share cards as images on both iOS and Android.
  • Tap and hold on truncated card names and descriptions to view the full content in a tooltip on iOS.
  • Easily access and share logs from the improved usability section of the Account tab on Android.

HyperIntelligence for Office

  • Search for cards directly in the add-in.
  • Use pattern matching to identify keyword based on character patterns defined by the card author. This is ideal for HyperIntelligence cards based on datasets with more than 500,000 rows.

MicroStrategy Workstation

MicroStrategy Desktop

  • Use keyboard shortcuts in free-form layout to move and delete containers, temporarily disable snapping, and select all items from the layers panel in your dossier.
  • Add a ring chart visualization to your dossier with one click from the Visualization Gallery.
  • Smarter data labels that ensure proper display by minimizing overlaps in bubble charts and avoid inconsistent label cut-off commonly seen in bar and line graphs.
  • Improved performance and near real-time experience with smarter refresh for dossiers that only renders visualizations that surface updated data.
  • Copy individual cells from grid visualizations to the clipboard.
  • Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions.
  • Export a dossier when viewed in presentation mode.
  • Hierarchy Reporting: Get the correct value for metrics defined with scope scripts using a new MDX pattern. See KB484318.

MicroStrategy Web

  • Use keyboard shortcuts in free-form layout to move and delete containers, temporarily disable snapping, and select all items from the layers panel in your dossier.
  • Add a ring chart visualization to your dossier with one click from the Visualization Gallery.
  • Smarter data labels that ensure proper display by minimizing overlaps in bubble charts and avoid inconsistent label cut-off commonly seen in bar and line graphs.
  • Improved performance and near real-time experience with smarter refresh for dossiers that only renders visualizations that surface updated data.
  • Copy individual cells from grid visualizations to a Clipboard.
  • Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions.
  • Export a dossier when viewed in presentation mode.
  • Hierarchy Reporting enhancements:
    • Support for live connection dossiers against MDX data sources in the History List.
    • Get the correct value for metrics defined with scope scripts using a new MDX pattern. See KB484318.

MicroStrategy Library

  • Manage the Related Content settings to show, limit, or hide related content.
  • View the dossier name in the title bar.
  • Copy individual cells from grid visualizations to the clipboard.
  • Improved handling of user session without requiring the user to re-authenticate.
  • Export multiple grids into multiple Excel sheets for the current page in Library Web.
  • Improved formatting and usability for export functionality.

MicroStrategy Library Mobile

iOS
  • Improved predictive caching prioritization for dossier bookmarks.
  • Improved design for the On-Demand download of dossier content.
  • Improved accessibility for adding and switching between libraries.
  • Native KPI visualization for improved formatting, performance, and stability.
  • Export multiple grids on a dossier page to Excel tabs.
  • Easily access the data of a dossier visualization in a grid and export it to an Excel, PDF, or CSV file.
  • Support for Multitasking with Split View and drag-and-drop functionality in iPadOS.
  • Disable user access to preferences and advanced settings.
  • Enhanced security and support for security pinning.
Android
  • Support for high-performance caching.
  • Enhanced security and support for security pinning.

Federated Analytics

MicroStrategy for Tableau

MicroStrategy for RStudio

  • Produce the R code for importing and exporting datasets.

MicroStrategy packages for R and Python (mstrio, mstrio-py)

  • Improved data loading performance.

MicroStrategy for Office

  • Duplicate imported reports, datasets, and visualizations.
  • Select multiple imported data to delete or refresh.
  • Track the progress of data import and refresh indicated in the task pane.
  • Notifications appear in the task pane.
  • Sort attributes, metrics, and filters by name when preparing data.
  • Customize the add-in labels prior to generating the add-in file via MicroStrategy Workstation.
  • Improved data import performance.

MicroStrategy Intelligence Server

  • New automatic server governing and prioritization improvements, which has a new Linux requirement.

  • Improved performance of many-to-many time transformations for Google BigQuery. See KB484238.

  • Improved Intelligence Server stability and Memory Management through unified Cartesian Join governing. See KB484141.

  • Optimized SQL for performance gains of up to 30% with many-to-many transformations in Google BigQuery. See KB484238.
  • Extended automated crash reporting for Intelligence Server child processes.
  • Intelligence server supports the new HTTP/2-based APNs API to send remote notification requests to Apple devices. The legacy protocol is no longer supported starting in November 2020.

Platform Analytics

  • Improved performance and reduced memory footprint of Platform Analytics Cube.*
  • Improvements to the out-of-the-box dossiers in the Platform Analytics project.*
  • Improved stability of Telemetry Server components on Windows.

*Both the Platform Analytics project and repository must be upgraded to take advantage of these changes.

MicroStrategy Collaboration Server

  • Improved performance and stability for environment handling.

MicroStrategy Integrity Manager

  • Automated validation of dossiers and documents using specific personal prompt answers. See KB484332.

MicroStrategy Mobile

  • Enhanced security in both iOS and Android.

  • Improved usability for filtering functionalities on Android.
  • Enhanced Grid Viewer to provide better support for the Fit to Container mode on iOS.

MicroStrategy Library Mobile SDK

Android

iOS

MicroStrategy Mobile SDK

Android

  • Automatically save photos, taken using the Photo Uploader widget, to the mobile device's photo gallery.

  • The Mobile SDK for Android is certified to work with Android 10 (API level 29)

iOS

MicroStrategy Embedding SDK

Identity SDK

Lock a user's account after several failed login attempts with invalid credentials sent by a partner for validation.

MicroStrategy REST APIs

MicroStrategy Cloud Platform

Amazon Web Services (AWS)

  • Deploy environments with only private IPs: New security enhancement that gives users to option to deploy environments that are not accessible over the internet. Connectivity must be done through a VPN.
  • Enterprise deployment availability: Available in Central Canada region.
  • New Region: Environments can be deployed into the Bahrain AWS region.
  • Deploy using a custom AWS Machine Image (AMI): New security feature to help conform to common enterprise cloud security and management requirements. Customers can deploy environments that use an AMI that they have certified and hardened internally. Often referred to as a golden image, this is a common request from enterprise cloud security teams.
  • Use Expert.now to connect live to a cloud expert over a video chat and get live support for any MicroStrategy Cloud issues, directly from the MicroStrategy Cloud Console.

Azure

  • Deploy environments with only private IPs: New security enhancement that gives users to option to deploy environments that are not accessible over the internet. Connectivity must be done through a VPN.
  • Deploy using a custom Azure Virtual Machine Image (VMI): New security feature to help conform to common enterprise cloud security and management requirements. Customers can deploy environments that use a VMI that they have certified and hardened internally. Often referred to as a golden image, this is a common request from enterprise cloud security teams.
  • New Region: Environments can be deployed into the South Africa North region and into the Japan East region.
  • Enterprise deployment availability: Available in Central Canada and Asia Southeast Azure regions.
  • Use Expert.now to connect live to a cloud expert over a video chat and get live support for any MicroStrategy Cloud issues, directly from the MicroStrategy Cloud Console.

Data Sources

See Platform Certifications for information on the latest supported and certified configurations.

  • MicroStrategy 2020 Update 2 ships the latest ODBC connectors for the following data sources:

    • Microsoft SQL Server
    • IBM Db2
    • Amazon Redshift
    • Oracle
    • MongoDB

  • MicroStrategy 2020 Update 2 ships the latest JDBC connectors for the following data sources:

    • Microsoft SQL Server
    • IBM Db2
    • Amazon Redshift
    • Oracle
    • MongoDB
  • MicroStrategy 2020 Update 2 ships the latest JDBC drivers for Hive.
  • MicroStrategy 2020 Update 2 ships the ODBC driver for Snowflake with MicroStrategy installation.
  • Teradata drivers are bundled out-of-the-box with MicroStrategy installation.
  • Configuration is supported via the Connectivity Wizard for the following gateways:
    • Google BigQuery
    • Hive
    • Impala
    • Spark SQL
    • Snowflake
  • Seamless authentication for JDBC and ODBC Snowflake and BigQuery drivers leveraging OAuth workflow.
  • Support for single sign-on (SSO) authentication with OAuth authentication for Snowflake.
  • Use localized and keyword based table and column naming conventions with BigQuery, Impala, SparkSQL, and Snowflake.
  • Support for table browsing by datasets and projects via the Data Import Catalog dialog with Google Big Query JDBC connector.
  • TLS configuration is supported for all gateways that MicroStrategy ships out-of-the-box in the Connectivity Wizard.

  • Performance improvements for Snowflake. The default intermediate table type has been changed to Derived Table. This allows the delivery of up to three times the amount of throughput and reduces report run times by up to 70%.

  • New SAP S/4HANA Data Gateway.
  • IBM Db2 11.5 is certified.
  • IBM Integrated Analytics System 1.0 is certified.
  • Yellowbrick 4.0 is certified.
  • CData Odata ODBC Driver is certified.

MicroStrategy Diagnostics and Performance Logging Tool

Fourteen new performance counters, as well as one existing counter, have been added to the MicroStrategy Server Jobs section of the Diagnostics and Performance Logging Tool.

  • Maximum Document Cache Delete Time (ms)
  • Total Document Cache Delete Time (ms)
  • Number of Document Cache Deletes
  • Maximum Document Cache Lookup Time (ms)
  • Total Document Cache Lookup Time (ms)
  • Number of Document Cache Lookups
  • Maximum Document Cache Update Time (ms)
  • Total Document Cache Update Time (ms)
  • Number of Document Cache Updates
  • Maximum Document Cache Swap Time (ms)
  • Total Document Cache Swap Time (ms)
  • Number of Document Cache Swaps (This is an existing counter)
  • Maximum Document Cache Load Time (ms)
  • Total Document Cache Load Time (ms)
  • Number of Document Cache Loads

2020 Update 1

Security

  • Chrome Web Browser version 80 and above introduces new changes which may impact embedding. For more information, see KB484005: Chrome v80 Cookie Behavior and the Impact on MicroStrategy Deployments.
  • The new URL Scanner tool allows you to scan MicroStrategy metadatas (10.4.x and higher) for URLs accessed by the Intelligence Server when exporting reports, documents, and dossiers to PDF or Excel. This tool can be used to whitelist only those safe URLs to protect against Server Side Request Forgery attacks. For more information, click here.
  • MicroStrategy Library upgraded its HTTP client to OkHttp 3.14.8. This may impact customers upgrading from MicroStrategy 2019. For more information, see KB484336: Upgrading your TLS certificate in MicroStrategy 2020.

MicroStrategy HyperIntelligence

HyperIntelligence for Web

  • Seamlessly re-authenticate without credentials when using a Single Sign-On mechanism like SAML.
  • Administrators can use whitelisting to only allow users to view cards on specified websites.
  • Auto-refresh displays the latest cards available in your environment and ensures new data published to your cube is immediately used to find card matches.

HyperIntelligence for Mobile

  • Use the QR code and barcode scanner to view cards on both iOS and Android.
  • Improved download speed of card data on iOS.

HyperIntelligence for Office

  • Support for Kerberos and Trusted authentication.

Federated Analytics

MicroStrategy for Power BI

  • Available out-of-the-box with the Power BI Desktop release.
  • Support for SAML and Badge authentication.
  • Ability to import data from a report with closed prompts or default prompt values.

MicroStrategy for Tableau

  • Support for LDAP and Standard authentication.
  • Generate log information for troubleshooting.

MicroStrategy for Jupyter

  • Enhanced ability to import large datasets.
  • Ability to update in-memory cubes using data frames from your Jupyter Notebook environment.

MicroStrategy for RStudio

  • Enhanced ability to import large datasets.
  • Ability to update in-memory cubes using data frames from your RStudio environment.

MicroStrategy packages for R and Python (mstrio, mstrio-py)

  • Certified with Python 3.8.

MicroStrategy for Office

  • Import and refresh data from dossier visualizations in Excel.
  • Browse for dossiers in your Library and environment.
  • View the object type, ID, date created, location, and description of data sources.
  • Import attribute forms in reports to separate grid columns.
  • Remove subtotals and totals when importing report data.

MicroStrategy Workstation

  • Support for Trusted authentication with special configurations.

  • Dossier authoring enhancements, including:

    • New context menu options to move, copy, or duplicate images, text boxes, and HTML containers. You can access these context menu options from each container, as well as the Layers panel, which makes it easier to move, copy, or duplicate containers in free-form layout.
    • When using free-form layout, you can choose targets for element/value filters and attribute/metric selectors in the Layers panel. In addition, you can choose the attribute or metric for replacement in an attribute/metric selector.
  • Updated default values for cache governing settings.

  • The following application governing settings are being retired. The settings will remain available, but will not take effect if the value is set below the default value. See, Server-Side Behavior Changes for Cache Settings for more information.

    Setting NameDefault Value

    Dataset - Maximum Number of Caches

    		100000

    Formatted Documents - Maximum Number of Caches

    		100000

    Maximum number of cubes

    		100000

MicroStrategy Web

  • 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. If you are leveraging Web ASP, see KB484127 to use this feature.
  • Dossier authoring enhancements, including:
    • New context menu options to move, copy, or duplicate images, text boxes, and HTML containers. You can access these context menu options from each container, as well as the Layers panel, which makes it easier to move, copy, or duplicate containers in free-form layout.
    • When using free-form layout, you can choose targets for element/value filters and attribute/metric selectors in the Layers panel. In addition, you can choose the attribute or metric for replacement in an attribute/metric selector.

MicroStrategy Desktop

  • New context menu options to move, copy, or duplicate images, text boxes, and HTML containers. You can access these context menu options from each container, as well as the Layers panel, which makes it easier to move, copy, or duplicate containers in free-form layout.
  • When using free-form layout, you can choose targets for element/value filters and attribute/metric selectors in the Layers panel. In addition, you can choose the attribute or metric for replacement in an attribute/metric selector.

MicroStrategy Intelligence Server

  • Improved cube index memory management and governing using the "Maximum % growth of an Intelligent Cube due to indexes" project configuration setting.

  • The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. While still exposed, the settings will not take effect if set below the default value for the setting. See, Server-Side Behavior Changes for Cache Settings for more information.

    Setting NameDefault Value

    Dataset - Maximum Number of Caches

    		100000

    Formatted Documents - Maximum Number of Caches

    		100000

    Maximum number of cubes

    		100000

Platform Analytics

MicroStrategy Mobile

iOS

  • Certification of native integrations with Airwatch, MobileIron, and BlackBerry Dynamics and AppConfig compliance.

  • Enable the option to automatically zoom to your current location on a map visualization in documents. For more information, click here.

Android

  • Certification of native integration with Airwatch and AppConfig compliance.

  • Enable the option to automatically zoom to your current location on a map visualization in documents. For more information, click here.

MicroStrategy Library

  • Use the Refresh View Automatically setting to seamlessly refresh a dossier on Library Mobile for iOS. Learn more about the setting here.
  • Use the Smart Download setting to enable predictive Library caching to improve dossier opening response time on Library Mobile for iOS. Learn more about the setting here.

  • Enable the option to automatically zoom to your current location on a map visualization in documents. For more information, click here.

  • Simplified exporting options in the Export to PDF dialog.
  • Export a grid to Excel using the main Share menu.

MicroStrategy Mobile SDK

Android

iOS

  • Use the URL API to deep link to third-party applications installed on the same device.
  • When you customize MicroStrategy Mobile for iOS, you must have an Apple Mac, running Xcode® 11.1 with the Apple iOS SDK 13.1, to develop and compile your application.

MicroStrategy Library Mobile SDK

iOS

When you customize Library Mobile for iOS, you must have an Apple Mac, running Xcode® 11.1 with the Apple iOS SDK 13.1, to develop and compile your application.

Identity SDK

Identity Server provides a way to create custom client error messages in any language.

MicroStrategy REST APIs

  • Manage server-level privileges
  • Control the presence of subtotals in report data when consumed using REST.
  • Generate report and cube instances asynchronously.

MicroStrategy Intelligence Server

The following project governing settings are being retired beginning with MicroStrategy 2020 Update 1. While still exposed, the settings will not take effect if set below the default value for the setting.

Setting NameDefault Value

Dataset - Maximum Number of Caches

100000

Formatted Documents - Maximum Number of Caches

100000

Maximum number of cubes

100000

MicroStrategy Identity

You can add a third-party service to your Identity Server installation.

MicroStrategy Cloud Platform

Amazon Web Services (AWS)

  • Improved security of default MicroStrategy on AWS deployments by integrating Center for Internet Security (CIS) baselines directly into MicroStrategy Templates.
  • Improvements to MicroStrategy Backup for AWS:
    • Ability to run on RHEL7 and Amazon Linux 2 and RHEL6.
    • Ability to back up additional warehouses.
    • Support for unique database users.
    • Improved log information.
    • Time stamps on the Summary page indicating how long each component took to back up.

Azure

  • Use MicroStrategy Backup to back up your essential MicroStrategy configurations, databases, and files on to the MicroStrategy Cloud Platform for Azure.
  • Deploy your environment using Azure Shared Image Gallery to improve deployment stability.
  • Use Azure Service Principal to specify whether MicroStrategy Cloud Platform has access to a subscription or resource group.

Data Sources

  • Full assessment testing on SAP HANA 2.0.
  • IBM Performance Server for PostgreSQL 11.0 is certified.
  • Use flexible keyword based object naming conventions with Cloudera and Hortonworks Hive Gateways.

See Platform Certifications for information on the latest supported and certified configurations.

2020 Platform Release

Security

MicroStrategy Repository

To help reduce deployment complexity MicroStrategy now includes an embedded repository that can support the following MicroStrategy products:

  • Metadata Repository
  • Collaboration Server
  • Platform Analytics

The infrastructure is installed and ready for use should this be the right fit for your deployment. This embedded repository is automatically configured, optimized, and managed for you with no manual intervention required for routine usage. Learn more about MicroStrategy Repository.

MicroStrategy Workstation

MicroStrategy Web

MicroStrategy Desktop

MicroStrategy HyperIntelligence

HyperIntelligence represents an entirely new class of applications where answers find you. These applications inject insights directly into a user’s existing workflows and transform familiar interfaces into intelligence tools—making every person, application, and device across the enterprise more intelligent.

  • Create cards with the new flexible design editor that allows you to change card header styles and add new widgets. For more information, see Create Cards.
  • New templates that support images and ring widgets for creating Persona-based cards such as Employee, Contact, and Profile cards.
  • Ability to add Contextual Links and email address links to cards.
  • View card usage activity.

HyperIntelligence for Web

HyperIntelligence for Web allows you to consume card data from your Google Chrome browser.

  • Cards can now be rendered on YouTube and LinkedIn.
  • Support for viewing cards on Microsoft Edge (Beta version).
  • Increased data volume to support up to 500,000 keywords.
  • Support for SAML authentication.
  • Support for trusted authentication.
  • Support for Kerberos authentication.
  • Improved card matching with a new carousel interface that allows for the discovery and display of multiple cards matching a keyword.
  • Ability to export log files for troubleshooting.

HyperIntelligence for Mobile

HyperIntelligence for Mobile is a universal iOS application and Android application that allows users to leverage contextual analytics whenever and wherever they need.

  • Calendar integration on both iOS and Android.
  • Search for cards directly in the app.
  • See the history of viewed cards from your in-app search results or from your calendar push notifications on the app home page.
  • Optimized performance of the Calendar tab.

HyperIntelligence for Office

HyperIntelligence for Office allows you to view cards in Microsoft Outlook.

  • Export the HyperIntelligence for Office manifest file from Workstation.
  • View and filter cards on Microsoft Outlook for Desktop for macOS or Windows OS or Office 365.
  • Ability to export HyperIntelligence for Office log files.

MicroStrategy Library

  • Improved PDF Export:
    • Improved, smarter defaults for PDF export to reduce redundancy and prevent data loss.
    • Ability to export the current page of a dossier to PDF.
    • Ability to fit grid content to the width of one page when exporting to PDF.
    • Ability to cancel PDF export requests to continue performing manipulations in Web.
    • Links to files and pages are still fully functional when exporting a dossier to PDF.
    • Enhanced pagination support for the KPI widget and custom visualizations.
  • In Library Mobile for iOS, you can search for hierarchical attribute elements across all levels.
  • Offline support for MicroStrategy Library on Android devices.
  • New dossier authoring features can be viewed in MicroStrategy Library.
  • Integration of PostgreSQL with the Collaboration Server.
  • Hierarchy Reporting enhancements:

MicroStrategy Mobile SDK

Android

The Mobile SDK for Android is certified to work with Android 9 Pie (API level 28).

iOS

When you customize MicroStrategy Mobile for iOS, you must have an Apple Mac, running Xcode® 11.1 with the Apple iOS SDK 13.1, to develop and compile your application.

MicroStrategy Library Mobile SDK

Android

The Library Mobile SDK for Android is certified to work with Android 9 Pie (API level 28).

iOS

When you customize Library Mobile for iOS, you must have an Apple Mac, running Xcode® 11.1 with the Apple iOS SDK 13.1, to develop and compile your application.

Platform Analytics

  • PostgreSQL is now supported as a Platform Analytics repository.
  • The Platform Analytics project and repository can be upgraded via the Configuration Wizard.
  • New out-of-the-box dossier to analyze and optimize job performance.
  • The Platform Analytics custom installer now accepts encrypted passwords.
  • The Intelligence Server can resend failed statistics messages to the Kafka server when the connection between the two servers is re-established.
  • The Configuration Wizard now supports interactive mode for creating the Platform Analytics project.

  • Enhanced tracking capabilities, including:

    • Canceled jobs.
    • Certified objects.
    • New metrics for jobs, prompts, intelligent cubes, and server processing time.
    • Intelligent Cube memory usage for each node in a clustered environment.

    • The change journal logs now process the type, version, and name for databases configured in an environment.

    • Object version changes for Subscription objects are now included in the change journal logs.

  • Ability to capture information on who made changes to schema and application objects on a particular date.
  • Enhanced installation logs that allow you to verify the initial load of object telemetry.
  • Improved health checks for Redis, Kafka, and MySQL components.
  • Ability to trigger a data clean-up of the Platform Analytics warehouse.
  • The Platform Analytics project schema has been updated to allow for data blending between Compliance Telemetry and Statistics data.

Federated Analytics

MicroStrategy for RStudio

  • Supported in MicroStrategy version 2019 Update 4 or later.

  • Ability to browse, filter, search, and import data from cubes and reports in RStudio.

  • Export data frames from RStudio to MicroStrategy in-memory cubes.

  • All MicroStrategy security settings are respected when interacting with MicroStrategy objects.

  • Support for Standard and LDAP authentication.

  • Certified to work with RStudio Desktop 1.2 and R 3.4.

MicroStrategy for Jupyter

  • Supported in MicroStrategy version 2019 Update 4 or later.

  • Ability to browse, filter, search, and import data from cubes and reports into Jupyter Notebook.

  • Export data frames from Jupyter Notebook to MicroStrategy in-memory cubes.

  • All MicroStrategy security settings are respected when interacting with MicroStrategy objects.

  • Support for Standard and LDAP authentication.

  • Certified to work with Jupyter Notebook 5.7 and Python 3.6.

MicroStrategy for Tableau

  • Ability to import datasets with four million rows and 30+ columns using the Tableau connector.

  • Ability to import prompted reports from MicroStrategy to Tableau.

  • Increased data import speed using the Tableau connector.

  • Streamlined experience of browsing, connecting, and importing MicroStrategy data.

MicroStrategy for Power BI

  • Ability to import datasets with four million rows and 30+ columns using the Power BI connector.

  • Increased data import speed using the PowerBI connector.

MicroStrategy for Qlik

  • Ability to import datasets with two million rows and 10+ columns using the Qlik connector.

  • Increased data import speed using the Qlik connector.

MicroStrategy for Office

  • Fast deployment on Windows and Mac clients and the Office 365 cloud.

  • Leverage MicroStrategy Library authentication.

  • Import reports or datasets from MicroStrategy to Excel.

  • Filter data before importing to Excel.

  • Refresh all imported datasets and reports without losing the formatting applied in Excel.

  • Support for prompted reports.

  • Support for reports with subtotals and totals.

  • Support for cross-tab reports.

  • Selecting an imported object highlights the data in the Excel workbook.

  • Ability to rename imported objects in Excel.

  • Ability to edit data already imported to the workbook.

  • Ability to re-prompt a report to the same workbook.

  • Faceted search for file type, owner, and date modified.

  • Ability to clear data from the workbook to control user access.

  • Improved data loading performance.

Data Sources

See Platform Certifications for information on the latest supported and certified configurations.

  • MicroStrategy ODBC Driver for PostgreSQL Wire Protocol for Windows and Linux is the new default driver used when creating a database instance with PostgreSQL.
  • MicroStrategy 2020 ships the latest ODBC connectors for the following data sources:
    • Cassandra
    • Microsoft SQL Server
  • MicroStrategy 2020 ships the latest JDBC connectors for the following data sources:
    • Microsoft SQL Server
    • Oracle
  • Optimization for Google Big Query:
    • Support for Implicit Table creation patterns with the ability to specify column headers.
    • Ability to import a dataset using the Google bulk-data API.
  • Oracle 19c is now supported.

MicroStrategy Intelligence Server

MicroStrategy Cloud Platform

Amazon Web Services (AWS)

  • Ability to deploy EC2 X1 instances, a high RAM AWS instance class that scales up to 2TB RAM.
  • As of 2020, AWS instances will utilize a Postgres database as a unified repository for Platform Analytics, Metadata, and Collaboration. MicroStrategy Backup can be used to migrate metadata, the Platform Analytics warehouse, Collaboration Store, and History List from MySQL to PostgreSQL.

Azure

  • Automation API's to manage MicroStrategy on Azure environments. Performing Cloud Console operations via API enables organizations to:

    • Automate the deployment and management of environments.

    • Integrate the cloud console into management and automation frameworks.

  • As of 2020, Azure instances will utilize a Postgres database as a unified repository for Platform Analytics, Metadata, and Collaboration. MicroStrategy Backup can be used to migrate metadata, the Platform Analytics warehouse, and Collaboration Store from MySQL to PostgreSQL.

MicroStrategy Tools

  • Configuration Wizard now provides the option to keep, change, or disable statistics when configuring the Intelligence Server.
  • As of MicroStrategy 2020, Project Mover is no longer supported.

MicroStrategy Mobile

iOS

  • Dynamic filtering and search support for Hierarchical data sources using the recursive attribute.

  • Users can now view and interact with prompted and linked dossiers.
  • Mobile SDK certification with Airwatch for iOS 13.
  • Mobile SDK certification with MobileIron for iOS 13.
  • Mobile SDK certification with Blackberry for iOS 13.

Android

  • Users can now view and interact with prompted and linked dossiers.
  • Instant scanning and answering of prompts on a document screen via Zebra IR bar code scanner.

Custom Visualization SDK

MicroStrategy REST APIs

MicroStrategy Identity

  • The MicroStrategy Identity Generic Database Agent (formerly called the Usher JDBC Agent) supports the synching of data from various databases, such as MySQL, Oracle, and MicrosoftSQL, with the Identity Server.

MicroStrategy R and R Package Installer

The MicroStrategy R and R Package installer is a standalone component to simplify the installation and configuration of R and the packages needed to use R in conjunction with MicroStrategy. You can download the R and R Package installer from the MicroStrategy download site for either Windows or Linux.