DSXchange: DataStage and IBM Websphere Data Integration Forum
View next topic
View previous topic
Add To Favorites
Author Message

Group memberships:
Premium Members

Joined: 18 Mar 2007
Posts: 155

Points: 1987

Post Posted: Tue Jul 11, 2017 7:48 am Reply with quote    Back to top    

DataStage® Release: 11x
Job Type: Parallel
OS: Unix
Hello Gurus

I am new to Cognos 10.2 - have some basic expereince in FM . The scenario is that there is a report requirement which needs to check for key change in a perticular column and within the group of same key rows - do a few checks based on certain date columns and create a new column to flag to say 'Y' or 'N'.
I have handelled these scenarios previously using datastage but now trying to find if there is a way to similar transformations in Cognos (either FM or Report Studio ) - From the little research I did I can say that this kind of transformation is only handlled by ETL tools but probably cannot be handled within cognos even if it has capabilities of creating new columns in a query subject and doing if else logic - purely because here the condition is based on grouping rows of data and not 'per' each row (if that makes sense)

It will be nice to know your comments based on the scenario .

Thank you
Display posts from previous:       

Add To Favorites
View next topic
View previous topic
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum

Powered by phpBB © 2001, 2002 phpBB Group
Theme & Graphics by Daz :: Portal by Smartor
All times are GMT - 6 Hours