it is pulling the acqusition or dispostion month from another cube.
IF the date is within the last 365 days. meaning the acqusition date for company x is april 2020, then I want data to be loaded into the Acqusition book from april 2020 - april 2021.
Code: Select all
sAcqPeriod = CELLGETS(CubAcq, strScenario, sCompany, '1010 - 1', 'Acquisition_Period');
IF(sAcqPeriod @<> '');
nAcqMonthValue = ATTRN('Period', sAcqPeriod, 'MonthValue');
nDiff = nCurrMonthValue - nAcqMonthValue;
IF(nDiff < 365);
IF (sAcqDept @='');
strBook = strBook_Acq;
ELSE;
IF( sDept @= sAcqDept);
strBook = strBook_Acq;
ENDIF;
ENDIF;
sYear = nAcqMonthValue (and somehow get the next 12 months)
and in my cellputN i use "sYear" for my period
or would i be using a while loop to get the next 12 months?
sorry for asking a simple question, im pretty new to coding and even newer to tm1