Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

How to filter member contain certain wording?

0 views
Skip to first unread message

Lester Lim

unread,
Oct 19, 2009, 3:39:39 AM10/19/09
to
Hi,

Just wonder how am going to filter member by using the following
command.

.ExcludedMember = (" ") --> if i want to filter customer Last Name

Any help will be appreciated.

SQLKID

unread,
Oct 21, 2009, 10:16:01 PM10/21/09
to
Hi Lester,
You might try something like

Filter( [Dim Customer].[Customer Name].[Customer Name].ALLMEMBERS, Instr(
[Dim Customer].[Customer Name].currentmember.Properties( 'Member_Caption' ),
'Lim' ) > 0 )


"Lester Lim" wrote:

> Hi,
>
> Just wonder how am going to filter member by using the following
> command.
>

> ..ExcludedMember = (" ") --> if i want to filter customer Last Name


>
> Any help will be appreciated.
>

> .
>

0 new messages