Equivalent Stored Procedure for Wildcard search.

hi,

i need convert following mdx functionality stored procedure in msas 2005:

select
{ filter([store type].allmembers, instr([store type].currentmember.name,"*", 0) > 0) }
on axis(0)
from [sales]

is possible use stored procedure "like" implemented under analysis services stored procedure project (www.codeplex.com)? if yes, equivalent mdx query implementing same functionality?

thanks , regards,
santosh.

hi santosh,

the function 1 worked on analysis services stored procedure project. implements pattern syntax used in t-sql function as possible using % wildcard character, following query should work:

select
{ assp.like([store type].allmembers, "%*%", [store type].currentmember.name) }
on axis(0)
from [sales]

however should aware using builtin instr() function noticably faster using stored proc. stored proc comes it's own when have more complicated filters or if is a user entered filters.

SQL Server  >  SQL Server Analysis Services