Print Page - Query Set (Union) Metadata callback

Title: Query Set (Union) Metadata callback
Post by: SMitchell on 22 Jul 2010 11:40:46 AM

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

Title: Re: Query Set (Union) Metadata callback
Post by: rockytopmark on 22 Jul 2010 02:29:12 PM

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

Title: Re: Query Set (Union) Metadata callback
Post by: MFGF on 23 Jul 2010 04:35:22 AM

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.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Framework Manager => Topic started by: SMitchell on 22 Jul 2010 11:40:46 AM