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
Post a Comment