I wonder if anyone else has run into this problem. It's not that uncommon
that the data in parent-child hierarchies is pre-aggregated for some non-leaf
members (i.e. the total is already provided which replaces the rollup of the
children).

This worked very well in AS 2000. You just indicated "non-leaf members with
data" and "non-leaf data members hidden". Doing something like this (only the
second setting is now present) in AS 2005 results in the pre-aggregated data
member being added to the total of the children. It just doesn't make sense
in most cases. The only work-around I see for this is the use of the
calculated measures (hiding the original ones). Are there any others? Does
Microsoft plan to change this behaviour?

Hi Stan,

Are you refering the ability of datamembers replacing the value of their
parents? The ability is certainly still there, but it's not in the wizard as
it used to be. And the custom level expressions used in 2000 are replaced by
mdx scripts.

I wrote up something on how to do this in 2005 at my own website:
http://www.sqlserveranalysisservices.com. Check out the doc entitled
"Loading Aggregate Data".,

Hope this helps,
Richard (richtk (AT) microsoft (DOT) com)



--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.


"Stan Kondrat" <StanKondrat (AT) discussions (DOT) microsoft.com> wrote

Thanks, this document clarified a few things and provided other useful
techniques.

Stan

"Stan Kondrat" wrote: