Hi,

It depends on two factors

What is the most common date used for querying - therefore the users queries will be quicker if partitioned correctly

Or do you get a date that is always incremental in your load and therefore you could process your cubes by just the latest partition - this will make your processing quicker

That's a judgement call you will have to make as it is impossible for me to understand any of this purely off the column names

Mack