MicroStrategy

Introduction to the MicroStrategy engine

The MicroStrategy engine at a glance

SQL generation process

Basic optimizations

Multipass SQL

Composing optimized SQL

Intermediate tables

Templates

Attributes

Hierarchies

Consolidations

Custom groups

Custom group banding

Metrics

Level metrics

Order of resolution: hierarchies in metrics

Nonaggregatable metrics

Conditional metrics

Transformation metrics

Nested metrics

Metric join types

Filters

Attribute qualification

Set qualification

The analytical engine

Report limits

Subtotals

Compound metrics

Evaluation order

Analytical functions

Introduction to VLDB properties

VLDB properties defined

The VLDB properties editor

VLDB Properties

Governing VLDB properties

Indexing VLDB properties

Joins VLDB properties

Pre/Post statements VLDB properties

Query optimizations VLDB properties

Select/insert VLDB properties

Tables VLDB properties

Dynamic sourcing VLDB properties

Additional benefits

Mock interview sessions

Resume building session