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.
In the long history of this product, version 7.2.3 is the most stable. Next to that, it is 9.4.1.
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.
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.
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.
Oct 09 2016