Database Reference
In-Depth Information
"COGS Assembly"="COGS Assembly"*1.10;
ENDFIX
FIX(@DESCENDANTS("Segment 1"), "Budget", "Version_1", "FY12", "New
Product 1")
"Mth End Bal" = (@MDSHIFT( "Payments" ,11,"period", ,
-1,"Years",)
+ @MDSHIFT( "UnLiquidated Payments" ,11,"period", ,
-1,"Years",) -
"Billings" + ("Sales" - "Shipment Billing")); )
ENDFIX
--- end of script #1 ---
--- beginning of script #2 ---
FIX("Ac_6004", "Actual”, "Cur Est", "FY12")
CALC DIM ("Version", "Location", "Entity", "Discretionary");
ENDFIX
--- end of script #2 ---
--- beginning of script #3 ---
FIX(@LEVMBRS("Location", 0), "FY12")
FIX(@LEVMBRS("Entity", 0), @LEVMBRS("Discretionary", 0),
@LEVMBRS("Version", 0))
FIX("Jan":"DEC")
CLEARDATA "Cur Est";
ENDFIX
ENDFIX
--- end of script #3. note add an EnDFIx so the script validates. ---
--- beginning of script #4 ---
note: Prefix with:
FIX(@LEVMBRS("Location", 0), "FY12")
FIX("D_00", "Load")
FIX("Jan":"DEC")
FIX(@ATTRIBUTE("Budget Self"), @ATTRIBUTE("Prior
History"))
"Cur Est" = "Plan 2011"->"Dept_JX"->"Final";
ENDFIX
FIX(@ATTRIBUTE("Budget at Parent 4JX"))
"Cur Est" = "Plan 2011"->"Dept_JX"->"4JX"
->"Final" ;
ENDFIX
FIX(@ATTRIBUTE("Budget Self at Parent"),
@ATTRIBUTE("Prior History"))
"Cur Est" = @PARENTVAL("Entity", "Plan
2011"->"Dept_JX"->"Final") ;
ENDFIX
ENDFIX
ENDFIX
ENDFIX
--- end of script #4 ---
once execution times and block counts are available from each script, address the
slowest sections first. This is where creativity comes into play. For example, in the first
