Keeping up with EPM Cloud

Import expressions can be added to an FDMEE import format to alter the data being imported from a file in several valuable ways. In this blog, I will focus on using the ‘Factor’ import expression, which allows you to multiply your data by any whole number or decimal factor. This means that you can scale the file data effortlessly by any numeric factor.  The syntax for this expression is Factor=Value, where the value is the user-defined whole or decimal number you wish to multiply your data by. The import expression should be entered in the 'Expression' field for the 'Amount' source column.  Listed below are a few things to consider when applying a factor to your data: Factors are only applied when the import format Data Type is set to one of the following   Delimited–Numeric data   Fixed–Numeric data   Multi-Column–Numeric Data   The factor will be applied to all data amounts in the file.   When importing a multi-column file with Accou...

Custom calculation scripts contain sections of code which can then be referenced several times within a Business Rule, or in multiple different Business Rules. They are created within Calculation Manager, in much the same way as Business Rules, and are listed below the relevant PBCS Plan Type, under the ‘Scripts’ heading, as below: Custom scripts are useful for times when a certain section of code is repeated throughout a Business Rule, or is contained in multiple Business Rules. Using scripts in this situation means that if the script needs to be altered, it only needs to be updated in one place, rather than having to be updated in multiple locations or Business Rules. This saves time and ensures all your Business Rules which contain this section of code are consistent. The syntax used to reference a script from within a Business Rule is: %Script(name:=" ScriptName ",application:=" AppName ",plantype:=" PlanType ") Where:   ScriptName...