Filtering multi-cube queries from a single value prompt

[ChrisJ]

Please, anyone, this is driving me nuts..

My report package hosts data from two cubes, each serving a crosstab of its own in the report.

Now: I need to filter both crosstab queries by Year. The cubes contain identical Time hierarchies, so I thought it should be possible to create a value prompt for Year and then apply the selected value to filter/slice both crosstab queries.

However, I have not been able to make this work!

Obviously, if I populate the value prompt from a query to one Time dimension, the result works on one crosstab but not on the other.

So I went on to populate the value prompt by static items instead (like All Years, 2004, 2005, 2006, etc).
Seemed a good idea, but making it work was another matter. I always stumbled on string / member comparison problems. Think I tried everything, but so far without success.

So please, what would be the best way do this?
Any hints greatly appreciated!

[billylodz]

use caption() in all queries