Version 2021
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 dossier 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 upgrade the Database Management Software (DBMS) to use the new features in each release. See KB5779: How to update the database type in MicroStrategy for more information about upgrading the DBMS via Developer.
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.
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 toProject
class to allow the deletion of projects.
-
Added the
hidden
parameter to create methods ofAttribute
andMetric
classes.
Minor changes
Renamed ObjectTypes.NONE
to ObjectTypes.NOT_SUPPORTED
in the mstrio.types
module.
Data Sources
Capture gateway telemetry to prioritize data-driven gateway certifications.
MicroStrategy Library Mobile
iOS
Support for iOS 17 and iPadOS 17. See MicroStrategy Mobile and MicroStrategy Library Apps crash on iPadOS & iOS 17 for more information.
MicroStrategy Mobile
iOS
Support for 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 themstrio.server.language
package to allow management of Languages
- Added
list_languages
andlist_interface_languages
to allow the listing of languages and interface languages
Deprecated
- The
Locale
class inmstrio.datasources
is no longer supported and is superseded by theLanguage
class in themstrio.server.language
package
- The
list_locales
function inmstrio.datasources
is no longer supported and is superseded by thelist_languages
function in themstrio.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.
-
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: Browse folder structure using Discover Content.
- 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.
MicroStrategy Packages for Python (mstrio-py)
Major Changes
-
Updated the
create
method of theOlapCube
class to support the following new parameters:template
,filter
,options
,advanced_properties
,time_based_settings
,show_expression_as
, andshow_filter_tokens
. -
Updated the
alter
method of theOlapCube
class to allow altering of the following new parameters:template
,filter
,options
, andtime_based
_settings. -
Added
set_partition_attribute
,remove_partition_attribute
andlist_attribute_forms
methods to theOlapCube
class to allow management of partition attribute and observing attributes forms. -
Added
list_vldb_settings
,alter_vldb_settings
andreset_vldb_settings
methods to theOlapCube
class to allow management of VLDB settings.
Deprecated
-
The update method of the
OlapCube
class is no longer supported. It is superseded by thealter
method and will be removed in the future. -
The
attributes
,metrics
andoverwrite
parameters in thecreate
method of theOlapCube
class are no longer supported. They are superseded by thetemplate
parameter and will be removed in the future.
MicroStrategy REST APIs
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
, andreset_vldb_settings
methods to theDatasourceInstance
andProject
classes to allow management of VLDB settings. -
Added a
Driver
class andlist_drivers
function in themstrio.datasources.driver
module to allow driver management. -
Added a
Gateway
class andlist_gateways
function in themstrio.datasources.gateways
module, as well asGatewayType
andDBType
enums inmstrio.datasources.helpers
to allow gateway management.
Minor Changes
-
Updated
ipython
dependency version to 8.10.0. -
Added a
project_id
property forMetric
instances. -
Added a
delivery_expiration_timezone
argument for theSubscription
class and its subclasses. This functionality will be supported in a future release. -
Added
SuperCubeAttribute
,SuperCubeAttributeForm
, andSuperCubeFormExpression
classes in themstrio.project_objects.datasets.super_cube
module to support attribute forms forSuperCube
.
MicroStrategy 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.
-
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 Application
-
MicroStrategy Insights are supported. MicroStrategy Insights allow users to select key business KPIs from their dossiers and track them all from a single page in MicroStrategy. 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.
-
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 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
, andFileSubscription
classes in themstrio.distribution_services.subscription
package to allow management of history list, FTP, and file subscriptions. -
Added a
DynamicRecipientList
class in themstrio_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 theReport
class. -
Added methods to convert connections from DSN to DSN-less format in the
DatasourceInstance
andDatasourceConnection
classes. -
Improved error messages when calling
list_dependents
andlist_dependencies
on unsupported objects. -
Added support for the
Time
type toSuperCube
class. -
Added
with
statement compatibility forConnection
object. -
Added a
find_objects_with_id
function inmstrio.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 thelist_table_columns
andlist_logical_tables
methods from thetable
module. -
Updated dependencies in
requirements.txt
. -
Combined the
_update_acl
and_modify_rights
methods. Added amodify_rights
method. -
Added
Service
andServiceWithNode
classes in themstrio.server.node
module.
MicroStrategy Library Mobile SDK
iOS
-
Certification of Intune native EMM SDK for iOS 16.
-
Certification of native integrated Intune SDK for Xcode 14.
MicroStrategy REST APIs
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 Application
In dossiers, the same information window can be targeted by two or more visualizations in the page for reusability.
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.
-
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: Flash Entry Points Removed from MicroStrategy Web 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.
-
Intune native EMM SDK is certified 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
-
Certification with MobileIron, AirWatch, and BlackBerry Dynamics SDKs for 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
-
Certification with MobileIron, AirWatch, and BlackBerry Dynamics SDKs for 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
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 Application
Embedded surveys have been removed.
MicroStrategy Web
Embedded surveys have been removed.
MicroStrategy REST APIs
-
Duplicate users.
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: Support 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.
-
Configure and manage dynamic recipient lists for subscriptions
-
Create and edit freeform SQL reports.
-
Create and modify reports and their advanced properties.
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
, andTransformationAttributeForm
classes in themstrio.modeling.schema.transformation
subpackage to allow transformation management. -
Added
list_transformations
to allow listing for transformations. -
Added the
DefaultSubtotals
,Dimensionality
,DimensionalityUnit
,FormatProperty
,Metric
,MetricFormat
, andThreshold
classes in themstrio.modeling.metric
subpackage to allow metric management. -
Added
list_metrics
to allow listing for metrics.
Minor Changes
-
Added
list_locales
to themstrio.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 themstrio.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 themstrio.users_and_groups
subpackage. -
The
mstrio.distribution_services.contact_group
module is deprecated and moved to themstrio.users_and_groups
subpackage. -
The
mstrio.access_and_security.security_filter
subpackage is deprecated and replaced by themstrio.modeling.security_filter
andmstrio.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.
-
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 Application
-
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.
-
Accessible contextual linking from graphs and other visualizations via the Show Data dialog.
-
Improvements to accessibility 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
-
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.
-
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.
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.
-
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
, andWarehouseTable
classes in themstrio.modeling.schema.table
module to allow table management. -
New
list_logical_tables()
,list_physical_tables()
,list_datasource_warehouse_tables()
, andlist_namespaces()
functions to allow the listing and searching of specific tables in the project.
Minor Changes
-
New
search_pattern
andproject_id
parameters in the object listing functions. -
New
move
method added toFolder
,Object
,SecurityFilter
,Attribute
,Fact
,UserHierarchy
,Report
,Shortcut
,SearchObject
,Document
, andDossier
to allow the moving of objects between folders -
Added
create_copy
method inSecurityFilter
,Attribute
,Fact
,UserHierarchy
,Report
,Shortcut
,SearchObject
,Document
, andDossier
.
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
-
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.
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 manage cube objects with advanced properties.
-
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
-
-
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.
-
Delete data sources from the revamped Data Sources dialog.
MicroStrategy Packages for Python (mstrio-py)
-
A
Fact
class in themstrio.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.
- OOTB Driver Updates:
-
Oracle ODBC Driver
-
Sybase ASE ODBC driver
-
Drill ODBC Driver
-
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 themstrio.modeling.schema.attribute
subpackage allows attribute management. -
New
AttributeForm
class in themstrio.modeling.schema.attribute_form
subpackage allows attribute form management. -
New
list_attributes
allows listing of attributes. -
New
list_functions
in themstrio.modeling.expression
subpackage allows listing of functions. -
New
act_expression
,expression
,expression_nodes
,parameters
, anddynamic_date_time
modules in the mstrio.modeling.expression subpackage allow management of fact expressions.
-
ExecutionMode
elements have been changed fromASYNCH_CONNECTION
toASYNC_CONNECTION
and fromASYNCH_STATEMENT
toASYNC_STATEMENT
. -
Refactored examples in the
code_snippets
folder, with modifications to make them easier to use in MicroStrategy Workstation. -
Renamed the
workstation_demos
folder toworkflows
.
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 Application
-
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.
-
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 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 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.
-
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.
-
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.
-
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 themstrio.modeling
subpackage that allows schema management.A
UserHierarchy
class in themstrio.modeling
subpackage that allows user hierarchy management.A
list_user_hierarchies
function that allows the listing of objects in the newly createdUserHierarchy
class.
MicroStrategy Visualization SDK
MicroStrategy REST APIs
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.
Gateway Certifications
Vertica 11.0.2
Denodo 8.0
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
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
Functionality Enhancements
Simple mode Data Source management for major Diamond and Platinum gateways with support of JDBC TLS configuration.
Support for OAuth authentication in the MicroStrategy application for the following gateways:
Google Drive
Google Analytics
Google BigQuery Native
Dropbox
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
MicroStrategy App for macOS and Windows
Workstation for macOS and Windows
2021 Update 4.1 (January 2022)
Released on January 28, 2022
MicroStrategy Library Mobile
iOS
Certification for native integrated Intune SDK for Xcode 13.1.
Android
Optimized data encryption and security. See KB485325 for more information.
MicroStrategy Mobile
iOS
Certification of native integrated AirWatch SWIFT SDK for Xcode 13.
MicroStrategy Packages for Python (mstrio-py)
The following have been added:
Contact
class in themstrio.distribution_services.contact
subpackage to allow contact managementContactGroup
class in themstrio.distribution_services.contact_group
subpackage to allow contact group managementDevice
class in themstrio.distribution_services.device
subpackage to allow device managementTransmitter
class in themstrio.distribution_services.transmitter
subpackage to allow transmitter managementlist_contact
,list_contact_groups
,list_devices
,list_transmitters
functions to allow listing of objects of newly created classesPackageConfig
class in themstrio.server.migration
subpackage with support forPackageSettings
andPackageContentInfo
, used for configuration migrationDelete functionality to the
Document
,Dossier
, andReport
classes
The
Event
class has been extended in themstrio.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
, andpatch
HTTP request methods can be added to theConnection
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
, orReport
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
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 Application
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
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
Control the display of items in authoring toolbar.
Control the display of authoring panels.
Support for creating a new dossier.
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
Mobile SDK certification with MobileIron to support 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
Certification of BlackBerry Dynamics native EMM SDK for iOS 15.
MicroStrategy Library Mobile SDK
iOS
Certification of Intune native EMM SDK for iOS 15.
MicroStrategy Packages for Python (mstrio-py)
A new
CacheUpdateSubscription
class in thesubscription
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 frommstrio.distribution_services
ormstrio.distribution_services.subscription
at most. Anything deeper is considered internal implementation detail and not guaranteed to remain stable.New
user
anduser_group
arguments added to thelist_security_filters
function to allow filtering results by user or user group.New
list_security_filter
method andsecurity_filters
property for theUserGroup
class.New
list_security_filter
methodsecurity_filters
property for theUser
class.
2021 Update 3 (September 2021)
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
MicroStrategy REST APIs
Data Sources
See Platform Certifications for information about the latest supported and certified configurations.
Gateway Certifications
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.
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
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 Application
- 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 HyperIntelligence
- Control the default on/off state of HyperIntelligence cards on HyperWeb and the MicroStrategy app.
- 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
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 themstrio.distribution_services.schedule
subpackage. - A new
ScheduleTime
class in themstrio.distribution_services.schedule
subpackage, which is a local object used for specifying time related properties of schedule. - A new
Event
class in themstrio.distribution_services.event
subpackage. - The
Subscription
class has been modified to useSchedule
objects. - A new
datasources
subpackage withDbms
,DatabaseConnections
,DatasourceInstance
,DatasourceLogin
,DatasourceMap
classes covering database management functionality. - New
list_available_dbms
,list_datasource_connections
,list_datasource_instances
,list_datasource_logins
, andlist_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
, andacl_alter
methods. - A
SecurityFilter
class andlist_security_filters
function in themstrio.access_and_security.security_filter
subpackage - A new
Qualification
class in themstrio.access_and_security.security_filter
subpackage, which is an object used to represent a security filter qualification. - New
PredicateBase
,PredicateForm
,PredicateElementList
,PredicateFilter
,PredicateJointElementList
, andLogicOperator
classes in themstrio.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
, andConstantArrayParameter
classes in themstrio.access_and_security.security_filter
subpackage to represent the parameters used inAttributeForm
. mstrio.admin.schedule
has been replaced with themstrio.distribution_services.schedule
subpackage.- The
schedules_id
argument has been replaced byschedules
in the create and alter methods of the Schedule class. mstrio.distribution_services.schedule.ScheduleManager
has been replaced withmstrio.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
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.
- New Gateways
- New Gateway Connector for Microsoft Dynamics 365.
- New Gateway Connector for Databricks.
- OOTB Driver Updates
Exasol ODBC and JDBC drivers are shipped out-of-the-box.
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.
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
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
, andPermissions
enums. - A new
Node
class to be used for node management in place of a raw dict. - A new
CubeCache
class added to themstrio.application_objects.datasets
subpackage. - The
load_cube
method can load cubes by name. - New
list_cube_caches
,delete_cube_caches
, anddelete_cube_cache
functions. - New
create
,update
,get_sql_view
, andpublish
methods for theOlapCube
class. - A new
unpublish
method for theOlapCube
andSuperCube
classes. - A new
list_reports
function for theReport
module. - New
alter
andlist_properties
methods for theReport
class. - The
id
parameter replaces thereport_id
parameter in theReport
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
andOlapCube
in themstrio.application_objects.datasets
subpackagelist_all_cubes
,load_cube
,list_super_cubes
, andlist_olap_cubes
functions that allow you to search for cubes by name and construct precise objectsuser_id
,user_full_name
,user_initials
to theConnection
classtrust_id
anddatabase_auth_login
parameters in the user.alter() method- More
Cube
object attributes similar to other MicroStrategy objects
- Alter the
name
,description
, andabbreviation
properties of cubes.
See the mstrio-py help for more information.
2021 Update 1 (March 2021)
MicroStrategy Application
- New zoom preferences to enable personalized readability.
- 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.
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
Certification of native integrations with AirWatch, MobileIron, BlackBerry Dynamics, and AppConfig compliance.
Android
Certification of 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.
- Gateway Certifications
- Oracle Cloud 21c
- Exasol 6.2
- Exasol 7.0
- OOTB Driver Updates
- The latest drivers for SQL Server, IBM Db2, MongoDB, and Salesforce gateways are out-of-the-box, optimizing security and performance.
- 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
- Set the Max Metric Alias Size VLDB property for the following gateways:
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 Application
Download the MicroStrategy app from the MicroStrategy download site.
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 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 Application
MicroStrategy is the new premiere viewing platform that brings the power of analytics right to the desktop—all at a faster speed. Get the instant response experience with new features unique to the app such as Smart Download and Automatic Refresh that predict and proactively download the content you need both online and offline.
- Search for and view HyperIntelligence cards in the MicroStrategy app.
- 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.
- Search for keywords to find specific data highlighted in a dossier or document.
- Improved color contrast with a more accessible primary blue and overall color palette
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:
- 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 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.
- 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.
- Library Mobile certification for 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.
- Library Mobile certification for 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
- MicroStrategy Mobile certification for iOS 14.
- Mobile SDK certification with AppConfig for 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.
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
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.
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.
Gateway Deprecation
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.
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