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' );
ProForma Data Load
-
- 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
get the data source to provide a tabular single list with one column representing the Month and year
GG