What's New in MicroStrategy ONE

MicroStrategy ONE 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 platforms—making it easier for users to build applications faster.

Below are the new features exclusive to MicroStrategy ONE 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 Product Documentation.

Preview features are early versions of features and are not to be used in a production environment as the core behavior remain subject to change between preview and GA. By selecting to expose preview features in MicroStrategy Workstation, you can access these features and use them as you would any other dashboard functionality. The official versions of preview features are included in subsequent releases. Any preview features on this page are marked with Preview Feature.

You must perform a metadata update when upgrading from a pre-2021 release to MicroStrategy ONE or MicroStrategy 2021.

Use the buttons below to view what's new in the MicroStrategy ONE and MicroStrategy 2021 monthly and platform releases. All MicroStrategy ONE and MicroStrategy 2021 updates include the features from the 2021 Platform Release.

Features that are supported in MicroStrategy Cloud environments are marked with a cloud icon.

MicroStrategy ONE (October 2024)

MicroStrategy Cloud Platform

Add support for GCP deployments in Los Angles and Tokyo regions.

MicroStrategy ONE (September 2024)

MicroStrategy Library

MicroStrategy AI

• Bots, Auto Answers, and Auto Dashboard have been upgraded from GPT-3.5 and GPT-4 usage to GPT-4o. By taking advantage of faster speed of GPT4o together our internal optimization of performance, MicroStrategy's platform is now two times faster than MicroStrategy ONE (June 2024).

• Deliver natural language summaries of dashboard pages or specific visualizations using auto narratives. Tailor the narrative format, highlight key trends with customizable color-coding, and dynamically update insights based on user interactions and filter conditions.

• Define custom instructions in the dashboard editor for Auto Answers responses.

• Bots and Auto Answers recognize and answer open-ended business questions.

• Bots, Auto Answers, and Auto Dashboard responses provide more descriptive statistics.

• Leverage advanced mode for more in-depth data preparation, enabling you to review, correct, and manipulate datasets with greater precision.

• Support for multiple datasets in Bots as well as support for report objects as a valid dataset format.

• Download learnings created or used inside Bots or Auto Answers in a .csv file format.

• Manually create AI indexes and view a new Partially indexed status in the dataset.

• The custom instruction character limit increased to 2500 characters.

Dashboards

• Improved the Library Home page filter panel for simplified object browsing, improved the filter panel organization to ensure consistency with the Library search results page, and other Library Home page updates.

• Get to your data faster using a bookmark with pre-selected filters, prompt answers, or other manipulations from the Library Home page.

• Configure PDF export options at the dashboard level.

• Create contextual links in visualizations and images or text to a dashboard in a different project while maintaining filter selections.

• Import SharePoint lists and SharePoint/OneDrive files such as CSV, Excel, and JSON.

MicroStrategy Workstation

MicroStrategy AI

Deliver natural language summaries of dashboard pages or specific visualizations using auto narratives. Tailor the narrative format, highlight key trends with customizable color-coding, and dynamically update insights based on user interactions and filter conditions.

Dashboards

• Configure PDF export options at the dashboard level.

• Configure and add action buttons to a modern grid to trigger actions defined in an associated Python script.

• Create contextual links in visualizations and images or text to a dashboard in a different project while maintaining filter selections.

• Import SharePoint lists and SharePoint/OneDrive files such as CSV, Excel, and JSON.

Administration

• Retrieve database credentials from a secret vault system, such as CyberArk, by creating, editing, and deleting vault connections. Create database logins based on the vault secret.

• Multiple OIDC and SAML configurations are supported. This support allows different applications to utilize SAML with various identity providers (IDPs) or OIDC with different identity access management systems (IAMs).

• Manage ACLs for user group child objects.

• A new Enable Dynamic Working Set Limit server-level setting that allows the Intelligence server to automatically increase or decrease the working set limit based on user settings and available resources in the system.

• A new Unload cube caches not used for (minutes) server-level setting that allows a user to release the cube cache from memory if it's not accessed by the specified amount of time.

• New Show delivery address for subscription results for Administrator and Show delivery address for subscription results for Owner project-level settings that allow administrators or subscription owners to view the plain email address. The delivery address is hidden by default for security purposes.

• Two new object types are supported for migration packages: Scripts for object packages and Runtime for administration packages.

• Enhanced timezones to consider a user’s preferred timezone when resolving dynamic dates or datetimes in filters or value prompts.

• History list enhancements:

  • Mark history list messages as read or unread.

  • A new Delete History button that lets users purge all currently filtered messages.

  • New Source and Content ID columns and a reordering of existing columns.

  • Tooltips appear when cell content is too long.

  • Updated differentiation between dashboards, documents, reports, OLAP cubes, and MTDI cubes, along with their respective icons.

• Create multiple connections to one environment, rename an environment, and create a new project while connecting to an environment.

• Change the Library Home page display name.

• Application and content group enhancements:

  • New Location and Version columns.

  • Access create content groups and applications dialog from the Navigation pane.

  • Unified right-click menu.

• Caches monitor enhancements:

  • Expanded filter options and improved search functionality.

  • Perform a single cube refresh for OLAP and MTDI cubes.

  • A new Send to History List option in datasets.

• Updated change journal columns and filters.

• Added change journal to the following properties dialogs:

  • Monitor > Triggers > Schedules > Properties

  • Monitor > Triggers > Events > Properties

  • Environment properties > Subscription properties > Delivery Type

  • Environment properties > Subscription properties > Delivery Device

• Added change journal to the following right-click menus:

  All Users, Applications, Bots, Cards, Content Groups, Dashboards, Data Sources, Datasets, Documents, Objects, Planned Tasks, Reports, Scripts, Subscriptions, and User Groups.

• Integrate OIDC support with Google.

MicroStrategy Library Mobile

iOS

• Support for iOS 18.

• Dashboards use the default PDF export options set at the dashboard level in Library or Workstation.

• Create links in visualizations and images or text to a dashboard in a different project while maintaining filter selections.

Android

• Dashboards use the default PDF export options set at the dashboard level in Library or Workstation.

• Create links in visualizations and images or text to a dashboard in a different project while maintaining filter selections.

MicroStrategy Mobile

iOS

Support for iOS 18.

Federated Analytics

MicroStrategy for Tableau

Support for Tableau Web Data Connector 3.0.

MicroStrategy for Office

Excel Add-in

• Automatically refresh Excel workbooks.

• Reuse prompt answers for imported objects without additional confirmation.

• Import all or select chapters and pages of a dashboard.

• Overwrite data in an existing cell.

• Updated import settings.

PowerPoint Add-in

• Automatically refresh PowerPoint presentations.

• Reuse prompt answers for imported objects without additional confirmation.

• Import all or select chapters and pages of a dashboard.

Teams App

Interact with Bots in private messages, group chats, and Teams channels.

Platform Analytics

• Gain visibility into the adoption and performance of auto narratives across your dashboards with auto narratives insights. Track usage metrics, execution success rates, and detailed user interactions to ensure optimal narrative performance and uncover opportunities for improvement.

• Auto learning insights enables administrators to access, review, and download user-generated learnings from across the environment. This powerful tool enables the identification and promotion of valuable insights as knowledge assets, extending their benefits to entire teams or the entire organization.

• Enable more performant time-series analysis. Evaluate adoption or usage month over month, quarter over quarter, or year over year, without waiting hours for a report to aggregate the transactional data.

• Enhanced the Status attribute in the Platform Analytics Project.

• Added a Job Canceler attribute that displays the MicroStrategy User who cancels a job.

MicroStrategy Library Mobile SDK

iOS

Hide the back button on the navigation bar so users can navigate through dashboards using customized links that you place on the screen.

MicroStrategy Packages for Python (mstrio-py)

A new mstrio.object_management.migration subpackage was added as an official release. This subpackage replaces the old module for object migrations introduced in 2021 Update 5 as a Preview Feature and is a breaking change.

• Added list_migrations method, list_migration_possible_content method, and Migration class to mstrio.object_management.migration.migration subpackage to allow management of migrations

• Added PackageConfig, PackageContentInfo, PackageType, PackageSettings, PackageStatus, and more classes to mstrio.object_management.migration.package subpackage to allow management of migration packages.

• Added the list_bots method and Bot class in the mstrio.project_objects.bots subpackage to allow management of Bots

• Added the list_content_groups method and ContentGroup class in the mstrio.project_objects.content_group subpackage to allow management of content groups.

• Added the list_applications method and Application class in the mstrio.project_objects.applications subpackage to allow management of applications.

• Added the StorageService class for the Storage service configuration of an environment.

• Added the storage_service property, fetch_storage_service, and update_storage_service methods to the Environment class to manage the environment's Storage service configuration.

• This is the official release of the Migration class and its methods, which introduces some breaking changes compared to the "Preview" state.

• Added the last_update_time property to Cube based classes.

Intelligence Server

• Improve server stability and prevent memory outages by swapping the least recently used server messages to disk in low memory scenarios.

• Improvements in memory management may require additional disk space for situations where the client session timeout is more than two hours. The default client session timeout setting and lower values are not affected.

• An opt-in enhancement to the ALTER USER Command Manager script is available. See KB486957 for more information.

Data Sources

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

• Create connections and run analytics with optimized SQL against Microsoft Fabric Warehouse.

  • Support OIDC single-sign-on and and Service Principal authentication using Entra ID.

  • Create connections with out-of-the-box Microsoft JDBC for SQL Server driver.

• Create Redshift data connections using the native Amazon Redshift JDBC driver, in addition to the MicroStrategy-branded drivers.

• Create SAP HANA data connections using the native SAP HANA JDBC driver.

• Support for Google BigQuery Single Sign-On Using Google.

• Certified gateway versions

  • IBM Db2 for z/OS 13

• Out-of-the-box driver updates

  Ensure security and reliability by supporting OpenSSL 3.x and other security updates for the following drivers:

  • Windows Driver Manager Files

  • Hive ODBC driver

  • IBM Db2 ODBC driver

  • Spark JDBC driver

  • Hive JDBC driver

  • Impala JDBC driver

MicroStrategy ONE (June 2024)

MicroStrategy is upgrading to Tomcat 10.1.x and JBoss 8 along with Spring 6. See 2024 Platform Certification Changes for more information.

MicroStrategy Library

MicroStrategy AI

• Enhanced Auto AI Visualizations: Dynamically select diverse visualization types based on contextual analysis, prioritizing user demand, keywords, and data components for streamlined decision-making.

• Auto Answers and Bots now support Bubble Charts, Horizontal Bar Charts, Vertical Clustered Bar Charts, and Insights+ Line Charts with Break By. This support enables users to visualize complex data relationships, rankings, comparisons, and trends more effectively.

• Cognitive Element Search enhances MicroStrategy AI accuracy using advanced index and semantic search capabilities to intelligently interpret user queries that contain element names, or element names with spelling mistakes, abbreviations, or synonyms. Business users can use this support for a wide range of query complexities and benefit from more meaningful and engaging chat-based analytic experiences.

• Empower Auto to learn and personalize responses. Auto adapts based on user feedback and clarifications, storing what it learns at an individual user level. This personalized learning improves future interactions and ensure that responses align with each user's preferences.

  • Improve Auto responses with feedback. Users can give feedback with thumbs-down and comments, and administrators can monitor performance and user interactions through the Auto Adoption Dashboard.

  • Improve the user experience with Smart Suggestions. When Auto detects an ambiguous query, it provides a default answer and suggests alternative options to help users clarify their queries and get more accurate results.

• Knowledge assets now require a user privilege.

• Use annotations in AI Interpretation and Execution for more information on how knowledge assets and user-level learnings were applied to answer a question.

• Enhance control levels over what information gets to AI and choose attribute forms for analysis and answer display.

Dashboards

• Parameters can be applied to dataset filters, therefore increasing performance and reducing load on the warehouse. The dataset query is executed after users make choices on the Filter panel or within in-canvas selectors.

• Users have more control over chapter filters. Users can specify the dataset from which all the attribute elements in the filter are sourced from.

• Introducing enhanced experiences for viewing wide grids by adding options to pin and freeze columns. Users can now freeze to the left or pin particular column(s) of interest to the left or right for better data analysis and comparison. Authors can define certain columns to be pinned or frozen by default.

• An enhanced Fit To Container mode now offers improved grid space utilization. Users can set minimum and maximum column widths, specify fixed widths for specific columns (such as the year), and dynamically adjust other columns (such as the address) for optimal width distribution.

• A lock ratio setting was added to enhance dashboard zoom behavior. Use lock ratio to choose a pre-defined or customized ratio so the dashboard can expand or contract according to zoom changes while maintaining component ratios.

• Export to Excel and PDF enhancements:

  • Seamlessly choose chapters, pages and visualizations to be included in export.

  • Choose option to export all objects from a page onto a single Excel sheet.

  • Export includes visualizations imported as data and other non-visualization objects such as images and text boxes.

  • Export supports free-form dashboard layout.

  • Select multiple pages or chapters when exporting.

Administration

• MicroStrategy delivered on its 2024 roadmap and updated MicroStrategy Library and MicroStrategy Web to the Jakarta EE 10 platform. This update removes support for Tomcat 8.x, Tomcat 9.x, and JBoss 7.x and adds support for Tomcat 10.1.x and JBoss 8.x. For more information, see Spring Security SAML Provider 6.2.3 Upgrade. The following authentication and configurations are also affected:

  • Spring Security SAML Customization

  • Logging into Library using Kerberos authentication with Tomcat 10 is affected. See KB486775 for more information.

  • Customizations made to MicroStrategy's bundled Tomcat, specifically to enable HTTPS, require changes to accommodate Tomcat 9, versus Tomcat 10 syntax. See KB486843 for more information.

• Use Cognitive Search, a centralized search service, that adds support when users search using synonyms, typos, abbreviations, natural language, and multilingual search queries.

MicroStrategy Workstation

MicroStrategy AI

• Customize the out-of-the-box AI disclaimer that displays in MicroStrategy AI offerings including Auto Answers, Auto Dashboard, Bots, and so on.

• Allow application owners to configure Auto knowledge assets at the application level and manage knowledge assets from a single view.

• Configure adaptive learning and user feedback at the application level.

Dashboards

• Parameters can be applied to dataset filters, therefore increasing performance and reducing load on the warehouse. The dataset query is executed after users make choices on the Filter panel or within in-canvas selectors.

• Users have more control over chapter filters. Users can specify the dataset from which all the attribute elements in the filter are sourced from.

• Introducing enhanced experiences for viewing wide grids by adding options to pin and freeze columns. Users can now freeze to the left or pin particular column(s) of interest to the left or right for better data analysis and comparison. Authors can define certain columns to be pinned or frozen by default.

• An enhanced Fit To Container mode now offers improved grid space utilization. Users can set minimum and maximum column widths, specify fixed widths for specific columns (such as the year), and dynamically adjust other columns (such as the address) for optimal width distribution.

• Mark attributes that should not be aggregated across multiple elements as non-aggregatable attributes to ensure accurate data slicing and reporting. Non-aggregatable attributes are available in traditional reporting and in MicroStrategy AI.

Administration

• Due to the end of the six-month notice for decommissioning Workstation Mac, Intelligence server will no longer accept connections from Workstation Mac. Users are advised to switch to Workstation on Windows for continued access and support.

• Create Freeform SQL Intelligent cubes.

• Create Freeform SQL Incremental Refresh Reports.

• Increase the scalability of the history list solution and migrate history list data storage to hybrid mode.

• Perform bulk actions on multiple users within the User and User Groups blades. This allows Administrators to efficiently manage user-related tasks in a streamlined manner. Select multiple users at once and perform actions such as updating permissions and modifying settings, saving time and effort in user management. Additionally, you can configure security access for user groups, view dependent subscriptions for users, and export users.

• Search recursively by name and ID in the Project blade. You can also filter by name, owner, date created, date modified, ID, location, and description in all Analysis blades.

• Detailed execution results for subscriptions, enabling Administrators and Power Users to easily identify recipients and the timing of content delivery from subscription results. This enhancement applies to all email, file, and mobile subscriptions.

• Administrators have the ability to set up password expiration rules for users during creation or editing, in line with customer internal security policies. Additionally, to streamline user maintenance processes, we have introduced the option to delete users along with their corresponding user profile folders.

• An HTML/JavaScript Content filter was added to the Content Inspector.

• A lock ratio setting was added to enhance dashboard zoom behavior. Use lock ratio to choose a pre-defined or customized ratio so the dashboard can expand or contract according to zoom changes while maintaining component ratios.

• The Maximum memory consumption per job (MB) setting applies to subscription job when subscription job level governing is turned on. Memory used by subscription jobs cannot exceed 30% of total memory by default. If the limit is reached, subscription requests will be postponed and subscription delivery may be delayed.

• The server-level setting, Maximum memory consumption for Intelligent Cubes (%), allows administrators to set the percentage of system RAM that Intelligent Cubes are allowed to consume. This setting is only exposed in the container environment.

• The server-level setting, Maximum RAM for Working Set Cache %, allows administrators to set the maximum RAM for he working set cache in terms of the percentage of total memory in a container environment.

• The project-level setting, Maximum memory consumption for Excel files (MB), is exposed to allow administrators to limit the memory consumption for Excel files generated from MicroStrategy Web. The default value is Use inherited value (-1). This means that when you upgrade to the latest build, you won't be affected by this setting and will continue to use the value set at the server level.

• Use Cognitive Search, a centralized search service, that adds support when users search using synonyms, typos, abbreviations, natural language, and multilingual search queries.

MicroStrategy HyperIntelligence

Enhance your Hyper insights by integrating Bots with selected cards for deeper, multi-layered analysis. Leverage the power of Hyper and AI seamlessly, whether you're working in a browser or on your mobile device.

