Page 1 of 1
Unable to load data in cube
Posted: Thu Jan 09, 2020 5:02 pm
by 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
Re: Unable to load data in cube
Posted: Thu Jan 09, 2020 6:35 pm
by 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.
Re: Unable to load data in cube
Posted: Fri Jan 10, 2020 9:40 am
by BilalSuleman2019
Hi Jim,
Please find attached file containing code in 'Data' tab
Best Regards
Bilal
Re: Unable to load data in cube
Posted: Fri Jan 10, 2020 2:47 pm
by 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));