Sunday January 21st 2018




Micro strategy 9 enables departmental BI

This information is from Microstrategy 9 Press release 2009. The main spirit of this specific topic is Setting up new departmental BI Environment quickly, with little or no IT Support. I found that an ideal solution as in my experience a lot of time is wasted during the process of understanding business end users needs and perception by pure technology expert. As most technical people, although they are good in there field but not in understanding business needs.  

Microstrategy had addressed these issues as follows;

The biggest hurdle with typical BI installations is staging the data so that users can begin assemble reports and dashboards. Data staging requires significant effort and entails designing the business intelligence data model, finding data sources, reconciling data discrepancies, and building the extract, load (ETL) routines that periodically refresh the business intelligence database with the latest information. Data staging takes time and requires engineering expertise that rarely exists within departments or work groups.

The Microstrategy’s solution;

Micro strategy addresses 9 addresses these issue as follows;


Multi-source ROLAP:


With Micro strategy 9, organizations can access and combine data from data marts, operational systems, and excel spreadsheets using new capabilities called “ Multi Source ROLAP”. Multi Source ROLAP eliminates the requirements to move data from multiple source databases into purpose built data ware house or data mart. Instead Multi source ROLAP allows companies to access the data directly from where it resides, with no special data engineering or data movement. This radically reduces the time to set up the BI environment and lowers the technical expertise required.


IN Memory ROLAP:


In-memory ROLAP includes a database that can serve data to reports, dashboards and OLAP analyses. In memory ROLAP requires no special set up or data modeling. Micro Strategy automatically designs and configures database based on the relationship between attributes and metrics specified by business users. The in memory database technology operates, in the computer server’s main memory for high speed performance, but is also stored on disk for greater performance and offers the ability to swap in and out  of memory based on usage.


Simplified extract and load capability


Micro strategy 9 supports a simplified extract and load capability to periodical repopulate the in memory database with latest information from source system database. Using Microsoft out of box query engines and scheduling  systems, departments can schedule extractions from RDBMS, Excel spread sheet, flat files and Multidimensional databases, including Microsoft analyses and Hyperion / Oracle Essbase. When combine with the Micro strategy 9 Multi-source ROLAP capability, the query system can even join data across multiple databases and Excel to populate in-memory database.


Rapid Meta data creation


Micro strategy 9 offers multiple features that enable the rapid creation of metadata. Micro strategy’s new graphical architect makes it possible for non-IT people to select one or more source databases, identify the tables and columns desired, load them into the BI System , and transform them into business oriented definitions that business people can understand and use assemble into reports and dashboards. Graphical Architect also includes a series of smart assistants to help streamline the process, including auto-recognizing attributes and metrics and auto recognizing the same data in multiple databases.


My poin of view;



I found this feature a promising one as it attempts to remove the main hurdle of  understanding gap between Business user’s needs which are critical for  survival of the business and tech personal’s non familiarity with business process.