Print Page - How to use same prompt/detail filter on two crosstabs

Title: How to use same prompt/detail filter on two crosstabs
Post by: Lisbeth on 31 Aug 2009 04:54:33 AM

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

Thanks

Title: Re: How to use same prompt/detail filter on two crosstabs
Post by: billylodz on 31 Aug 2009 05:16:41 AM

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

Title: Re: How to use same prompt/detail filter on two crosstabs
Post by: Lisbeth on 31 Aug 2009 07:01:10 AM

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...

Title: Re: How to use same prompt/detail filter on two crosstabs
Post by: billylodz on 31 Aug 2009 08:09:57 AM

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

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Lisbeth on 31 Aug 2009 04:54:33 AM