Hi ,
Thanks for the reply. Any how i got the solution
WITH SET Top10Cust AS
[DimGeographyBuyer].[State].[State]
set topP as
Generate( {Top10Cust}, CrossJoin( {[DimGeographyBuyer].[State].CurrentMember},
TopCount([DimProduct].[MaterialId].[MaterialId].Members, 1, ([Measures].[DistributorSalesSum]))))
SELECT
{([Measures].[DistributorSalesSum]) } ON COLUMNS ,
non empty {topP}
ON ROWS
FROM (SELECT ( { [MarketYear].[MarketYearHierarchy].[MARKETYEAR].&[2014] } ) ON COLUMNS
FROM
[Mycube])