ProForma Data Load

Post Reply
sh226
Posts: 30
Joined: Wed Jun 06, 2012 8:59 pm
OLAP Product: TM1
Version: TM1 9.5.2
Excel Version: 2010

ProForma Data Load

Post by sh226 »

Hello experts!
I need to load first time monthly ProForma data ranging from 2003 to 2020 to my existing bucket "Pro Forma". The file has months as columns for example "for each year there are 12 colmuns from JAN-DEC means for 18 years there are 216 columns".
I can load data in year bucket separately. Is it possible to load this data by defining year as a parameter value? I am looking for a way to avoid repeating the process 18 times. Here is what i have in my Data tab of TI process. Thanks in advance for your expert advice.

numCurrValJan =
CELLGETN ( strCube,
'Pro Forma',
strActivity,
strBooks,
strClasses, strConsolEntity,
strDivision,
strInstitutionalPart,
strInsuranceCo,
strInvestmentStatus,
strLender,
strLocation,
strOpsStatus,
strOrganization,
strOrganizationAcct,
strOrganizationMnt,
strOwner,
strRehabStatus,
strStatus,
strStructure,
strThirdParty,
strThirdPartyOwner,
strVehicle,
strYieldstarStatus,
vAcct,
strBOOK,
'Jan 2003' );

numNewValJan = ( Jan * numSign ) + numCurrValJan;

CELLPUTN ( numNewValJan,
strCube,
'Pro Forma',
strActivity,
strBooks,
strClasses, strConsolEntity,
strDivision,
strInstitutionalPart,
strInsuranceCo,
strInvestmentStatus,
strLender,
strLocation,
strOpsStatus,
strOrganization,
strOrganizationAcct,
strOrganizationMnt,
strOwner,
strRehabStatus,
strStatus,
strStructure,
strThirdParty,
strThirdPartyOwner,
strVehicle,
strYieldstarStatus,
vAcct,
strBOOK,
'Jan 2003' );
BigG
Community Contributor
Posts: 211
Joined: Tue Sep 15, 2009 11:13 pm
OLAP Product: IBMPA
Version: PA 2.0 Cloud
Excel Version: 2010

Re: ProForma Data Load

Post by BigG »

get the data source to provide a tabular single list with one column representing the Month and year
GG
Post Reply