Hi,
I need to convert the following MDX functionality into a Stored Procedure in MSAS 2005:
SELECT
{ FILTER([Store Type].AllMembers, InStr([Store Type].CurrentMember.Name,"*", 0) > 0) }
ON AXIS(0)
FROM [Sales]
Is it possible to use the stored procedure "Like" implemented under the Analysis Services Stored Procedure Project (www.codeplex.com) If yes, what would be the equivalent MDX query for implementing the same functionality
Thanks and Regards,
Santosh.