I have a dimension with a hierarchy that has a complex aggregation, which I
cannot do inside the cube. Is it possible to load data on non-leaf members,
ie not-lowest-level members?

Thanks

You can use "Members With Data" option on P-C dimensions:

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

In Analysis Services, an assumption is usually made about the content of
members. Leaf members contain data derived from underlying data
sources;nonleaf members contain data derived from aggregations performed
on child members.

In a parent-child dimension, however, some nonleaf members may also have
data derived from underlying data sources, in addition to data
aggregated from child members. For these nonleaf members in a
parent-child dimension, special system-generated child members can be
created that contain the underlying fact table data. Referred to as data
members, they contain a value directly associated with a nonleaf member
that is independent of the summary value calculated from the descendants
of the nonleaf member.

Data members are available only to parent-child dimensions, and only if
the parent-child dimension allows nonleaf members with data. This
feature can be enabled with Dimension Editor by setting the Members with
Data property to Nonleaf data visible or Nonleaf data hidden
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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

Thank you for your answer! I thought about this, but then each parent also
occurs like a child of its own. I want the value on the parent level and see
the data on that level...

"Deepak Puri" wrote: