Generations

Returns the generation specified by the input generation number.

Syntax

dimension.Generations ( index )

Generations ( dimension, index )

Parameter	Description
dimension	The dimension specification.
index	The numerical depth from the top member of the outline, where the top member is 1.

Example

The following query

SELECT
 [Year].[Qtr1].Generation.Members
ON COLUMNS,
 [Product].Generations(2).Members
ON ROWS
FROM Sample.Basic

returns the grid:

(axis)	Qtr1	Qtr2	Qtr3	Qtr4
100	7048	7872	8511	7037
200	6721	7030	7005	7198
300	5929	6769	6698	6403
400	5005	5436	5698	5162
Diet	7017	7336	7532	6941