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!
use caption() in all queries