MicroStrategy Library Mobile

• Bots include a thumbs-down icon to collect user feedback, smart alternative suggestions, and improved response quality and accuracy through learning from user feedback.

• Improved capability to view wide grids on mobile devices by freezing a column or set of columns to the left while scrolling through the rest of the grid for better data analysis and comparison.

• Improved dashboard performance with newly introduced dataset level filters with parameters by reducing the query result set.

• The Spring Security SAML provider was updated to v6.2.3 and includes the following affected authentication and configuration:

  • Spring Security SAML Customization

MicroStrategy for Office

Excel Add-in

• Automatically distribute data across multiple Excel sheets using imported page-by reports.

• Import data directly into a PivotTable format, with automatic population of rows using Attributes and values using Metrics.

• Utilize an object details setting to specify which information should appear in the side panel and which should be directly imported into the Excel sheet for each object.

• Import attributes as text to ensure accurate data representation

• Choose between merged or unmerged columns when importing cross-tab grids.

• Track imported content with an improved side panel that groups objects based on their Excel sheet placement.

• Import reports and grid visualizations while preserving their original formatting.

PowerPoint Add-in

• Track imported content with an improved side panel that groups objects based on their PowerPoint slide placement.

Teams App

• Register an Azure bot in Microsoft Azure.

• Share bots and dashboards as hyperlinks via the MicroStrategy Teams app.

Platform Analytics

• Configure the Usage Telemetry Service to collect feedback information in the Auto Adoption Dashboard.

MicroStrategy Library SDK

• Provide a dependency list for the Library Web app restful-api jar.

MicroStrategy Library Mobile SDK

The MicroStrategy Library Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Library Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Iguana and newer is supported.

MicroStrategy Mobile SDK

The MicroStrategy Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Iguana and newer is supported.

Intelligence Server

• Preview Feature: Additional scenarios for cube accessibility are supported regardless of the status of the node where the cubes were initially published.

• Platform Analytics Warehouse supports JDBC connections with PostgreSQL.

• Increase the scalability of the history list solution and migrate history list data storage to hybrid mode using the Configuration wizard.

• Improved the Working Set Cache to enhance the accuracy of memory usage calculations and enforce a minimum value for the Maximum RAM for Working cache to ensure it remains at 15% of the total memory.

• Enable stronger application-level encryption at AES-256 for objects stored in the metadata. MicroStrategy recommends users implement full-disk and database level encryption as part of a comprehensive security practice in addition to application level encryption.

• Use more granular control over the cube unload process in low memory.

MicroStrategy REST APIs

The unified Bot API is a streamlined interface designed to seamlessly integrate MicroStrategy AI into virtually any enterprise application. Key features include:

• Simplified Integration: Users no longer need to maintain individual Bot instances.

• Automatic Bot Selection: Users no longer need to specify which Bot to send your data questions to. The API leverages advanced semantic search to automatically identify and engage the appropriate Bot.

• Visualization Export: A new API endpoint allows users to export static visualization images from data answers. This enhances the end-user experience by providing a more visually appealing data representation.

MicroStrategy Packages for Python (mstrio-py)

New Features

• Automate the refresh (full or incremental) and deletion of OLAP and MTDI cubes. This enhancement is particularly valuable for Administrators, as it streamlines the process of managing cubes. To automate the refresh of these cubes without any interaction and creating a Job, we have added the refresh() method to the OlapCube and SuperCube classes. To assist users, we have provided useful workflows for managing cubes within Python scripts.

• Added support for providing a folder path, instead of a folder ID, to methods within the Folder class, as well as quick_search, full_search, and all methods inheriting from them that accept a folder ID argument.

• Added include_subfolders flag to the get_contents method of Folder class to allow getting the contents of the children of the specified folder recursively.

• Added the sql property to the Report class, allowing the retrieval of the SQL view of a report without executing it.

• Added the IncrementalRefreshReport class to the mstrio.object_management.incremental_refresh_report package to allow the management of Incremental Refresh Reports.

• Added the list_incremental_refresh_reports method to allow the listing of Incremental Refresh Reports in a project.

• Added the quick_search_by_id() function to mstrio.object_management.search_operations to allow searching for objects by object and project ID.

• Added the send_email() function in mstrio.distribution_services.email to allow the sending of emails.

• Added the execute_query() method to the DatasourceInstance class to allow the execution of SQL queries.

• Added the status property to the Subscription class to allow the checking of a subscription status.

• Added support for answering prompts in the to_datasource() method of the Report class, along with a Prompt class in mstrio.project_objects.prompts to support prompts.

• Added support for password_auto_expire and password_expiration_frequency fields to the User class.

• Added support for page-by in the Report class.

• Added support for VLDB properties in the Report class.

Minor Changes

• Added a warning message to the OlapCube and SuperCube classes that appears when the provided ID belongs to different type of Cube.

• Updated PageSize Enum values to allow proper subscription initialization.

• Added support for both name and display_name in the VLDB settings provided by ModelVldbMixin.

• Added a vldb_settings property in the VldbMixin class that stores VLDB settings in dict with setting names as keys.

MicroStrategy Cloud Platform

• MicroStrategy Backup and Restore supports Storage Service

• Support for PostgreSQL 14 and 16

• Support for Oracle 21c

• Support for SQL Server 2022

Data Sources

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

• Certified gateway versions

  • Teradata 20.x

  • Greenplum 7.x

  • Informix 14.10

  • Yellowbrick

• Out-of-the-box driver updates

  Ensure security and reliability by other security updates and fixing bugs for the following drivers:

  • Oracle ODBC driver

  • Spark JDBC driver

  • Exasol ODBC driver

  • Google BigQuery JDBC driver

  • Salesforce ODBC and JDBC drivers

  • Driver Manager files

Privileges

See Privileges by License Type for information about license types and associated privileges.

The following existing privileges were removed from the Server - Reporter license and added to the MicroStrategy AI license:

• Create and Edit AI Bots

• Run AI Bots

• Use Auto Assistant and ML Visualizations

The Create and Configure Knowledge Assets privilege has been added to the MicroStrategy AI license.

---

MicroStrategy ONE (March 2024)

Dossiers have been renamed to dashboards to simplify the user experience across enterprise systems and follow the best naming convention practices in the BI industry. You may notice that existing folders are named "My Dossiers" and "My Shared Dossiers", while new user profile folders are named "My Dashboards" and "My Shared Dashboards". For more information, see KB486427: Rename "My Dossiers" and "My Shared Dossiers" to "My Dashboards" and "My Shared Dashboards" for Each User Account.

MicroStrategy is transitioning from Java 11 to Java 17 in this release. MicroStrategy ONE cloud hosted environments, or MicroStrategy on-premise environments that use the bundled Tomcat version, will have the necessary changes automatically applied during their upgrade. MicroStrategy on-premise environments with their own web application server must upgrade the JDK to JDK17. MicroStrategy Web ASP environments should not see any impact. Customizations written using Java 11 versions should continue to work with Java 17. See Platform Certifications for more information.

MicroStrategy introduces granular control over HTML and JavaScript execution to enhance security. If HTML and scripts were globally allowed before upgrading, they are now paused by default after upgrading to MicroStrategy ONE (March 2024). The update activates granular settings and requires you to review and authorize HTML and script usage individually. MicroStrategy encourages you to invalidate all caches and use the inspector tool available in Workstation to selectively enable content in each dashboard, document, and report. This proactive measure ensures a safer environment by minimizing unwanted script execution while maintaining functionality, where trusted. If you are upgrading to MicroStrategy ONE from a previous version, see KB486433: HTML Content Settings When Upgrading to MicroStrategy One (March 2024) or Later from Previous Versions. If you are using the Content Inspector tool with certified objects, see KB486729: Use Content Inspector with Certified Objects.

MicroStrategy Library

MicroStrategy AI

• Auto Answers and Bots can answer compound multi-faceted questions that allow deeper, contextually rich insights drawn from multiple data points within the same query.
• Auto enables dashboard and Bot owners to boost chat experiences by allowing owners to upload knowledge assets such as business glossaries, acronyms, and synonyms. Knowledge assets ensure business users receive more accurate data answers.
• Auto Answers adds support for queries across multiple in-memory datasets within a single dashboard, including reports, subset reports, and cubes. This enhancement enables you to seamlessly integrate and interrogate data across different datasets for richer, more informed insights.
• Use AI Interpretation and Execution for a deeper understanding into how AI interprets and executes its queries, which enhances transparency and insight in data exploration. Using specific information based on user privileges, power users gain access to robust tools for efficient troubleshooting and validation.
• The snapshot panel adds new options to rename a snapshot title, ask again, and clear all snapshots.
• When creating a Bot, right-click an object in a dataset to rename it or configure a number format.
• Format a visualization filter or selector to apply to Auto Answers and Auto Dashboard. Auto Answers responses are based on the selector content and visualizations generated using Auto Dashboard are automatically filtered.
• When creating a Bot, add up to three topics related to the dataset used in the Bot. Topic summaries that are retrieved during consumption help onboard the Bot consumer and inspire them with insights the Bot can provide. The Ask About panel provides a closer look at dataset objects to support in depth questions.

Dashboards

• Leverage Python enabled transaction grids in dashboards to update records in Salesforce, ServiceNow, and more.
• Dashboard authors can require users to make filter selections before displaying data.
• Improved legend positioning for bar, line, area, scatter, and pie charts.
• Mapbox boundaries are upgraded to Enterprise v4. This upgrade improves data coverage and updates boundary information.
• Set metric value as HTML content from the Metric Editor and data import.
• Display HTML and JavaScript content in documents, reports, dashboards, and Bots according to the object-level security setting.

• Empower users to seamlessly leverage and reuse prompted answers across diverse prompts while importing content through MicroStrategy Library, streamlining data analysis and enhancing productivity.

Administration

• Define display behavior for notifications. Turn on Persistent Notifications so notifications appear until they are acknowledged.
• The My Language setting has been updated to control language preferences for metadata and data.

MicroStrategy Workstation

Dashboards

• Dashboard authors can require users to make filter selections before displaying data.

• Improved legend positioning for bar, line, area, scatter, and pie charts.
• Mapbox boundaries are upgraded to Enterprise v4. This upgrade improves data coverage and updates boundary information.

Administration

• Create a Python enabled transaction dashboard.

• The MicroStrategy Storage service supports Google Cloud Storage.

• The Automatic option for Maximum memory consumption per job setting's default was updated to 10% of the total memory when a specific value is not set.

• Improve server stability and prevent memory outages by dynamically adjusting the job level governing in low memory situations.

• Modify a project's primary data source and add/remove data sources from a project.

• Streamlined ability to create, edit, and delete standalone database connections and logins.

• Restrict multiple sessions from multiple devices.

• Configure granular control of HTML and JavaScript content via an environment-level security setting.

• Use the Content Inspector tool to perform granular control on HTML and JavaScript content at the object level. If you are using the Content Inspector tool with certified objects, see KB486729: Use Content Inspector with Certified Objects.

• Support IAM based modern authentication (OAuth 2.0) for smart hosts such as Microsoft Exchange for email delivery devices.

• Update Workstation from the menu bar or a banner on the main window. To streamline the installation process and reduce unnecessary components, the MicroStrategy service tray has been removed.

• View components and dependents for hierarchies and tables. You can also view system managed objects, as well as an object's ID and location.

• New Description and ID columns in the objects grid.

MicroStrategy Library Mobile

iOS

• Use Bots to gather insight on a selected dataset, save your favorite responses using snapshots, embed a bot to a web page, and share your bot with other users.
• Use AI Interpretation and Execution for a deeper understanding into how AI interprets and executes its queries which enhances transparency and insight in data exploration. Using specific information based on user privileges, power users gain access to robust tools for efficient troubleshooting and validation.
• The snapshot panel adds new options to rename a snapshot title, ask again, and clear all snapshots.

• Display HTML and JavaScript content in documents, reports, dashboards, and Bots according to the object-level security setting.

• Support for Python transactional grids.

• Filters can be configured as required.

• Upgraded geospatial boundaries for an accurate worldview.

• Support for legend position at the top or bottom of a graph.

Android

• Use Bots to gather insight on a selected dataset, save your favorite responses using snapshots, embed a bot to a web page, and share your bot with other users.
• Use AI Interpretation and Execution for a deeper understanding into how AI interprets and executes its queries which enhances transparency and insight in data exploration. Using specific information based on user privileges, power users gain access to robust tools for efficient troubleshooting and validation.
• The snapshot panel adds new options to rename a snapshot title, ask again, and clear all snapshots.

• Display HTML and JavaScript content in documents, reports, dashboards, and Bots according to the object-level security setting.

• Support for Python transactional grids.

• Filters can be configured as required.

• Upgraded geospatial boundaries for an accurate worldview.

• Support for legend position at the top or bottom of a graph.

MicroStrategy Web

Restrict multiple sessions from multiple devices.

MicroStrategy for Office

• View, pin, and share Bots in the Teams add-in.
• Share dashboards in Teams using the Teams add-in.
• Import visualizations as an image in the Excel add-in.
• Empower users to seamlessly leverage and reuse prompted answers across diverse prompts while importing content through the intuitive MicroStrategy add-in for PowerPoint, streamlining data analysis and enhancing productivity.
• See an overview of imported objects and interact with them using the Excel and Powerpoint add-ins.

MicroStrategy Library Mobile SDK

The MicroStrategy Library Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Library Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Giraffe and newer is supported.

MicroStrategy Mobile SDK

The MicroStrategy Mobile SDK for Android is certified to work with Android 14 (API level 34). When you customize MicroStrategy Mobile SDK for Android, you must have Android SDK 34 to develop and compile your application. Android Studio Giraffe and newer is supported.

MicroStrategy REST APIs

• Use MicroStrategy Bot APIs.

• Support for Freeform SQL cubes and Freeform SQL Incremental Refresh Reports (IRRs).

MicroStrategy Packages for Python (mstrio-py)

New Features

• Added delete_object_cache() and delete_element_cache() methods to the Project class to allow the deletion of object and element caches.

• Added an optional show_description argument to ProjectSettings.list_caching_properties() to show descriptions for each setting.

• Added delete_server_object_cache() and delete_server_element_cache() methods to the Environment class to allow the deletion of object and element caches from all projects.

• Added a MobileSubscription class in the mstrio.distribution_services.subscription package to allow management of the new subscription type.

• Added the following new bulk methods to the Translation class: to_json_from_list, add_translations_from_json, to_database_from_list, add_translations_from_database, to_dataframe_from_list, and add_translations_from_dataframe.

• Updated the to_csv_from_list and add_translations_from_csv older translation methods with the functionality present in the newer bulk methods for json, databases and dataframes.

• Added support for the comments field in MicroStrategy objects to view and edit their long descriptions.

• Added the EmbeddedConnection class to allow access to embedded connection templates in DatasourceInstance.

• Added support for Python 3.12.

Minor Changes

• Updated the script template for data source scripts.

• The enableHtmlContentInDossier server setting is now read-only for environments. This setting cannot be changed using mstrio-py since it is superseded by allowHtmlContent.

Deprecated

The mstrio.project_objects.dossier module is superseded by mstrio.project_objects.dashboard and will be removed in the future, after a one year deprecation period

Removed

The MicroStrategy for Jupyter Extension is no longer developed and supported and has been removed from the mstrio-py package in this release. You can still use the mstrio-py library and all its current and upcoming features.

MicroStrategy for RStudio and mstrio for R are no longer supported and developed and have been archived. You can still use the last available version.

MicroStrategy R Integration Pack

The R Integration Pack is in maintenance. No new features are planned. Only critical security updates will be provided.

Intelligence Server

Restrict users from logging in to MicroStrategy from multiple devices.

MicroStrategy Modeling Service

Set the timeout value for requests sent from the MicroStrategy Modeling service to the Intelligence server using the modelservice.iserver.requestTimeout property in modelservice.conf.

Data Sources

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

• Certified gateway versions

  • PostgreSQL 16

  • Oracle 23c

  • Impala 4.x

  • Exasol 8.x

  • MongoDB 7

• Out-of-the-box driver updates

  Ensure security and reliability by supporting OpenSSL 3.x and other security updates for the following drivers:

  • Impala ODBC driver

  • Hive JDBC driver

  • SparkSQL ODBC driver

  • Teradata ODBC driver

  • Redshift JDBC driver

  • Snowflake ODBC driver

  • Google BigQuery JDBC driver

  • Native PostgreSQL ODBC driver

  • SQL Server ODBC driver

---

MicroStrategy ONE (February 2024)

MicroStrategy Packages for Python (mstrio-py)

The MicroStrategy for Jupyter extension will no longer be developed and supported and will be removed from the mstrio-py package starting in MicroStrategy ONE (March 2024). You can still use the mstrio-py library and all its current and upcoming features.

---

MicroStrategy ONE (January 2024)

MicroStrategy Library

Improvements to Auto Answers time-related questions including time level transformations. The update distinguishes between Month and Month of Year and between Quarter and Quarter of Year.

---

MicroStrategy ONE - Update 12 (December 2023)

MicroStrategy Library

MicroStrategy AI

• Create and customize a stand-alone Bot for your organization. Customize the bot's appearance, custom instructions, data settings, and other general settings.
• Use Bots to gather insight on a selected dataset, save your favorite responses using Snapshots, embed a bot to a web page, and share your bot with other users.
• Auto Answers improvements:
  • Improved response times and accuracy in business intelligence analysis.
  • Enhanced experience for complex queries such as, year-to-date summaries and non-aggregatable value calculations based on MicroStrategy schema objects.
  • Retain chat history per page while the dossier session is running with a new confirmation step to clear history and prevent accidental data loss.
  • Automatically translated suggested questions based on a user's language preference setting.
