Inserting values from Oracle to TM1 cube

[monishapm]

Hi,

While loading the values from oracle, the TI process is showing following error.

"Forecast","25000.","Other","FY2010-P01","4000.",Data Source line (11) Error: Data procedure line (3): Cell type is string.



Here 25000 is data.. rest all are elements.


Data Procedure lines


#****Begin: Generated Statements***
CellPutN(AMOUNT,'11111111',ACCOUNT_CATEGORY,FISCAL_PERIOD_NUMBER,scenario,STOREIDOF);
#****End: Generated Statements****


Please give suggestions.

Regards,

Monisha

[jstrygner]

Monisha,

Looks like you have a '11111111' cube that has 4 dimensions.

Your last dimension has an element that is a type of S (string), not N (numeric), this element name is the same as the value of STOREIDOF variable for the 11th record in your source.

Your TI process is trying to insert 25000 (numeric) as a string and is not able to, so you get the "Cell type is string" error.

As I did not try to reproduce your error there is a chance the problem is somewhere else and your message means something else than I am guessing it does.

HTH

[rkaif]

Your data "25000." should not have a . (dot) in it. Same is the case with "4000.". Unless you are doing this intentionally. I think you have to do type casting for your data variable.

Use StringToNumber() or NumberToString() functions depending upon what you are trying to achieve.

Alternatively, you can also do this type casting within your SQL. You can use TO_CHAR() or TO_NUMBER() oracle functions within your SQL statement.

[monishapm]

Hi,

Thanks a lot...

Its working now Used to_char and to_number function...


Regards,

Monisha