Tech Corner

Tech Corner

Tech Corner

Tech Corner

Feedback Wanted - Data Security

by Newcomer Wanting Newcomer 3 hours ago (22 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 3 weeks ago - last edited 3 weeks ago by Community Manager (290 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 (530 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,374 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,568 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 (3,191 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 (412 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.