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 Set (Union) Metadata callback

Started by SMitchell, 22 Jul 2010 11:40:46 AM

Previous topic - Next topic

SMitchell

Hello,

I'm trying to avoid a metadata callback using a Query Set. I have two Model Query Subjects both with a filter applied to them and from these two Model Query Subjects I created a Query Set using Union. There are no calculations or filters on the Query Set but the Query Information still shows the Metadata callback, thus it's not using Minimized SQL.

Is this a "matter of fact" when using Query Sets or did I design something wrong.

Thanks
Shaun

rockytopmark

My guess is the filters on the Model Queries is forcing it.  Can you do the UNION on your datasource query subjects? 

MFGF

If you track this right back to the underlying data source query subjects, how are they defined - are there any filters, calculations or customised SQL queries in either of them?

MF.
Meep!