SSAS cube creation question - parent/child relationship?

Not currently being able to see the dimensions/measures present in your cube, it would be roughly SELECT { Measures. Total, Measures. Position } ON 0 FROM YourCube WHERE( Race.RaceType.

A, Result.Gender. M ) This is assuming you've chosen the default aggregation for your measures, which is SUM.

Thanks, that makes sense. I don't have access to my cube at the minute to try this so I'll ask instead... if I were to change Race 2 to type B and Result 4 to have a Gender of M would this still return the same results - it's this that I have struggled with. – SMGoodyear Jul 27 '10 at 11:13 @Big Fat Noodle - I don't think so, as result 4 would be Gender M but not RaceType A.

The criteria in the WHERE for MDX can be roughly thought of as an AND operation. – Jamiec Jul 27 '10 at 11:15 OK, so is this because of the way that the dimensions and/or underlying data is structured, or is it just not possible to solve? – SMGoodyear Jul 27 '10 at 12:00 And thanks for the comments - they're really helpful.

– SMGoodyear Jul 27 '10 at 12:01.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.