• Auto Dashboard evolves and enables an interactive chatbot conversation to create a dashboard page or a visualization and modify generated visualizations on the bot panel, all through natural language commands and questions.

Dossier

• The new data import experience is available out-of-the-box. This new experience includes an organized data source tree that lists all available data sources, a centralized table canvas and powerful search functionality, enabling users to navigate, import, and manage data from multiple sources using a streamlined experience.

• Enable data comparison, dynamic conditions and what-if analysis using parameters.

• Use content discovery to:

  • Rename, copy, move, and delete folder content.

  • Create new folders and shortcuts to organize folder contents.

• Conditionally display text boxes, image, and shapes in dossiers.

• Display totals and subtotals on stacked bar charts.

• Export to Excel:

  • Enable export using dossier chapter filters.

• Keyboard shortcuts for improved accessibility on the Attribute Element Prompt dialog.

• Manage user access of all objects in Library, including when sharing dossiers, documents, and reports.

MicroStrategy Workstation

This is the last release before the retirement of MicroStrategy Workstation for Mac. Support for security and services updates on Workstation for Mac will remain available until June 2024. See Mac Workstation Client End-of-Life Announcement for more information.

MicroStrategy AI

Expose and manage standalone AI bots.

Dossier

• The new data import experience is available out-of-the-box. The new experience includes an organized data source tree that lists all available data sources, a centralized table canvas and powerful search functionality, enabling users to navigate, import, and manage data from multiple sources using a streamlined experience.

• Calendar based reporting.

• Display totals and subtotals on stacked bar charts.

• Conditionally display text boxes, image, and shapes in dossiers.

• Enable data comparison, dynamic conditions, and what-if analysis using parameters.

Administration

• Add or remove servers from a cluster environment and enable servers for cluster start up.

• Access and monitor MicroStrategy licenses to register new licenses and activate or deactivate existing licenses.

• Configure panels in Library to be pinned or docked via applications, including the sidebar, dossier table of contents, filter panel, and comments.

• Create data sources generically with connection strings.

• Enhanced user monitor to visually depict user account status.

MicroStrategy for Office

• Use the MicroStrategy Teams App

• Empower users to seamlessly leverage and reuse prompted answers across diverse prompts while importing content through the intuitive MicroStrategy add-in for Excel, streamlining data analysis and enhancing productivity.

MicroStrategy Platform Analytics

• Expanded Auto Adoption: Platform Analytics now captures object (dossier or bot) information (for example, description, ID, or modification date) linked to every AI-related question submitted by a user
• Improved out-of-the-box dossier: The newly captured information was added to the Auto Adoption dossier. Authors can measure adoption of owned content based on the number of questions asked.

MicroStrategy Library Mobile SDK

iOS

When you customize MicroStrategy Library Mobile SDK for iOS to develop and compile your application, you must have an Apple Mac with Ventura 13.5.2 and above that uses an Intel x86 or Apple M1/M2 chip machine and runs Xcode 15.0 with Apple iOS SDK 17.0.

Android

Android Push Notifications with Firebase Cloud Messaging (FCM):

• Upgraded Firebase Cloud Messaging (FCM) API to the new HTTP V1 version, enhancing performance, reliability, and security of push notifications. For Out-of-the-Box (OOTB) Android push notification devices, this migration is seamless, requiring no user action.

• For custom MicroStrategy Android apps, see Enable Push Notifications in Android to update your configuration.

MicroStrategy Mobile SDK

iOS

When you customize MicroStrategy Mobile SDK for iOS to develop and compile your application, you must have an Apple Mac with Ventura 13.5.2 and above that uses an Intel x86 or Apple M1/M2 chip machine and runs Xcode 15.0 with Apple iOS SDK 17.0.

Android

Android Push Notifications with Firebase Cloud Messaging (FCM):

• Upgraded Firebase Cloud Messaging (FCM) API to the new HTTP V1 version, enhancing performance, reliability, and security of push notifications. For Out-of-the-Box (OOTB) Android push notification devices, this migration is seamless, requiring no user action.

• For custom MicroStrategy Android apps, see Enable Push Notifications in Android to update your configuration.

MicroStrategy Packages for Python (mstrio-py)

New Features

• Changed list_users to allow filtering on the enabled field.

• Added support for ldapdn, language, owner, and default_timezone for Users.

• Added support for ldapdn for UserGroups.

• Added add_datasource() and remove_datasource() methods to the Project class to allow the addition and removal of data sources from the project.

• Added data_language_settings and metadata_language_settings properties to the Project class to allow interacting with project internalization:

  • Added add_language(), alter_language(), remove_language(), alter_current_mode(), alter_default_language() methods for the data_language_settings property.

  • Added add_language() and remove_language() for the metadata_language_settings property.

• Added a new optional show_description argument to ProjectSettings.list_properties(), ProjectSettings.to_csv(), ServerSettings.list_properties(), and ServerSettings.to_csv() to show descriptions for each setting.

• Added Enums in mstrio.server.setting_types to allow altering Enum settings by providing Enum values instead of string.

Minor Changes

• Updated code snippets for data sources to use the Language class and list_languages function from the mstrio.server.language package instead of the Locale class and list_locales function.

• Members in user groups are now instances of the User or UserGroup class, instead of dictionaries.

• Addresses in the User class are now instances of the Address class, instead of dictionaries.

Deprecated

The ability to provide initials as a filter in list_users is deprecated and will be removed in the future.

Removed

• Removed the Locale class and list_locales function from the mstrio.datasources.datasource_map module.

• Removed the update() method from the OlapCube class.

• Removed the mstrio.api.exceptions and mstrio.helpers.exceptions modules.

• Removed the overwrite, attributes, and metrics parameters from the OlapCube.create() method.

• Removed the ability to pass an instance of the Locale class as an argument in the mstrio.datasources.datasource_map module.

MicroStrategy Embedding SDK

There is a new API to embed a bot consumption page. Some UI customizations can be made as well.

Federated Analytics

The MicroStrategy for QlikView and MicroStrategy for Qlik Sense connectors deployed from prior versions no longer connect to the Intelligence server. See KB486119 for more information.

Data Sources

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

• Gateway changes

  • The following SaaS gateways leverage ODBC instead of JDBC: Square, Shopify, ServiceNow, Paypal, Marketo, Hubspot, Eloqua, and Concur. Upon upgrade, existing connections are automatically modified to the new out-of-the-box ODBC-based connectors.

  • The MapR Drill connector has been deprecated and retired.

• Out-of-the-box driver updates

  Ensure security and reliability by supporting OpenSSL 3.x and other security updates for the following drivers:

  • SQL Server

  • Postgres SQL

  • Google Big Query

---

MicroStrategy ONE - Update 11 (November 2023)

MicroStrategy Library Mobile SDK

iOS

Use Intune MAM AppConfig with Intune Integrated iOS Library SDK.

---

MicroStrategy ONE - Update 11 Patch 1 (October 2023)

This release includes remediations for CVE-2023-4863 and CVE-2023-5217 by upgrading libwebp and libvpx to safe versions.

---

MicroStrategy ONE - Update 11 (September 2023)

MicroStrategy Library

Auto

• Use Auto Dashboard to create dossier pages with visualizations.

• Use Auto Answers to self serve insights.

• Turn historical data into actionable predictions. Unlock future insights with time series forecasting.

• Chart your growth trajectory. Uncover clear patterns with time series linear trend analysis.

• Elevate decision-making and understand the dominant factors influencing specific outcomes with key driver analysis.

• Enable and disable Auto at the dossier-level.

Dossier

• Discover content via folder browsing. This former preview feature is available out-of-the-box.
• Enable or disable the passing of selected objects to the target page with contextual linking.
• Copy and paste visualization formatting.
• Link to a dossier in a different project.
• New Transactions tab added to the Format panel for dossier transaction grids.
• Create thresholds on each visual component of Multi-Metric KPIs and Comparison KPIs. Thresholds can be duplicated within a single visualization. Thresholds can be based on the following:
  • Value
  • Rank
  • Increasing/Decreasing trend
• View your library in a customizable list view.

• More granular controls for applications.

• Export to PDF enhancements:
  • Expanded PDF paper size export options.
  • Use the Dossier Properties dialog to define a default paper size and orientation when exporting a dossier to PDF.

Administration

Check the Modeling services IP and port using the Library log file.

MicroStrategy Workstation

Auto

• Enable and disable Auto on the project-level, application-level, and dossier-level.

• Use Auto Dashboard to create dossier pages with visualizations.

• Turn historical data into actionable predictions. Unlock future insights with time series forecasting.

• Chart your growth trajectory. Uncover clear patterns with time series linear trend analysis.
  

• Elevate decision-making and understand the dominant factors influencing specific outcomes with key driver analysis.

• Use Auto SQL to create Freeform SQL tables. This former preview feature is available out-of-the-box.

Dossier

• Users can create data sources and access context menu options using the new data import experience, instead of contacting the administrator to do so.

• Link to a dossier in a different project.

• Enable or disable the passing of selected objects to the target page with contextual linking.

• Copy and paste visualization formatting.

• New Transactions tab added to the Format panel for dossier transaction grids.

• Create thresholds on each visual component of Multi-Metric KPIs and Comparison KPIs. Thresholds can be duplicated within a single visualization. Thresholds can be based on the following:

  • Value
  • Rank
  • Increasing/Decreasing trend

Administration

• Reduce cube file size by up to 50% using cache compression. This former preview feature is available out-of-the-box.

• Create security filters based on relational sources for live and in-memory analytics. This former preview feature is available out-of-the-box.

• Browse folder structure using content discovery in Library. This former preview feature is available out-of-the-box. 

• Manage Library subscriptions.

• Allow parallel execution of burst subscriptions to improve performance on both single node, as well as clustered Intelligence server environments.

• Configure allowed URLs for data import.

• Support for warehouse partition mapping and metadata partition mapping.

• Use an existing package to edit and recreate a migration package.

• Change the Workstation interface language in Windows. This feature enables users to switch languages on demand, without changing the Windows language.

• There is a new option to enable HTTP Strict Transport Security (HSTS) for the MicroStrategy Modeling service.

• Check the available Modeling services.

• Edit custom language objects to specify their default interface language in Workstation.

• More granular controls for applications.

• Configure the logo and color theme of Library via the application's Appearance Editor. This feature is now also applicable to Library Mobile for iOS and Android.

• Data Source Management:

• Create data sources against Amazon Athena

• Configure OIDC single-sign-on Databricks

• Create Python data sources

MicroStrategy Library Mobile

iOS

• Supports iOS 17.
• Discover content via folder browsing.

• Configure the color theme via applications.

• Link to a dossier stored in a different project from images or text

• Passing the selected objects when linking from a visualization can be disabled.

• Support line breaks in transactional grids.

• More granular controls in applications.

Android

• Discover content via folder browsing.

• Configure the color theme via applications.

• Link to a dossier stored in a different project from images or text

• Passing the selected objects when linking from a visualization can be disabled.

• Support line breaks in transactional grids.

• More granular controls in applications.

MicroStrategy Mobile

iOS

Supports iOS 17.

MicroStrategy for Office

Import visualizations from MicroStrategy to PowerPoint

MicroStrategy Intelligence Server

• Reduce cube file size by up to 50% using cache compression. This former preview feature is available out-of-the-box.

MicroStrategy REST APIs

• Manage cluster startup membership configuration.

• Update a table's physical structure.

MicroStrategy Packages for Python (mstrio-py)

New Features

• Added support for metric object VLDB properties by providing list_vldb_settings, reset_vldb_settings, and alter_vldb_settings methods, as well as a vldb_settings attribute.

• Added a refresh argument to list_datasource_warehouse_tables to allow the refreshing of available warehouse tables in a data source.

• Enhanced the update_physical_table_structure and update_physical_table_structure_for_all_tables methods of LogicalTable to work after changing WarehouseTable structure.

• Added a Translation class to the mstrio.object_management.translation package to allow the management of translations for any object with the following methods: add_translation, alter_translation, remove_translation, to_csv_from_list, and add_translations_from_csv.

• Added list_translations to allow listing translations for objects.

• Added add_translation, alter_translation, remove_translation, and list_translations methods to all objects inheriting from Entity to allow translation management directly through the objects.

Minor Changes

Moved Rights, AggregatedRights, and Permissions enums to the mstrio.helpers module.

Removed

Removed list_folders, create_folder, and delete_folder from mstrio.utils.helper because they have been superseded by the mstrio.object_management.folder module.

MicroStrategy Embedding SDK

Event handlers have been added to Library for item and menu selection.

Federated Analytics

This is the last release in which the MicroStrategy for QlikView and MicroStrategy for Qlik Sense connectors are available on the download site. See KB486119 for more information.

Data Sources

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

• Gateway Certifications:

  • Google Analytics v4

  • SAP Datasphere

• New Gateway Single Sign-On Certifications:

  • Support OIDC SSO with Generic Identity Provider

  • OIDC authentication for Azure Databricks with Azure AD

  • Enable OIDC Authentication with AWS Databricks Using Databricks Identity Provider

• Gateway Enhancements:

  • Certify and support for temporary tables for Google BigQuery

  • Support for the Push Down function Product and GeoMean for GoogleBigQuery

• Ensure security and reliability by supporting openssl 3.x with the following updated drivers:

  • Redshift ODBC driver

  • Oracle ODBC driver

  • IBM DB2 ODBC Driver

Privileges

See Privileges by License Type for information about license types and associated privileges.

The Use Auto Assistant and ML Visualizations privilege has been added to the Server - Reporter license.

---

MicroStrategy ONE - Update 10 (August 2023)

MicroStrategy Workstation

Create IAM objects with a generic OAuth type.

MicroStrategy Packages for Python (mstrio-py)

New Features

• Added the delete() method to the Project class to allow the deletion of projects.

• Added the hidden parameter to create methods of Attribute and Metric classes.

Minor Changes

Renamed ObjectTypes.NONE to ObjectTypes.NOT_SUPPORTED in the mstrio.types module.

MicroStrategy Library Mobile

iOS

Supports iOS 17 and iPadOS 17. See MicroStrategy Mobile and MicroStrategy Library Apps crash on iPadOS & iOS 17 for more information.

MicroStrategy Mobile

iOS

Supports iOS 17 and iPadOS 17. See MicroStrategy Mobile and MicroStrategy Library Apps crash on iPadOS & iOS 17 for more information.

---

MicroStrategy ONE - Update 10 (July 2023)

MicroStrategy Workstation

Enable Analytics Architects to view fact extensions in the fact editor.

MicroStrategy Library

Edit header and footer text when exporting a report to Excel.

MicroStrategy Packages for Python (mstrio-py)

Major changes

• Added the Language class in the mstrio.server.language package to allow management of Languages

• Added list_languages and list_interface_languages to allow the listing of languages and interface languages

Deprecated

• The Locale class in mstrio.datasources is no longer supported and is superseded by the Language class in the mstrio.server.language package

• The list_locales function in mstrio.datasources is no longer supported and is superseded by the list_languages function in the mstrio.server.language package

---

MicroStrategy ONE - Update 10 (June 2023)

MicroStrategy Workstation

• Preview Feature: Use artificial intelligence (AI) when creating Freeform SQL tables.

• Preview Feature: Use artificial intelligence (AI) for dataset analysis in Library.

• Preview Feature: Create security filters based on relational sources for live and in-memory analytics.

• Preview Feature: Reduce cube file size by up to 50% using cache compression.

• Preview Feature: Browse folder structure using content discovery in Library.

• Support oAuth On-behalf-of authentication mode for Snowflake against Okta. This former preview feature is available out-of-the-box.

• Enable Administrator and Analyst personas to deliver content to mobile devices with mobile subscriptions. This is an extension of subscription management, now enabling the ability to send content directly to mobile devices.

• Define reusable dossier themes.

• Configure the logo and color theme of Library Web via the application's Appearance Editor. Color preferences now apply to collaboration, MicroStrategy Insights, subscriptions and search interfaces, as well as the table of contents.

• Add reports to a content group.
• SharePoint Lists allow you to import any list from SharePoint.
• Enable single logout with OIDC authentication.

• Improve project loading and schema update performance by optimizing Intelligent cubes processing for dynamic sourcing.

• Data Source Management:

  • Create data sources against Amazon Athena

  • Configure OIDC single-sign-on authentication to Snowflake and Amazon Athena Using Okta and Azure AD

MicroStrategy Library

• Preview Feature: Use artificial intelligence (AI) for dataset analysis.

• Preview Feature: Discover content via folder browsing.

• Content groups can view and create new application content.
• Dossier authoring enhancements:

  • A Special number format has been added for attributes. It can be modified at the dataset level and within modern grids. This allows the formatting of numbers such as zip codes, phone numbers, and social security numbers.

  • Modern grids have enhanced border formatting options that allow you to set specific borders (top, bottom, left, right) for each column set.

  • Apply a theme to your dossier.

MicroStrategy Library Mobile

iOS

Dossier transaction grids have an input control "switch" so users can add and modify data. The switch uses a toggle or checkbox style. Both styles support on/off/unset states in data modification mode and on/off for data insertion mode.

Android

• Dossier transaction grids have an input control "switch" so users can add and modify data. The switch uses a toggle or checkbox style. Both styles support on/off/unset states in data modification mode and on/off for data insertion mode.

• Dynamically switch between time zones for your data.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

• Updated the create method of the OlapCube class to support the following new parameters: template, filter, options, advanced_properties, time_based_settings, show_expression_as, and show_filter_tokens.

• Updated the alter method of the OlapCube class to allow altering of the following new parameters: template, filter, options, and time_based_settings.

• Added set_partition_attribute, remove_partition_attribute and list_attribute_forms methods to the OlapCube class to allow management of partition attribute and observing attributes forms.

