Returns all members in a dimension with the specified generation name. This command does not work with Hybrid Analysis members.
GEN name, dimension
name | Generation name |
dimension | Dimension name |
When used as an extraction command in conjunction with the <LINK command, the syntax is:
<GEN(dimension,genNumber)
dimension | Dimension name |
genNumber | Generation number |
GEN3,Year
Selects members of generation 3 from the Year dimension.
CityGen,State
Selects members of the user-defined generation name CityGen from the State dimension.
"GEN2,All Markets"
Selects members of generation 2 from the All Markets dimension.
<LINK (<GEN(Product,3) AND <LEV(Product,0))
Selects members with generation 3 and level 0 from the Product dimension.
©2004 Hyperion Solutions Corporation. All Rights Reserved. http://www.hyperion.com |