Creates and distinguishes lists that are processed by functions that require list arguments. @LIST can be used to create expLists, member lists, or rangeLists. @LIST treats a collection of parameters as one entity.
@LIST (argument1, argument2, ..., argumentN)
| 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. |
@LIST does not check for or eliminate duplicates.
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 through Mar and Apr through 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
| ©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |