changing source of dataitem without requerying

[garfunkal]

Hi

I have a report with a few numeric data items.  Cased on the user choice from a drop down with a default static item, the data in two of the data items will change.

for example:

column A = Cheese
Column B = new data item (container for other data)
Column C = 55.56
Column D = 65.41
Column E = 100.14

So when the user chooses C from the prompt, I want Column B to hold C's Data (55.56) Likewise  when they choose D and E - I'll eventually hide CDE and B will become a conditionally formatted image. 

I can do all that and it works  - I want to know how to make it so it doesn't re-query the database each time the prompt is changed.  All the data is there in the query already - So should it need to go back to the DB?  how do i make it just use the exisiting data items?

[blom0344]

Since Cognos 8 lacks a client component the query resultset will always originate from the combination of DB/Server. The Cognos server may re-use cached data, but I think it is wrong to think of the query as a datacontainer. Going back to the DB may not be a problem either as results may still be in memory, access-paths are available etc.

[garfunkal]

ahhhh - that makes sense - i guess i'm used to old BO dataproviders!

cheers for your help!

[blom0344]

The sight of  'BO' and the term  'dataproviders'  makes me grin from ear to ear!!  Back to the days of the finest BI solution that ever was!

BO full client  (coined 'desktop' intelligence by now and still available.)

The slickness of synchronizing 'umpteen' dataproviders at the client side , the speediness in developing a report!

Okay , I'm getting carried away, tons of stuff Cognos 8 does better.. 

[garfunkal]

We still use 5.1.6. Seriously. On a Citrix neighbourhood.

It's awesome. It's like 1999 over here.