Hey

I am just wondering whether it is possible to display a different value
in the Total value then the aggregation will produce.

Let me try to explane..

for example.. I have a Time dimension that has this layout

YEAR MONTH DAY
-All Time All Time Total

2004 Total
-2004 + June June Total
1
2
3
4
5
6
+ December

What I am wondering... is it possible to <B>not</B> show "June Total" as
the total of all days in June and rather show it as the last day of
June.. but still retain the sum value for the individual days.

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

You can use custom rollup on the Time dimension:

http://msdn.microsoft.com/library/de.../en-us/olapdma
d/aglevels_344z.asp

Custom rollup formulas and custom member formulas are expressions,
written in Multidimensional Expressions (MDX), that determine the cube
cell values associated with members. A custom rollup formula applies to
all the members (except calculated members) in a level. A custom member
formula applies to a single member.

Custom rollup formulas and custom member formulas are different from
calculated members. Custom rollup formulas and custom member formulas
apply to members that exist in dimension tables. In contrast, calculated
members are not stored in dimension tables. Calculated members provide
members in addition to those in the tables.

Custom rollup formulas and custom member formulas use similar kinds of
MDX expressions.

Both custom rollup formulas and custom member formulas override the
aggregate functions associated with measures.
...

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!