My cube contains a dimension (Company) in which I allow
Parent Level Data. Is there a why to prevent values from
sublevels to be aggregated up to Parent level? I have
tried to use Unary Operator '~' for sublevels, but the
only effect I see is that values for sublevels will not
be displayed. Is there a way to display values on
sublevels, but prevent these values to be aggregated?

Thanks,

Hi Rickard,

on one of cubes I had the same problem.
You have a parent-child dimension and parents have their own data.

The solution/workaround I made is:
to take parent value - sum of all children

example:
[Measures].[SalesVolume] -
sum(
descendants([Products].currentmember, 1), [Measures].[SalesVolume])

And then I do not show the original measure, but this one. It works fine.

Tell me if it work for you.


Peace,
Andrej



"Rickard" <rickard.rygin (AT) frango (DOT) com> wrote