I am making a cube which Avg must be used instead of Sum for
aggregation. As there is no Avg provided out of the box, how can I
easily create such cube? The cube has 5 dimensions and Avg must be
applied for all of them.

Any help will be greatly appreciated!!


Jimmy

There's an example of this in one of the Foodmart cubes. All you need to do
is create one measure based on SUM and one measure based on COUNT. Then
create a calculated member that divides the SUM by the COUNT.


--
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.

"Jimmy" <me (AT) jimmyho (DOT) com> wrote