MicroStrategy Review

Intelligent Cubes give the illusion of real-time response from reports. I'd like for them to be shareable with other reporting tools.

Valuable Features

Intelligent Cubes: not all database environments are optimized for reporting, nor do all BI lanes have access to a proper data warehouse. Often the BI tools are directly used against operational tables from the source. Intelligent Cubes provide the ability to pre-cache the results for non-real-time reporting to give the illusion of real-time response from reports (especially dashboards).

Improvements to My Organization

It provides a single point of reporting from many data sources.

Room for Improvement

List of improvements that this product lacks:

  • The ability to export and make the Intelligent Cubes shareable with other reporting tools.
  • Expand on the capabilities of the Visual Insight dashboard creation wizard to include more complex document templates to make it more appealing for business users who need greater sophistication but less development time nor reliance to BI developers.

Use of Solution

I have used it for 1.5 years at my current company, and for 15.5 years in my entire career.

Stability Issues

In the long history of this product, version 7.2.3 is the most stable. Next to that, it is 9.4.1.

Scalability Issues

I have not encountered any scalability issues.

Customer Service and Technical Support

Unfortunately, over the past five years, fewer capable first-level technical support technicians have been able to answer my questions. The quality of technical support expertise has degraded and there is more reliance on the MicroStrategy community users to help each other than from the vendor.

Initial Setup

Setup is overall fairly easy. However, changes in the metadata/statistics tables from one version to the next can benefit from better documentation to give clients a heads up.

Pricing, Setup Cost and Licensing

Like any enterprise implementation, clients should first take time to analyze the needs of their organization, the level of expertise of their user base and how reports are to be delivered to the end users. Before doing any future upgrades, they should do a sizing exercise by gauging how much server resource is used historically and the projected use over the next 12 months. In particular, many companies underestimate the size and total number of Intelligent Cubes that need to be preprocessed each day.

Other Advice

What I’ve mentioned elsewhere: Planning and sizing is a must, as well as thoroughly understanding the user base and their reporting delivery needs.

Disclosure: I am a real user, and this review is based on my own experience and opinions.
1 Comment
Orlee GillisConsultant

Which practical changes in your productivity would you see in your workflow if more complex document templates were available?

10 October 16
Sign Up with Email