How to use same prompt/detail filter on two crosstabs

[Lisbeth]

Hi!
Can anyone tell me how I can use the same prompt/detail filter on two crosstabs (w/different queries)?

Thanks

[billylodz]

If it's the same cube, just copy filter to second query

[Lisbeth]

Hi!

I already tried that but get this error:

RSV-VAL-0010 Failed to load the report specification. CCL_ASSERT_NAMED(m_bAllRowsOptimization == FALSE, "The master dataset cannot be re-used for a second iterator if AllRows optimization was applied when the query was executed.");

Have no idea what is wrong...

[billylodz]

http://www.cognoise.com/community/index.php?topic=5866.0