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

Sub-Queries in Teradata Reports

Started by eliza_jane, 01 Feb 2011 12:08:45 AM

Previous topic - Next topic

eliza_jane

We have a report that implements the below sub-query concept:

select...
from Fact A
where
A.Date in (select max(date) from Fact A)

This was implemented in Dev, tested and promoted to QA and all the way to Prod. There were some environment (cognos + ODBC.ini + hot-fixes) changes implemented in Dev that has caused this to fail. The QA and Prod versions are working fine. We are still trying to figure out what change is causing this issue but it is proving to be too difficult and this issue is also holding up promotion of the fixes to other environments. But it is very strange that any environment change can cause this to break.

Has anyone else faced this issue?