Posts Tagged ‘Variables’
A Notation for Variables
Setting up variables in EPM for Substitution, User Variables or Run Time Prompts without some forethought beforehand will lead to a proliferation of variables, the use of which can become obfuscated and can become redundant without anyone noticing. This article is my naming structure to pre-empt these problems. Often when I’ve seen EPM systems, variables…
Read MoreConfigure Financials Automatically
To all you EPM administrators out there, here’s one job you can automate, the monthly Configuration of the open periods on the Scenario dimension and setting of the “OEP_” substitution variables. One less thing to do each month end…. Save a bit of time. Basically I’ve got two scripts, the first to set the variables,…
Read More