Discussion › Forums › discussion › Creating a Scheme for TM1
This topic contains 0 voices and has 0 replies.
I would love to start documenting a SCHEME to use pnotepad for writing scripts for TM1 ‘Turbo Integrator’ aka TI (the ETL piece of an in-memory OLAP modeling tool).
Currently the best editor is NOTEPAD. IBM Cognos clearly focus on the marketing end of the product and not us developers. A snippet of code below..
Can anyone provide an example.. a starting point please?
vCube8 = ‘FY Load Estimates’;
vCAL_YEAR = NumberToString(CAL_YEAR);
vCAL_YEARCD = NumberToString(CENSUS_YR);
vWeek = ‘Week ‘|NumberToString(FIN_WEEK_IN_YEAR);
vWeekCD = ‘Week ‘|NumberToString(CDWEEK);
vYEAR_OF_STUDY = ‘Year of Study ‘|NumberToString(YEAR_OF_STUDY);
ENROLMENT_GROUP_CD = ‘EFTSL Continuing’;
ENROLMENT_GROUP_CD = ‘EFTSL Commencing’;
#DEAL WITH AMBIGUOUS HIERARCHIES
COURSE_CD = COURSE_CD|’_'|OWNING_SCHOOL;
IF(TIMVL(NOW,’Y') = CAL_YEAR) ;
nGetVal = CellGetN(vCube8,
‘This Week CY’,
You must be logged in to reply to this topic.