- MicroStrategy Tutorial
- MicroStrategy - Home
- MicroStrategy - Overview
- MicroStrategy - Environment Setup
- MicroStrategy - Desktop
- MicroStrategy - Architecture
- MicroStrategy - Importing Data
- MicroStrategy - OLAP Services
- MicroStrategy Objects
- Configuration Objects
- MicroStrategy - Public Objects
- MicroStrategy - Schema Objects
- MicroStrategy - Report Objects
- MicroStrategy Basic Reporting
- MicroStrategy - Report Types
- MicroStrategy - Slicing
- MicroStrategy - Dicing
- MicroStrategy - Pivoting
- MicroStrategy - Drilldown
- MicroStrategy - Rollup
- MicroStrategy - Creating Metrics
- MicroStrategy - Nested Metrics
- MicroStrategy Advanced Reporting
- Creating Derived Metrics
- MicroStrategy - Metric Comparison
- MicroStrategy - Creating Filters
- MicroStrategy - Advanced Filters
- Shortcut & Embedded Filters
- MicroStrategy - Refreshing Reports
- MicroStrategy - Intelligent Cubes
- MicroStrategy Dashboards
- Creating a Dashboard
- Formatting a Dashboard
- MicroStrategy - Graph Visualizations
- MicroStrategy - Grid Visualizations
- Heat Map Visualization
- MicroStrategy - N/W Visualization
- Visualization with Multiple Datasets
- Filtering Data in Dashboard
- MicroStrategy - Adding Web Content
- MicroStrategy Office
- Conditional Formatting
- MicroStrategy - Custom Groups
- MicroStrategy - Report Cache Flow
- MicroStrategy - Data Marts
- MicroStrategy - Predictive Models
- MicroStrategy Useful Resources
- MicroStrategy - Quick Guide
- MicroStrategy - Useful Resources
- MicroStrategy - Discussion
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
MicroStrategy - Schema Objects
Schema Objects are the MicroStrategy Objects which are logical representation of the structures of a data warehouse. These are the objects which are decided during the creation of a MicroStrategy project.
Login to MicroStrategy developer as administrator. Navigate to MicroStrategy Tutorial and expand the Schema Objects option. The following screen opens up showing the various schema objects.
Following are the various Schema Objects with their description.
Facts − They are the numeric values, which can be aggregated to represent the value of some business data.
Attributes − They represent the granularity of data in the facts table. They are generally the descriptive data from the business.
Hierarchies − They represent the relationship between various attribute values. They help in carrying out drill-up and drill-down analysis on the data.
Functions and Operators − These are the various inbuilt mathematical functions and operators available in MicroStrategy to apply calculations to the data.
Tables − They simply represent data in a tabular form (columns and rows).
Transformations − They are the data transformation features used for time-series based analysis of the data.
Partition Mapping − This feature is used to create a logical division of the partition of fact tables so the querying becomes more efficient.