How can I get a known subset of hierarchy members when slicing a cube. The code attached (against Adventure Works) will work. It will return all reseller sales in Arlington, Texas between 7/1/2005 and 7/1/2006. ALMOST what I want. If I change &[Arlington]&[TX] to allmembers - a get a result set for all Cities in the hierarchy.
But I want just Arlington and Atlanta. If I uncomment Atlanta, I get "The City hierarchy is used more than once in the Crossjoin function." How can I limit my result set to just two cities??
(I'm offering 500 points here. Please give me working code. Thankyou.)
[Measures].[Reseller Order Count]
// * [Geography].[City].&[Atlanta]&[GA]
) on 0
from [Adventure Works]