Returns the generation specified by the input generation number.
Syntax
dimension.Generations ( index )
Generations ( dimension, index )
Parameter | Description |
---|---|
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 |
See Also