Tech Corner

Tech Corner

Tech Corner

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. 



3 Ways to Empower Employees with Data

by Active Contributor Vijay Anand Active Contributor on ‎08-12-2016 10:37 AM (501 Views)

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.


New in 10.4: Reserving nodes with Work Fences

by Pioneer Sdobbs Pioneer on ‎07-19-2016 08:43 AM (1,265 Views)

Within a cluster, work fences allow an administrator to reserve specific nodes for use by
certain users or workloads during normal operation.


New in 10.4: native JSON data support through RESTful APIs

by Moderator on ‎07-07-2016 04:24 PM (5,159 Views)

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.

JavaScript Sample for the JSON REST APIJavaScript Sample for the JSON REST API

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.


What's New in 10.4 - In-Memory Analytics

by Pioneer Moha Pioneer on ‎07-07-2016 09:30 AM (2,965 Views)

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.


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.





7 Key Considerations for Data Governance

by Active Contributor Vijay Anand Active Contributor on ‎06-29-2016 09:30 AM (379 Views)

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.


5 Signs You Have Outgrown Your Analytics Software

by Newcomer KrassiG Newcomer on ‎06-28-2016 12:00 PM (358 Views)

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.


Introducing MicroStrategy v10 License keys

by Community Manager on ‎06-23-2016 09:46 AM (5,600 Views)

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.