@@SHx

The @@SHx statement in an Essbase calculation macro represents a subset of all arguments starting with position x and including the rest of the arguments for the macro.

Syntax

@@Sx

Where x is the number of an argument in the signature of the macro, with 0 representing the first position, 1 representing the second position, and so on.

Notes

The @@SHx argument variable can be used multiple times within a macro expansion.
The @@SHx argument variable can be used with the @@x and @@S argument variables within a macro expansion.

Example

The following example shows a macro that multiplies the first arguments together and adds them to the sum of the remaining arguments.

create macro Sample.'@MULTANDSUM'(single, single, any) 
  as '(@@1 * @@2) + @SUM(@@SH2)';