Forthcoming MicroStrategy Tool To Tap Multidimensional Databases - InformationWeek

InformationWeek is part of the Informa Tech Division of Informa PLC

This site is operated by a business or businesses owned by Informa PLC and all copyright resides with them.Informa PLC's registered office is 5 Howick Place, London SW1P 1WG. Registered in England and Wales. Number 8860726.

IoT
IoT
Software // Information Management

Forthcoming MicroStrategy Tool To Tap Multidimensional Databases

MicroStrategy 8 users will be able to report on, analyze and monitor data held in relational databases as well as multidimensional sources.

Business intelligence software maker MicroStrategy said this week that the latest release of its flagship analytics and reporting platform will be able to access multidimensional data sources, such as Microsoft Analysis Services and Hyperion Essbase. MicroStrategy expects to release the software upgrade in the first quarter of this year.

The change means MicroStrategy 8 users will be able to report on, analyze and monitor data held in relational databases and multidimensional sources from SAP, Microsoft and Hyperion. The BI firm hopes the upgrade will help it capitalize on companies' growing desire to standardize on fewer reporting and analysis apps.

"By providing direct access to multidimensional data sources, our customers have added flexibility and functionality to use MicroStrategy across their enterprise," said MicroStrategy COO Sanju Bansal in a prepared statement.

MicroStrategy's Relational Online Analytical Processing engine uses an optimized dynamic SQL capability to access data warehouses. The upcoming release of MicroStrategy 8 will include a Multidimensional Expressions engine, which is capable of tapping into MDX data sources such as Microsoft Analysis Services and Hyperion Essbase.

The MDX engine is built on the XML for Analysis standard. MDX uses a syntax similar to SQL, but whereas SQL is used to query relational tables, MDX is used to query multidimensional cubes, or OLAP databases.

We welcome your comments on this topic on our social media channels, or [contact us directly] with questions about the site.
Comment  | 
Print  | 
More Insights
InformationWeek Is Getting an Upgrade!

Find out more about our plans to improve the look, functionality, and performance of the InformationWeek site in the coming months.

News
Becoming a Self-Taught Cybersecurity Pro
Jessica Davis, Senior Editor, Enterprise Apps,  6/9/2021
News
Ancestry's DevOps Strategy to Control Its CI/CD Pipeline
Joao-Pierre S. Ruth, Senior Writer,  6/4/2021
Slideshows
IT Leadership: 10 Ways to Unleash Enterprise Innovation
Lisa Morgan, Freelance Writer,  6/8/2021
White Papers
Register for InformationWeek Newsletters
Video
Current Issue
Planning Your Digital Transformation Roadmap
Download this report to learn about the latest technologies and best practices or ensuring a successful transition from outdated business transformation tactics.
Slideshows
Flash Poll