I am trying to find a function to check if a particular member exist in the
dimension. I will have a string that it could or not be a valid member in the
dimension. For

Example:
STRING ===> "[Time].[Standard].&[Jan 2002]"
I want to check if this string is a valid dimension member in my Time
dimension.

Any help would be appreciated. Thanks.

Dont think you can use the StringToMember.

Try
FILTER([Vintage].Standard.Members,
[Vintage].Standard.CurrentMember.UniqueName = "[Time].[Standard].&[Jan
2002]").Count=0
OR
FILTER([Vintage].Standard.Members,
[Vintage].Standard.CurrentMember.Properties("Key") = "Jan 2002").Count=0

"Sampa2870" wrote:

You can do this with the VBA ISERROR function, as in the following Foodmart
2000 example:

WITH MEMBER MEASURES.TEST AS 'IIF(VBA!ISERROR(STRTOVALUE("MEASURES.[UNIT
SALES]")), 1,0)'
MEMBER MEASURES.TEST2 AS 'IIF(VBA!ISERROR(STRTOVALUE("MEASURES.[THIS WONT
WORK]")), 1,0)'
SELECT {MEASURES.TEST, MEASURES.TEST2} ON 0 FROM SALES

HTH,

Chris


"Sampa2870" wrote: