Can i use same result sets b/w several lists and crosstabs with different filters?

For example: I have developed a master query for all lists and crosstabs becoz columns are almost same bt showing different data based on  different filters.

For Performance improvement, i dnt want to run same query again and again with different filter. Just want to run master query only one time and then apply filter on list or crossing tab level only.

THANKS IN ADVANCE.

Regards,
Deepak Seth



------------------------------
Deepak Seth
------------------------------

#CognosAnalyticswithWatson

Hi Deepak,
Please have a look at these links:
https://www-01.ibm.com/support/docview.wss?uid=swg21344305
https://www.ibm.com/support/knowledgecenter/en/SSEP7J_11.1.0/com.ibm.swg.ba.cognos.ug_fm.doc/c_dqm_governors.html
Hopefully there is enough information in those articles to allow you to get the desired effect.
If not, please describe the tools that you're using:
for modeling are you using Framework Manager or Web-based modeling?
for visualization are you using Reporting or Dashboarding?
Which version of Cognos Analytics are you using?
//Henk

------------------------------
HENK CAZEMIER
------------------------------

​We have some reports that have a main filtering criteria and the subqueries have subset of the main query.

If you look at the image, you set subquery <- short cut to main query.

So each of the sub-queries have the filtering to pull from the main query what is needed.  In this report, we have unduplicated and duplicated class types.

So one subset will filter all types of non-campus class type to unduplicated the count and another will filter each non-campus class type separately to get the totals for specific non-campus class type groups.


------------------------------
Jo Marie Sellner
------------------------------