Preview the new community

We’re making it easier for you to find answers and network with others. Visit our preview site and let us know what you think.

Tech Corner

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:PrePost.png






Feedback Wanted - Cube Refresh Functionality

by Newcomer Wanting Newcomer on ‎03-03-2017 11:31 AM (2,217 Views)

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.


Feedback Wanted - Data Security

by Newcomer Wanting Newcomer on ‎02-23-2017 03:25 PM (1,721 Views)

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:


Additional Date Forms to Include in Your Date Hierarchy

by Trusted Expert Trusted Expert on ‎01-31-2017 02:14 PM - last edited on ‎02-02-2017 04:03 PM by Community Manager (939 Views)

Additional considerations for your date hierarchy attributes for easier reporting.


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 (702 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.


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.


New in 10.4: Reserving nodes with Work Fences

by Pioneer Sdobbs Pioneer on ‎07-19-2016 08:43 AM (2,012 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 (7,739 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.