If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Query Reference in RS

Started by StelaK, 26 Nov 2010 03:38:12 AM

Previous topic - Next topic

StelaK

What are the main advantages of a Query reference in RS? Why would you use it?

ksr

A query will be created by using existing query when you want to use the same kind of query with different scenario....

For example..

let us consider a scenario where in, we have to create a multi page report , In the first page we have to show the revenue and quantities for all the available years and the second page will have to show only for particular year, and the third page will have to show data for another particular year and so on...

In this case go to query explorer and create a query Named query1 and add the requierd query items say Year, qty, revenue..

create second query say query2 and drag query1 to the right of the query2 and when you see left faced arrow pointing to query2 then release the mouse then you can see that a short cut of query1 will be created and pointing to query2..

now double click query2 and in the insertable objects pane you can see only the data items of query1 and drag the query items from insertable object pane to query2 and create a detail filter for query2 as [year]=2005 like that

repeat creating queries as above and refrence query1 for all and apply detail filter for each and every query..

Here, the advantage is, Only the query1 will be fired to database and the resultant rows will be used for the queries those are being refereced query1..


Blacksails

#2
hello,    im trying to use this technique  for improving perfomance on my reports.is true the last answer on this post?only one query is fired and other queries will use local cache and will hit  the result set of query 1?please could you clarify
my doubt.i think that cognos will hit the db .am i right?thanks