Friday, February 24, 2012

Maintenance scripts - Calculations

//ESS_LOCALE English_UnitedStates.Latin1@Binary
/* Author: Jay Raghupathruni, Script is part of the yearly maintenance */
Yearly maintenance calc script ---As a Hyperion Administrator, you get Monthly, Quarterly, Yearly tasks to maintain Planning/Essbase applications...
Scenarios that a request can be -

  1. We want to clear whole year : wow that’s simple1



     



  1. Clear Budget data for year FY10, remove data for Descendants of Entity dimension, excluding Descendants(Parent1)
similarly there might be a request for writting a script from scenario dimension, asking to eliminate few selected from say 50+ members...