To Remove Year-2012 from my cognos cubes!

[Rizwan88online]

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