WITH SET res1 AS ' Filter(Descendants([ID].[Hierarchy].[structure].[1a2p-1], 2) , [ID].[Hierarchy].CurrentMember.Properties("Atom Name")="CA" )' SET res2 AS ' Filter(Descendants([sekret ID].[Hierarchy].[structure].[1a2p-1], 2) , [sekret ID].[Hierarchy].CurrentMember.Properties("Atom Name")="CA" )' MEMBER [Measures].[resnum2] as '[Sekret id].[residue number].membervalue' MEMBER [Measures].[resnum1] as '[ID].[residue number].membervalue' MEMBER [Measures].[distance] as ' ( ((res1.Item( Rank([sekret ID].[Hierarchy].CurrentMember,res2) - 1),[Measures].[x Coord]) -([ID].[Hierarchy].CurrentMember,[Measures].[x Coord]))^2 + ((res1.Item( Rank([sekret ID].[Hierarchy].CurrentMember,res2) - 1),[Measures].[y Coord]) -([ID].[Hierarchy].CurrentMember,[Measures].[y Coord]))^2 + ((res1.Item( Rank([sekret ID].[Hierarchy].CurrentMember,res2) - 1),[Measures].[z Coord]) -([ID].[Hierarchy].CurrentMember,[Measures].[z Coord]))^2 ) ^ 0.5' SELECT filter (res1 * res2, [Measures].distance < 10 and [Measures].distance <> 0) on rows, {MEASURES.[resnum1],MEASURES.[resnum2], MEASURES.[distance]} on columns FROM [dynameomics] WHERE ( [Time].[1], [Run].[1], [Temp].[498], [Conditions].[cs=.4,nbcycl=3,cor=8] );