GEN

The Essbase Report Writer GEN command returns all members in a dimension with the specified generation name.

Syntax 1

GEN name, dimension

Syntax 2

When used as an extraction command in conjunction with the <LINK command, the syntax is:

<GEN(dimension,genNumber)

Parameters

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.