Welcome to the new CogKnowHow.com!


If you have trouble logging in, reset your password via the login window
by clicking the 'Forgot Password' link.

ETL question


#1

Fairly new to using Framework Manager. We have data coming from several sources. We will be using ETL to transform and clean data etc. if we do this will it eliminate the need to build the transformation layer in cognos framework manager?

The training classes I took went right from dub source so this is a new approach I’m trying to get up to speed on. I’m reading The Data Warehouse Toolkit book, to learn more. Any help would be greatly appreciated :slight_smile:


#2

Using a trigger is the way to go. Have not used events for a while. this is version 8.4 but the principles are the same in Cognos 10.x.
See doc : http://publib.boulder.ibm.com/infocenter/caapps/v8 r4m0/index.jsp?topic=/com.ibm.swg.im.cognos.ug_cc.8.4.1.doc/ug_cc_i_Sett ingUpEvent-BasedReportScheduling.html