COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Transformer => Topic started by: Rizwan88online on 03 Oct 2017 05:39:53 AM

Title: To Remove Year-2012 from my cognos cubes!
Post by: Rizwan88online on 03 Oct 2017 05:39:53 AM
Hi All,

I have a requirement to Remove Year-2012 from the Cognos cubes.

My Cognos version: 10.2.2
Tool : PowerPlay Transformer
Datasource : IQD file

We have nearly five years data reason for this requirement is to save space/time of cube building.
I thought of applying "Exclude" option in category level but does this works or else do I have to write any condition in my IQD query.

Please advise.

Thanks,
Rizwan.A