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

SQL and XMIN

Started by gosoccer, 28 Jul 2017 08:02:24 AM

Previous topic - Next topic

gosoccer

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 ! :) :)