For the longest time, I understood that Analysis Office did not support this feature.
I happened to be reviewing the SAP Help recently, and found that SP4 supports Contains Pattern:
“Contains pattern (for example, all values that begin with A)* A” Source: SAP Help
I tried it as follows:
It seems to find it:
This is a very simple tip from reading the SAP help.