Unable to import alpha numeric cost center

[babu babu]

Hi,

Earlier i can import the data with numeric cost centers.Now we have updated the file with new alnumeric cost centers.when i am importing these cost centers i am not able to see the alphanumeric cost center it's showing only 0.Please give me the solution.

Thanks,
Anand.

[ericlfg]

Hi Anand,

What is the d-list / d-cube format of that particular dimension?  Is it possible that it is a numeric format and you need to switch it over to text?

[babu babu]

Hi Eric,

Thanks for your response.I have changed property to text in excel and i am getting same problem.I have converted this excel to csv and created file maps.when i run the link i can import all cost centers but the client wants to proceed with odbc instead of file maps.

Thanks,
Anand.

[kbrauer]

I do think that you need to convert the numeric format to text in the SQL statement by using the STR command infront of the field