MDX via OPENQUERY

When you run a basic MDX query directly against the cube, it returns only those measures and dimensions you have specified in the query. Note that [Customer Geography] is a hierarchy. Select Non empty [Measures].[Sales Amount] ON Axis(0), [Customer].[Customer Geography].[State-Province].Allmembers ON Axis(1) FROM [Adventure Works]            …