Share Result Set

[ww55d]

I'm trying to wrap my head around how to properly use the "Share Result Set" property within the Properties > Data portion of a List. I think that I understand the description under it, however an example would be helpful.

secondarily, what I'm trying to do is retrieve an initial relational query for example:


date, location name, brand, sales

then create separate graphs for :
total sales by date
total sales by brand
total sales by location

even after enabling that previous function, it still looks to execute three different queries with no re-use.
with our Realtime DBs here, speed becomes an issue -- eg: if the first query took 2-3 minutes to execute, the data would've changed by then for the subsequent queries..

thanks in advance for any insights..

(cognos 10.2.2 / report studio )

[MFGF]

I'm trying to wrap my head around how to properly use the "Share Result Set" property within the Properties > Data portion of a List. I think that I understand the description under it, however an example would be helpful.

secondarily, what I'm trying to do is retrieve an initial relational query for example:


date, location name, brand, sales

then create separate graphs for :
total sales by date
total sales by brand
total sales by location

even after enabling that previous function, it still looks to execute three different queries with no re-use.
with our Realtime DBs here, speed becomes an issue -- eg: if the first query took 2-3 minutes to execute, the data would've changed by then for the subsequent queries..

thanks in advance for any insights..

(cognos 10.2.2 / report studio )

Hi,

I was with you, nodding along in agreement, until I got to the part that read:

then create separate graphs for :

Sadly, the "Share result sets" feature is applicable only to lists, repeaters and repeater tables. Take a look at the Report Studio User Guide, page 970:
http://public.dhe.ibm.com/software/data/cognos/documentation/docs/en/10.2.2/ug_cr_rptstd.pdf

Cheers!

MF.