Returns all members in a dimension with the specified generation name. This command does not work with Hybrid Analysis members.
Syntax
GEN name, dimension
When used as an extraction command in conjunction with the <LINK command, the syntax is:
<GEN(dimension,genNumber)
Parameter | Description |
---|---|
name | Generation name |
dimension | Dimension name |
genNumber | Generation number |
Notes
The report script can use either default generation names or user-defined generation names. Examples of default generation names are GEN1, GEN2, and so on.
Use quotes around the GEN command if the dimension name contains spaces.
Example
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.
See Also