Dear All,

I have a cube named Sales. it has several dimensions two of them are
[Product Form] and [Product Category] and they have the same
hierarchy. I am trying to find a member inside the [Product Category]
that is equivalnt to a specfic member inside the [Product Form] using
the following:

LinkMember( [Product Form].[All Product Form].[DROPS].[OTOCALM Ear
Drops 10 ML 23] , [Product Category])

This function returns "Miscellanous" which is a member in [Product
Category] and not a member in [Product Category].[product].

Note:
when I run this function using a product other than "OTOCALM Ear Drops
10 ML 23" the function returns true result.

I don't know why this happened.

Thanks for any suggestion.

Marwa.

Marwa, are you aware that LinkMember is based on key, not name? Do the keys
conform?

public @ the domain below
www.tomchester.net

"Marwa" <maelteir (AT) yahoo (DOT) com> wrote

Hi Tom,


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Hi Tom,


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote

Hi Tom,

Thanks for your note, I can solve the problem by simply modifying the
key of the first level in the [product category]dimension to be a name
instead of a number.

Thanks again.


"Tom Chester" <publicNOSPAM (AT) tomchester (DOT) net> wrote