Hello
I want to use the FILTER keyword to extract all members from a dimension whose name is a given value. This is quite easy
FILTER( DimName.children, DimName.currentmember.properties("Name") = "MyValue"

What I now want to do is get every member whose name contains a given string. Something a bit like this
FILTER( DmName.children, DimName.currentmember.properties("Name") LIKE "%MyValue%"

That isn't valid MDX though. Does anyone know how to do this

cheer
Jamie Thomso

using the MDX filter () function and the vba text functions you have plenty of search possibilities.

filter (DimName.children, instr(DimName.currentmember.Properties("Name"),"My Value")>0)

HTH.
Cheers,
Sanka


----- Jamie Thomson wrote: -----

Hello,
I want to use the FILTER keyword to extract all members from a dimension whose name is a given value. This is quite easy:
FILTER( DimName.children, DimName.currentmember.properties("Name") = "MyValue" )

What I now want to do is get every member whose name contains a given string. Something a bit like this:
FILTER( DmName.children, DimName.currentmember.properties("Name") LIKE "%MyValue%")

That isn't valid MDX though. Does anyone know how to do this?

cheers
Jamie Thomson

Thanks Sanka, thats great
What do i need to do in order to be able to use VBA functions? Is it simply having MS Office installed on the same machine as the Pivot Table Service

Regard
Jami


----- Sanka wrote: ----

using the MDX filter () function and the vba text functions you have plenty of search possibilities

filter (DimName.children, instr(DimName.currentmember.Properties("Name"),"My Value")>0

HTH
Cheers
Sank


----- Jamie Thomson wrote: ----

Hello
I want to use the FILTER keyword to extract all members from a dimension whose name is a given value. This is quite easy
FILTER( DimName.children, DimName.currentmember.properties("Name") = "MyValue"

What I now want to do is get every member whose name contains a given string. Something a bit like this
FILTER( DmName.children, DimName.currentmember.properties("Name") LIKE "%MyValue%"

That isn't valid MDX though. Does anyone know how to do this

cheer
Jamie Thomso

Yes. VBA is a core component of Microsoft Office

Cheers
Sank

----- Jamie wrote: ----

Thanks Sanka, thats great
What do i need to do in order to be able to use VBA functions? Is it simply having MS Office installed on the same machine as the Pivot Table Service

Regard
Jami


----- Sanka wrote: ----

using the MDX filter () function and the vba text functions you have plenty of search possibilities

filter (DimName.children, instr(DimName.currentmember.Properties("Name"),"My Value")>0

HTH
Cheers
Sank


----- Jamie Thomson wrote: ----

Hello
I want to use the FILTER keyword to extract all members from a dimension whose name is a given value. This is quite easy
FILTER( DimName.children, DimName.currentmember.properties("Name") = "MyValue"

What I now want to do is get every member whose name contains a given string. Something a bit like this
FILTER( DmName.children, DimName.currentmember.properties("Name") LIKE "%MyValue%"

That isn't valid MDX though. Does anyone know how to do this

cheer
Jamie Thomso

Nothing other than the client install is required.

Cheers,
Richard

--
This posting is provided 'AS IS' with no warranties, and confers no rights.

"Jamie" <jamiekthomson (AT) removeme (DOT) blueyonder.co.uk> wrote

Service?