Print Page - CSV file as a data source in cognos Framework Manager using Microsoft text drive

Title: CSV file as a data source in cognos Framework Manager using Microsoft text drive
Post by: sunny bachan prasad on 23 May 2017 07:25:57 AM

Hi,

I am using CSV file as a data source in cognos 10.2.2 framework manager and it is connected as a microsoft text driver(*txt;*CSV) in ODBC . I have to define one filter for the query subject created by this data source which uses substring but while validating the model i am getting error as mention below can any one share experience on this?

"UDA-SQL-0043 The underlying database detected an error during processing the SQL request.[Microsoft][ODBC Text Driver] Undefined function 'substring' in expression"

Thanks in Advance
Sunny

Title: Re: CSV file as a data source in cognos Framework Manager using Microsoft text drive
Post by: bdbits on 24 May 2017 11:12:49 AM

Unfortunately, it appears substring() is not supported for the text driver.

Could the file be ETLed to your database? This will give you a lot more flexibility.

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: sunny bachan prasad on 23 May 2017 07:25:57 AM