D AppFunctions

The AppFunctions library supports a number of functions and special expressions, most of which are for internal use, and not recommended for customer use, except TransformSpread, which achieves higher performance than its peer in RPAS.

Supported Functions

The following functions are supported by AppFunctions:

AsDouble
clndstart
addperiods
datediff
datefn
dateToString
doubletoint
hiername
union_int_low
union_int_high
ispopulated
merge
parseDate
parseDateFromPosition
range
resizeCal

Supported Special Expression Functions

The following special expression functions are supported by AppFunctions:

activeindex
copyseries
maskedAgg
rangese
RepIndInRangeExpr
ScaleExpr
TransformSpread

TransformSpread

The TransformSpread special expression function converts data across hierarchies using different spreading flavors: transformProp, transformRepl, and transformEven.

Syntax

<target1, [target2, …, targetn]> <- TransformSpread (<transform spreading flavor>, <map>, Source [<hierarchy>].[<dimension>], Desination [<hierarchy>].[<dimension>]< input1> [, < input2> … ,< inputn>])

Input Parameters

Table D-2 provides the input parameters for the TransformSpread function.

Table D-1 Input Parameters for the TransformSpread Function

Parameter Name	Description
Transform spreading flavor	Spreading flavor map
Source	[<hierarchy>].[<dimension>]
Destination	[<hierarchy>].[<dimension>]
Input1, [input2,...,inputn]	Input measures from which data are spread

Output Parameter

Table D-2 provides the output parameter for the TransformSpread function.

Table D-2 Output Parameter for the TransformSpread Function

Parameter Name	Description
target1, [target2, …, target]	Measures into which the source measures are spread to.

Example D-1 TransformSpread Function

mace -d . -run -expression "output1,output2,output3 <-TransformSpread(\"repl\",map,[CLSH].[CLST],[LOC].[STR],input1,input2,input3)"