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 »

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: 3958
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Unable to load data in cube

Post 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.
Struggling through the quagmire of life to reach the other side of who knows where.
Shop at Amazon
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
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 »

Hi Jim,

Please find attached file containing code in 'Data' tab

Best Regards

Bilal
Attachments
Code in Data section.txt
(17.89 KiB) Downloaded 322 times
ascheevel
Community Contributor
Posts: 312
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: PA 2.0.9.1
Excel Version: 365
Location: Minneapolis, USA

Re: Unable to load data in cube

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