Hi just a quick question about OLAP cubes.
Can the values in one dimension be determined by the contents of another.
Dimension1 - Gender
Dimentsion2 - Title
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.