Unable to load data in cube

[BilalSuleman2019]

Hi,

I am new to TM1. I have written a process to load data in cube. When I run the process, I do not get any error but data is not loaded in cube. I have used TM1 function 'asciioutput' to write data in excel file and data seems to be fine.

Response from TM1 expert will be highly appreciated.

Best Regards

Bilal

[jim wood]

This could many things. You need to at least put some of your code up so we can eliminate some of the possibilities,

Jim.

[BilalSuleman2019]

Hi Jim,

Please find attached file containing code in 'Data' tab

Best Regards

Bilal

[ascheevel]

Are you referring to the ascii output at the bottom of the code you attached? Add your loadvalue variable to that output and reevaluate the outputted file. You'll need to wrap it in NumberToString() function like below. My first guess is your loadvalue variable might be evaluating to zero.

Code: Select all

asciioutput(getprocesserrorfiledirectory|'\Prodher99.csv', v_Year,v_Period,v_Entity,v_CurrencyOverride,v_Channel,v_Brand,v_ProductGroup,v_ProfitCentre,v_Season,v_Intercompany,v_SaleReturnOverride,v_Customer,Pafield,'Actual',v_Payer,v_ShipTo,v_BillTo,v_EndUser,NumberToString(loadvalue));