Many of the measures that I have in a cube I developed cannot be rolled up. For example, we take a snapshot of # of accounts we have every month. So if don't do anything and I look at this measure by year, it is duplicating the counts. The numbers will only show correctly if I get to the month level. Is there a way to combat this issue in Transformer?
You should be able to choose how you aggeregate it in the measures area in transformer.
Sorry, I am not understanding what you mean...
I was hopeful that Time State Rollups would do the trick. Particularly 'Last' and 'Current'. But Last won't show a 2010 value until December. 'Current' won't show a 2009 value. Basically, I just if it is May, I want May to be the 2010 Value. But I want December 09 to be the 2009 value. Can this be resolved somehow with special categories?