MicroStrategy Tutorial
MicroStrategy Objects
MicroStrategy Basic Reporting
MicroStrategy Advanced Reporting
MicroStrategy Dashboards
MicroStrategy Office
MicroStrategy Useful Resources
Selected Reading
- MicroStrategy - OLAP Services
- MicroStrategy - Importing Data
- MicroStrategy - Architecture
- MicroStrategy - Desktop
- MicroStrategy - Environment Setup
- MicroStrategy - Overview
- MicroStrategy - Home
MicroStrategy Objects
- MicroStrategy - Report Objects
- MicroStrategy - Schema Objects
- MicroStrategy - Public Objects
- Configuration Objects
MicroStrategy Basic Reporting
- MicroStrategy - Nested Metrics
- MicroStrategy - Creating Metrics
- MicroStrategy - Rollup
- MicroStrategy - Drilldown
- MicroStrategy - Pivoting
- MicroStrategy - Dicing
- MicroStrategy - Slicing
- MicroStrategy - Report Types
MicroStrategy Advanced Reporting
- MicroStrategy - Intelligent Cubes
- MicroStrategy - Refreshing Reports
- Shortcut & Embedded Filters
- MicroStrategy - Advanced Filters
- MicroStrategy - Creating Filters
- MicroStrategy - Metric Comparison
- Creating Derived Metrics
MicroStrategy Dashboards
- MicroStrategy - Adding Web Content
- Filtering Data in Dashboard
- Visualization with Multiple Datasets
- MicroStrategy - N/W Visualization
- Heat Map Visualization
- MicroStrategy - Grid Visualizations
- MicroStrategy - Graph Visualizations
- Formatting a Dashboard
- Creating a Dashboard
MicroStrategy Office
- MicroStrategy - Predictive Models
- MicroStrategy - Data Marts
- MicroStrategy - Report Cache Flow
- MicroStrategy - Custom Groups
- Conditional Formatting
MicroStrategy Useful Resources
Selected Reading
- Who is Who
- Computer Glossary
- HR Interview Questions
- Effective Resume Writing
- Questions and Answers
- UPSC IAS Exams Notes
MicroStrategy - Architecture
MicroStrategy - Architecture
MicroStrategy has a metadata-driven architecture. The metadata is a central repository, which stores all the objects used by it. Also the metadata can be used by any of the MicroStrategy products, which has ensured uniformity in the values of the objects. The objects stored in the metadata are reusable.
Object Layers
The following diagram represents the different layer of objects created and stored in MicroStrategy metadata.
Administration Objects − This Objects layer estabpshes the security, user grouping, and performance parameters that govern the MicroStrategy apppcations.
Report Objects − This objects layer assembles the building blocks from the Schema and Analysis Object Layers to provide insightful textual and visual analysis.
Analysis Objects − This objects layer provides the building blocks for sophisticated analysis. The analysis objects are built on the objects developed in the schema layer.
Schema Objects − This objects layer provides a logical abstraction of the database schema that is tailored for the business model.
ROLAP Architecture
MicroStrategy can access data from data warehouses, cube databases, flat files, operational databases such as ERPs, CRMS, Web apppcations, etc. For this, it uses a relational OLAP architecture.
The following diagram shows an overall architecture of MicroStrategy platform describing how it accesses data from various sources using the metadata objects.
Dynamic MDX Engine − It generates optimized Multidimensional Expressions (MDX) for interactively accessing cube databases from SAP, Microsoft Analysis Services, Hyperion Essbase, etc.
Dynamic SQL Engine − It generates optimized SQL for interactively accessing data warehouses.
Freeform SQL Engine − It provides direct access to operational databases, text files, and spreadsheets via a graphical Query Builder or through freehand SQL.
Unified Metadata
Finally, MicroStrategy Architect can model multiple sources as if they were a single data source, storing all this information in MicroStrategy s unified metadata.
Advertisements