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 )
Quote from: ww55d on 18 Aug 2015 04:33:25 PM
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:
Quote from: ww55d on 18 Aug 2015 04:33:25 PMthen 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.