Hi all,

I have a virtual cube build on two cubes

- Cube C1 with measure M1 and dimensions D11 and D12
- Cube C2 with measure M2 and dimensions D21 and D22

Now when I filter the dimension D11, all measure values of M2 disappear!
How can I avoid that?

I would like, that filtering on dimensions of the first cube takes no effect
on
the measures of the second cube and vice versa.

Thanks in advanced
Chris

Hi Chris

Create a calculated member that includes the expression

validmeasure(M2)

This will force the value of M2 to be displayed at the all-level of the
dimensions not included in C2. Also remember to hide the original M2 in your
virtual cube so that only the new calculated member is visible to the users.

/Michael

"Chris" <spiii (AT) gmx (DOT) net> wrote

Hi Michael

Great! It works! Exactly what I want.

Thank you very much!
Chris


"Michael Barrett Jensen" <pwuh1ml02 (AT) NOTVALIDsneakemail (DOT) com> schrieb im
Newsbeitrag news:%23VwKVz1tEHA.2468 (AT) TK2MSFTNGP09 (DOT) phx.gbl...

Do you create the calculated member in the base cube or the virtual cube?
And how do you hide the original measure?

Thanks!
Glen

"Michael Barrett Jensen" <pwuh1ml02 (AT) NOTVALIDsneakemail (DOT) com> wrote