ODS
Operational Data Store
EDS
Enterprise Data Store
RDS
RDS
RDS
RDS
CMS
SQL
Cognos
ODS
ODS
Operational Data Store
EDS
Enterprise Data Store
RDS
RDS
RDS
RDS
CMS
SQL
Cognos
ODS
Architecture
DATA RELATIONSHIPS
Dimensions represent categories/hierarchy.
Facts represent data/statistic.
An index is a reference to a subset of data.
**The Dictionary Analogy**
Performance based on lookup latency.
Performance based on computation.
Calc