• Added list_vldb_settings, alter_vldb_settings and reset_vldb_settings methods to the OlapCube class to allow management of VLDB settings.

Deprecated

• The update method of the OlapCube class is no longer supported. It is superseded by the alter method and will be removed in the future.

• The attributes, metrics and overwrite parameters in the create method of the OlapCube class are no longer supported. They are superseded by the template parameter and will be removed in the future.

MicroStrategy REST APIs

• Retrieve, create, and update KPI objects and insights.

• Change the owner of an object.

• Create a dossier in memory based on a list of objects.

• Retrieve a list of documents.

• Retrieve the hierarchy of a document.

• Enhancements for folder browsing

MicroStrategy Cloud Platform

• MicroStrategy Backup and Restore unlocks all projects that were previously locked after the restore process.

• Support for Amazon Linux 2023 and RHEL 8.6

• New Spain region for AWS

• One Click Upgrade includes a Tomcat upgrade.

Intelligence Server

Preview Feature: Reduce cube file size by up to 50% using cache compression.

Data Sources

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

• Gateway Certifications

  • Certify Sharepoint Lists as an out-of-the-box gateway in Workstation's new data import experience

  • Support XML format for file uploads in the data import workflow

  • IBM Z/OS v12

• New Gateway Single Sign-On Certifications:

  • OIDC single sign-on to Snowflake with Okta

  • OIDC single sign-on to Amazon Athena with Okta and Azure AD

• OOTB Driver Updates

  Ensure security and reliability with the following updated drivers:
  

  • IBM DB2 ODBC Driver

  • MicroStrategy Driver Manager Files

  • Teradata ODBC Driver

  • Exasol ODBC Driver

Upgrade

The MicroStrategy Repository is an embedded PostgreSQL repository that supports the storage of Collaboration Server, Platform Analytics, and the Storage Service. In MicroStrategy ONE Update 10, the embedded PostgreSQL version is upgraded from v 11.x to 14.7. To learn more, see MicroStrategy Repository Upgrade.

Installation

The Korn Shell (KSH package) is not required to launch setup. Bash shell is used by default.

---

2021 Update 9 (May 2023)

MicroStrategy Workstation

• Create datamart objects. This former preview feature is available out-of-the-box.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

• Added list_vldb_settings, alter_vldb_settings, and reset_vldb_settings methods to the DatasourceInstance and Project classes to allow management of VLDB settings.

• Added a Driver class and list_drivers function in the mstrio.datasources.driver module to allow driver management.

• Added a Gateway class and list_gateways function in the mstrio.datasources.gateways module, as well as GatewayType and DBType enums in mstrio.datasources.helpers to allow gateway management.

Minor Changes

• Updated ipython dependency version to 8.10.0.

• Added a project_id property for Metric instances.

• Added a delivery_expiration_timezone argument for the Subscription class and its subclasses. This functionality will be supported in a future release.

• Added SuperCubeAttribute, SuperCubeAttributeForm, and SuperCubeFormExpression classes in the mstrio.project_objects.datasets.super_cube module to support attribute forms for SuperCube.

MicroStrategy Embedding SDK

Native Embedding SDK

• You can use the Native Embedding SDK to embed visualizations from separate containers to improve performance.

• Users can interact with the embedded visualization.

• Users can use APIs to perform manipulations such as filtering.

---

2021 Update 9 (April 2023)

MicroStrategy HyperIntelligence

All HyperIntelligence products were updated for consistent refresh data behavior in card properties.

---

2021 Update 9 (March 2023)

MicroStrategy Workstation

• Preview Feature: Create datamart objects.

• Preview Feature: Support oAuth On-behalf-of authentication mode for Snowflake against Okta.

• Administrators can specify different default authentication modes per application to customize the login experience in Library for end users. This former preview feature is available out-of-the-box.

• Create data sources to Palantir Foundry. This former preview feature is available out-of-the-box. The corresponding driver is shipped with Workstation.

• Improved data source management.

• The server-level security setting, Allow lockout duration (Minutes), allows administrators to set the amount of time (in minutes) to lock an account after a user fails to log in a certain amount of times.

• Administrators can restore all password security settings back to the default with one click.

• Secure users and user groups access with ACLs to control who can view, modify, or delete them.

• Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application. See Manage Content Groups for more information.

• Administrators can configure linking between environments via applications and enable users in Library Web to switch between environments using the new Switch Workspace option under the Account menu.

• Expanded time zone based reporting to additional gateways and optimized background performance, including the option to delete unused system calendars.

• Configure smart attribute formatting at the dossier level. Exporting services feature all supported languages.

• Edit migration packages.
• Edit transactional reports.
• Create Intelligent cube reports.

• The history list monitor allows you to view history list messages for all users, as well as detailed information for each message.

• Configure the logo and color theme of Library Web via the application's Appearance Editor.

• Dossier transaction grids have an input control "switch" so users can add and modify data. The switch uses a toggle or checkbox style. Both styles support on/off/unset states in data modification mode and on/off for data insertion mode.

• Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information.

• Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

• Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

MicroStrategy Library

• Preview Feature: Enable a Filter panel for report consumption in Library Web.

• Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information.

• Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

• Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

• Dossier transaction grids have an input control "switch" so users can add and modify data. The switch uses a toggle or checkbox style. Both styles support on/off/unset states in data modification mode and on/off for data insertion mode.

• Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application.

MicroStrategy Library Mobile

iOS

• MicroStrategy Insights are supported. Review insightful data changes on-the-go.

• Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information

• Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

• Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

• Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application.

Android

• MicroStrategy Insights are supported. Review insightful data changes on-the-go.

• Selections in visualization (in-canvas) filters can be matched between source and target dossier pages with contextual linking. See Use a Visualization to Filter Data in a Different Dossier and Link a Text Field or Image to a Dossier for more information.

• Filter selectors can be configured to automatically update by either clearing or by resetting to a dynamic first/last N element selection to avoid returning no data due to mutually exclusive selections. See Create a Visualization Filter for more information.

• Filters configured with a dynamic last/first N element selection can be configured to prevent consumers from clearing (unsetting) them. This enforces a selection and avoids large amounts of data being returned. See Create a Default Dynamic Selection Filter for more information.

• Administrators can allow business users of an application to create, search for, and view new content in their library when content groups are associated with the application.

MicroStrategy Platform Analytics

Client telemetry offers a realm of insightful data. This former preview feature is available out-of-the-box.

• Developers/BI Architects can discover consumption patterns of a dossier such as page clicks, time elapsed, and so on.

• Administrators can monitor end-to-end performance of the platform, including client-side rendering times.

• Starting in MicroStrategy 2021 Update 9, a new out-of-the-box dossier showcases this feature's new capabilities.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

• Added HistoryListSubscription, FTPSubscription, and FileSubscription classes in the mstrio.distribution_services.subscription package to allow management of history list, FTP, and file subscriptions.

• Added a DynamicRecipientList class in the mstrio_distribution_services.subscription package to allow management of dynamic recipient lists.

• Added list_dynamic_recipient_lists to allow the listing of dynamic recipient lists.

Minor Changes

• Added verification when initializing the Report object, if the object is supported. Currently, objects with the following subtypes are supported: 768 - grid, 769 - graph 769, 770 - engine, 774 - grid and graph, 778 - transaction, and 781 - hyper card.

• Changed the list_reports function to return objects only supported by the Report class.

• Added methods to convert connections from DSN to DSN-less format in the DatasourceInstance and DatasourceConnection classes.

• Improved error messages when calling list_dependents and list_dependencies on unsupported objects.

• Added support for the Time type to SuperCube class.

• Added with statement compatibility for Connection object.

• Added a find_objects_with_id function in mstrio.object_management.search_operations to allow searching for an object when knowing only its ID.

• Added checking during creation to see if a SuperCube with given name already exists in a folder and displays an error if it does.

• Added support for Python 3.11

• Altered the attributes.py code snippet to use the list_table_columns and list_logical_tables methods from the table module.

• Updated dependencies in requirements.txt.

• Combined the _update_acl and _modify_rights methods. Added a modify_rights method.

• Added Service and ServiceWithNode classes in the mstrio.server.node module.

MicroStrategy Library Mobile SDK

iOS

• Supports Intune native EMM SDK for iOS 16.

• Supports native integrated Intune SDK for Xcode 14.

MicroStrategy REST APIs

• Retrieve gateway objects.

• Retrieve and update driver objects.

• Retrieve applicable properties for metrics.

• Execute a datamart.

• Set advanced properties for attributes.

• Retrieve, create, and update warehouse/metadata partition mapping tables.

• Apply custom logo and colors to Library.

• Manage mobile subscriptions.

• Edit migrations and migration groups.

Data Sources

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

• Gateway Certifications
  Create connections and run analytics with optimized SQL against the following new gateways:

  • SQL Server 2022

  • PostgreSQL 15

  • Teradata VantageCloud Lake

  • Unity Catalog for Databricks

  • Palantir Foundry

  • Dremio

• OOTB Driver Updates
  Ensure security and reliability with the following updated drivers:

  • Denodo JDBC driver is out-of-the-box

  • Palantir Foundry driver is out-of-the-box

  • Snowflake ODBC driver upgraded to 2.25.7

  • Drill JDBC driver upgraded to 1.6.12.1009

  • SQL Server ODBC driver upgraded to 08.02.1081

• Improved enterprise security with extended data source single-sign-on authentication support using Open ID Connect and oAuth:

  • Support oAuth On-Behalf-Of authentication mode for Google BigQuery against Azure AD through Google’s Workforce Identity Federation.

  • Preview Feature: Support oAuth On-behalf-of authentication mode for Snowflake against Okta.

• Improved data source management in Workstation:

  • Convert DSN-based data sources to DSN-less through Workstation and Python for self-service data source definition in on-prem or cloud environments.

  • A new tab under Data Sources for gateway and driver management. Here you can disable or enable drivers and gateways to limit users' access to them based on enterprise policy.

  • Create and edit data sources for PayPal, Shopify, Marketo, HubSpot, ServiceNow, and Square SaaS gateways.

  • Create and edit data sources against the new Dremio and Palantir Foundry gateways.

Upgrades

During upgrades, the platform installer automatically backs up integral configuration files that can be manually updated by a user; therefore, automating a key manual pre-upgrade step.

---

2021 Update 8 (February 2023)

MicroStrategy Workstation

Create dynamic address lists to dynamically source the recipients list for subscription delivery.

MicroStrategy Embedding SDK

Embed MicroStrategy Report page.

• Users can embed MicroStrategy Report consumption page.

• Users can control the visibility of the navigation bar of the Report consumption page.

---

2021 Update 8 (January 2023)

The January 2023 release includes defect fixes for stability and user experience.

---

2021 Update 8 (December 2022)

MicroStrategy Workstation

• Preview Feature: Administrators can specify different default authentication modes per application to customize the login experience in Library for end users.

• Preview Feature: Create data sources to Palantir Foundry. Manual driver deployment is required.

• Monitor content caches in the Cache Monitor. This former preview feature is available out-of-the-box.

• Administrators can configure the contents, logo and URLs of the notification emails that users get when sharing content and using collaboration in Library. This former preview feature is available out-of-the-box.

• Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more. This former preview feature is available out-of-the-box.

• Time zone based reporting. This former preview feature is available out-of-the-box.

  • Create, edit, delete, and view internationalization objects.

  • Set a project's default time zone.

  • Assign user's default time zone and language.

  • Seamlessly create new time hierarchies with smart attributes.

  • Use a language object to customize smart attribute formatting.

• Localize your metadata objects for all the languages supported by your project.

• Administrators can set default authentication for Library Web.

• Administrators can duplicate user accounts.

• Administrators can delete projects.

• The FreeForm SQL Report Editor allows you to write your own queries to create reports. This former preview feature is available out-of-the-box.

• Define templates for creation of new dossiers.

• For data sources and projects, manage advanced properties for null handling, SQL generation, evaluation order, query optimization, joins, and more.

• Certify migration packages.

• Clear the object and element cache from server memory.

• Monitor and manage quick search indices to re-build them and configure the index directory.

• In dossiers, the same information window can be targeted by two or more visualizations in the page for reusability.

MicroStrategy Web

All Flash entry points in documents have been removed. See KB485844 for more information.

MicroStrategy Library

• MicroStrategy Insights allow users to select key business KPIs from their dossiers and track them all from a single page in Library. Based on the KPIs users track, MicroStrategy helps bring trends and outliers to the surface, as well as alert users with in-app and email notifications.

• Time zone reporting. This former preview feature is available out-of-the-box.

  • Dynamically switch between time zones for your data.

  • Select a preferred time zone for users.

  • Select preferred formatting for smart attributes with a language object. This setting allows you to switch the Library user interface languages as well, if it is one supported out of the box.

• The Report Editor comes to Library. Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more. This former preview feature is available out-of-the-box.

• Set default authentication for Library Web using the Library server config file.

• Define templates for creation of new dossiers.

• In dossiers, the same information window can be targeted by two or more visualizations in the page for reusability.

MicroStrategy Library Mobile

iOS

• Undo or redo dossier manipulations such as filtering, drilling, and sorting.

• Supports Intune native EMM SDK for iOS 16.

MicroStrategy Platform Analytics

Preview Feature: Client telemetry offers a realm of insightful data:

• Developers/BI Architects can discover consumption patterns of a dossier such as page clicks, time elapsed, and so on.

• Administrators can monitor end-to-end performance of the platform, including client-side rendering times.

MicroStrategy Library Mobile SDK

iOS

• Supports MobileIron, AirWatch, and BlackBerry Dynamics SDKs with Xcode 14.

• When you customize MicroStrategy Library Mobile SDK for iOS, you must have an Apple Mac with Monterey 12.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 14.1 with the Apple iOS SDK 16.1, to develop and compile your application.

MicroStrategy Mobile SDK

iOS

• Supports MobileIron, AirWatch, and BlackBerry Dynamics SDKs with Xcode 14.

• When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with Monterey 12.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 14.1 with the Apple iOS SDK 16.1, to develop and compile your application.

MicroStrategy Web SDK

Several APIs have been removed.

MicroStrategy Embedding SDK

• Ability to customize dossier pages from embedding Library home page.

• Ability to customize Library home page from embedding dossier page.

MicroStrategy REST APIs

• Purge object and element caches.

• Delete a project in the project administration workflow.

• Retrieve, create, and update transaction report objects.

• Manage application customized emails.

• Advanced properties for database instances.

• Advanced properties for projects.

• Convert connection string from data source name (DSN) to DSN-less for a data source.

• Manage Watch KPI and Insight service privileges.

Data Sources

• Create and manage data sources in Workstation for the following SaaS sources:

  • Dropbox

  • Google Analytics

  • Google Drive

  • SAP oData Gateways

  • Salesforce Reports

  • Twitter

• Create and manage data sources in Workstation through DSN-less and guided connection definitions to the following additional sources:

  • Azure SQL Database

  • IBM DB2

  • MariaDB

  • MySQL

  • SingleStore

  • Sybase

  • Tibco Data Virtualization

  • Vertica

• Configure OAuth for SAP HANA single-sign-on pass-through authentication.

• Import data from OneDrive and Box using the new data import experience.

• Create connections and run analytics with optimized SQL against Trino.

---

2021 Update 7 (November 2022)

MicroStrategy Library

Export Report Services documents to Excel.

MicroStrategy Packages for Python (mstrio-py)

There are two new Python modules for documents and dossiers. Check out this video to learn more.

---

2021 Update 7 (October 2022)

MicroStrategy Workstation

• Preview Feature: Monitor content caches in the Cache Monitor.

• Subscribe and deliver content with file subscriptions.

• Create user and subscription fences to reserve nodes of a cluster environment with fencing.

• Configure OAuth authentication for Google BigQuery data sources.

• Embedded surveys have been removed.

MicroStrategy Library

Embedded surveys have been removed.

MicroStrategy Web

Embedded surveys have been removed.

MicroStrategy REST APIs

• Duplicate users.

• Manage quick search indices.

---

2021 Update 7 (September 2022)

MicroStrategy Workstation

• Preview Feature: Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more.

• Preview Feature: The FreeForm SQL Report Editor allows you to write your own queries to create reports.

• Preview Feature: A new data import experience with enhanced data source catalog browsing and multi-source data import workflow.

• Preview Feature: Configure the logo, links, and content of the notification email when sharing.

• Move objects between environments using migration packages. This former preview feature is available out-of-the-box.

• Enterprise Security allows the management of Identity and Access management (IAM) objects that encapsulate oAuth profiles that can be used to configure gateways to support OAuth authentication.

• Control advanced properties for incremental refresh reports. Configure metric aggregations, null handling, indexing, and more.

• Manage advanced LDAP settings. See KB485644 and KB485645 for more information.

• The certification symbol for certified dossiers appears in the Content Groups and Applications Editors.

MicroStrategy Library

• Preview Feature: The Report Editor comes to Library. Create and edit reports with your favorite features including the Advanced Properties panel, View Filters, SQL View, and many more.

• Preview Feature: Support OAuth authentication against OAuth-enabled gateways for live connected dossier and report executions.

• Improved color contrast with a more accessible primary blue and overall color palette.

MicroStrategy Library Mobile

iOS

• Preview Feature: Supports OAuth authentication against OAuth-enabled gateways for live connected dossier executions.

• Enhanced iOS 16 and iPadOS 16 compatibility to provide more stable upgrades.

• Improved color contrast with a more accessible primary blue and overall color palette.

Android

Enhanced dossier viewing experience with the ability to undo and redo basic operations such as filtering, drilling, sorting, and so on.

MicroStrategy Mobile

iOS

Enhanced iOS 16 and iPadOS 16 compatibility to provide more stable upgrades.

