Form Scripts — TGKML · Tagetik Application

TGKML Scripts source
Sources: PROSPETTO_XML

Form	Dimension	Node/Element	Axis
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2); result := this.lowest.select("$Period.code<PER");
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(1) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(2) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(3) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(4) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(5) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(6) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(7) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(8) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(9) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(10) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(11) ;
A302 Aggregated Rolling Forecast	`PERIODO` Period	`\|`	Cols (Rolling Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(12) ;
A260 Project Planning	`DEST5` Miscellaneous;it=Miscellaneous	PR_10 `ALL`All Projects	Rows (Project Economics/New Project Expenses)
TGKML 1.0 result := AND(this.lowest.select("$Cust_Dim5.attribute2 = $Cust_Dim1.code"),this.lowest.select("$Cust_Dim5.attribute1 = $Entity.code"));
B102 Supplemental Movement	`CONTO` Account;fr=Compte	`TIPO\|`	Rows (Supplemental Schedule/Balance Sheet)
TGKML 1.0 // Account deriving from prompt filter accountFGD := prompt().$Account; // all control groups variation type allCG := this.children; // we select all control groups with first 5 digit equal to the // code of the account chosen in the prompt FilteredGroup := allCG.select("LEFT($Account.code,5)=accountFGD.code"); result := FilteredGroup.lowest.select("LEN($Account.code)>5");
B102 Supplemental Movement	`CONTO` Account;fr=Compte	`\|SCH`	Rows (Supplemental Schedule/Balance Sheet)
TGKML 1.0 result:=prompt().$Account;
PS_015 Fee Income Plan	`DEST4` Employees;fr=Employés	100 `110`Existing 100 `130`Positions	Rows (Fee Income Plan/Fee Income Plan)
TGKML 1.0 Partner := "Partner"; result := this.lowest.select("$Cust_Dim4.attribute1 = 'Partner'");
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(1) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(2) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(3) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(4) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(5) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(6) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(7) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(8) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(9) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(10) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(11) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Forecast Calculate)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER).offset(12) ;
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2); result := this.lowest.select("$Period.code<PER");
A303 Top Down Rolling Forecast	`PERIODO` Period	`\|`	Cols (Forecast/Rolling Forecast)
TGKML 1.0 PER:= RIGHT($Scenario.code,2) ; result := getLeaf(PER) ;
C202 Product Profitability	`DEST2` Products;fr=Produit	010 $DEST2_010_P	Rows (Activity Based Costing Analysis/Profitability)
Refs `PD_030` TGKML 1.0 result := this.lowest - getLeaf("PD_030");
E236 Organic Growth Analysis	`AZIENDA_CTP`	$`$`	Cols (Growth Analysis/Constant Growth)
TGKML 1.0 SCEN_PREV:= LEFT(@SCE_ACT.PREV.CODE,4); SCEN_SUCC:= LEFT(@SCE_ACT.CODE,4); SET1:=this.lowest.select("RIGHT($ICEntity.attribute3,4)","!=",SCEN_PREV); SET2:=this.lowest.select("RIGHT($ICEntity.attribute2,4)","!=",SCEN_SUCC); SET3:=this.lowest.select("RIGHT($ICEntity.attribute3,4)","!=",SCEN_SUCC); SET4:=this.lowest.select("RIGHT($ICEntity.attribute2,4)","!=",SCEN_PREV); result:=orfilter(intersect(SET1,SET2,SET3,SET4));
E236 Organic Growth Analysis	`AZIENDA` Entity;fr=Entité	$`$`Default Legal Entity	Cols (Growth Analysis/Constant Growth)
TGKML 1.0 SCEN_PREV:= LEFT(@SCE_ACT.PREV.CODE,4); SCEN_SUCC:= LEFT(@SCE_ACT.CODE,4); SET1:=this.lowest.select("RIGHT($Entity.attribute3,4)","!=",SCEN_PREV); SET2:=this.lowest.select("RIGHT($Entity.attribute2,4)","!=",SCEN_SUCC); SET3:=this.lowest.select("RIGHT($Entity.attribute3,4)","!=",SCEN_SUCC); SET4:=this.lowest.select("RIGHT($Entity.attribute2,4)","!=",SCEN_PREV); result:=orfilter(intersect(SET1,SET2,SET3,SET4));

TGKML Scripts

TGKML Scripts sourceSources: PROSPETTO_XML

TGKML Scripts source
Sources: PROSPETTO_XML