TM1 Forum

The below script is in data tab in TI :
CubeName=’sale’;
vTTT_sale_rupees= StringtoNumber(TTT_sale_rupees);
IF(vTTT_sale_rupees <>'');
CellIncrementN (vTTT_sale_rupees, CubeName, p1 , t1 , time1 , ‘Sales_Measures’ ) ;
ENDIF;
Where my “TTT_sale_rupees” values are coming from oracle like this
120.0023
100.2002
201.01002
.
.
.
And I am getting the attached error while I am saving,can you please help as its urgent for me

Have you provided your EXACT code?

The screenshot suggests it actually contains "ddd_sales_dollars" and I can't see that in what you've provided.

mincharug.shulft wrote:The below script is in data tab in TI :
CubeName=’sale’;
vTTT_sale_rupees= StringtoNumber(TTT_sale_rupees);
IF(vTTT_sale_rupees <>'');
CellIncrementN (vTTT_sale_rupees, CubeName, p1 , t1 , time1 , ‘Sales_Measures’ ) ;
ENDIF;
Where my “TTT_sale_rupees” values are coming from oracle like this
120.0023
100.2002
201.01002
.
.
.
And I am getting the attached error while I am saving,can you please help as its urgent for me

The following is correct one:


vDDD_SALES_DOLLARS= StringToNumber(DDD_SALES_DOLLARS);
IF( DDD_SALES_DOLLARS @<> '');
CellIncrementN ( vDDD_SALES_DOLLARS, CubeName, CMA_ID , CP_Contracts , PRODUCT_BRAND_DSCR , vTIME_DATE_DAY , CP_Sales_Measures ) ;
ENDIF;



Where my “DDD_SALES_DOLLARS” values are coming from oracle like this
120.0023
100.2002
201.01002
200.9090

The following is correct one:


vDDD_SALES_DOLLARS= StringToNumber(DDD_SALES_DOLLARS);
IF( vDDD_SALES_DOLLARS @<> '');
CellIncrementN ( vDDD_SALES_DOLLARS, CubeName, CMA_ID , CP_Contracts , PRODUCT_BRAND_DSCR , vTIME_DATE_DAY , CP_Sales_Measures ) ;
ENDIF;



Where my “DDD_SALES_DOLLARS” values are coming from oracle like this
120.0023
100.2002
201.01002
200.9090

Well as a starting point:

VDDD_sales_dollars @<>

Is illogical since it is not string but a number as per your stringtonumber function.

Thanks even i have used numbertostring though getting same error.actually my data is like this
120.0023
100.2002
201.01002
200.9090

I don't think you've actually grasped my previous point.

A snapshot of your variables tab could help.

Attached

You are doing stringtonumber on something that is already a number....

Mean to say i have to use Numbertostring or not required and are not required both(numbertostring and stringtonumber).
if i use @<> attached geting the attached error.

Wouldn't you be better changing the variable type of DDD_SALES_DOLLARS to numeric and not doing the conversion in your code? And, why test for zeros (or '' as you have written it)? Just cellincrement the value - you don't need the if test at all.

Thanks lot david ur valuable reply BUT
As we are getting the some zero values for that i want to ommit the zero values and only non zero values i plan to load it as this process is talking 10 hours to load completly as table is having 1+ crores records.so this is approach correct?

mincharug.shulft wrote:Thanks lot david ur valuable reply BUT
so this is approach correct?

I don't know. Is it urgent?????

Probably a good idea to adjust the query to exclude zero rows before they reach TM1.
Probably also a good idea to explain what a crore is ie http://en.wikipedia.org/wiki/Crore - I don't believe it's a well known term outside South Asia.

David Usherwood wrote:Probably also a good idea to explain what a crore is ie http://en.wikipedia.org/wiki/Crore - I don't believe it's a well known term outside South Asia.

Also... use this site: http://translate.google.com/
Whatever you do, it cannot be less clear than what you posted above.