COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: sushmak on 14 Jun 2016 09:10:14 AM

Title: Dealing with External data in Report Studio
Post by: sushmak on 14 Jun 2016 09:10:14 AM
 Hi All,

         I am importing excel and using one of the column info in the filter criteria of report studio.I am getting  the below error message while validating

QE-DEF-0469

RQP-DEF-0513 The determinants of model query subject 'Master' are ignored, because it has no joins to other query subjects and its 'Generate SQL' option is set to 'Minimize'

Attached is the error message while running

I don't required to join the external source as the external excel is used only as input for filter criteria

Thanks a ton in advance for any kind of help..

Regards

KKP
Title: Re: Dealing with External data in Report Studio
Post by: MFGF on 14 Jun 2016 11:01:12 AM
Quote from: skkp on 14 Jun 2016 09:10:14 AM
Hi All,

         I am importing excel and using one of the column info in the filter criteria of report studio.I am getting  the below error message while validating

QE-DEF-0469

RQP-DEF-0513 The determinants of model query subject 'Master' are ignored, because it has no joins to other query subjects and its 'Generate SQL' option is set to 'Minimize'

Attached is the error message while running

I don't required to join the external source as the external excel is used only as input for filter criteria

Thanks a ton in advance for any kind of help..

Regards

KKP

Hi,

The error you posted is UDA-EE-0011, and is usually generated where you try to cast something non-numeric as an integer

http://www-01.ibm.com/support/docview.wss?uid=swg21341619

MF.