MicroStrategy Library Mobile SDK

Android

The MicroStrategy Library Mobile SDK for Android is certified to work with Android 13 (API level 33). When you customize MicroStrategy Library Mobile SDK for Android, you must have Android SDK 33 to develop and compile your application. Android Studio Chipmunk and newer is supported.

MicroStrategy Mobile SDK

Android

The MicroStrategy Mobile SDK for Android is certified to work with Android 13 (API level 33). When you customize MicroStrategy Mobile SDK for Android, you must have Android SDK 33 to develop and compile your application. Android Studio Chipmunk and newer is supported.

MicroStrategy Embedding SDK

• The MicroStrategy Embedding SDK help has been moved to GitHub Pages. This allows easier collaboration from the developer community. The new help site has improved page navigation, cleaner design, instant search, and also supports dark mode.

• Embed the MicroStrategy Library home page.

  • Users can also embed any child page accessed from the sidebar, including subscriptions, etc.

  • Control the visibility of the navigation bar and sidebar of the MicroStrategy Library home page.

MicroStrategy REST APIs

The MicroStrategy REST API help has been moved to GitHub Pages This allows easier collaboration from the developer community. The new help site has improved page navigation, cleaner design, instant search, and also supports dark mode.

The MicroStrategy REST API Explorer still remains on the demo site. In addition, we have also released a new REST API Playground.

• Move object migration groups between environments.

• Upload and download migration packages.

• Retrieve, create, and update datamart objects.

• Retrieve, create, and update calendar objects.

• Retrieve, create, and update runtime objects.

• Configure and manage dynamic recipient lists for subscriptions

• Create and edit freeform SQL reports.

• Create and modify reports and their advanced properties.

• Ability to translate metadata objects.

• Retrieve, create, and update language objects.

Data Sources

• Preview Feature: Library supports OAuth authentication against OAuth-enabled gateways for live connected dossiers and reports.

• Support for OAuth authentication to Exasol in MicroStrategy Library and data import.

• Support DSN-less data source creation for the following additional gateways: Spanner, AlloyDB, IBM Netezza, IBM NPS, Yellowbrick, and Denodo.

• Case and CaseV Functions are pushed down to the gateway for SingleStore, Vertica, and mongoDB.

• Edit data sources created during data import in Workstation Data Sources management.

• Create connections and run analytics with optimized SQL against Starburst.

• Convert old manual oAuth configurations in data import to new IAM objects for Snowflake and Azure Synapse. See KB485668 for more information.

• Create connections and run analytics with optimized SQL against upcoming Google AlloyDB for PostgreSQL.

---

2021 Update 6 (August 2022)

MicroStrategy Workstation

• The Intelligent Cube Editor offers control over advanced properties. Configure metric aggregations, null handling, indexing, and more.

• Burst your content for personalized data distribution to multiple recipients dynamically.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

• Added the Transformation, TransformationAttribute, and TransformationAttributeForm classes in the mstrio.modeling.schema.transformation subpackage to allow transformation management.

• Added list_transformations to allow listing for transformations.

• Added the DefaultSubtotals, Dimensionality, DimensionalityUnit, FormatProperty, Metric, MetricFormat, and Threshold classes in the mstrio.modeling.metric subpackage to allow metric management.

• Added list_metrics to allow listing for metrics.

Minor Changes

• Added list_locales to the mstrio.datasource.datasource_map module to allow the listing of locales.

• Added the DatasourceMap.alter() method to allow the altering of user-defined connection mapping.

• Added the list_warehouse_tables() method to the mstrio.modeling.schema.table.warehouse_table module to allow listing of all warehouse tables from all available data sources.

Deprecated

• The mstrio.distribution_services.contact module is deprecated and moved to the mstrio.users_and_groups subpackage.

• The mstrio.distribution_services.contact_group module is deprecated and moved to the mstrio.users_and_groups subpackage.

• The mstrio.access_and_security.security_filter subpackage is deprecated and replaced by the mstrio.modeling.security_filter and mstrio.modeling.expression subpackages.

---

2021 Update 6 (July 2022)

MicroStrategy Workstation

• Monitor objects changes through the change journal. This former preview feature is available out-of-the-box.

• Create and edit FTP subscriptions.

• Lock and unlock projects and configurations.

• Configure and manage job prioritization to ensure better performance for your high priority users.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

Added a Filter class in the mstrio.modeling.filter subpackage to allow filter management.

Added list_filters to allow listing of filters.

Turned off certificate verification when using get_connection.

Minor Changes

Added the ability to pass project_name, instead of project_id, in functions that allowed only project_id in the past.

---

2021 Update 6 (June 2022)

MicroStrategy Library

• Preview Feature: Reports are available for consumption in Library Web! This preview feature allows users to run, favorite, search, and share reports.

• New transaction grids for dossiers allow you to add, edit, or remove data directly from a relational data source in a dossier. You can configure and even pause this functionality with minimal effort, while keeping the same great look and feel with a simplified workflow.

• Administrators can define a set of color palettes available per application, including defining the application’s default palette to apply it automatically during consumption.

• Users can see the list of applications that they have access to and easily switch between them via the Account menu.

• Renamed right-click menu options to clarify the viewing and hiding of containers. Show/Hide on Mobile is renamed to Show/Hide on Responsive View. Show/Hide on Canvas is renamed to Show/Hide on Default View.

• Accessible contextual linking from graphs and other visualizations via the Show Data dialog.

• Improvements to accessibility and dossiers including keyboard and screen reader usage.

• 30% faster undo performance in Library consumption.

• Expanded range selection for subscriptions to Excel and PDF files to include chapter and page level selection.

• The graph engine was upgraded as part of our MicroStrategy Security Assurance Program.  While all efforts are made to minimize impact to graph rendering, there are some noticeable changes to documents as part of this release.  KB485520 describes the specific examples where changes may be seen as part of this upgrade.

MicroStrategy Library Mobile

iOS

• Dossier transaction grids are supported.

• Administrators can define a set of color palettes available per application, including defining the application’s default palette to apply it automatically during consumption.

Android

• Dossier transaction grids are supported.

• Administrators can define a set of color palettes available per application, including defining the application’s default palette to apply it automatically during consumption.

• Automatically execute a dossier or document after scanning a barcode.

MicroStrategy Workstation

• Preview Feature: Reports include support for prompts, page-by, SQL view in execution mode, and drilling.

• Preview Feature: Move your content across the platform via migration packages. You can choose to move project-related objects, administration objects, or merge entire projects together. You can also enable monitoring of content movement in the Migrations section of the Workstation window.

• Preview Feature: Easily modify the Library logo using the application Appearance Editor.

• New transaction grids for dossiers allow you to add, edit, or remove data directly from a relational data source in a dossier. You can configure and even pause this functionality with minimal effort, while keeping the same great look and feel with a simplified workflow.

• Edit and configure customized drill paths.

• Associate a drill map with a consolidation.

• Define and create your own special aggregation rules with custom subtotals.

• Determine the data refresh mechanism for your Intelligent cubes by using incremental refresh reports.

• Accessible contextual linking from graphs and other visualizations via the Show Data dialog.

• Improvements to accessibility and dossiers including keyboard and screen reader usage.

• Renamed right-click menu options to clarify the viewing and hiding of containers. Show/Hide on Mobile is renamed to Show/Hide on Responsive View. Show/Hide on Canvas is renamed to Show/Hide on Default View.

• Import SAP HANA calculation views with input parameters into the Modeling schema.

• Configure SameSite cookies for Library via a user interface, instead of manually editing files.

• The graph engine was upgraded as part of our MicroStrategy Security Assurance Program.  While all efforts are made to minimize impact to graph rendering, there are some noticeable changes to documents as part of this release.  KB485520 describes the specific examples where changes may be seen as part of this upgrade.

MicroStrategy Web

• New authoring features are not implemented in MicroStrategy Web. Please note that users must be on MicroStrategy Library or MicroStrategy Workstation to access all new features starting with this release. Moving forward, new features will no longer be available in MicroStrategy Web. This is to ensure an optimized analytics experience with high performance.

• Renamed right-click menu options to clarify the viewing and hiding of containers. Show/Hide on Mobile is renamed to Show/Hide on Responsive View. Show/Hide on Canvas is renamed to Show/Hide on Default View.

• Configure SameSite cookies for MicroStrategy Web and MicroStrategy Mobile via a user interface, instead of manually editing files.

• The graph engine was upgraded as part of our MicroStrategy Security Assurance Program.  While all efforts are made to minimize impact to graph rendering, there are some noticeable changes to documents as part of this release.  KB485520 describes the specific examples where changes may be seen as part of this upgrade.

MicroStrategy Platform Analytics

Improved monitoring and troubleshooting after the Intelligence server crashes by capturing job telemetry during initial job creation.

MicroStrategy Packages for Python (mstrio-py)

Major Changes

• New LogicalTable, PhysicalTable, and WarehouseTable classes in the mstrio.modeling.schema.table module to allow table management.

• New list_logical_tables(), list_physical_tables(), list_datasource_warehouse_tables(), and list_namespaces() functions to allow the listing and searching of specific tables in the project.

Minor Changes

• New search_pattern and project_id parameters in the object listing functions.

• New move method added to Folder, Object, SecurityFilter, Attribute, Fact, UserHierarchy, Report, Shortcut, SearchObject, Document, and Dossier to allow the moving of objects between folders

• Added create_copy method in SecurityFilter, Attribute, Fact, UserHierarchy, Report, Shortcut, SearchObject, Document, and Dossier.

Deprecated

The name_begins parameter is deprecated in functions listing cubes and reports in favor of the name parameter.

See the mstrio-py help for more information.

MicroStrategy Library Mobile SDK

iOS

• Configure a specific application URL as an entry point.

• When you customize MicroStrategy Library Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

Android

• The Library Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize MicroStrategy Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio Bumblebee and newer is supported.

• Configure a specific application URL as an entry point.

MicroStrategy Mobile SDK

iOS

When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

Android

The MicroStrategy Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize MicroStrategy Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio Bumblebee and newer is supported.

MicroStrategy Web SDK

Several APIs have been modified.

MicroStrategy REST APIs

• Create and edit user and workload fences.

• Create and edit drill maps.

• Create and edit Incremental Refresh Reports (IRR).

• Create and manage cube objects with advanced properties.

• Create and manage SAP HANA tables with input parameters.

• Create and import migration packages just as in Workstation. This allows all packages to be managed by the MicroStrategy Storage Service so migration processes can be monitored in Workstation.

Authentication

Support for SAML single logout.

Data Sources

• Gateway Certifications:

  • Yellowbrick 5.x

• OOTB Driver Updates:

  • Big Query ODBC: 2.4.6.1015

  • Big Query JDBC: 1.2.23.1027

  • Spark ODBC driver 2.6.23.1039

  • Spark JDBC 2.6.26.1045

  • Impala ODBC 2.6.16.1022

• Functionality Enhancements:

  • Delta Lake format support via Cloud Storage Connector for ADLS2, Amazon S3, and Google Cloud Storage

  • Ability to access cross-account buckets in S3

• Security and Performance Enhancements

  • Case and CaseV Functions have been pushed down to the database side for Azure Synapse and Db2.

  • Secure transaction certification for Snowflake and SingleStore

---

2021 Update 5.2 (May 2022)

Released on May 20, 2022

MicroStrategy HyperIntelligence

This version of HyperIntelligence is based on Google's new manifest version, Manifest V3. New browser requirements apply. The browser must be Chrome v99 or later.

MicroStrategy Workstation

• Create contacts and contact groups to subscribe to content in subscriptions. This former preview feature is available out-of-the-box.

• Create connection mappings to ensure data security for content.

• View and edit security access for projects.

• Delete data sources from the revamped Data Sources dialog.

MicroStrategy Packages for Python (mstrio-py)

• A Fact class in the mstrio.modeling.schema.fact subpackage allows fact management.

• A list_facts function allows the listing of facts.

See the mstrio-py help for more information.

Data Sources

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

1. OOTB Driver Updates:

• Oracle ODBC Driver

• Sybase ASE ODBC driver

• Drill ODBC Driver

2. Functionality Enhancements

• Support for Kerberos and LDAP authentication modes in Modern Data Source Management in Workstation

• TLS Support for ODBC connectivity in Modern Data Source Management

Released on May 12, 2022

This release provides remediation for a group of security vulnerabilities found within Java by upgrading the Java version to 11.0.15+10 across products. Learn more.

---

2021 Update 5.1 (April 2022)

Released on April 22, 2022

MicroStrategy Workstation

• Configure subscription delivery types in your environment for content delivery.

• Create and edit delivery devices to package content for seamless delivery.

• Preview Feature: Create contacts and contact groups to subscribe to content in subscriptions.

• Preview Feature: Create reports using the Report Editor.

Android

• Subscribe to the entire dossier content in PDF or Excel format to send updates directly to your email inbox.

• Export entire dossiers to Excel.

MicroStrategy Packages for Python (mstrio-py)

• New Attribute class in the mstrio.modeling.schema.attribute subpackage allows attribute management.

• New AttributeForm class in the mstrio.modeling.schema.attribute_form subpackage allows attribute form management.

• New list_attributes allows listing of attributes.

• New list_functions in the mstrio.modeling.expression subpackage allows listing of functions.

• New act_expression, expression, expression_nodes, parameters, and dynamic_date_time modules in the mstrio.modeling.expression subpackage allow management of fact expressions.

• ExecutionMode elements have been changed from ASYNCH_CONNECTION to ASYNC_CONNECTION and from ASYNCH_STATEMENT to ASYNC_STATEMENT.

• Refactored examples in the code_snippets folder, with modifications to make them easier to use in MicroStrategy Workstation.

• Renamed the workstation_demos folder to workflows.

MicroStrategy Cloud Platform

• Increased default sizes for EBS and disk for all MicroStrategy Cloud environments to better support smart memory, increasing data scalability.

• Increased throughput for shared storage from 25 MB to 40 MB for all MicroStrategy Cloud environments. This optimizes deployment and overall performance.

Released on April 7, 2022

This release includes remediations for CVE-2022-22965 by upgrading Spring Framework libraries version to 5.3.18.

---

2021 Update 5 (March 2022)

MicroStrategy Workstation	MicroStrategy Mobile SDK
MicroStrategy Web	MicroStrategy Packages for Python (mstrio-py)
MicroStrategy Library	MicroStrategy Visualization SDK
MicroStrategy Library Mobile	MicroStrategy REST APIs
Intelligence Server	MicroStrategy Cloud Platform
MicroStrategy Platform Analytics	Data Sources
MicroStrategy Library Mobile SDK

MicroStrategy Workstation

• Easily display and compare one or more key metrics on a scale using thresholds with a Gauge visualization.

• Waterfall chart setting to dynamically color the start point according to increase or decrease for enhanced precision.

• A new KPI section houses multi-metric, comparison, and classic KPIs.

• Sankey and Time Series visualizations appear in the More section.

• Setting to control how users dismiss information windows with the option to enable a close button.

• Lock specific filter selections to disable interactions in the Filter panel.

• Options for vertical scrolling have been extended to allow authors to expand the canvas while retaining the existing content dimensions.

• Create transformations.

• Create custom groups.

• Create and edit history list subscriptions.

• View and edit log configuration settings.

• Create Intelligent cubes. This former preview feature is available out-of-the-box.

• Improve report and cube performance against the data warehouse by using an attribute form caching Intelligence cube.

• Shortcuts allow architects to organize their objects in a way that is more accessible and convenient for both the end-users and the architecture team managing them. Right-click an object anywhere on the Workstation window to create a shortcut.

• Customize user delivery addresses in the User Editor.

• Easily manage and distribute content groups to users or user groups for viewing across Library applications. This former preview feature is available out-of-the-box.

• Preview Feature: Monitor objects changes through the change journal.

• Request and configure a new ESRI key. This is required for ESRI maps to continue to display starting in this release. ESRI map styles have been updated for enhanced readability.

• Open and edit a dossier without loading the data.

• MicroStrategy Storage Service adds a local or remote repository for Library server. This former preview feature is available out-of-the-box. In this release, the following new features have been added:

  • Amazon S3 is supported.

  • The database is configured automatically in both on-premises and cloud environments.

  • Shared storage is configured through Workstation.

MicroStrategy Web

• Easily display and compare one or more key metrics on a scale using thresholds with a Gauge visualization.

• Waterfall chart setting to dynamically color the start point according to increase or decrease for enhanced precision.

• A new KPI section houses multi-metric, comparison, and classic KPIs.

• Sankey and Time Series visualizations appear in the More section.

• Setting to control how users dismiss information windows with the option to enable a close button.

• Lock specific filter selections to disable interactions in the Filter panel.

• Options for vertical scrolling have been extended to allow authors to expand the canvas while retaining the existing content dimensions.

• Request and configure a new ESRI key. This is required for ESRI maps to continue to display starting in this release. ESRI map styles have been updated for enhanced readability.

MicroStrategy Library

• Easily display and compare one or more key metrics on a scale using thresholds with a Gauge visualization.

• Waterfall chart setting to dynamically color the start point according to increase or decrease for enhanced precision.

• A new KPI section houses multi-metric, comparison, and classic KPIs.

• Sankey and Time Series visualizations appear in the More section.

• Setting to control how users dismiss information windows with the option to enable a close button.

• Lock specific filter selections to disable interactions in the Filter panel.

• Options for vertical scrolling have been extended to allow authors to expand the canvas while retaining the existing content dimensions.

• Open and edit a dossier without loading the data.

• Rename a dossier from the File menu.

• An updated, modern Save and Save As dialog.

• View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

• Request and configure a new ESRI key. This is required for ESRI maps to continue to display starting in this release. ESRI map styles have been updated for enhanced readability.

