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