Microstrategy Basics

Micro Strategy Desktop is a business intelligence environment designed to meet today’s sophisticated business intelligence requirements. It brings integrated query and reporting, powerful collaborative analytics, and investigative workflow to every desktop.

Micro Strategy Desktop enables project designers, report designers, and system administrators to design, create, and maintain an entire business intelligence system from a single interface.

Desktop has two editions:

• Micro Strategy Desktop Designer is a full-featured version of Micro Strategy’s business reporting environment that enables report designers to develop complex and sophisticated reports and documents.

•  Micro Strategy Analyst is a simplified version of Desktop Designer that provides functionality that lets users format and reorganize report data for easier analysis.

Micro Strategy Web is a user-friendly environment for interactive analysis. A full set of data browsing, drilling, and reporting development capabilities.

ROLAP Architecture of Micro strategy Platform.

Following diagram shows the ROLAP architecture.

Core or Micro Strategy BI Platform.

·         SQL Engine and Query Engine: Works together to generate and send optimized SQL to the RDBMS.

·         Analytical Engine: Adds analytical power to greatly extend the capability of the system beyond the RDBMS provides and also responsible for MOLAP functionality.

·         Server Components: Responsible for all aspects of report generation, element retrieval, and object retrieval.