My suggestion would be a new column in the fact table. My reason behind this is that where I work we don't only use the datamart to feed the cube...

Can you explain what you mean by grand total?

From what you are explaining you have a monthly snapshot and by adding a new column in your fact table this should...

I know this posting is old and just incase someone is looking for an answer, I have one.

First let me explain the source data. I have a query that returns...