thanks a lot steve, that was more where I was trying to go. I understood most of your advice and I appreciate the reply. I am a little ignorant of...

Thanks, I was unclear if I could set the cube up that way in analysis services or if it was done on the viewer. You are saying it can only...

My date time dimension table is very similar to yours. So how do I get the aggregations I want. For example how do I get the cube to compare fiscal...