WITH
MEMBER [Measures].[ParameterCaption] AS [Customer].[Customer Hierarchy].CURRENTMEMBER.MEMBER_CAPTION
MEMBER [Measures].[ParameterValue] AS [Customer].[Customer Hierarchy].CURRENTMEMBER.UNIQUENAME
MEMBER [Measures].[ParameterLevel] AS [Customer].[Customer Hierarchy].CURRENTMEMBER.LEVEL.ORDINAL
SELECT NON EMPTY
{ [Measures].[ParameterCaption]
, [Measures].[ParameterValue]
, [Measures].[ParameterLevel]
} ON COLUMNS
, NON EMPTY
HEAD ( FILTER ([Customer].[Customer Hierarchy].[Customer].ALLMEMBERS, INSTR ( 1 ,
[Measures].[ParameterCaption], @paramCustomerSearch)>0) , 5) ON ROWS
FROM [Cube]