Differences between OLAP cubes and Super cubes
OLAP | Super | |
---|---|---|
Version | Existed before MicroStrategy 10.0 | New in MicroStrategy 10.0 |
Data Volume | In 9.x, limited to 2 billion rows | Each partition can have up to 2 billion rows |
Schema | A single table dataset, pre-joined | Multiple tables, not pre-joined Closer to raw data staged in-memory; Multiple in-memory fact tables, including varying grains, many-to-many relationship tables, and entity-relation model semantics |
Definition | User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter | User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables |
Query Generation
|
Intelligence Server generates the SQL to execute against the data source (can use Multi-Source) By default, final pass of SQL joins lookup tables to fact table and/or metric temp tables to retrieve attribute descriptions |
Queries submitted to the RDBMS are simple SELECT statements against the tables—no joins among tables |
Partition | Available | Available |
Parallel | Parallel Data Fetch Option set at Intelligent Cube level | Maximum Parallel Queries Per Report set at Project level |
Comments
Post a Comment