Year object format in DB2 and Sybase Universe

building semantic layer
1

Hi All,

Below is my universe object select statement in DB2 to display year

RMS_DW.RMS_DIM_DATE.CAL_YEAR

I have the same formula in Sybase universe as well.
When I run this sybase year object in Deski XIR2 , the year object displays as
2000,2001 etc.,

When I run this the DB2 year object in Deski XIR3 , the year object displays as 2000.00,2001.00 etc.,How can I fix this in the DB2 universe where this object display as 2000,2001.

Is this issue with functions or between R2 and R3.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)

2

I sorted it out.
The object was defined as Number and the format for that object in DB2 universe is not set properly.
Thanks…

JohnJustus :us: (BOB member since 2007-06-25)