Unable to load data in cube

Post Reply
BilalSuleman2019
Posts: 7
Joined: Wed Jul 24, 2019 10:41 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2013

Unable to load data in cube

Post by BilalSuleman2019 » Thu Jan 09, 2020 5:02 pm

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

User avatar
jim wood
Site Admin
Posts: 3760
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: TM1 10.2.2
Excel Version: 2007
Location: 1639 Route 10, Suite 107, Parsippany, NJ, USA
Contact:

Re: Unable to load data in cube

Post by jim wood » Thu Jan 09, 2020 6:35 pm

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

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Application Consulting Group (ACG) TM1 Consulting
OS: Windows 10 64-bit. TM1 Version: 10.2.2

BilalSuleman2019
Posts: 7
Joined: Wed Jul 24, 2019 10:41 pm
OLAP Product: TM1
Version: 10.1
Excel Version: 2013

Re: Unable to load data in cube

Post by BilalSuleman2019 » Fri Jan 10, 2020 9:40 am

Hi Jim,

Please find attached file containing code in 'Data' tab

Best Regards

Bilal
Attachments
Code in Data section.txt
(17.89 KiB) Downloaded 10 times

ascheevel
Posts: 100
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.8
Excel Version: 2016

Re: Unable to load data in cube

Post by ascheevel » Fri Jan 10, 2020 2:47 pm

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));

Post Reply