Print Page - Unable to import alpha numeric cost center

Title: Unable to import alpha numeric cost center
Post by: babu babu on 02 Sep 2011 05:50:03 PM

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.

Title: Re: Unable to import alpha numeric cost center
Post by: ericlfg on 05 Sep 2011 08:42:46 AM

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?

Title: Re: Unable to import alpha numeric cost center
Post by: babu babu on 06 Sep 2011 10:45:04 AM

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.

Title: Re: Unable to import alpha numeric cost center
Post by: kbrauer on 09 Sep 2011 04:35:31 AM

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

COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: babu babu on 02 Sep 2011 05:50:03 PM