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

Views in FM

Started by kskanth, 05 Aug 2010 11:17:21 AM

Previous topic - Next topic

kskanth

Hi all,

My database type is Teradata
I was given access only to the views and so I just imported views. But issue is I cannot see the columns in it. And when I try to execute the view Teradata sql asst. it worked. And then I tried passing Pass-thru sql in FM and when I try to test the sample it throws an error as following.

This query contains an error and can not be executed.

It is recommended that you view the query feedback on the "Query Information" tab.

RQP-DEF-0177 An error occurred while performing operation 'sqlPrepareWithOptions' status='-69'.
UDA-SQL-0043 The underlying database detected an error during processing the SQL request.
[NCR][ODBC Teradata Driver][Teradata Database] The user does not have SELECT access to PROD_FATS_VW.FATV0101



Plz help me

Thanks.

tupac_rd

As the error says, I am guessing the user id you are using to query from Cognos does not have select priveleges. Or else it might be the ODBC driver version issue...