Outline

1. Infrastructure (Today)
2. Modeling Concepts (FM)
3. Modeling for Reports (FM)
4. OLAP/Cubes (Transformer) | Reporting (Studios)
5. Capstone & Future

ODS

Operational Data Store

EDS

Enterprise Data Store

RDS

RDS

RDS

RDS

CMS

SQL

Cognos

70 Guides

• ~250pp/ea
• 17,500 pages total

Equivalent of reading "War and Peace" 14 times

Objectives

• Architecture: The Important Parts
• Capacity Planning
• Administration
• Security
• Capability Planning
• Development
• Trajectory & Scheduling

AWARENESS

Architecture: What really matters?

Architecture

Special Features

• Audit Log
• Content Archives

Architecture

Scale Geographically

Scale Performance

Growth

Performance

Understanding Capacity

• Track Stress Levels
• OLAP Data (Cubes)
• Relational Data (SQL Server)
• ETL (The stessor below the surface)

(Gatekeeper, aka Don's future)

Administration

Security

• Cognos Security
• Company Security (Active Directory)
• Source Security

Capability Planning

• Tenants
• Connection
• Access Control
• Package Features

Organizational Structure

Development

• Connection
• Access Control
• Package Features

Trajactory

• Data Accessibility
• Human Factor
• Automation

Managing Trajectory

• Standardized Req. Gathering
• Natural Workgroups
• Published Roadmap
• COE (Governance, Req. Mgmt, Status)
• Scheduled Release Cycles (Agile)

Questions?