MicroStrategy Library Mobile

iOS

• View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

• Lock specific filter selections to disable interactions in the Filter panel.

Android

Lock specific filter selections to disable interactions in the Filter panel.

Intelligence Server

• Preview Feature: The metadata, Distribution Service, and History List repositories support JDBC connection with PostgreSQL.

MicroStrategy Platform Analytics

Client Telemetry data can be purged in Platform Analytics. This completes full parity with Enterprise Manager for Client Telemetry.

MicroStrategy Library Mobile SDK

iOS

When you customize MicroStrategy Library Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

MicroStrategy Mobile SDK

iOS

• BlackBerry certification to support iOS 15 with Xcode 13.1.

• MobileIron certification to support iOS 15 with Xcode 13.1.

• When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 or Apple M1 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

MicroStrategy Packages for Python (mstrio-py)

You can use the mstrio-py Python library and its dependencies when using Python within Workstation. Download the mstrio-py Python library through PyPi or GitHub. See the mstrio-py help help for a complete guide of the available modules for MicroStrategy data science and system administration tasks. New features include:

• Preview Feature: A Python module for object migrations. Use Python to create a migration package on the source and deploy it on a target environment. You do not have to enable preview features in Workstation to use this functionality.

• A SchemaManagement class in the mstrio.modeling subpackage that allows schema management.

• A UserHierarchy class in the mstrio.modeling subpackage that allows user hierarchy management.

• A list_user_hierarchies function that allows the listing of objects in the newly created UserHierarchy class.

MicroStrategy Visualization SDK

Tag custom visualizations to appear in relevant sections of the Visualization Gallery.

MicroStrategy REST APIs

• Retrieve, create, and update metric objects.

• Retrieve, create, and update transformation objects.

• Retrieve, create, and update base formula objects.

• Retrieve, create, and update subtotal objects.

• Retrieve, create, and update cube objects.

• Create, edit, and delete history list subscriptions.

MicroStrategy Cloud Platform

• Deploy Azure Enterprise Environments in the UAE North Region

• Support for Azure environments in the Switzerland North Region. Now customers in this region can select from Team, Department, or Enterprise environments.

Data Sources

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

1. Gateway Certifications

   • Vertica 11.0.2

   • Denodo 8.0

2. OOTB Driver Updates

   • Snowflake ODBC and JDBC Driver

   • Google BigQuery ODBC and JDBC Driver

   • Cloudera Hive and Impala JDBC Driver

   • Driver Manager files on Linux Platform

   • SQL Server JDBC Driver

   • MongoDB JDBC Driver

   • SAP HANA ODBC Driver

   • Salesforce ODBC Driver

   • Drill JDBC Driver

   • Spark SQL JDBC Driver

   • Concur JDBC Driver

   • Eloqua JDBC Driver

   • HubSpot JDBC Driver

   • Marketo JDBC Driver

   • ServiceNow JDBC Driver

   • Shopify JDBC Driver

   • Square JDBC Driver

3. Security and Performance Enhancements

   • Case and CaseV functions have been pushed to the gateway side for PostgreSQL, SQL Server, Redshift, MySQL, Google BigQuery, Impala, Spark SQL, Hive, and Oracle 21c.

   • Enable secure transaction in a live metadata update for SQL Server

4. Functionality Enhancements

   • Simple mode data source management for major Diamond and Platinum gateways with support of JDBC TLS configuration.

---

2021 Update 4.1 (February 2022)

The February release includes security, performance, and user experience updates to:

• HyperMobile for Android and iOS

• Library Mobile for Android and iOS

• Workstation for macOS and Windows

---

2021 Update 4.1 (January 2022)

Released on January 28, 2022

MicroStrategy Library Mobile

iOS

Support for native integrated Intune SDK with Xcode 13.1.

Android

Optimized data encryption and security. See KB485325 for more information.

MicroStrategy Mobile

iOS

Support of native integrated AirWatch SWIFT SDK with Xcode 13.

MicroStrategy Packages for Python (mstrio-py)

• The following have been added:

  • Contact class in the mstrio.distribution_services.contact subpackage to allow contact management

  • ContactGroup class in the mstrio.distribution_services.contact_group subpackage to allow contact group management

  • Device class in the mstrio.distribution_services.device subpackage to allow device management

  • Transmitter class in the mstrio.distribution_services.transmitter subpackage to allow transmitter management

  • list_contact, list_contact_groups, list_devices, list_transmitters functions to allow listing of objects of newly created classes

  • PackageConfig class in the mstrio.server.migration subpackage with support for PackageSettings and PackageContentInfo, used for configuration migration

  • Delete functionality to the Document, Dossier, and Report classes

• The Event class has been extended in the mstrio.distribution_services.event subpackage with functionalities to create, update, and delete events.

• The Connection object attribute, session, has been renamed to _session.

• The get, head, post, put, delete, and patch HTTP request methods can be added to the Connection object.

• Change the Connection object to automatically renew the connection or reconnect when the session becomes inactive if authenticated with login and password.

• Connect to your MicroStrategy environment using the Connection class.

  The UseLibrary privilege is required to log into Library

• Import and filter data from OlapClub, SuperCube, or Report into a Pandas DataFrame.
• Export data into MicroStrategy by creating or updating SuperCube.
• The following administration modules are included:
  • Project management module
  • Server management module
  • User and Usergroup management modules
  • Schedules management module
  • Subscription management modules, including email subscription and cache update subscription
  • Document and Dossiers in User Library modules
  • User Connections management module
  • Privilege and Security Role management modules
  • Cube Cache management module
  • Intelligent cube management module
  • Security Filter module
  • Datasources subpackage for database management
  • Job Monitor module
  • Object Management module
  • Contact module
  • Contact Group module
  • Device module
  • Transmitter module
  • Event module

See the mstrio-py help for more information.

Released on January 10, 2022

This release includes remediations for CVE-2021-45105 and CVE-2021-44832 by upgrading to Apache Log4j 2 version to 2.17.1.

MicroStrategy 2021 Update 4.1 includes the following three remediated vendor drivers, which have been upgraded to Log4j 2.17:

• Magnitude SparkSQL

• Hive

• ImpalaJDBC

---

2021 Update 4 (December 2021)

This release includes remediations for CVE-2021-44228 and CVE-2021-45046 by upgrading to Apache Log4j 2 versions to 2.16.0.

MicroStrategy 2021 Update 4 includes three third-party, vendor-provided drivers with embedded Log4j libraries. MicroStrategy has determined these libraries are vulnerable. We are working with the vendors to make remediated drivers available. In the interim, we recommend mitigation steps to be taken on the following systems where these drivers are present: MicroStrategy Intelligence Server and MicroStrategy Workstation. Environments deployed in the MicroStrategy Cloud have these supplemental mitigation steps already applied.

Mitigation steps are detailed in MicroStrategy’s response to the Log4j Vulnerability (CVE-2021-44228) and (CVE-2021-45046).

Platform Certifications

Changes to the support matrix for third-party software will come into effect after June 2022. See KB485274 and Platform Certifications for more information.

MicroStrategy Workstation

• Show or hide objects.

• Design and create custom applications for unique Library viewing experiences based on user or user group requirements.

• Provide in-context data without taking up permanent screen real estate with information windows in dossier. Trigger information windows from an image, text box, or visualization.

• After searching for a location on a Geospatial Service visualization, a pin automatically drops so you can easily interact with the selectors to discover what points of interest are within range.

• Preview Feature: Create Intelligent cubes using the Intelligent Cube Editor.

• Preview Feature: Move objects between environments using migration packages.

• Preview Feature: Easily manage and distribute content groups to users or user groups for viewing across Library applications.

• Preview Feature: MicroStrategy Storage Service adds a local or remote repository for Library server.

MicroStrategy Web

• Provide in-context data without taking up permanent screen real estate with information windows in dossier. Trigger information windows from an image, text box, or visualization.

• After searching for a location on a Geospatial Service visualization, a pin automatically drops so you can easily interact with the selectors to discover what points of interest are within range.

• By default, the Convert to Document button is no longer available from the File menu in dossier authoring. Dossier’s latest, modern workflows are not compatible with document features. If you need to enable this setting, go to /webapps/MicroStrategy/WEB-INF/xml/sys_defaults.xml on the Web server. Then change the value in Allow Dossier to RSD conversion from 0 to 1 and restart the Web server.

MicroStrategy Library

• Connect to multiple app workspaces to view customized Library experiences.

• Edit or create new dossiers all within the Library interface.

• View the My Content section in the Sidebar menu to filter by all content that you own.

• Subscribe to dossier content in PDF or Excel format to send updates directly to your email inbox.

• Undo or redo dossier manipulations such as filtering, drilling, and sorting.

• Provide in-context data without taking up permanent screen real estate with information windows in a dossier. Trigger information windows from an image, text box, or visualization.

• After searching for a location on a Geospatial Service visualization, a pin automatically drops so you can easily interact with the selectors to discover what points of interest are within range.

• Preview Feature: View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

MicroStrategy Library iOS

• Connect to and switch between multiple app workspaces to view customized Library experiences.

• View the My Content section in the Sidebar menu to filter by all content that you own.

• Subscribe to dossier content in PDF or Excel format to send updates directly to your email inbox.

• Provide in-context data without taking up permanent screen real estate with information windows in a dossier. Trigger information windows from an image, text box, or visualization.

• Preview Feature: View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

MicroStrategy Library Android

• Connect to and switch between multiple app workspaces to view customized Library experiences.

• View the My Content section in the Sidebar menu to filter by all content that you own.

• Provide in-context data without taking up permanent screen real estate with information windows in a dossier. Trigger information windows from an image, text box, or visualization.

• Preview Feature: View default content groups in the Sidebar menu pushed automatically to your Library application by administrators.

MicroStrategy Library Mobile SDK

iOS

When you customize Library Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

Android

The Library Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize Library Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio 4.2 and up is supported.

MicroStrategy Mobile SDK

iOS

When you customize MicroStrategy Mobile SDK for iOS, you must have an Apple Mac with BigSur 11.6 and above using an Intel x86 chip machine, running Xcode® 13.1 with the Apple iOS SDK 15, to develop and compile your application.

Android

The MicroStrategy Mobile SDK for Android is certified to work with Android 12 (API level 31). When you customize MicroStrategy Mobile for Android, you must have Android SDK 31 to develop and compile your application. Android Studio 4.2 and up is supported.

MicroStrategy Web SDK

Several APIs have been deprecated.

MicroStrategy Embedding SDK

• Enhancements for authoring an embedded dossier.

• Control the display of items in authoring toolbar.

• Control the display of authoring panels.

• Support for creating a new dossier.

• Show or hide all entries for a subscription.

Installation

Install updates using a full platform installer on Windows and Linux. See KB485278 for more information.

Data Sources

• Microsoft SQL Server 2019 Analysis Services is certified.

• Cloudera Data Platform (CDP) Private Cloud Base 7.1 is certified.

• Secure text input through parameterized queries has been extended to transaction inputs in transaction services reports and documents. See KB485174 for more information and a list of certified gateways that are automatically enabled with each MicroStrategy 2021 Update release.

---

2021 Update 3 (November 2021)

MicroStrategy Mobile SDK

iOS

Support for MobileIron with iOS 15.

---

2021 Update 3 (October 2021)

MicroStrategy Library

Export to PDF filter summaries include the full attribute and metric names.

MicroStrategy Library Mobile

iOS

Export entire dossiers to Excel.

MicroStrategy Mobile SDK

iOS

Supports BlackBerry Dynamics native EMM SDK with iOS 15.

MicroStrategy Library Mobile SDK

iOS

Supports Intune native EMM SDK with iOS 15.

MicroStrategy Packages for Python (mstrio-py)

• A new CacheUpdateSubscription class in the subscription module.

• Return a specific type of subscription object using list_subscriptions.

• The inner structure of mstrio.distribution_services.subscription was changed. Make sure to import from mstrio.distribution_services or mstrio.distribution_services.subscription at most. Anything deeper is considered internal implementation detail and not guaranteed to remain stable.

• New user and user_group arguments added to the list_security_filters function to allow filtering results by user or user group.

• New list_security_filter method and security_filters property for the UserGroup class.

• New list_security_filter method security_filters property for the User class.

---

2021 Update 3 (September 2021)

MicroStrategy HyperIntelligence	MicroStrategy Mobile
MicroStrategy Workstation	MicroStrategy Web SDK
MicroStrategy Web	MicroStrategy Embedding SDK
MicroStrategy Library	MicroStrategy REST APIs
Federated Analytics	Data Sources
MicroStrategy Command Manager	Privileges

MicroStrategy HyperIntelligence

Add contextual dosser links to HyperIntelligence cards.

MicroStrategy Workstation

• Create and edit user hierarchies.
• View the system hierarchy of a project.
• Manage and monitor jobs.
• Create and edit cache update subscriptions.
• Compare environment configurations.
• Use a Multi-Metric KPI to provide a quick performance indication for two or more metrics.
• Use a Comparison KPI to indicate the progress towards an objective, like sales and goal.
• For every dossier object, experience an intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.
• From the Layers panel, drag and drop existing visualizations and objects from the canvas into panels in dossier panel stacks.
• Support a new MDX/OLAP data source of Kyligence for hierarchy reporting.
• Applications have been renamed to projects.

• Better control of how attributes are related in data import Intelligent cubes (also known as Super Cubes) with a single Attribute Relationship Model setting. This feature requires a data engine version of 2021 or above.

• Preview Feature: Add information windows in dossiers. Information windows are dynamic popups that enhance the visual interactivity for the end-user.

MicroStrategy Web

• Use a Multi-Metric KPI to provide a quick performance indication for two or more metrics.
• Use a Comparison KPI to indicate the progress towards an objective, like sales and goal.
• For every dossier object, experience an intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.
• From the Layers panel, drag and drop existing visualizations and objects from the canvas into panels in dossier panel stacks.
• Support a new MDX/OLAP data source of Kyligence for hierarchy reporting.
• Manage SAML configuration files in a Web browser.

MicroStrategy Library

Export entire dossiers to Excel.

Federated Analytics

MicroStrategy for Power BI

Support for OIDC authentication.

MicroStrategy Command Manager

Enable, disable, and list mobile telemetry settings of Platform Analytics statistics properties through Command Manager.

MicroStrategy Mobile

Manage SAML configuration files in a Web browser.

MicroStrategy Web SDK 

Several APIs have been deprecated.

MicroStrategy Visualization SDK

Create a Format panel using a React-based framework.

MicroStrategy Embedding SDK

• Author an embedded dossier.

• Enable the selection of attribute elements.

MicroStrategy REST APIs

• View a newly created migration package.
• View content from an uploaded migration package.

Data Sources

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

1. Gateway Certifications

   • Azure PostgreSQL is certified. See KB485177 for more information.
   • Azure SQL Managed Instance is certified. See KB485172 for more information.

2. OOTB Driver Updates

   • The latest ODBC trace file, drivers for SQL Server, IBM Db2, Redshift, Oracle, and SAP HANA gateways are out-of-the-box, optimizing security and performance.

3. Security and Performance Enhancements

   • OAuth authentication is supported via ADFS authentication for Snowflake.
   • OAuth authentication is supported via Cognito for Amazon S3.

   • Azure SQL Database single sign-on (SSO) support extends to JDBC driver.

   • SSL is enabled by default for PostgreSQL in MicroStrategy Web and Workstation.
   • SSL is enabled by default for SQL Server in MicroStrategy Web and Workstation.
   • The following functions have been pushed to the gateway side for PostgreSQL:
     • RunningStdevPFunction
     • MovingStdevPFunction
     • MovingStdevFunction
     • RunningStdevFunction
     • LagFunction
     • LeadFunction
     • ToNumberFunction
     • StrLastPositionFunction
     • StrBeginsWithFunction
     • StrEndsWithFunction
     • StrCharFunction
     • StrReplaceFunction
     • StrRepeatFunction

4. Functionality Enhancements

   • Connect to the Salesforce Sandbox instance through the Salesforce Report connector.

Privileges

See Privileges by License Type for information about license types and associated privileges.

The Manage Application privilege has been added to the Server - Intelligence license.

---

2021 Update 2 (August 2021)

The August release includes defect fixes for stability and user experience.

---

2021 Update 2 (July 2021)

MicroStrategy Workstation

• Create and edit consolidations.
• Display a customized interface based on a user's assigned privileges.

---

2021 Update 2 (June 2021)

MicroStrategy HyperIntelligence	MicroStrategy Packages for Python
MicroStrategy Workstation	MicroStrategy for Office
MicroStrategy Web	MicroStrategy Embedding SDK
MicroStrategy Library	MicroStrategy REST APIs
MicroStrategy Library Mobile	Data Sources
MicroStrategy Mobile	Privileges

MicroStrategy HyperIntelligence

• Control the default on/off state of HyperIntelligence cards on HyperWeb.
• Create Hyper cards with the Compact template ideal for landscape viewing and sharing via Twitter.
• Generate a white-labeled HyperIntelligence for Web add-in via MicroStrategy Workstation.
• Improved app accessibility with contrast-friendly colors.

MicroStrategy Workstation

• Create and certify Python scripts.
• Dedicated Python Script Gallery section with Python mstrio modules, sample Python scripts, Python code snippets, and built-in search for easy navigation.
• Python Script Gallery tooltip with insight on how to use classes and functions, with usage examples.
• A time series visualization that enables common financial and market analysis workflows.
• A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
• Add rich formatting to text boxes to create compelling infographic dossiers.
• Intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.
• Edit panel stacks with an intuitive tree structure in the Layers panel, use filters outside panel stacks to target dynamic text boxes, and copy and move panel stacks across chapters and pages.
• Panels in dossier panel stacks are executed on demand to improve performance.
• Create and edit schedules.
• Manage and monitor jobs.
• Change ownership of subscriptions.
• Create, edit, and manage security filters.
• View component and dependent objects.
• Create multiple types of objects such as filters, metrics, prompts, security filters, attributes, and facts in one place. To access this functionality, open the main Workstation window and click next to Objects.
• View and edit Library Administration settings in Workstation.

