Hi,
what are/is a way to not aggregate measures along let's say a time
dimension? I tried to use various properties of the dimension and it's
levels (like Aggregation usage, enable aggregation) and they don't seem to
do the trick.
Thanks in advance,
Koni.

Hi Koni,

Setting those properties controls whether or not aggregates will be created
along those dimensions. However, I'm not sure that is what you're trying to
do. I think you might be trying to keep the data from being aggregated
using the aggregate function defined by a base measure (say SUM, MIN, MAX,
COUNT, etc). That is an entirely different subject. BOL addresses this
under topics such as Custom Rollups, Unary Operators, Calculated Cells, etc.


Sean


--
Sean Boon
SQL Server BI Product Unit

--
This posting is provided "AS IS" with no warranties, and confers no rights.
Use of included script samples are subject to the terms specified at
http://www.microsoft.com/info/cpyright.htm.


"Koni Kogan" <k_kogan (AT) hotmail (DOT) com> wrote

Thanks, for the response. May be I need to explain the details.
I have a simple cube:

dimensions:
Tables: Server->Database->Table
Time: Year->month->date
Measures: Tables Size, Index size, Total size (calc)


As you might imagine these measures need to be aggregated along Tables
dimension but not Time. We just have to display the growth of different
levels of Tables dimension over time.
I am looking for a 'simple' way to do this. I mean something that avoids
MDX coding as in Custom Rollups or Calculated cells. I could not find a way
to apply Unary Operators. It seems like a very common scenario, so can this
be done?

Thanks,
Koni.

"Sean Boon [MS]" <seanboon (AT) online (DOT) microsoft.com> wrote