Calculation condition: loading 15 yrs of data, objects calculate on variable

[sibrulotte]

Hi,

so i was told it'd be quicker to load all the data from our warehouse, instead of selecting and posing the condition

Where

GLDetail.Annee_fiscale>=2009;

Thus only loading 5 years.

Load time is quicker without that condition, but object calculations are a pain.

So, how do I use the calculation condition in my objects (pivots) to limit the calculations done to only

GLDetail.Annee_fiscale = AnnCourBilan

Any help is appreciated.

Thanks

Simon

I've tried alot of combinations and still can't get to my goal

[sibrulotte]

Is there anyone one out there savy?

[sibrulotte]

Is there anyone one out there savy?

Is it possible to limit calculations of objects to years determined in a variable?