ssrs 2012 - MDX Query Wild Card Search -


can 1 me on how perform wild card search in mdx queries?

for example have parameter called testname in ssrs report.default value of parameter [dim test master].[test name].[all]. when test name searched example quli% should return qualitative test in result.
have tried using instr asks default value. in case cannot predict test name can ,so if give false default value not expected out put. insert query

 select   filter(      [dim test master].[test name].[test name].allmembers    ,instr([dim test master].[test name].currentmember.properties( 'member_caption' ), @tname )  > 0   

when report opens test names should displayed default , when search 1 particular searched test must displayed.

if have ssas multidimensional recommend deploying assp , using 1 of these string searching wildcard functions. think more straightforward attempting use instr: http://asstoredprocedures.codeplex.com/wikipage?title=stringfilters&referringtitle=home


Comments