MDX: EXISTING

  By default, sets are evaluated within the context of the cube that contains the members of the set. The Existing keyword forces a specified set to be evaluated within the current context instead.   with member [Measures].[k] as ([Product].[Category].currentmember, [Measures].[Measures].[Reseller Sales Amount] ) Select [Product].[Category].[All].Children on 1 , Measures.k on 0 from [Adventure Works]…

4