Hi just a quick question about OLAP cubes.
Can the values in one dimension be determined by the contents of another.

E.g.

Dimension1 - Gender
Male
Female

Dimentsion2 - Title
Mr
Mrs
Miss


Basically if I filter a cube to show just 'Male' records using Dimension1, it would be great if when I listed the values in Dimension2 it just showed 'Mr' and not the other two values - as the underlying data would only relate to this one value.

Is this possible?