MicroStrategy Web

• A time series visualization that enables common financial and market analysis workflows.
• A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
• Add rich formatting to text boxes to create compelling infographic dossiers.

• Intuitive Format panel with visual cues, organized into three consistent tabs for visualization or object specific options, text and form, and container. Collapsible folders and toggles make it easy to find what you're looking for.

• Edit panel stacks with an intuitive tree structure in the Layers panel, use filters outside panel stacks to target dynamic text boxes, and copy and move panel stacks across chapters and pages.

• Panels in dossier panel stacks are executed on demand to improve performance.

• Basic OIDC authentication support.
• The Admin pages support basic authentication when SAML authentication is enabled for Web.

MicroStrategy Library

• Enhanced OIDC authentication workflows for automatic and seamless login.
• A time series visualization that enables common financial and market analysis workflows.
• A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
• Add rich formatting to text boxes to create compelling infographic dossiers.
• Panels in dossier panel stacks are executed on demand to improve performance.
• Enhanced accessibility with a new F6 keyboard shortcut allowing for quick navigation between regions.
• Improved ability to navigate throughout Dossier containers in a logical order using screen readers and keyboard controls.

MicroStrategy Library Mobile

iOS

Improved graph readability with y-axis word-wrap, nested labels, and bar chart label positioning.

Android

Panels in dossier panel stacks are executed on demand to improve performance.

iOS and Android

• Enhanced OIDC authentication workflows for automatic and seamless login.
• A time series visualization that enables common financial and market analysis workflows.
• A modern grid visualization that allows you to include microcharts within cells and support one-click contextual linking.
• Add rich formatting to text boxes to create compelling infographic dossiers.

MicroStrategy Mobile

iOS and Android

Basic OIDC authentication support.

MicroStrategy Packages for Python (mstrio-py)

• A new Schedule class in the mstrio.distribution_services.schedule subpackage.
• A new ScheduleTime class in the mstrio.distribution_services.schedule subpackage, which is a local object used for specifying time related properties of schedule.
• A new Event class in the mstrio.distribution_services.event subpackage.
• The Subscription class has been modified to use Schedule objects.
• A new datasources subpackage with Dbms, DatabaseConnections, DatasourceInstance, DatasourceLogin, DatasourceMap classes covering database management functionality.
• New list_available_dbms, list_datasource_connections, list_datasource_instances, list_datasource_logins, and list_datasource_mappings functions that list all data source related objects.
• A database_connections module that allows you to browse and manage database connections to the environment.
• New ACL management functionality for all supporting objects by adding list_acl, acl_add, acl_remove, and acl_alter methods.
• A SecurityFilter class and list_security_filters function in the mstrio.access_and_security.security_filter subpackage
• A new Qualification class in the mstrio.access_and_security.security_filter subpackage, which is an object used to represent a security filter qualification.
• New PredicateBase, PredicateForm, PredicateElementList, PredicateFilter, PredicateJointElementList, and LogicOperator classes in the mstrio.access_and_security.security_filter subpackage to represent predicates that can be used when creating a security filter qualification.
• New ParameterBase, ConstantParameter, ObjectReferenceParameter, ExpressionParameter, PromptParameter, DynamicDateTimeParameter, and ConstantArrayParameter classes in the mstrio.access_and_security.security_filter subpackage to represent the parameters used in AttributeForm.
• mstrio.admin.schedule has been replaced with the mstrio.distribution_services.schedule subpackage.
• The schedules_id argument has been replaced by schedules in the create and alter methods of the Schedule class.
• mstrio.distribution_services.schedule.ScheduleManager has been replaced with mstrio.distribution_services.schedule.list_schedules().

See the mstrio-py help for more information.

MicroStrategy for Office

Generate the manifest file for the MicroStrategy for Office add-in from MicroStrategy Web.

MicroStrategy Embedding SDK

• Interact with panel stacks in dossiers.
• Embed a single visualization.

MicroStrategy REST APIs

• Create and manage user hierarchy objects.
• Create and manage custom group objects.
• Create and manage consolidation objects.
• Create and import migration packages.
• Retrieve SQL statements and query details.

Data Sources

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

1. New Gateways
   • New Gateway Connector for Microsoft Dynamics 365.
   • New Gateway Connector for Databricks.
2. OOTB Driver Updates

   • Exasol ODBC and JDBC drivers are shipped out-of-the-box.

3. Security and Performance Enhancements

   • Oracle Cloud Wallet authentication files are supported end-to-end for Oracle Cloud environments.

   • Azure Active Directory is supported via SAML authentication tokens for Snowflake, Azure SQL Database (ODBC Driver), and Azure Synapse Analytics (ODBC Driver).

   • Azure Active Directory is supported via OIDC tokens for Snowflake, Google BigQuery, Azure SQL Database (ODBC Driver), and Azure Synapse Analytics (ODBC Driver).

   • Google Cloud Storage supports authentication via OAuth and Service Account workflows.

4. Functionality Enhancements

   • Financial Force, Veeva CRM, and ServiceMax have been integrated through the Salesforce Connector.

Privileges

See Privileges by License Type for information about license types and associated privileges.

The following privileges have been added to the Server - Intelligence license:

• Create and edit content bundles

• Certify Python Script

The following privileges have been added to the Architect license:

• Create package

• Apply package

---

2021 Update 1 (May 2021)

Workstation

• Create and edit derived elements for a report.
• Create and edit object prompts.

Federated Analytics

MicroStrategy Packages for Python (mstrio-py)

• Modified file structure to organize modules in clean and readable way.
• New and improved type hints across the code base.
• New PrivilegeMode, IdleMode, GroupBy, ServiceAction, Rights, and Permissions enums.
• A new Node class to be used for node management in place of a raw dict.
• A new CubeCache class added to the mstrio.application_objects.datasets subpackage.
• The load_cube method can load cubes by name.
• New list_cube_caches, delete_cube_caches, and delete_cube_cache functions.
• New create, update, get_sql_view, and publish methods for the OlapCube class.
• A new unpublish method for the OlapCube and SuperCube classes.
• A new list_reports function for the Report module.
• New alter and list_properties methods for the Report class.
• The id parameter replaces the report_id parameter in the Report class.

See the mstrio-py help for more information.

---

2021 Update 1 (April 2021)

MicroStrategy Workstation

Create and edit value prompts.

Federated Analytics

MicroStrategy Packages for Python (mstrio-py)

• The following have been added:

  • SuperCube and OlapCube in the mstrio.application_objects.datasets subpackage
  • list_all_cubes, load_cube, list_super_cubes, and list_olap_cubes functions that allow you to search for cubes by name and construct precise objects
  • user_id, user_full_name, user_initials to the Connection class
  • trust_id and database_auth_login parameters in the user.alter() method
  • More Cube object attributes similar to other MicroStrategy objects
• Alter the name, description, and abbreviation properties of cubes.

See the mstrio-py help for more information.

---

2021 Update 1 (March 2021)

MicroStrategy HyperIntelligence	MicroStrategy Mobile
MicroStrategy Workstation	MicroStrategy Library Mobile SDK
MicroStrategy Web	MicroStrategy REST APIs
MicroStrategy Library	MicroStrategy Cloud Platform
MicroStrategy Library Mobile	Data Sources
MicroStrategy Intelligence Server	Privileges

MicroStrategy HyperIntelligence

• Performance and stability are optimized for HyperIntelligence cards that are enabled with pattern matching:
  • Improved pattern detection and card rendering performance on HyperWeb and HyperOffice for 8-10 million rows of data.
  • Decreased loading time when authoring a card based on a large dataset in MicroStrategy Workstation.
  • Improved speed when enabling a card on the HyperWeb extension.
• Control text alignment when formatting card widgets.

MicroStrategy Workstation

• New Sankey Diagram visualization to compare data flow is available in the Custom area of the Visualization Gallery.
• Add panel stacks from the top toolbar to enable additional flexibility on analytics workflows, while optimizing the use of screen real estate.
• Improved graph readability with y-axis word-wrap, nested labels, and bar chart label positioning.
• Drop-down selectors in documents support multi-selection.
• Create and edit Distribution Services email subscriptions with multiple pieces of content.
• Create and edit attribute objects, including form expressions, relationships, and display and sort information.
• View user activity, additional property information, and SQL execution details from the cube monitor.
• View, load, and unload projects. You can also view recent users and specify on which nodes' projects are loaded during server start up.
• Execute Python scripts saved to your metadata from Workstation.
• New dossier and document property that allows the administrator to choose the default open state of the content in Library as Last Viewed (available at both Environment and Project levels).
• Preview Feature: Add Microcharts and Rich Text formatting for text boxes in dossiers.

MicroStrategy Web

• New Sankey Diagram visualization to compare data flow is available in the Custom area of the Visualization Gallery.
• Add panel stacks from the top toolbar to enable additional flexibility on analytics workflows, while optimizing the use of screen real estate.
• Improved graph readability with y-axis word-wrap, nested labels, and bar chart label positioning.
• Drop-down selectors in documents support multi-selection.
• New dossier and document property that allows the author to choose the default open state of the content in Library as Last Viewed or Last Saved.
• Enhanced sharing workflow that enables search to return all users and user groups that contain the key term.

MicroStrategy Library

• Select the default open state of dossiers and documents in Library as Last Viewed by the end user or Last Saved by the author (reset to original view).
• Drop-down selectors in documents support multi-selection.
• SAML Admin Groups govern the Library admin pages when SAML authentication is enabled.

MicroStrategy Library Mobile

iOS

• Download and view Excel and CSV files with native in-app support.
• Select the default open state of dossiers and documents in Library as Last Viewed by the end user or Last Saved by the author (reset to original view).
• Select and copy individual grid cells contents and URLs to the clipboard.
• New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.
• Enhanced Pie and Ring charts with optimized use of container blank space, improved data labels with leader lines, and option to show percentage.
• Sort Pie and Ring charts in ascending and descending order.
• Hide or show the Metrics header text in a grid visualization.
• Use compound grid visualizations to filter data in other visualizations.
• Certification of native integration with Intune and AppConfig compliance.
• Drop-down selectors in documents support multi-selection.

Android

• Use a document or dossier as the home screen to build powerful mobile experiences.
• Select the default open state of dossiers and documents in Library as Last Viewed by the end user or Last Saved by the author (reset to original view).
• Select and copy individual grid cells contents and URLs to the clipboard.
• New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.
• Enhanced Pie and Ring charts with optimized use of container blank space, improved data labels with leader lines, and option to show percentage.
• Sort Pie and Ring charts in ascending and descending order.
• Hide or show the Metrics header text in a grid visualization.
• Use compound grid visualizations to filter data in other visualizations.
• Drop-down selectors in documents support multi-selection.

MicroStrategy Intelligence Server

• Memory usage breakdown information is logged in the DSSErrors.log to help troubleshoot Memory Contract Manager denial state or shut down due to an extended timeout limit of the denial state.

• Improved cube loading time by up to 50% through persisting and loading attribute indexes from disk. See KB48489 for more information.

MicroStrategy Mobile

iOS

Support for native integrations with AirWatch, MobileIron, BlackBerry Dynamics, and AppConfig compliance.

Android

Support for native integrations with AirWatch and AppConfig compliance.

MicroStrategy Library Mobile SDK

Preconfigure Library Mobile for Android.

MicroStrategy REST APIs

• Reload (update) the schema and manage the schema lock.
• Create and manage attribute objects and relationships.
• Create and manage fact objects.
• Create and manage table objects, including user free-form SQL to create logic tables.
• Create and manage security filters, including filter definition and user assignment.
• Create and manage derived elements.
• Create and manage prompt objects, including expression, object, attribute element, and value prompts.
• Dossier API enhancements to enable interaction with filters and selectors.
• Create, update, and delete Distribution Services devices, events, transmitters, and contacts via APIs.
• Create, update, list, and delete devices for email and FTP device types.
• Create, update, list, and delete events.
• Create, update, list, and delete transmitters for email, FTP, file, print, iPhone/iPad, and Android.
• Create, update, list, and delete contacts.
• Schedule enhancement to support multiple days of the week or month, choosing first or last weekday of the week or month (excluding holidays), and choosing last day of the month.
• Update multi-content subscriptions.
• Datasource management API enhancements to configure job prioritization.

MicroStrategy Cloud Platform

Improvements to MicroStrategy Backup and Restore (MSTRBak) to aid in the process of migrating customers into MicroStrategy Cloud, including:

• Additional database support when using Oracle and SQL Server databases, so you can leverage MicroStrategy Backup and Restore.
• New incremental update mode (“-u”) to improve the experience during cutover to a parallel, upgraded environment.

Data Sources

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

1. Gateway Certifications
   • Oracle Cloud 21c
   • Exasol 6.2
   • Exasol 7.0
2. OOTB Driver Updates
   • The latest drivers for SQL Server, IBM Db2, MongoDB, and Salesforce gateways are out-of-the-box, optimizing security and performance.
3. Functionality Enhancements
   • Set the Max Metric Alias Size VLDB property for the following gateways:
     

     Gateway	Max Metric Alias Size
     SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019	128
     Azure Synapse	128
     Db2	128
     PostgreSQL	63
     Oracle 12c	30
     Oracle 12cR2 Oracle 18c Oracle 19c Oracle 21c	128
     Redshift	127
     Teradata 15.x Teradata 16.x Teradata 17	128
     Google BigQuery	128
     Snowflake	256

Privileges

See Privileges by License Type for information about license types and associated privileges.

The Use Hyper SDK privilege is required to use Hyper SDK. See KB484951 for more information.

The Use Freeform SQL Editor privilege has been migrated from the Client - Architect license to the Server - Intelligence license. You can grant this privilege to the user and it won't occupy a Client - Architect license. Although it is listed under Client-Architect in the User Editor, it is mapped to the Intelligence license when the Intelligence server does a compliance check.

The Enable on-premise data access via gateway agent privilege has been added to the Server - Intelligence license.

---

2021 Platform (February 2021)

MicroStrategy HyperIntelligence

Ability to support and enforce mobile security policies through any EMM platform that supports the AppConfig standards on HyperMobile for Android.

MicroStrategy Workstation

• Configure Okta as an OIDC authentication provider.
• View all database instances and set security access.
• Browse, filter, and search schema objects by ID.

Data Sources

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

New SAP ECC Data Gateway.

MicroStrategy Library Mobile SDK

Preconfigure Library Mobile for Android.

---

2021 Platform

MicroStrategy Desktop	MicroStrategy Integrity Manager
MicroStrategy HyperIntelligence	MicroStrategy Mobile
MicroStrategy Workstation	MicroStrategy Library Mobile SDK
MicroStrategy Web	MicroStrategy Mobile SDK
MicroStrategy Library	MicroStrategy Visualization SDK
MicroStrategy Library Mobile	MicroStrategy Embedding SDK
MDX	MicroStrategy REST APIs
Federated Analytics	MicroStrategy Cloud Platform
MicroStrategy for Office	Installation
MicroStrategy Intelligence Server	Data Sources
MicroStrategy Platform Analytics	Privileges

MicroStrategy Desktop

MicroStrategy 2021 does not include a separate Desktop application. Soon, Workstation will be available to use for free, offline workflows, just as Desktop previously worked. Advanced functionality in Workstation will only be enabled when you connect to a MicroStrategy environment.

MicroStrategy HyperIntelligence

• Create and apply thresholds to the card header.
• Support for derived metrics on the card editor.
• Ability to replace datasets without sacrificing card design on the card editor.
• Embed HyperIntelligence on web-based applications using Hyper SDK.

• Ability to support and enforce mobile security policies through any EMM platform that supports the AppConfig standards on HyperMobile for iOS.

MicroStrategy Workstation

• macOS High Sierra is no longer supported. Only macOS Mojave (version 10.14) and Catalina (version 10.15) are supported.
• Enable single sign-on with OpenID Connection (OIDC) authentication for Azure.
• Monitor and manage user connections from the User Connection Monitor.
• Monitor and manage database connections from the Database Connection Monitor.
• Monitor and manage subscriptions from the Subscription Monitor.
• Monitor and manage Intelligent cubes from the Intelligent Cube Monitor.

• Additional server and project-level administrative settings migrated from Developer to Workstation. See the following topics for more information:

  • Edit Server-Level Governing Settings
  • Edit Server-Level Security Settings
  • Edit All Server-Level Settings
  • Edit Application-Level Cache and Intelligent Cube Settings
  • Edit All Application-Level Settings

• Improved performance when using percentile functions. See KB484742 for more information.
• Enhanced formatting properties when creating documents.

