Topic
4 replies Latest Post - ‏2012-04-02T03:38:37Z by coolcognos
coolcognos
coolcognos
4 Posts
ACCEPTED ANSWER

Pinned topic inner join in Report Studio

‏2012-03-31T06:10:21Z |
In a report we have 2 queries.One query is from package other one from sql statement.
query 1 columns A B c
Query 2 Columns D E F
now i want combine those 2 queries and i have do calculation C-F.when i am doing inner join it is giving an error.
if i filter on date only one query is filtering.other query is not filtering...
Please anyone give the solution.
Updated on 2012-04-02T03:38:37Z at 2012-04-02T03:38:37Z by coolcognos
  • SystemAdmin
    SystemAdmin
    214 Posts
    ACCEPTED ANSWER

    Re: inner join in Report Studio

    ‏2012-03-31T06:45:04Z  in response to coolcognos
    I'm going to guess that the error message is
    
    UDA-SQL-0107 A general exception has occurred during the operation 
    "prepare". [NCR][ODBC Teradata][Teradata Database] Name is longer than 30 characters.Unable to get catalog string.
    


    In which case, this is a limitation of the Teradata database. The solution is to either use shorter query subject names or to adjust the aliasing property in the Cognos ini files.

    If this isn't helpful then I would recommend looking at the following link to identify some useful information to include when asking for assistance.

    https://www.ibm.com/developerworks/forums/thread.jspa?threadID=391841
    • coolcognos
      coolcognos
      4 Posts
      ACCEPTED ANSWER

      Re: inner join in Report Studio

      ‏2012-04-01T06:50:28Z  in response to SystemAdmin
      Thanks alot phil...

      i am getting following error
      Initially, in data source type(s) '', the function 'realDataMode' is not supported in 'NoDataModeProvider'. After decomposition, in data source type(s) '', the function 'subQuery' is not supported in 'TabularFuncProvider'.

      thanks in advance....