@LIST
The @LIST calculation function for Essbase creates and distinguishes lists to be processed by functions that require list arguments.
This function can be used to create expLists, member lists, or rangeLists. This function treats a collection of parameters as one entity.
Syntax
@LIST (argument1, argument2, ..., argumentN)
Parameters
Notes
@LIST does not check for or eliminate duplicates.
Example
The following example is based on the Sample Basic database. Assume that the Year dimension contains an additional member, Sales Correl. @LIST is used with the @CORRELATION function to determine the sales relationship between a product's two peak periods (Jan-Mar and Apr-May):
FIX(Sales)
"Sales Correl" = @CORRELATION(SKIPNONE,
@LIST(Jan,Feb,Mar),@LIST(Apr,May,Jun));
ENDFIX
This example produces the following report:
Colas Actual New York
Sales
=====
Jan 678
Feb 645
Mar 675
Apr 712
May 756
Jun 890
Sales Correl 0.200368468