What's New in this Guide

MicroStrategy 10.7

• When performing In-Memory calculations - such as derived metrics, subtotals, and dynamic aggregation - on simple and aggregation functions, we would ignore nulls during the calculation of aggregation functions while still treating them as 0 for scalar operations. The new calculation behavior is applied by default but can be reverted by through the Advanced VLDB Properties Editor. For more information, see Null Checking for Analytical Engine
• When running a multi-source report in 10.7, you can execute multiple report pre- and post-SQL statements in an expected order for both primary and all secondary databases. The SQL statements are also executed when the report is used in a document or dashboard. To apply pre- and post-SQL statements, use the Pre/Post Statements VLDB setting. For more information, see Multi-Source Report Pre and Post Statements.

MicroStrategy 10.5

• Added procedure for defining secure Freeform SQL text prompts to guard against malicious SQL injections. For more information, see Using Secure Freeform SQL Text Prompts.

MicroStrategy 10.4

• Added support for Kerberos without pass-through to XQuery data source connections. You can use a single Kerberos certificate to authenticate all users for a web service. For more information, see Using Kerberos to Authenticate XQuery Data Sources.

MicroStrategy 9.4

• The examples for creating and formatting stock graphs have been updated for additional best practices information and requirements, which are provided in Stock and Stock.
• Report Services document designers can enable Grid/Graphs as report condition selectors to filter the data in a dataset, allowing users to view subsets of large amounts of data, rather than loading and displaying all the data at once. This can be supported for datasets created using Freeform SQL and XQuery, as described in Reporting Analysis Features and Supporting Grid/Graph Filtering for Document Datasets Based on Large XQuery Reports respectively.