/
Cognos Report Development Options
Cognos Report Development Options
- Durendal Huynh
Owned by Durendal Huynh
| Area | Option No | Option | Description | Development Efforts | ETL Requirement | Developer Complexity | User Complexity | Performance | Security | Maintenance Efforts | Slowly Changing Dimension Support |
|---|---|---|---|---|---|---|---|---|---|---|---|
| Report Creation | |||||||||||
| 1 | Cognos Tool: Workspace Advanced | Self-serve BI and reporting | 16-40 | See data modeling | Low. | Low, if package properly vested, designed and implemented | Same as others | High. Integrated with KSAMS | Low. User maintains their own. Cognos developer maintains package. | See data modeling | |
| 2 | Cognos Tool: CAFÉ | Self-serve BI and reporting | 16-40 | See data modeling | Low. | Low, if package properly vested, designed and implemented, and users are proficient with Excel | Same as others | High. Integrated with KSAMS | Low. User maintains their own. Cognos developer maintains package. | See data modeling | |
| 3 | Report Studio: Canned report. Simple with no prompts, few summary | Developed by Cognos developers, execute by users. | 2-4 hours | See data modeling | Low. | Low | Same as others | High. Integrated with KSAMS | Low | See data modeling | |
| 4 | Report Studio: Canned report. Medium complexity with more than 10 prompts, groupings and charts | Developed by Cognos developers, execute by users. | 20-40 hrs | See data modeling | Low. | Low | Same as others | High. Integrated with KSAMS | Low | See data modeling | |
| 5 | Report Studio: Canned report. High complexity with more than 10 prompts, groupings and charts, dynamic columns and sort selection (GL Transaction and Summary) | Developed by Cognos developers, execute by users. | 40-160 hrs | See data modeling | Low. | Low | Same as others | High. Integrated with KSAMS | Low | See data modeling | |
| 6 | Cognos Application (GL Adhocs) | Cognos Workspace Advanced replacement | Weeks-Months, see estimate worksheet below | See data modeling | Low. | Low | Same as others | High. Integrated with KSAMS | Low | See data modeling |
Estimate Worksheet
| Report Development | ||||||
|---|---|---|---|---|---|---|
| 1 | Filter criteria | Count | Unit Hrs | Total Hrs | ||
| How many are text | ||||||
| How many are check boxes | ||||||
| How many are dates | ||||||
| How many are drop down | ||||||
| How many are search & select | ||||||
| 2 | Output options | |||||
| Default columns: what are they | ||||||
| Selectable columns? Yes-> how many | ||||||
| Sort-table columns? Yes-> how many | ||||||
| 3 | Drill down? | |||||
| How many? To existing or new reports? | ||||||
| 4 | Dynamic Grouping: | |||||
| How many levels? | ||||||
| How many different columns? | ||||||
| 5 | Dynamic Sub-Total | |||||
| How many different columns? | ||||||
| 6 | Save query? | |||||
| Project Management | Count | Unit Hrs | Total Hrs | |||
| Requirement Spec | ||||||
| Functional Spec | ||||||
| Test Specs | ||||||
| SN Project | ||||||
| UAT | ||||||
| Meeting/Project Updates | ||||||