COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Framework Manager => Topic started by: gosoccer on 28 Jul 2017 08:02:24 AM

Title: SQL and XMIN
Post by: gosoccer on 28 Jul 2017 08:02:24 AM
Hi folks,
Good morning, :)

I'm trying to use the SQL that is generated from Cognos Subject Query in FM but it's producing XMIN for every column. Like below,

XMIN(CAR_INVEST.MAIN_CAR_ID  for CAR_INVEST.BMW_CAR_ID)

It's doing this for every single row in the SQL and SQL doesn't  like it in DB2.

PLease help ! :) :)