Cognos @ATF
Outline
- Infrastructure
- Modeling Concepts (FM) (TODAY)
- Modeling for Reports (FM)
- OLAP/Cubes (Transformer) | Reporting (Studios)
- Capstone & Future
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
Objectives
- Dimensions & Facts
- SNOWFLAKE Model
- STAR Model
- Indexes
- Measures & Calculations
- Custom Functions
DATA RELATIONSHIPS
Dimensions vs Facts
Dimensions represent categories/hierarchy.
Facts represent data/statistic.
Snowflake
STAR
Indexes
An index is a reference to a subset of data.
**The Dictionary Analogy**
Performance based on lookup latency.
Performance based on computation.
Calc
Measures vs Calculations
Functions
Today()
ReportDate()
ReportName()
Day 2
By Corey Butler
Day 2
Framework Manager
