@@S
The @@S statement in an Essbase calculation macro is a variable representing all input arguments for the macro.
Syntax
@@S
Notes
-
The @@S input argument variable can be used multiple times within a macro expansion.
-
The @@S input argument variable can also be used with the @@x and @@SHx argument variables within a macro expansion.
Example
The following example shows a macro that divides the sum of all arguments by the sum of the first two arguments.
create macro Sample.'@DIVIDE'(single, single, optional_group)
as '@SUM(@@S)/(@@1 + @@2)';