Problem with numeric values

[#1]

Hello,

I have a problem loading a table when I try to concatenate different columns into one dimension. The problem basically is that I lost one of the fields that is related with the year.

Loading the column alone into one dimension gives no problem (on the image the dimension EJERCICIO) but using concatenation

EJERCICIO&num(mes,'00')&'-'&ID_EMPRESA&'-'&ID_TRABAJADOR results in the example of pk_TieEmpleado_key where the year doesn't appear.

The only way I find to solve it is to force EJERCICIO inside num() num(EJERCICIO)&num(mes,'00')&'-'&ID_EMPRESA&'-'&ID_TRABAJADOR but I would like to understand the problem.

On the database the column EJERCICIO is numeric.

Thanks for you help.

Regards

[vishsaggi]

Can you share some sample data and a qvw file if possible ?

[Anil_Babu_Samineni]

Instead of image values what values you are expecting.