I have a cube with two dimensions country and group and the cube has one
measure only: MemberCount which is count
of members by country and group.
Group dimension in Cube 1 named Group1 has the following member
keys:1,2,3,4,5

I have another cube with two dimensions -country and group2. the country
dimension is the same as the Cube1 , but the group
dimension has member keys 1,2,3 only but the keys for the group leaf level
are the same as in group1 dimension in
the first cube. The second cube has pricing data and pricing measures by
country and groups.

I intend to join these two cubes in a virtual cube, and get the member count
by country and group to be
used to divide other measures from cube 2. I bring in group dimensions from
both the cube in this virtual cube, and hide
the group1 dimension.

I use the following calculated member in the virtual cube:

validmeasure((MemberCount,linkmember(Group2.curren tMember,Group1)))

The value for the leaf level is correct, however the rollup for Group2
dimension are not correct.
The Rollup for the levels above leaf level in group2 dimension are getting
the data from group1 levels which includes the sum for member keys 4 and 5
also.

How can I fix this.

lve

Never mind. I figured it out.


"lve" <lve3162 (AT) yahoo (DOT) com> wrote