What's new in 10.7: Support for running Report Pre/Post SQL statements against the secondary databases for a multi-sour
Until 10.6 release, for a multi-source report, if there are Report Pre/Post SQL statements specified at Database Instances, only Pre/Post SQL statements from the Primary Database Instances were run and not from Secondary Database Instances.
In 10.7, this is addressed and now Report Pre/Post SQL statements from all Database Instances (Primary, Secondary) can be run that are involved in the current report execution.
The Report Pre/Post SQL statements can be set at Database Instance or Report level via Developer as shown below:
We are working on the next generation of MicroStrategy tools that will provide users the ability to manage datasets including refreshing a dataset and schedule a dataset refresh. To provide a better user experience, we would like to gather feedback from customers who have experience with these functionalities that we currently have on MicroStrategy Web.Read more...
We are designing the next generation of MicroStrategy tools that will provide our users the ability to create datasets via Data Import workflows and manage the security of those datasets.
We would like to understand how customers are currently controlling the data security for the Data Import datasets, and what you expect to be improved in the new product. Please share your use cases by answering the questions below in the comments:Read more...
Additional considerations for your date hierarchy attributes for easier reporting.Read more...
In 10.5 release, prepared statements are used to secure Freeform SQL reports text prompt answers against data sources that support prepared statements. For data sources that do not support prepared statements, redesign of Freeform SQL reports may be required.
No company holds itself back from operating smoothly on purpose. Yet many teams continue to struggle with properly allocating time and resources. As organizations increasingly rely on technology to communicate effectively and make key business decisions, data analytics can help empower employees every day. Leveraging the power of data can be tremendously helpful in eliminating process roadblocks and ensuring everyone is operating with the highest possible efficiency. Here are three ways to make company data work in your favor and give employees the tools they need to thrive:
The 2016 Olympic Games are officially here. Every four years, the world’s top athletes proudly wear their country’s colors and compete on a global stage for a chance to bring home the gold.Read more...
Since 9.x release, an “attribute only report” could be dynamically sourced against Intelligent Cube. However, there was no support for Element Browsing request against an Intelligent Cube.
Starting 10.2, Element Browsing requests can be dynamically sourced against an Intelligent Cube instead of going to database.Read more...
Within a cluster, work fences allow an administrator to reserve specific nodes for use by
certain users or workloads during normal operation.
MicroStrategy 10.4 introduces native support for RESTful APIs to provide access to data in JSON format 3rd party applications can use.
You can download the new API server on the MicroStrategy download site (10.4 Add-Ons and Tools).
You can download a sample web-based consumer of the RESTful API here.
The comprehensive documentation can be found here.
The 10.4 RESTful API capability was optimized for the following use cases:
- Interactive applications
- Small dataset reports sourcing data from MicroStrategy in-memory cubes.
- Large dataset reports sourcing data from MicroStrategy in-memory cubes (up to 100MB of data per fetch).
- Small dataset reports sourcing data directly from data sources.
- Large dataset reports sourcing data directly from data databases (up to 100MB of data per fetch).
- On-demand report generation applications
- Dynamic queries against MicroStrategy in-memory cubes.
- MicroStrategy as a data source for other data visualization deployments
- Data source in other MicroStrategy projects using Data Import
MicroStrategy grid formatting details are provided in the JSON data returned by the APIs (metric value range, column headers, data type and format, threshold information, etc.)
The MicroStrategy RESTful API capabilities are going to evolve in the near future.
Existing APIs will be enhanced with additional MicroStrategy capabilities. More APIs will be added exposing other areas of the MicroStrategy Platform.
We need your feedback to help us prioritize what to work on next. Please provide your feedback as a reply to this post.