• Dossier enhancements, including:

  • Create dossier-level filters to filter data across multiple chapters or an entire dossier.
  • Visualization Gallery moved to top toolbar to showcase nine new one-click Bar charts, three new one-click Line/Area charts, and provide more authoring space.
  • Compare two or more metric values in a Bar chart using a common scale with the new Synchronized Axis Bar chart or right-mouse-clicking on a dual-axis chart.
  • Enhanced Pie and, new out-of-the-box, Ring chart with optimized use of container blank space, improved data labels with leader lines, and option to show as a percentage.

  • Allow multiple selections for data labels in pie, circle, and bar charts.

  • Sort pie and ring charts in ascending or descending order.
  • New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.

  • Build Geospatial Service visualizations with the following new styles:

    • Border: Display only geographic borders and no terrain details. Use a background color or image to make the data pop.
    • Focused: Focus only on the geographic area where you have data, without surrounding areas distracting the view.
  • New Format panel option to disable panning, zooming, tilting, and rotating of Geospatial Service visualizations.
  • New Format panel option to disable the Geospatial Service visualization toolbar.
  • Sort and filter the attributes/metrics in the Dataset panel with new one-click filtering options for derived metrics, geo-attributes, unused objects, objects used on selected visualization, and more.
  • Create dynamic default filters based on the First N / Last N element(s).
  • Support passing filter selections and answer prompts while linking from text boxes and images.
  • Change the fill color opacity for text boxes, grids, and containers to customize transparency.
  • Add shapes to the canvas from the top toolbar to visually group elements, help frame a visualization, or create a layered effect.
  • Smarter labels for most visualizations to improve readability and design.
  • Additional visualization formatting flexibility through x-axis label rotation and word wrap.
  • Enhanced grid sorting to support working with totals, as well as allowing users to specify nested, absolute, and level grid sorting on metrics.
  • Hide or show the Metrics header text in a grid visualization.
  • Select and copy individual grid cells contents and URLs to the clipboard.
  • Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.
  • Import measures as regular dimensions when using Oracle Essbase MDX/OLAP sources for hierarchy reporting.

  • Support a new MDX/OLAP data source of Kyvos 2020.2.4 for hierarchy reporting.

  • Add metrics to rows in compound grids.
  • Use compound grid visualizations to filter data in other visualizations.
  • Enable vertical scrolling in free-form layout dossiers.
  • Hide or show visualization containers for mobile views in free-form layout.
  • Use the keyboard to move and delete, disable auto-snapping, and select all layers under free-form layout dossiers.
  • Export dossiers to PDF while in presentation mode.

MicroStrategy Web

• Export hierarchy reports to Excel with the hierarchy structure and levels preserved.
• A new feature flag called Customize the Position of Parent Elements appears on the General Preferences page. Administrators can turn on this feature flag to allows users to customize the position of hierarchical attribute parent elements above or below child elements in dossier grids. The default setting is Off.
• Improved performance when using percentile functions. See KB484742 for more information.

• Dossier enhancements, including:

  • Create dossier-level filters to filter data across multiple chapters or an entire dossier.
  • Visualization Gallery moved to top toolbar to showcase nine new one-click Bar charts, three new one-click Line/Area charts, and provide more authoring space.
  • Compare two or more metric values in a Bar chart using a common scale with the new Synchronized Axis Bar chart or right-mouse-clicking on a dual-axis chart.
  • Enhanced Pie and, new out-of-the-box, Ring chart with optimized use of container blank space, improved data labels with leader lines, and option to show as a percentage.

  • Allow multiple selections for data labels in pie, circle, and bar charts.

  • Sort pie and ring charts in ascending or descending order.
  • New Waterfall chart supports Show Difference and Show Sum modes to display data intuitively, as well as an option to hide or show the connection line.

  • Build Geospatial Service visualizations with the following new styles:

    • Border: Display only geographic borders and no terrain details. Use a background color or image to make the data pop.
    • Focused: Focus only on the geographic area where you have data, without surrounding areas distracting the view.
  • New Format panel option to disable panning, zooming, tilting, and rotating of Geospatial Service visualizations.
  • New Format panel option to disable the Geospatial Service visualization toolbar.
  • Sort and filter the attributes/metrics in the Dataset panel with new one-click filtering options for derived metrics, geo-attributes, unused objects, objects used on selected visualization, and more.
  • Create dynamic default filters based on the First N / Last N element(s).
  • Support passing filter selections and answer prompts while linking from text boxes and images.
  • Change the fill color opacity for text boxes, grids, and containers to customize transparency.
  • Add shapes to the canvas from the top toolbar to visually group elements, help frame a visualization, or create a layered effect.
  • Smarter labels for most visualizations to improve readability and design.
  • Additional visualization formatting flexibility through x-axis label rotation and word wrap.
  • Enhanced grid sorting to support working with totals, as well as allowing users to specify nested, absolute, and level grid sorting on metrics.
  • Hide or show the metric header text in a grid visualization.
  • Select and copy individual grid cells contents and URLs to the clipboard.
  • Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.
  • Import measures as regular dimensions when using Oracle Essbase MDX/OLAP sources for hierarchy reporting.

  • Support a new MDX/OLAP data source of Kyvos 2020.2.4 for hierarchy reporting.

  • Add metrics to rows in compound grids.
  • Use compound grid visualizations to filter data in other visualizations.
  • Enable vertical scrolling in free-form layout dossiers.
  • Hide or show visualization containers for mobile views in free-form layout.
  • Use the keyboard to move and delete, disable auto-snapping, and select all layers under free-form layout dossiers.
  • Export dossiers to PDF while in presentation mode.
• Enhanced security when using the MicroStrategy Connector. To take advantage of the improved MicroStrategy Connector, enable CORS settings on your Library Server.

MicroStrategy Library

• Share bookmarks to keep your team updated with more in-depth insights.
• Collaborate with direct messages that allow users to start discussions with individuals or groups.
• Search for objects both inside and outside of Library with global search.
• Add dossiers or documents to the Favorites section for quick navigation.
• Create uniquely named and personalized groups to organize content.
• Enable or disable the view of the Comments and Discussion panel across environments.
• Improved PDF generation response time when exporting from a dossier.
• Select and copy individual grid cells contents and URLs to the clipboard.
• Export dossiers with table of contents and grid pagination.
• Enable auto-fit for column width when exporting a document or dossier grid to Excel.
• Enhanced grid sorting to support working with totals, as well as allowing users to specify nested, absolute, and level grid sorting on metrics.
• Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.
• Export hierarchy reports to Excel with the hierarchy structure and levels preserved.
• Improved color contrast with a more accessible primary blue and overall color palette
• Seamlessly re-direct Library sessions to a healthy node when the current Intelligence server node is hanging or crashing.
• Allow the Library server to communicate with the MicroStrategy Modeling service when auto-configuration has failed.

MicroStrategy Library Mobile

iOS

• Use a document or dossier as the home screen to build powerful mobile experiences.
• New universal MicroStrategy Library app that can be installed on both the iPhone and iPad.
• View Library in low-light environments with support for dark mode in iOS.
• Select and change text sizes within dossier grids.
• Share bookmarks to keep your team updated with more in-depth insights.
• Collaborate with direct messages that allow users to start discussions with individuals or groups.
• Search for objects both inside and outside of Library with global search.
• Add dossiers or documents to the Favorites section for quick navigation.
• Create uniquely named and personalized groups to organize content.
• Download multiple versions of PDF and Excel files in one single location for future reference and version comparison.
• Deep link to Library from other applications.
• Supports iOS 14.
• Export dossiers with table of contents and grid pagination.

Android

• Support for tap, tap and hold, and double tap touch gestures.
• Support for swiping gestures between dossiers pages.
• Support for multi-select touch gestures to select multiple objects.
• Share bookmarks to keep your team updated with more in-depth insights.
• Collaborate with direct messages that allow users to start discussions with individuals or groups.
• Search for objects both inside and outside of Library with global search.
• Supports Android OS 11.
• Deep link to Library from other applications.
• Export dossiers with table of contents and grid pagination.
• Customize the position of hierarchical attribute parent elements above or below child elements in grids. This feature only applies to MDX/OLAP sources for hierarchy reporting.

MDX

• Ability to control aggregation behavior on metrics defined with a SCOPE statement with SSAS data sources for hierarchical reporting (MDX).
• Added support for Secure Network Communications (SNC) authentication method against SAP WH (MDX).
• Improved performance on hierarchical reporting against OLAP sources (MDX) through parallel execution of multiple MDX queries.
• Add dossiers with hierarchical reporting via Live connection to OLAP sources (MDX) to History List caching for faster response time.

Federated Analytics

MicroStrategy for Power BI

• Improved import performance.
• Import data in your defined locale.

MicroStrategy for Tableau

• Improved import performance.
• Use the suggested default MicroStrategy Library URL.

MicroStrategy for RStudio

RStudio Server Open Source Edition 1.2 is certified.

MicroStrategy Packages for Python (mstrio-py)

• Support for standard and LDAP authentication using a proxy server.
• Manage server, server configuration, and cluster details.
• Use Python modules to manage schedules and subscriptions.
• Manage Library content, including dossiers and documents.
• Use sample scripts to manage applications and create users, user groups, and user security.

See the mstrio-py help for more information.

MicroStrategy for Office

• Import data from compound grid visualizations to Excel.
• View imported object and source information such as prompt answers, filters, attributes, metrics, owner, certification status, last modified date, etc., of imported data in the add-in side panel.
• Select a new import destination if the original selected range is unavailable.
• Support for OIDC authentication for Azure.

MicroStrategy Intelligence Server

• Replace a slice of data in an Intelligent cube using a single incremental cube refresh step.
• The VLDB property, Attribute to Join When Key From Neither Side can be Supported by the Other Side becomes obsolete once you upgrade your data engine version to 2021. See KB484738 for more information.
• Improve report and cube performance against the data warehouse by using an attribute form caching Intelligence cube.

• Keep up to two times more In-Memory Cubes active on existing hardware using Smart Memory Usage on Intelligence Server.

MicroStrategy Platform Analytics

Configure Platform Analytics to use a custom respository database name.

MicroStrategy Integrity Manager

New modern, user-friendly page for SQL comparison in dossiers, documents, and reports.

MicroStrategy Mobile

iOS

• Supports iOS 14.
• Supports AppConfig with iOS 14.

MicroStrategy Library Mobile SDK

iOS

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

• Deep link to Library from other applications.
• Preconfigure Library Mobile for iOS.

Android

• The Library Mobile SDK for Android is certified to work with Android 11 (API level 30). When you customize Library Mobile for Android, you must have Android SDK 30 to develop and compile your application. Android Studio 3.6 and up is supported.

• Deep link to Library from other applications.

MicroStrategy Mobile SDK

iOS

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

Android

The MicroStrategy Mobile SDK for Android is certified to work with Android 11 (API level 30). When you customize MicroStrategy Mobile for Android, you must have Android SDK 30 to develop and compile your application. Android Studio 3.6 and up is supported.

MicroStrategy Visualization SDK

Configure the display of the Change Visualization context menu.

MicroStrategy Embedding SDK

• More updates in error handling.
• Apply multiple filters after a dossier is rendered.
• Show or hide the shareDossier function.

MicroStrategy REST APIs

• Identify applications to load on server startup.
• Manage filter objects.
• Create and edit email subscriptions.
• List available recipients for a given user, including Shared List and Personal Addresses.
• Execute a single subscription on demand.
• Create, update, and delete schedules.
• Manage data sources with a complete set of REST APIs.
• Ability to request DateTime data to be returned from reports, cubes, and dossiers in the ISO 8601 format.
• Ability to update page-by selections for reports.
• Enhancement to APIs returning data from reports and cubes to allow the modification of attribute and metric template positioning.
• Enhancement to APIs that execute reports, cubes, and dossiers to allow the request for asynchronous executions.
• Monitor and manage cubes. This includes viewing and changing the status of a cube.
• Additional server and application level settings from MicroStrategy Developer are available in MicroStrategy Workstation.
• Ability to request object lineage information.
• Create, list, and delete multi-content subscriptions.

MicroStrategy Cloud Platform

Improved scalability of deployments across AWS and Azure, including:

• A new One-Node Enterprise deployment type for production-quality single node deployments that leverage scalable file storage and high availability MD instances
• The availability of one-click hotfix upgrades to M2019 Update 7 and M2020 Update 3
• The ability to stop/start/resize individual nodes within a cluster for improved vertical scalability

Amazon Web Services (AWS)

Security enhancements, including:

• Option to deploy environments with only Private IPs
• Automatic, default SSL encryption between I-server and Web server in MCP deployments for 11.3 and beyond
• Improved load balancer encryption to TLS 1.2 protocol

Enhanced global availability of MCP deployments recently expanding into the following regions:

• Middle East (Bahrain)
• Canada Central
• Sao Paulo
• EU (Stockholm)

Azure

Security enhancements, including:

• Option to deploy environments with only Private IPs
• Automatic, default SSL encryption between I-server and Web server in MCP deployments for 11.3 and beyond
• Improved load balancer encryption to TLS 1.2 protocol

Enhanced global availability of MCP deployments recently expanding into the following regions:

• South Central US (Texas)
• Canada Central
• Asia Southeast
• Japan East
• South Africa (North)

Installation

• The Windows and Linux debug installation log file MSTRInstall.log has been renamed to MSTRDebugInstall.log to help distinguish it from the high-level install.log. Additionally, the file has been moved to the Log directory to centralize all log collection.
• The MicroStrategy Repository is an independent component that can selected for use during installation for Platform Analytics and Collaboration server. If you want to use your own certified Postgres database, or if you have already installed the MicroStrategy Repository on another machine, a new screen allows you to connect to a remote repository instead.
• Administrators can use the Recheck button for Windows and Linux installations when missing requirements are identified. Now, the requirements can be installed, and without leaving the same installer screen, administrators can recheck these requirements and proceed when they have all been satisfied.
• MicroStrategy supports and bundles Adopt OpenJDK11 with the Linux and Windows platform installers. Fresh installations or upgrades to 2021 are automatically upgraded, with no further action needed. For your hosted J2EE web application servers, you must upgrade to JDK11 before deploying the new 2021 WAR files. You may also use Oracle JDK11, which is supported.

Data Sources

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

1. Gateway Certifications

   • Teradata 17
   • Oracle Cloud 19c
   • Oracle Autonomous Data Warehouse
   • SAP HANA 2.0 SPS05
   • PostgreSQL 12 & 13
   • IBM DB2 11.5
   • IBM Integrated Analytics System 1.0
   • MongoDB 4.x
   • Cloudera Data Platform (CDP) Public Cloud Base 7.1
   • Yellowbrick 4.0

2. New Gateways

   • New Cloud Object Storage Connector supporting AWS S3, Azure Data Lake Storage Gen2 and Google Cloud Storage for files in Parquet, Avro, and ORC formats.
   • New Gateway Connectors for Kyvos, Yellowbrick, IBM Integrated Analytics System (IAS).
   • New OData Connectors for SAP S/4 HANA, SAP BW/4 HANA.
   • Azure SQL Data Warehouse is Azure Synapse Analytics and is certified with MicroStrategy. See the Microsoft documentation for more information.

3. OOTB Driver Updates

   • Teradata drivers are bundled out-of-the-box with MicroStrategy installation (Teradata Driver 17).
   • Snowflake drivers are bundled out-of-the-box with MicroStrategy installation (Snowflake Driver 3.12.11 (JDBC) and 2.21.2 (ODBC)).
   • SAP Hana Drivers are bundled out-of-the-box with MicroStrategy installation (SAP Hana Driver 2.6).
   • MicroStrategy 2021 ships the latest drivers for all gateways MicroStrategy shipped out-of-the-box optimizing security and performance.

4. Gateway Deprecation

   • Some connectors are deprecated.

5. Security and Performance Enhancements

   • Support Kerberos, certificate-based authentication, and scram-sha-256 for password encryption of PostgreSQL. See KB484539, KB484540, and KB484541 for more details.
   • TLS configuration is supported in GUI and command line mode for all gateways that MicroStrategy ships out-of-the-box in the Connectivity Wizard. (SAP HANA excluded) See KB42495 for more information.
   • Secure SQL Execution using parameterized queries has been enabled by default for the following data sources: Amazon Redshift, IBM Db2, Oracle, Teradata, PostgreSQL, SAP HANA, Snowflake, Google BigQuery, MySQL, Yellowbrick, MemSQL, IBM IAS, IBM IPS, IBM Netezza, and Amazon Aurora PostgreSQL Compatible. See KB484512 for more information.
   • Implement unified quoting with Diamond and Platinum gateways as well as select gold gateways - PostgreSQL, Amazon Aurora PostgreSQL, Yellowbrick, IBM Integrated Analytics System, IBM Netezza, and IBM Performance Server for PostgreSQL.
   • The calculation of the DateDiff function has been pushed to the gateway side for SQL Server, Azure Synapse Analytics, and Amazon Redshift. To incorporate this change, you must update your metadata and schema. This change increases performance when executing reports and live dossiers or when publishing cubes against SQL Server or Amazon WH when DateDiff calculations are used.
   • The calculation of the Percentile function has been pushed to the gateway side for all Diamond and Platinum data sources. To incorporate this change, you must update your metadata and schema. This change increases performance when executing reports and live dossiers or when publishing cubes when Percentile calculations are used.
   • Snowflake - Improved live connections (report/cube) throughput performance by up to three times by updating the default Intermediate Table Type to Derived Table.

6. Functionality Enhancements

   • Extended Connectivity Wizard DSN creation for Google BigQuery, Apache Spark SQL, Hive, Impala, Teradata, and Snowflake.
   • Google BigQuery gateway supports billing project and catalog browsing by namespace.
   • Seamless Authentication for JDBC and ODBC drivers leveraging OAuth workflow. For example, Snowflake and Google BigQuery.
   • New report searching functionality for Salesforce Report gateway connector. See KB484556 for more information.
   • Network proxy support for MicroStrategy Community Connectors.
   • Support HTTP connection (proxy connection) for relational gateways.

Privileges

See Privileges by License Type for information about license types and associated privileges.

A few privileges have been migrated between license groups.

• The following privileges have been moved from Client-Web to Client-Reporter:
  • Web add to History List
  • Web execute datamart report
• The following privileges have been moved from Server-Intelligence to Server-Reporter:
  • View History List
  • Save personal prompt answers
• The following privilege has been moved from Client-Web to Server-Distribution:
  • Web subscribe to History List