Cognos Report Development Options

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

Public Documents

Cognos Report Development Options

Analytics

Related content