MDX help! Need to peg a dimension member.

I'm having problems constructing an MDX statement. I need to be able to navigate one dimension, while returning a value for a specfic member in another dimension. So, where ever I go in dimension A, I need to have an unchanging amount from dimension B.

How can I peg dimension B regardless of where I navigate in dimension A?

Let me know if I need to post an example.

Put the desired member from the dimension B into "where" clause in your MDX query.

For instance:

Select [Product].[Products].[Product Family].members on columns
from [Sales]
where [Time].[Time].[Quarter].&[Q1]&[1997]

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.