Hi,

I am trying to build a cube which has time dimension into it. I wish
to avoid aggregations while processing the cube. The scenario is like
this.

There are monthly values for a set of parameters. When I choose the
year, AS aggregates these values and shows as the value for the
corresponding year. For eg: If the % production for March is 34% and
like wise for other months, when I choose the year It should the value
for the year and not as an aggregated value of all the 12 months (435%
is what I am getting!!!)

Some pointers to avoid aggregation would be appreciated..

Thanks

What is the rule for aggregating the monthly % values for a year
(assuming all months don't have identical values)? If it is a weighted
average, then it may be possible to aggregate the numerator and
denominator separately as sums, then define a calculated measure that
divides them.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***