Hi everyone, I want to do a query that give me my ProjectLead names, and also the full dimension name and the measure associate with it. example : Xldaoul | [ProjectLeadDim].[All].[Xldaoul] | 200 Luoadlx | [ProjectLeadDim].[All].[Luoadlx] | 12 Can you help me ?Ludovic Bouaziz - MCSD .net

Hi, MDX function Member_Caption can retieve the names, and UniqueName to retrieve the full dimension name. The following is an example against AdventureWorks cube: with member Measures.fullname as [Product].[Product Categories].currentmember.uniquename member measures.capname as [Product].[Product Categories].currentmember.member_caption select {measures.capname,Measures.fullname,[Measures].[Internet Sales Amount]} on 0, [Product].[Product Categories].[Product].members on 1 from [Adventure Works] thanks, Jerry

Thanks Jerry, I was looking for Currentmember function :) but uniquename and member_caption are very useful tought ! Now i bought the mdx step by step book and it's very useful. :) Ludovic Bouaziz - MCSD .net