Version 2021
The MicroStrategy 2021 Update 5.2 release includes remediation for a group of security vulnerabilities found within Java by upgrading the Java version to 11.0.15+10 across products. Learn more.
What's New in MicroStrategy 2021
MicroStrategy 2021 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 2021 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. They are not ready for full release, but are functional enough for you to try out and experiment with in your dossiers. By selecting to expose preview features in MicroStrategy Workstation, you can access these features and use them as you would any other 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 2021. In addition, if you are upgrading within 2021 and plan to test out the new time zone based reporting preview feature, you must perform a metadata update. Otherwise, a metadata update is not necessary when upgrading within 2021 versions.
Use the buttons below to view what's new in the 2021 monthly and platform releases. All 2021 updates include the features from the 2021 Platform Release.
2021 Update 5.2, May
Released on May 20, 2022
MicroStrategy Workstation
-
Create contacts and contact groups to subscribe to content in subscriptions. This former preview feature is now available out-of-the-box.
-
Create connection mappings to ensure data security for content.
-
Delete data sources from the revamped Data Sources dialog.
MicroStrategy Web
Configure SameSite cookies for MicroStrategy Web and MicroStrategy Mobile.
MicroStrategy Packages for Python (mstrio-py)
A Fact
class in the mstrio.modeling.schema.fact
subpackage allows fact management.
A list_facts
function allows the listing of facts.
See the mstrio-py help for more information.
Data Sources
See Platform Certifications for information on the latest supported and certified configurations.
- 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
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 static 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
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 now available out-of-the-box.
-
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 now available out-of-the-box.
-
Preview Feature: Monitor objects changes through the change journal.
-
Preview Feature: Time zone based reporting.
-
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 now available out-of-the-box. In this release, the following new features have been added:
-
Amazon S3 is supported.
-
The database is now 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.
-
Preview Feature: Change time zone preferences.
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 now be purged in Platform Analytics. This completes full parity with Enterprise Manager for Client Telemetry.
MicroStrategy Mobile SDK
iOS
-
BlackBerry certification to support iOS 15 with Xcode 13.1.
-
MobileIron certification to support iOS 15 with Xcode 13.1.
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 Certification
-
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 DataSource 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
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
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 for 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 management -
ContactGroup
class in themstrio.distribution_services.contact_group
subpackage to allow contact group management -
Device
class in themstrio.distribution_services.device
subpackage to allow device management -
Transmitter
class in themstrio.distribution_services.transmitter
subpackage to allow transmitter management -
list_contact
,list_contact_groups
,list_devices
,list_transmitters
functions to allow listing of objects of newly created classes -
PackageConfig
class in themstrio.server.migration
subpackage with support forPackageSettings
andPackageContentInfo
, used for configuration migration -
Delete 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
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.
-
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.
-
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.
-
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.
-
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
Enhancements to authoring an embedded dossier, including:
-
Controlling display of items in authoring toolbar
-
Controlling display of authoring panels
-
Support for creating a new dossier
Show or hide all entries for a subscription.
Intelligence Server
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.
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.
2021 Update 3, November
MicroStrategy Mobile SDK
iOS
Mobile SDK certification with MobileIron to support iOS 15.
2021 Update 3, October
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
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 Certification
-
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.
- 13 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
The August release includes defect fixes for stability and user experience.
2021 Update 2, July
MicroStrategy Workstation
- Create and edit consolidations.
- Display a customized interface based on a user's assigned privileges.
2021 Update 2, June
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 now 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 now 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 now 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 now 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 through the Modeling service.
- Create and manage custom group objects through the Modeling service.
- Create and manage consolidation objects through the Modeling service.
- 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
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
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
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 through the Modeling service.
- Create and manage fact objects through the Modeling service.
- Create and manage table objects through the Modeling service, including user free-form SQL to create logic tables.
- Create and manage security filters through the Modeling service, including filter definition and user assignment.
- Create and manage derived elements through the Modeling service.
- Create and manage prompt objects through the Modeling service, 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 Certification
- 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
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:
- Secure text input through parameterized queries. See KB484512 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
- Secure text input through parameterized queries. See KB484512 for more information.
- 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
- Custom 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 through the Modeling service.
- 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 now 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 now 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 now 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 Certification
- 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 now 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 now 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
Other
The MicroStrategy 2021 platform includes modifications to Libstdc++.so.