Cognos Data Sourcing Options

Area	Option No	Option	Description	Development Efforts	ETL Requirement	Developer Complexity	User Complexity	Performance	Security	Maintenance Efforts	Slowly Changing Dimension Support
Data Modeling
	1	Direct SQL in Report Studio	No data modeling required. Use SQL statement to extract data at run time. Dynamic SQL will be created when prompt parameter is embedded in SQL.	2-4 hrs	None	Low, assuming developer knows ODS well	High	Low, as it impact the ODS	Low. User can specify their own SQL. UCI requires Restricted Developer KSAMS role	High. Request ODS knowledge.	No
	2	Simple FM model on ODS model	FM model is developed with SQL statements as data source.	8-40 hrs	None	Low, assuming developer knows ODS well	Low. FM package expose business layer info.	Low, as it impact the ODS	High. Secured by KSAMS	Low	No
	3	Simple FM model on ODS model using view	FM model is developed with SQL view as data source.	8-40 hrs	None	Low, assuming developer knows ODS well	Low. FM package expose business layer info.	Low, as it impact the ODS	High. Secured by KSAMS	Low	No
	4	Simple FM model on ODS model using materialized/indexed view	FM model is developed with Materialized/Indexed view as data source.	16-40 hrs	None	Low, assuming developer knows ODS well	Low. FM package expose business layer info.	High, if all materialized/indexed views are extensively indexed	High. Secured by KSAMS	Medium. Materialized/indexed views refreshment requires a bit of coding/scheduling.	No
	5	Simple FM model on ODS model using a cloned ODS	FM model is developed with cloned ODS data source.	16-40 hrs	None	Low, assuming developer knows ODS well	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	Medium. Replication requires a bit of coding/scheduling.	No
	6	Simple FM model on ODS model using simple dimensional model (e.g. UCI Cognos Performance)	Dimensional DB schema. Relational Cognos model.	40-80	Yes	Medium. DB design required.	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	Medium. ETL, DB development required.	Yes
	7	Simple FM DMR model on ODS model using complex dimensional model (e.g. UCI Cognos Performance)	Dimensional DB schema. Relational Cognos model.	60-100	Yes	Medium. DB design required.	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	Medium. ETL, DB development required.	Yes
	8	Moderate FM model on ODS model using simple dimensional model (F5 Performance Monitoring, KSAMS)	Dimensional DB schema. Relational Cognos model.	100-160	Yes	Medium. DB design required.	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	Medium. ETL, DB development required.	Yes
	9	Moderate FM DMR model on ODS model using complex dimensional model (F5 Performance Monitoring, KSAMS)	Dimensional DB schema. Relational Cognos model.	100-160	Yes	Medium. DB design required.	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	Medium. ETL, DB development required.	Yes
	8	Complex FM model on ODS model using simple dimensional model (KFS, UCPath)	Dimensional DB schema. Relational Cognos model.	Months	Yes	Medium. DB design required.	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	High. ETL, DB development required.	Yes
	9	Complex FM DMR model on ODS model using complex dimensional model (KFS, UCPath)	Dimensional DB schema. Relational Cognos model.	Months	Yes	Medium. DB design required.	Low. FM package expose business layer info.	High. No impact on production ODS	High. Secured by KSAMS	High. ETL, DB development required.	Yes

Estimate Worksheet

Data & Modeling	No	Item	Description	Count	Unit Hrs	Total Hrs
	1	Selected Data Modeling Option	Select data modeling base upon needs
	2	Model design	Design Relational/Dimensional per #1
	3	DB Design	Implement DB per #1
	4	ETL	ETL per #1
	5	Security	Report/Object/Row level security design and implementation
	7	Framework	Framework Design & Development
	8	Package	Package Design & Development

Project Management				Count	Unit Hrs	Total Hrs
		Requirement Spec
		Functional Spec
		Test Specs
		SN Project
		UAT
		Meeting/Project Updates

Public Documents

Cognos Data Sourcing Options

Analytics

Related content