Creating a Scheme for TM1

Hi there

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);

IF(ENROLMENT_GROUP_CD@=’CON’);

ENROLMENT_GROUP_CD = ‘EFTSL Continuing’;

ELSE;

ENROLMENT_GROUP_CD = ‘EFTSL Commencing’;

ENDIF;

#DEAL WITH AMBIGUOUS HIERARCHIES

COURSE_CD = COURSE_CD|’_'|OWNING_SCHOOL;

#

IF(TIMVL(NOW,’Y') = CAL_YEAR) ;

nGetVal = CellGetN(vCube8,

‘This Week CY’,

MODE_OF_STUDY_CD,

vYEAR_OF_STUDY,

DETAILED_BASIS_OF_ADMISSION_CD,

CAMPUS_CD,

NARROW_FUNDING_CATEGORY_CD,

FUNDING_CLUSTER_CD,

COURSE_CD,

TAUGHT_SCHOOL,

vWeek,

ENROLMENT_GROUP_CD

);

ENDIF;