<anonymous@discussions.microsoft.com> wrote:

>Hello there,
>
>The "issue", that I have, is that the OLAP server sums every measure regardless the type of dimension. For example, suppose that I have a fact table which loads every Friday the account balance for the customers. And for example the account balance is not additive by time as if I cut the date dimension to set it to March 2004, the OLAP server gives the sum off all the balances for March which is makes no sense; so what I do is to set the date dimension to the last value available that I have for which I have data loaded in the fact table, lets say the third Friday of March and the value that I get that way is the right one. The same applies to the debts the customers have.
>
>Do you know how to deal with these issue using the OLAP?

>
>Thanks
>Cesar