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...
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.
10.4 is now Generally Available, and while the README has a good overview of what is new in 10.4, this post delves into more detail about what is new in MicroStrategy’s In-memory Analytics functionality.Read more...
In the 10.4 release, a Report/Intelligent Cube (against a relational source) that uses Insert and/or Table Pre/Post SQL Statements can take advantage of the Parallel Query Execution feature, which was not the case in 10.3.
Data contamination is as bad as it sounds. Unverified data sources can poison a company’s well of information, negate the hard work of employees, and set up countless problems down the road. If the thought of contaminated data makes you cringe, you’re not alone. Every company looking to scale up their self-service deployment without adequate governance faces the same problem.Read more...
It’s been an exciting few years in the business intelligence space, with fresh analytics players, new products, and a slew of acquisitions. Just a few weeks ago Qlik sold for $3B to Thoma Bravo, a private equity firm, following on the heels of the TIBCO and Roambi acquisitions earlier this year.Read more...
MicroStrategy 10.4 introduces a single, permanent ‘MicroStrategy v10 license’ key effectively replacing ‘versioned-license keys’. Customers can now use this permanent key to install 10.4 or any later release on version 10.Read more...