Monday, March 16, 2009

Sample Calculation Script

/*Information */
/*
Script Name : CopyAct2Fcst
Created by : Dornakal, Hyperion Consultant, March 16, 2009
Purpose : Copy Actuals to Current Forecast
Directions : Set substitution variables CurFcst, Actmnth,CY
Versions : Essbase 9.3.1
Assumptions : The Accounts, Time dimensions are Dense and the rest of dimensions are Sparse
Comments : This script copies actual data from actual scenario to forecast scenario; This rule should be run before every forecast.
*/




/*House Keeping*/

/*Set the calculator cache. */
SET CACHE HIGH ;

/* Display calculation statistics in application log. */
SET MSG Summary;

/* Display calculation completion messages in application log at 20% intervals. */
SET NOTICE LOW;

/*Turn off Intelligent Calculation */
SET UPDATECALC OFF;

/* Enables parallel calculation. */
SET CALCPARALLEL 4;


/* Baseline Fix on CurYear, Local Currency, and Level 0 cost center */
FIX(@LEVMBRS("Cost Center",0),Local)



/* Main Rollup */

/* Copies data for all existing employees of all Expense Accounts from Actual scenario , final version to Current Forecast and Working version */

FIX ("Existing_Employees", @IDESCENDANTS("Expense Accounts"), Jan:&Actmnth)
DATACOPY Actual->Final TO &CurFcst->Working;
ENDFIX


/* End of baseline Fix*/
ENDFIX;

2 comments:

  1. Hi Dornakal,

    I have gone through your script. It is really good. Can you post some more calculation scripts like this.It really helps me.

    Thanks,
    Mahesh

    ReplyDelete
  2. Hi Mahesh,
    Thanks for your comment.
    I am planning to post more calc scripts and business rules in future.
    have a great day.

    with best wishes,
    Dornakal.

    ReplyDelete