How to filter on String properties ?

[jlmuller]

Hello,

I need to filter members on one of their properties. I can easily do this if the property is of type numeric, but I'm unable to filter on string properties.

The following expression does work :
FILTER ([Customer].[Business Id].members, [Measures].prop2 = 1)
The following expression does NOT work :
FILTER ([Customer].[Business Id].members, [Measures].prop1 = AAA)

How could I proceed, as I don't want to create a dimension for that property.

Thank you very much for your help !

 

[MDXer]

have you tried single quotes or double quotes I forget which AS uses.

FILTER ([Customer].[Business Id].members, [Measures].prop1 = 'AAA')

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck

 

[jlmuller]

double quotes gives Syntax Error, while single quote gives Invalid Token Error (I'm using MDXSample application).

If I try [Measures].prop1 <> AAA, I've got some results, including the properties whose value is AAA...

Any idea ?