Chris Webb does it again!
I had a tricky problem where I needed to execute a wild card search against a dimension member. I was just about to send Chris an email when I Googled up the very answer from 3 years ago as posted by the very man!.
http://www.dbforums.com/archive/index.php/t-677973.html
PS Chris If you read this can you email me – User Management Console for SQL Analysis Server 2005 will be ready for external feedback as soon as I can generalise it, soon .
First of all great articles.i am new to mdx and have an issue with using wildcards in mdx. can you show a example how to use wildcards to filter data in a mdx query.
for Ex: some thing like this i know this is not valid in MDX , how to achieve something like this. I cant use VBA options inside MDX as SAP BW doesnt support that.
SELECT
[Measures].MEMBERS ON COLUMNS,
FILTER([USERNAME].MEMBERS, [USERNAME].[USERNAME] = “*SAN*” ) ON ROWS
FROM [$CUBE_1]
By: sanjay on Wednesday 19 September, 2007
at 6:37 am