Hi. I am working on this SQL Analysis Services 2005 project. I created
my fact table, cube, dimensions and measures. One thing I can't seem
to figure out is to prevent a measure from rolling up to a certain
level. One example is percentage. It does not make sense to roll up to
the percentage totals on that column. But it makes sense to show the
percentage result at the most granular level. Another example is total
accounts receivable by location. This measure fluctuates every month
and it does not make sense to roll up the sum of every month's AR all
the way to the year level, but it makes sense to roll it up to the
location level for a specific month.

Any help would be greatly appreciated.

Thanks