@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

argument1, argument2, ..., argumentN

The list of arguments that are collected and treated as one argument so they can be processed by the parent function. Arguments can be member names, member combinations, member set functions, range functions, and numeric expressions.

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